Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 events by user dvdraymond occurring around 2021-07-09 13:23:10.
2022-01-20
| ||
15:40 | • Reply: feature request: vacuum into without indexes artifact: 3af80049ee user: dvdraymond | |
2022-01-13
| ||
16:49 | • Reply: Unable to read while database is locked artifact: 3fe1aa5b4d user: dvdraymond | |
2022-01-12
| ||
18:38 | • Reply: SELECT with LIMIT OFFSET clause return unexpected result (with sample db and query) artifact: 195588b84d user: dvdraymond | |
2022-01-06
| ||
14:27 | • Reply: autovacuum in sqlite VS autovacuum in PG artifact: f24c56d390 user: dvdraymond | |
2021-12-13
| ||
16:33 | • Reply: How to merge two or more tables that have the same structure? artifact: bb0ca9f424 user: dvdraymond | |
2021-11-17
| ||
13:16 | • Reply: ROWID primary key works slower than index artifact: 53a09f7a9f user: dvdraymond | |
2021-10-20
| ||
18:39 | • Reply: I need a little help with UPDATE? artifact: 1bb7b4bdd9 user: dvdraymond | |
2021-10-13
| ||
14:59 | • Reply: binary .dump format artifact: d287c1fe01 user: dvdraymond | |
2021-09-28
| ||
13:36 | • Reply: Views, Casting vs and converters artifact: 3a773c65a1 user: dvdraymond | |
2021-09-01
| ||
13:19 | • Reply: STRICT tables and UNIQUE indices artifact: 146daf1138 user: dvdraymond | |
2021-08-31
| ||
14:54 | • Reply: Possible bug: Unexpected result using correlated aggregate subquery artifact: 1d6f05c554 user: dvdraymond | |
14:21 | • Reply: Possible bug: Unexpected result using correlated aggregate subquery artifact: 85a3337362 user: dvdraymond | |
2021-08-24
| ||
15:20 | • Reply: Most performant way to test for having 0, 1 or more rows in a table artifact: 9d87c828fc user: dvdraymond | |
2021-08-16
| ||
12:49 | • Reply: Avoiding recursive CTE materialisation artifact: 6523441ecc user: dvdraymond | |
2021-08-12
| ||
17:05 | • Reply: LEFT AND RIGHT OUTER JOINS problem artifact: 9387707b37 user: dvdraymond | |
13:40 | • Reply: SQL lite irrespective query artifact: 99678ffcb5 user: dvdraymond | |
2021-07-22
| ||
13:20 | • Reply: problem report: incorrect join behavior artifact: d730d754d7 user: dvdraymond | |
13:01 | • Reply: How to submit changes artifact: b7d7244259 user: dvdraymond | |
12:44 | • Reply: operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors artifact: a148f53ae6 user: dvdraymond | |
2021-07-20
| ||
13:48 | • Reply: cycle detection in CHECK constraint with recursive CTE artifact: a184978699 user: dvdraymond | |
2021-07-19
| ||
19:43 | • Reply: Unexpected return from the NULL column artifact: 3b70b2ac1d user: dvdraymond | |
2021-07-15
| ||
18:23 | • Reply: Should SQLite be able to optimize this query? artifact: 3344977a85 user: dvdraymond | |
12:56 | • Reply: Feature request: add index info to WITH clause table artifact: 47e359f7ec user: dvdraymond | |
2021-07-14
| ||
19:19 | • Reply: can i custom index blob data? artifact: a524364a3a user: dvdraymond | |
2021-07-09
| ||
13:23 | • Reply: How to handle collation version changes artifact: 9edc83b98c user: dvdraymond | |
2021-07-07
| ||
14:36 | • Reply: Shortcut to change a non changing update or upsert in a noop artifact: 16d7383a0c user: dvdraymond | |
14:07 | • Reply: Shortcut to change a non changing update or upsert in a noop artifact: a3edf4ec1f user: dvdraymond | |
2021-06-30
| ||
18:09 | • Reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: 195d361259 user: dvdraymond | |
2021-06-10
| ||
15:28 | • Reply: Slow insert with prepare/step artifact: c6759f6f31 user: dvdraymond | |
14:15 | • Reply: Slow insert with prepare/step artifact: 1db30fbdd7 user: dvdraymond | |
2021-06-09
| ||
12:14 | • Reply: Feature request: Stored Procedures artifact: cd05f203c9 user: dvdraymond | |
2021-06-01
| ||
15:15 | • Reply: How to relate a row with more than one topic? See example artifact: 314bfa4f70 user: dvdraymond | |
2021-05-27
| ||
16:21 | • Reply: Is there a way to optimize this UPDATE command to run faster? artifact: 90f7c9ed54 user: dvdraymond | |
2021-05-25
| ||
15:01 | • Reply: How can I merge results from two SELECTs? artifact: 80c56da25f user: dvdraymond | |
2021-05-19
| ||
15:11 | • Edit reply: ORDER BY out of order. Is this a bug or expected? artifact: fe70cc3e9a user: dvdraymond | |
15:10 | • Reply: ORDER BY out of order. Is this a bug or expected? artifact: 713d1aa50d user: dvdraymond | |
2021-05-11
| ||
13:33 | • Reply: Fast way to insert rows in SQLite artifact: db7d038eb9 user: dvdraymond | |
12:58 | • Reply: Fast way to insert rows in SQLite artifact: f832398c19 user: dvdraymond | |
2021-05-06
| ||
14:02 | • Reply: Table Btree and Index Btree artifact: 8cc2c69629 user: dvdraymond | |
13:47 | • Reply: Why do I have a `SQLITE_AUTOINDEX` index for my primary key? Is the table itself not an index on the PK? artifact: f16f8ed866 user: dvdraymond | |
2021-04-30
| ||
17:29 | • Reply: Where is the temporary database file stored? artifact: bfd1f0c044 user: dvdraymond | |
2021-04-19
| ||
14:14 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: ff2610b7d0 user: dvdraymond | |
2021-04-13
| ||
17:58 | • Reply: how DISTINCT remove the duplicate rows? artifact: bd2555df20 user: dvdraymond | |
13:01 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: cc6a7f156e user: dvdraymond | |
2021-04-05
| ||
17:58 | • Reply: What indexes help Window Functions artifact: 543442cd01 user: dvdraymond | |
2021-03-24
| ||
14:09 | • Reply: Help rewriting a query to match the speed of a 2nd query artifact: bec274b1de user: dvdraymond | |
2021-03-23
| ||
13:28 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: fcb26719db user: dvdraymond | |
2021-03-18
| ||
17:52 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: fcc7206112 user: dvdraymond | |
2021-03-17
| ||
18:25 | • Reply: Serious problems with STORED columns artifact: 33283001e1 user: dvdraymond | |
16:00 | • Reply: Getting the error artifact: a59c7ba43f user: dvdraymond | |