SQLite User Forum

Today In History
Login

This Day In History For 2025-10-13

1 Year Ago (more context)

2024-10-13
22:59 Reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: b0a9475bbf user: sqlite_jnosh
22:40 Edit reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: 2449fbb154 user: stephan
22:39 Reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: c2cfaf86f8 user: stephan
22:34 Post: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: c4da1da119 user: sqlite_jnosh
22:26 Reply: .expert Broken Error Message artifact: b6e263cfd3 user: stephan
21:39 Reply: Dump cannot be imported artifact: 771dcc5abe user: stephan
21:02 Reply: Dump cannot be imported artifact: 20b8aa342c user: blackbit
20:34 Reply: Dump cannot be imported artifact: 9b7141a703 user: stephan
20:23 Reply: Dump cannot be imported artifact: 83d4b7d1f2 user: blackbit
19:17 Reply: Dump cannot be imported artifact: 759fb1c168 user: stephan
17:50 Reply: Dump cannot be imported artifact: e0ff68a72e user: blackbit
17:10 Post: Dump cannot be imported artifact: 2e31f49d00 user: blackbit
14:36 Reply: Optimizing SQLite for readonly low latency queries artifact: c3d32c1c2b user: slavin
13:43 Reply: Optimizing SQLite for readonly low latency queries artifact: d861cbeab1 user: lexfiend
06:17 Post: Optimizing SQLite for readonly low latency queries artifact: 5098178c21 user: michaelb072

2 Years Ago (more context)

2023-10-13
20:44 Reply: INSERTing records that are not repeat of the previous record artifact: b43868af24 user: jicman
19:16 Reply: UNIQUE column allowing only a single NULL value artifact: c0b791279e user: dvdraymond
18:37 Post: UNIQUE column allowing only a single NULL value artifact: 1ae0e4d29a user: younique
16:18 Reply: Failed to create db on CIFS network mount: Runtime error: database is locked (5) artifact: b4126faa36 user: stephan
16:01 Edit reply: Failed to create db on CIFS network mount: Runtime error: database is locked (5) artifact: f7d688a249 user: theroggy
15:53 Reply: INSERTing records that are not repeat of the previous record artifact: e65a625ddc user: larrybr
15:41 Post: INSERTing records that are not repeat of the previous record artifact: e9ff05f94b user: jicman
13:19 Reply: (Deleted) artifact: 724ac025e9 user: dkfellows
13:06 Reply: Experience with SQLite as a store of Files and Images artifact: afdab61f30 user: dkfellows
12:52 Reply: A Null-pointer-dereference bug in sqlite3_db_config artifact: fedb6a0076 user: stephan
12:19 Reply: Strange behavour Window functions artifact: f9ffe98fd5 user: drh
11:58 Reply: Strange behavour Window functions artifact: 96f2a628cc user: sjoerd_at_westland
11:49 Reply: Strange behavour Window functions artifact: 1a0cb01c44 user: sjoerd_at_westland
10:40 Reply: Strange behavour Window functions artifact: 6d526dd5a2 user: stephan
10:35 Post: Strange behavour Window functions artifact: 1d1716ff77 user: sjoerd_at_westland
06:01 Reply: Failed to create db on CIFS network mount: Runtime error: database is locked (5) artifact: 959aa87a18 user: sqweek
02:58 Reply: Potential NULL dereference in shell.c? artifact: cbccb3e68e user: larrybr
01:57 Reply: Potential int overflow in hexFunc() (when SQLITE_MAX_LENGTH > INT_MAX / 2) artifact: 679ce8da1d user: larrybr

3 Years Ago (more context)

2022-10-13
23:38 Reply: System.Data.SQLite on macOS using C# ? artifact: a9464160b4 user: npalardy
23:05 Edit reply: System.Data.SQLite on macOS using C# ? artifact: 0045965551 user: npalardy
22:52 Reply: System.Data.SQLite on macOS using C# ? artifact: 532ff6a4cf user: npalardy
22:38 Reply: Could not get expect result by Bloom Filter artifact: 502eb17299 user: dakangger
21:01 Reply: JSON numbers order by artifact: 80ba00498d user: ben123
20:31 Reply: JSON numbers order by artifact: 374ea23af8 user: dvdraymond
20:12 Reply: JSON numbers order by artifact: 47d5083ab5 user: drh
20:11 Edit reply: JSON numbers order by artifact: 4ed74c6cc5 user: dvdraymond
20:07 Reply: JSON numbers order by artifact: 378a019f91 user: dvdraymond
19:35 Reply: JSON numbers order by artifact: 7014db3695 user: ben123
19:11 Reply: JSON numbers order by artifact: 75febd047d user: dvdraymond
19:06 Reply: JSON numbers order by artifact: 764d9ee8fc user: drh
19:05 Reply: JSON numbers order by artifact: b91794c2e3 user: drh
18:51 Reply: JSON numbers order by artifact: edd4a45c20 user: RandomCoder
18:35 Reply: JSON numbers order by artifact: a642f389cf user: ben123
18:17 Edit reply: Heap size estimation artifact: 31bc5d6549 user: drh
18:10 Reply: Heap size estimation artifact: cebd3c482d user: drh
17:53 Post: Heap size estimation artifact: 520e6a23dc user: AhmedHRABI
17:21 Edit reply: System.Data.SQLite on macOS using C# ? artifact: d522d40347 user: chrisjlocke1
17:21 Reply: JSON numbers order by artifact: ea234e9093 user: ben123
17:20 Reply: System.Data.SQLite on macOS using C# ? artifact: 2f9f65928d user: chrisjlocke1
16:52 Reply: sqlite3 installation via ruby gems fails artifact: 741fd67127 user: stephan
16:50 Reply: sqlite3 installation via ruby gems fails artifact: 94e8bf7320 user: drh
16:43 Post: sqlite3 installation via ruby gems fails artifact: 763c094dc1 user: anonymous
16:39 Reply: JSON numbers order by artifact: 027a0d9236 user: dvdraymond
16:23 Reply: System.Data.SQLite on macOS using C# ? artifact: 8e9a0ea089 user: npalardy
16:06 Post: JSON numbers order by artifact: a43e9bdd6c user: ben123
15:38 Reply: blob IS NULL significantly slower than length(blob) IS NULL artifact: 551d89779d user: dvdraymond
13:40 Reply: blob IS NULL significantly slower than length(blob) IS NULL artifact: a2b5bd6d43 user: dvdraymond
13:15 Reply: blob IS NULL significantly slower than length(blob) IS NULL artifact: 31d5ac1d3f user: ddevienne
12:56 Reply: blob IS NULL significantly slower than length(blob) IS NULL artifact: f4d9010ad8 user: dvdraymond
11:24 Post: blob IS NULL significantly slower than length(blob) IS NULL artifact: 3c08d4715d user: anonymous
07:03 Reply: Faster way to open a restore database artifact: f2843b4c7c user: wyoung
05:50 Reply: System.Data.SQLite on macOS using C# ? artifact: 0ecff5ee3b user: npalardy
05:28 Post: Faster way to open a restore database artifact: 273c19402f user: berzerker
00:34 Reply: System.Data.SQLite on macOS using C# ? artifact: 7bfbba9216 user: mistachkin

