SQLite User Forum

Today In History
Login

This Day In History For 2025-10-14

1 Year Ago (more context)

2024-10-14
23:11 Reply: Extremely slow enumeration by primary key in large table artifact: 3e513dbe51 user: drh
22:37 Post: Extremely slow enumeration by primary key in large table artifact: 972dcc7367 user: snej
22:36 Reply: Optimizing SQLite for readonly low latency queries artifact: 446ad7a420 user: sqlitening
19:25 Reply: Can't build Windows sqlite3.exe using cygwin artifact: c3af3fcea0 user: jicman
18:58 Reply: Dump cannot be imported artifact: 9d23513241 user: blackbit
18:30 Reply: Can't build Windows sqlite3.exe using cygwin artifact: 3afcfedb6b user: drh
18:27 Reply: Can't build Windows sqlite3.exe using cygwin artifact: 84dc7640fa user: drh
15:44 Reply: Can't build Windows sqlite3.exe using cygwin artifact: e89e336bf8 user: jicman
15:43 Reply: Can't build Windows sqlite3.exe using cygwin artifact: ce18e974f0 user: jicman
14:13 Reply: Support artifact: 40049a121c user: slavin
14:09 Reply: Can't build Windows sqlite3.exe using cygwin artifact: 72de424221 user: stephan
14:03 Reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: b13a700ac2 user: rogerbinns
13:51 Reply: Can't build Windows sqlite3.exe using cygwin artifact: 341d433091 user: jicman
11:50 Reply: Dump cannot be imported artifact: e38fc2a438 user: drh
07:43 Reply: Optimizing SQLite for readonly low latency queries artifact: 6dcac9fdf1 user: ralfbertling
02:06 Reply: Support artifact: 96567fdff6 user: drh
02:04 Edit reply: Support artifact: dd32981e91 user: stephan
02:03 Reply: Support artifact: 63d9139c0b user: stephan
01:31 Post: Support artifact: 65b701e884 user: anonymous
01:16 Reply: .expert Broken Error Message artifact: 3fc3730852 user: stephan
00:23 Reply: .expert Broken Error Message artifact: 14bc68adb5 user: SeverKetor

2 Years Ago (more context)

2023-10-14
23:29 Reply: UNIQUE column allowing only a single NULL value artifact: 85ed54b672 user: anonymous
21:28 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 2e5bd2f1f6 user: drh
21:06 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 6dd4fb9a32 user: stephan
20:55 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 0dff924953 user: Clothears
20:48 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 97f35a0453 user: stephan
20:40 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 1571492553 user: larrybr
20:32 Post: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 96c1152d35 user: stephan
19:59 Reply: How does SQLite store tables and delete rows? artifact: 7cb92e55df user: drh
19:59 Reply: How does SQLite store tables and delete rows? artifact: 88344e1167 user: stephan
19:48 Post: How does SQLite store tables and delete rows? artifact: 600044d7b7 user: anonymous
19:17 Reply: UNIQUE column allowing only a single NULL value artifact: 489d623e0a user: larrybr
19:06 Reply: (Deleted) artifact: 003816e968 user: JLHainaut
19:02 Reply: dynamic date query with COUNT and Python artifact: b4a61711f2 user: larrybr
18:59 Reply: UNIQUE column allowing only a single NULL value artifact: 948691691c user: younique
18:46 Reply: UNIQUE column allowing only a single NULL value artifact: c19eadcc92 user: younique
18:07 Post: dynamic date query with COUNT and Python artifact: 16d7598ff4 user: anonymous
16:35 Reply: Error Opening Sqlite artifact: 0a059729b8 user: larrybr
15:24 Post: Error Opening Sqlite artifact: e12a0a16fd user: PaterB
14:12 Edit reply: Experience with SQLite as a store of Files and Images artifact: 618cc6e288 user: stephan
13:44 Reply: Experience with SQLite as a store of Files and Images artifact: 4c04dfc49e user: drh
12:26 Reply: UNIQUE column allowing only a single NULL value artifact: 08c60d3075 user: anonymous
12:24 Reply: Experience with SQLite as a store of Files and Images artifact: a4bc623ee3 user: slavin
08:51 Reply: UNIQUE column allowing only a single NULL value artifact: 362ddf0be9 user: lifepillar
01:33 Post: Update config.{sub,guess} artifact: 90017582f5 user: anonymous

3 Years Ago (more context)

