SQLite Forum

Timeline
Login

50 events by user dvdraymond occurring around 2021-06-30 18:09:46.

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: SQLite 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
2021-03-16
15:40 Reply: Serious problems with STORED columns artifact: 6fc4f9b690 user: dvdraymond
2021-03-08
14:35 Reply: how to open or create db in sqlite3 artifact: b1194804d3 user: dvdraymond
2021-03-03
17:05 Reply: encoding on new DB-File artifact: 00dca7ba42 user: dvdraymond
15:58 Reply: encoding on new DB-File artifact: 18cc31cb81 user: dvdraymond
2021-02-25
12:37 Reply: sqlite3_prepare_v2 does not seem to work. artifact: 0d8a78408f user: dvdraymond
More ↓