4 Years Ago (more context)

2021-10-13
22:58 Reply: inconsistent output: insert on conflict with returning artifact: a490a6b058 user: cuz
19:31 Reply: binary .dump format artifact: 4870e9b119 user: anonymous
19:18 Reply: inconsistent output: insert on conflict with returning artifact: a339db3dbc user: slavin
16:52 Edit reply: binary .dump format artifact: 43dc3c1f82 user: hitchmanr
16:45 Reply: binary .dump format artifact: 4d0e0cb4c7 user: hitchmanr
16:27 Edit reply: binary .dump format artifact: 5a737662d2 user: hitchmanr
16:22 Edit reply: binary .dump format artifact: 6e90374d3e user: hitchmanr
16:20 Reply: binary .dump format artifact: 70514f1b20 user: hitchmanr
16:15 Reply: binary .dump format artifact: 5651e6d221 user: hitchmanr
15:26 Reply: Different time spent in Windows and Linux artifact: d8db57418b user: dan
15:17 Reply: binary .dump format artifact: 8b5549ca46 user: ddevienne
15:10 Reply: Data Types artifact: 2aa9f14827 user: gunter_hick
14:59 Reply: binary .dump format artifact: d287c1fe01 user: dvdraymond
14:48 Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: cebd13c65b user: drh
13:46 Reply: Data Types artifact: 03b7203053 user: anonymous
13:10 Post: Different time spent in Windows and Linux artifact: 05897c25b7 user: Lyalot
12:53 Post: inconsistent output: insert on conflict with returning artifact: b2dc888367 user: mkSqliteId
12:25 Reply: binary .dump format artifact: 5ffa89363d user: cuz
12:19 Reply: Data Types artifact: 073be6a27e user: slavin
12:10 Reply: binary .dump format artifact: f96d8d6001 user: drh
11:59 Reply: Build fails with SQLITE_OMIT_WAL and SQLITE_MAX_MMAP_SIZE=0 artifact: e1f858f5bb user: drh
10:40 Reply: Data Types artifact: 00aa7257d7 user: anonymous
10:18 Reply: binary .dump format artifact: ae16f90b20 user: ddevienne
10:15 Reply: binary .dump format artifact: a67aa42b9a user: andreas-kupries
10:13 Reply: binary .dump format artifact: e511a9cb23 user: anonymous
09:51 Reply: binary .dump format artifact: bd7d3d1c1b user: cuz
09:18 Reply: Build fails with SQLITE_OMIT_WAL and SQLITE_MAX_MMAP_SIZE=0 artifact: dfcb495ca6 user: anonymous
07:22 Reply: binary .dump format artifact: 84c3501432 user: andreas-kupries
06:45 Reply: Data Types artifact: a7da004e3b user: anonymous
05:10 Post: binary .dump format artifact: b15e0ae5c8 user: hitchmanr
03:56 Edit reply: sqlite3_busy_handler missing artifact: c8762970f0 user: mistachkin

5 Years Ago (more context)

2020-10-13
19:24 Reply: update-from on without rowid virtual tables artifact: 9794190f9e user: kev82
10:30 Reply: Triggers artifact: acb52610c8 user: cuz
08:26 Reply: Triggers artifact: b8ad5b6f49 user: anonymous
06:48 Reply: Check Contraints artifact: 5db417567a user: anonymous
06:48 Post: Triggers artifact: 06763a0c19 user: anonymous
05:16 Reply: Check Contraints artifact: ceec571459 user: kmedcalf
04:57 Reply: Check Contraints artifact: 9de75df61d user: jake
04:19 Edit reply: Check Contraints artifact: a50d7f3c4e user: kmedcalf
04:18 Reply: Check Contraints artifact: 4140413a14 user: kmedcalf
02:12 Post: Check Contraints artifact: 680295046e user: anonymous
00:22 Reply: Ubuntu SQLite 3.33 artifact: daa0d5b541 user: RacketRebel
00:06 Reply: Ubuntu SQLite 3.33 artifact: 21b411eb2a user: oneeyeman