2022-10-14
23:15 Reply: System.Data.SQLite on macOS using C# ? artifact: 22d2124dac user: npalardy
21:55 Reply: finding rows that contain a non-numeric character artifact: 80b61841bb user: anonymous
21:44 Reply: finding rows that contain a non-numeric character artifact: c4dfa27f35 user: cleverly
20:53 Edit reply: finding rows that contain a non-numeric character artifact: 598f4b0c1a user: punkish
20:35 Reply: finding rows that contain a non-numeric character artifact: 587762cb21 user: punkish
20:32 Reply: finding rows that contain a non-numeric character artifact: 4014c0a860 user: punkish
20:31 Reply: finding rows that contain a non-numeric character artifact: 7b28a08e37 user: cleverly
20:29 Reply: finding rows that contain a non-numeric character artifact: da843cbfe4 user: chrisjlocke1
20:20 Reply: finding rows that contain a non-numeric character artifact: 60fb641eba user: punkish
20:13 Reply: finding rows that contain a non-numeric character artifact: 66d368784d user: cleverly
19:46 Post: finding rows that contain a non-numeric character artifact: 8d476ada6f user: punkish
18:38 Edit reply: Persist query plans? artifact: d96122c249 user: jicman
18:36 Edit reply: Persist query plans? artifact: 6fab786d8f user: jicman
17:36 Reply: Persist query plans? artifact: ab489f3957 user: jicman
17:04 Reply: Persist query plans? artifact: 49268ef6b9 user: chrisjlocke1
16:55 Reply: Persist query plans? artifact: cdf457f793 user: dvdraymond
16:48 Reply: Persist query plans? artifact: af110b1fa6 user: Clothears
16:26 Reply: Persist query plans? artifact: e5723126c8 user: biodrool
16:18 Reply: Persist query plans? artifact: 69a57ccbed user: dvdraymond
15:55 Post: Persist query plans? artifact: 083de03448 user: biodrool
15:12 Reply: Bug Report and Patch: LIKE operator mishandles U+0080 artifact: 05b33caf05 user: dan
12:29 Edit reply: sqlite3_update_hook - which changes are consiered? artifact: 524b9656ce user: jtheisen42
12:15 Reply: sqlite3_update_hook - which changes are consiered? artifact: 2a3c3c9d97 user: jtheisen42
12:00 Post: Bug Report and Patch: LIKE operator mishandles U+0080 artifact: 61bf7ccbdf user: chys00
11:29 Reply: sqlite3_update_hook - which changes are consiered? artifact: dbba5f96e8 user: ddevienne
11:13 Reply: sqlite3_update_hook - which changes are consiered? artifact: 83cba5700f user: gunter_hick
06:15 Reply: System.Data.SQLite on macOS using C# ? artifact: 644a9f278a user: chrisjlocke1
02:32 Post: sqlite3_update_hook - which changes are consiered? artifact: 58794c2d2d user: jtheisen42

4 Years Ago (more context)

2021-10-14
20:50 Edit reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: 12b7857bbb user: mistachkin
18:15 Reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: eeaefb84ec user: mistachkin
15:27 Reply: sqlite .archive can't handle big files? artifact: 91ecd7cf73 user: schmitzu
15:06 Reply: sqlite .archive can't handle big files? artifact: e64e94a17a user: stephan
15:01 Post: sqlite .archive can't handle big files? artifact: 7d167e2a80 user: schmitzu
14:59 Reply: Pragma_Function_List() artifact: bba5790bc0 user: stephan
14:49 Edit reply: Pragma_Function_List() artifact: 65f256e964 user: ddevienne
14:47 Reply: Pragma_Function_List() artifact: 130b2f8c14 user: anonymous
14:46 Reply: binary .dump format artifact: b6eae8e5c9 user: RichardDamon
14:33 Edit reply: binary .dump format artifact: 698355ddf8 user: slavin
14:33 Reply: binary .dump format artifact: 7501594306 user: slavin
14:04 Reply: Pragma_Function_List() artifact: 48b468b7e4 user: drh
13:43 Reply: Pragma_Function_List() artifact: 7872a4aa18 user: ddevienne
13:22 Post: Pragma_Function_List() artifact: 76ab9d8b72 user: anonymous
12:07 Reply: binary .dump format artifact: 46fee948f9 user: RichardDamon
11:58 Reply: sqldiff for Windows 10 x 64 bits artifact: 1b2b1a1424 user: knu
11:47 Reply: binary .dump format artifact: 0a013984da user: ddevienne
10:10 Edit reply: binary .dump format artifact: 442587d3b7 user: slavin
10:08 Reply: binary .dump format artifact: 02470db818 user: slavin
09:06 Post: sqldiff for Windows 10 x 64 bits artifact: 31ba540c4a user: anonymous
09:03 Post: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: 1d1c43493a user: acatanzaro
06:54 Reply: inconsistent output: insert on conflict with returning artifact: 9cc8c73efc user: ddevienne
06:05 Reply: Different time spent in Windows and Linux artifact: ba83948884 user: Lyalot
03:18 Reply: SIGBUS in sqlite artifact: cf32387473 user: liziqi

5 Years Ago (more context)

2020-10-14
18:16 Reply: WHERE a IN (SELECT non-existing column ) artifact: 5f1d43a20d user: kmedcalf
18:07 Reply: WHERE a IN (SELECT non-existing column ) artifact: af72711e97 user: drh
17:57 Post: WHERE a IN (SELECT non-existing column ) artifact: 0125cd068c user: moskvich412
16:57 Post: 'SQL logic error no such module: fts5' artifact: 05b8e74d07 user: zrzr23
16:38 Reply: update-from on without rowid virtual tables artifact: 42def3a589 user: kev82
15:38 Reply: update-from on without rowid virtual tables artifact: 8798cb45bb user: drh
13:58 Reply: Lack of abstraction ability in SQLite artifact: c267198590 user: cuz
13:51 Reply: Lack of abstraction ability in SQLite artifact: 773d63a809 user: gunter_hick
13:39 Reply: update-from on without rowid virtual tables artifact: fd6418cedd user: gunter_hick
13:37 Reply: Lack of abstraction ability in SQLite artifact: a1b9ccc564 user: knu
13:06 Reply: update-from on without rowid virtual tables artifact: 51489c3df8 user: kev82
12:43 Reply: Error: near line 1: no such module: fts5 artifact: 9b0a4b210c user: mattkuine
12:37 Reply: update-from on without rowid virtual tables artifact: 1f56f76e9b user: gunter_hick
10:47 Reply: update-from on without rowid virtual tables artifact: 9a8d5c6845 user: kev82
09:14 Edit reply: update-from on without rowid virtual tables artifact: b0c63169e6 user: gunter_hick
09:11 Reply: update-from on without rowid virtual tables artifact: dd39544eb3 user: gunter_hick
08:58 Post: Lack of abstraction ability in SQLite artifact: 1042988a22 user: mattkuine
08:12 Reply: update-from on without rowid virtual tables artifact: 89099ee832 user: kev82
07:07 Edit reply: update-from on without rowid virtual tables artifact: 2395594044 user: kev82