SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 events by user dvdraymond occurring around 2021-03-18 17:52:43.

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
2021-02-24
14:10 Reply: Update Query artifact: 946aa3b2aa user: dvdraymond
13:59 Reply: Stuck with 3.22 and no docs ... artifact: b3afdd6564 user: dvdraymond
2021-02-22
13:57 Reply: SQLite database in space? artifact: f52bd8b6d6 user: dvdraymond
2021-02-18
14:41 Reply: statement subtransaction journal artifact: aac368a9a5 user: dvdraymond
2021-02-11
16:42 Reply: Slow select operation after many times of insert different Table artifact: 4e9c17a3c5 user: dvdraymond
16:24 Reply: Slow select operation after many times of insert different Table artifact: 04cc85624f user: dvdraymond
15:45 Reply: Slow select operation after many times of insert different Table artifact: 58887d61cc user: dvdraymond
13:18 Reply: Slow select operation after many times of insert different Table artifact: 81539e94a4 user: dvdraymond
2021-02-10
20:14 Reply: sqlite bindings error artifact: ec4b16cad6 user: dvdraymond
14:04 Reply: SAVEPOINTS artifact: a697279164 user: dvdraymond
2021-02-08
14:46 Reply: Recover Database artifact: 0bbf6e94a4 user: dvdraymond
13:48 Reply: pending lock macro artifact: 4b111a6475 user: dvdraymond
2021-02-05
13:19 Reply: Query data between dates artifact: 28b5256dcf user: dvdraymond
2021-02-04
15:39 Reply: Primary Key v Unique Index artifact: 36cdde8591 user: dvdraymond
2021-02-03
18:12 Reply: Use of RETURNING clause as a subquery artifact: dbd3d46a23 user: dvdraymond
2021-01-20
14:04 Reply: COLLATE - Multiple? artifact: 1a6cfe8e57 user: dvdraymond
2021-01-19
16:33 Reply: 2 queries asking the same, give different answers artifact: 011a415f76 user: dvdraymond
2021-01-15
19:36 Reply: Can't migrate auto-increment bigint columns artifact: 7db931db6f user: dvdraymond