SQLite User Forum

Today In History
Login

This Day In History For 2025-10-26

1 Year Ago (more context)

2024-10-26
23:57 Reply: Find none overlapping intervals artifact: 57318c4ef1 user: AAsk1902
22:56 Reply: Suggestion for something worth mentioning on quirks.html artifact: f3f924d93a user: ncruces
22:23 Reply: Feature Request: Increase Maximum Page Limit artifact: df995504d7 user: nuclight
22:21 Post: Algorithms - minimizing number of page touches artifact: 841974afd4 user: nuclight
21:52 Reply: Ever read ahead/prefetch hints? artifact: a2d243bf2f user: nuclight
21:36 Reply: struct DateTime in src/date.c artifact: c9da54bed5 user: nuclight
21:32 Reply: Can one assign variables in sqlite3 artifact: 3b1a8510f6 user: nuclight
21:03 Post: Suggestion for something worth mentioning on quirks.html artifact: 8e0c5954a2 user: tbodt_
19:15 Reply: Path issues in buildtclext.tcl artifact: fe6143ceb2 user: drh
18:35 Reply: Announce: migration of the build system to autosetup artifact: 08f43a1709 user: stephan
18:21 Reply: What is the expected output of "PRAGMA optimize(-1);" ? artifact: 72d235ba9f user: anonymous
18:16 Reply: Find none overlapping intervals artifact: 0ad0adb0f8 user: itandetnik
18:15 Post: cte-problem artifact: a57ffe56d3 user: anonymous
18:05 Reply: Join happens before it needs to, making the query slow artifact: 95fe67d537 user: itandetnik
18:03 Reply: Find none overlapping intervals artifact: daa1e85386 user: chrisjlocke1
16:50 Edit reply: Announce: migration of the build system to autosetup artifact: 6126d46747 user: stephan
16:49 Reply: Announce: migration of the build system to autosetup artifact: 6a0f1efa97 user: stephan
16:17 Post: Find none overlapping intervals artifact: f837635673 user: mlsull
15:39 Edit reply: Announce: migration of the build system to autosetup artifact: 56096d2cfb user: stephan
15:38 Reply: Announce: migration of the build system to autosetup artifact: a7a4551fe1 user: stephan
13:36 Post: Join happens before it needs to, making the query slow artifact: 738db36e59 user: Bomi__
11:02 Reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: ef3725b4aa user: sqlite_jnosh
10:21 Reply: Announce: migration of the build system to autosetup artifact: 65d2076644 user: mark
10:04 Reply: Announce: migration of the build system to autosetup artifact: 1653ddcbcb user: mark
09:43 Edit reply: Announce: migration of the build system to autosetup artifact: d110f713de user: mark
09:41 Edit reply: Announce: migration of the build system to autosetup artifact: cec0293c0c user: mark
09:40 Reply: Announce: migration of the build system to autosetup artifact: dad47fd60e user: mark
09:28 Reply: Announce: migration of the build system to autosetup artifact: c7c7b8be27 user: mark
08:17 Reply: Announce: migration of the build system to autosetup artifact: 6099080eaf user: curmudgeon
04:31 Reply: Announce: migration of the build system to autosetup artifact: ca691ad862 user: stephan
04:29 Reply: Announce: migration of the build system to autosetup artifact: d3ebe33e93 user: stephan
03:20 Reply: What is the expected output of "PRAGMA optimize(-1);" ? artifact: b54dc69cdb user: lexfiend
01:28 Reply: Removing rowid from table, will it affect sqlite journaling artifact: 84c4eac15e user: sqlitening
00:39 Reply: Official support for BEGIN CONCURRENT artifact: 619d939756 user: ncruces

2 Years Ago (more context)

2023-10-26
23:46 Reply: Asking again about virtual table bestIndex issue artifact: f62aa22f4e user: alexgarciaxyz
22:09 Reply: Select up to last entered date instead of 'now' artifact: 8b181fa27f user: doug9forester
21:40 Reply: Select up to last entered date instead of 'now' artifact: 62f9d6454e user: anonymous
20:19 Reply: Select up to last entered date instead of 'now' artifact: 13a2655551 user: CecilWesterhof
20:06 Reply: Eponymous virtual table for attached database? artifact: 0d56bfdd89 user: ahtoh_
20:03 Reply: Confirmations about the custom build documentation artifact: 0a9f04bc15 user: rayB
19:50 Post: Asking again about virtual table bestIndex issue artifact: 24a72ddfe7 user: snej
19:30 Edit reply: Connection Closes blocks all other threads artifact: 1f0bfebf77 user: jicman
18:53 Reply: Connection Closes blocks all other threads artifact: 43b84bc484 user: jicman
17:15 Reply: Connection Closes blocks all other threads artifact: b13d718467 user: anonymous
17:15 Reply: Select up to last entered date instead of 'now' artifact: ed9f1beccc user: anonymous
15:06 Edit: Select up to last entered date instead of 'now' artifact: d2e349f7e6 user: CecilWesterhof
15:01 Reply: Select up to last entered date instead of 'now' artifact: 14b7a468fd user: CecilWesterhof
14:58 Reply: Select up to last entered date instead of 'now' artifact: 9203c34fcb user: CecilWesterhof
14:16 Reply: Confirmations about the custom build documentation artifact: 154a571855 user: ncruces
14:11 Reply: Confirmations about the custom build documentation artifact: 0fdb936285 user: ncruces
13:31 Reply: Select up to last entered date instead of 'now' artifact: 2357ca0108 user: dvdraymond
13:31 Edit reply: Select up to last entered date instead of 'now' artifact: 0b0b50d66a user: jicman
13:29 Reply: Select up to last entered date instead of 'now' artifact: f486bae0b2 user: jicman
13:05 Post: Select up to last entered date instead of 'now' artifact: 0a1a7568d1 user: CecilWesterhof
12:29 Reply: Confirmations about the custom build documentation artifact: 4eb6b88a4c user: anonymous
12:29 Reply: sqlite3.exe for Windows cannot be compiled currently with MinGW artifact: c961af52f4 user: larrybr
12:17 Post: Eponymous virtual table for attached database? artifact: e023d736bf user: paulvh
12:03 Post: sqlite3.exe for Windows cannot be compiled currently with MinGW artifact: c3ef1a72e7 user: anonymous
09:36 Reply: Confirmations about the custom build documentation artifact: ce3ddd2642 user: fbaube
07:44 Post: (Deleted) artifact: f15015d046 user: anonymous
00:56 Reply: SQLite version 3.44.0 now in beta artifact: dcbb75d3e3 user: ncruces
00:07 Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: bd254e2607 user: anonymous

3 Years Ago (more context)

2022-10-26
21:25 Reply: Local time zone UTC offset in SQLite query artifact: 86e6019bca user: stephancb
20:43 Edit reply: Local time zone UTC offset in SQLite query artifact: e6956ef482 user: guavascript
20:27 Reply: Integrity check failures on Mac OS artifact: f7e7962119 user: dfgriggs
20:03 Reply: Minor spelling mistake in SELECT docs, Section 9.2 artifact: 1bb5499b89 user: drh
19:43 Post: Integrity check failures on Mac OS artifact: 7a3cebf88a user: anonymous
19:09 Post: Minor spelling mistake in SELECT docs, Section 9.2 artifact: 1af006ebaf user: mikaylam
18:37 Reply: fiddle 2022-10-26 artifact: 4bc6a20dff user: WaKa_sqllite
17:48 Reply: Local time zone UTC offset in SQLite query artifact: 26876bd74c user: kmedcalf
17:30 Reply: fiddle 2022-10-26 artifact: e411bb7666 user: WaKa_sqllite
17:14 Reply: Undefined reference to 'compress' artifact: 412e40a292 user: curmudgeon
17:01 Reply: Undefined reference to 'compress' artifact: 035545818a user: stephan
16:54 Reply: Local time zone UTC offset in SQLite query artifact: 781d0161d9 user: anonymous
16:49 Post: negative-size-param in dbdataNext() leading to SIGABRT artifact: 04adccdefb user: geeknik
16:46 Post: Undefined reference to 'compress' artifact: 6f0c809577 user: curmudgeon
16:43 Reply: Local time zone UTC offset in SQLite query artifact: f0dcd44c61 user: anonymous
16:06 Reply: Local time zone UTC offset in SQLite query artifact: 0c9886e986 user: stephancb
15:42 Reply: fiddle 2022-10-26 artifact: cfe2b78a97 user: stephan
15:32 Reply: fiddle 2022-10-26 artifact: 7ce312b7a6 user: stephan
15:28 Edit reply: Local time zone UTC offset in SQLite query artifact: a5006c626b user: kmedcalf
15:26 Reply: Local time zone UTC offset in SQLite query artifact: 0724cfda8c user: kmedcalf
15:14 Edit reply: Local time zone UTC offset in SQLite query artifact: adf7c10d44 user: kmedcalf
15:14 Reply: fiddle 2022-10-26 artifact: 1fa328bac7 user: drh
15:13 Reply: fiddle 2022-10-26 artifact: 9c6d0f24e7 user: stephan
15:12 Reply: Local time zone UTC offset in SQLite query artifact: 15d107382b user: kmedcalf
15:11 Reply: Local time zone UTC offset in SQLite query artifact: 68c32d99d8 user: guavascript
15:07 Post: fiddle 2022-10-26 artifact: 67d985ac0b user: WaKa_sqllite
14:50 Reply: Local time zone UTC offset in SQLite query artifact: 78dcc093fe user: anonymous
14:46 Reply: Local time zone UTC offset in SQLite query artifact: d92baea6b5 user: anonymous
14:25 Reply: feature req VACUUM INTO trigger artifact: 7746f6b2b5 user: ingo
13:20 Reply: export/import of binary data in csv artifact: 0285d8afb9 user: kjames3411
12:54 Reply: feature req VACUUM INTO trigger artifact: b7c863d61c user: slavin
12:29 Reply: Access underlying rowid even when overwritten artifact: 67d61a1d6c user: ddevienne
11:56 Edit reply: Access underlying rowid even when overwritten artifact: 325b952e69 user: cuz
11:55 Reply: Access underlying rowid even when overwritten artifact: edf23d734d user: cuz
11:54 Reply: Temp B-Tree not limited to right part when joining unclustered tables with virtual tables artifact: d8f9282f15 user: anacrolix
11:29 Reply: Access underlying rowid even when overwritten artifact: c587153cec user: gunter_hick
11:24 Reply: Temp B-Tree not limited to right part when joining unclustered tables with virtual tables artifact: 9aa4bf1bcd user: gunter_hick
11:23 Reply: Local time zone UTC offset in SQLite query artifact: 9fbe6af387 user: anonymous
11:03 Reply: Crash when try to insert data into db artifact: 721bd0339f user: gunter_hick
10:34 Post: Crash when try to insert data into db artifact: ff691cfc8c user: Gengxin.Lee
09:20 Reply: Access underlying rowid even when overwritten artifact: c0b83eb40c user: adrian.s
08:38 Reply: VACUUM INTO 'other.db' and fsync artifact: aea58a01dd user: pepijnve
06:24 Reply: feature req VACUUM INTO trigger artifact: 7713f8e015 user: ingo
05:51 Reply: Access underlying rowid even when overwritten artifact: 981628f355 user: anonymous
02:15 Reply: (Deleted) artifact: 899a7b354b user: mbenningfield1
00:28 Post: Temp B-Tree not limited to right part when joining unclustered tables with virtual tables artifact: 4400a8d215 user: anacrolix

4 Years Ago (more context)

2021-10-26
23:12 Reply: cksumvfs producing invalid checksums artifact: 6a47db65a2 user: achamb
21:46 Reply: Database on android SD CARD artifact: 605fa14ffe user: larrybr
21:32 Edit reply: Configuring SQLite to wait indefinitely artifact: fbe2f75316 user: casaderobison
21:30 Reply: Configuring SQLite to wait indefinitely artifact: 5eab27608c user: casaderobison
21:22 Edit reply: Database on android SD CARD artifact: be9094781c user: Webalchemist
21:00 Reply: Database on android SD CARD artifact: 178f0672cb user: Webalchemist
20:28 Reply: Configuring SQLite to wait indefinitely artifact: 961ea2698f user: slavin
19:41 Reply: Database on android SD CARD artifact: 65a6731d78 user: stephan
19:30 Reply: Configuring SQLite to wait indefinitely artifact: e90db2a100 user: itroot
19:18 Reply: Database on android SD CARD artifact: 7661094626 user: Webalchemist
18:17 Reply: Get SQLITE_PROTOCOL error when opening database artifact: 4bda3c9b0e user: anonymous
18:06 Reply: Get SQLITE_PROTOCOL error when opening database artifact: 2cece78f9d user: anonymous
17:57 Reply: Get SQLITE_PROTOCOL error when opening database artifact: f22d79300e user: RandomCoder
17:37 Post: Configuring SQLite to wait indefinitely artifact: 2744b798ff user: nchammas
17:22 Reply: Get SQLITE_PROTOCOL error when opening database artifact: 0de0b94877 user: larrybr
16:37 Reply: Get SQLITE_PROTOCOL error when opening database artifact: 61d6aa44a2 user: anonymous
16:24 Edit: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: c68cb87012 user: Minoru
16:18 Edit reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: bf94df725a user: larrybr
15:40 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 715037eaca user: anonymous
15:30 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 37f63aff57 user: larrybr
15:20 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 93938f101c user: anonymous
14:50 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 05bded67c9 user: larrybr
14:45 Edit reply: Get SQLITE_PROTOCOL error when opening database artifact: 629f9bdd62 user: larrybr
14:42 Reply: Get SQLITE_PROTOCOL error when opening database artifact: d3de6254b8 user: larrybr
14:39 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 1a9f396689 user: anonymous
14:32 Post: Get SQLITE_PROTOCOL error when opening database artifact: 2cdfe4f3f4 user: anonymous
14:32 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: 92ab78f89d user: Minoru
13:47 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: 29f056d0c7 user: larrybr
13:20 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: e51d19f8e6 user: billwade
12:38 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 7a5a24d36c user: anonymous
12:20 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 79e6f32064 user: billwade
11:00 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 8d10f33d81 user: anonymous
10:21 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 6733f1d20a user: drh
10:00 Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: c7e03274d8 user: stephan
09:12 Post: No ".open" option in version 3.7.17 2013-05-20 artifact: ccc79ad508 user: anonymous
04:23 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: 1bf33f0ef4 user: kmedcalf
00:45 Edit reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: a7f2f09ebf user: kmedcalf
00:43 Edit reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: cb728a42e1 user: kmedcalf
00:38 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: f162d6f95b user: kmedcalf

5 Years Ago (more context)

2020-10-26
17:57 Reply: Bug: Database schema corruption artifact: 6c96a8dfbd user: drh
17:17 Reply: Bug: Database schema corruption artifact: b21993bb56 user: kmedcalf
17:04 Reply: Bug: Database schema corruption artifact: 20856d82a9 user: drh
16:50 Reply: Bug: Database schema corruption artifact: 0ad8c45664 user: kmedcalf
16:49 Reply: Bug: Database schema corruption artifact: 7eb73e0989 user: drh
16:48 Edit reply: Bug: Database schema corruption artifact: 8e5e3f4bda user: kmedcalf
16:44 Reply: Bug: Database schema corruption artifact: 3e856b52ff user: kmedcalf
16:24 Reply: Test ext/session/sessionrebase.test:2.1.1 fails on HPPA architecture artifact: 4a49714ed0 user: dan
16:05 Post: Bug: Database schema corruption artifact: daa2c728cc user: leonbe
13:28 Reply: ext/fts5/fts5_tokenize: not handle tokens that contain embedded nul characters artifact: 09609d7e22 user: dan
10:41 Post: When will VS 2019 compatible version be released artifact: f3906dc644 user: anonymous
10:37 Reply: VACUUM temp directory artifact: 231b0aaa87 user: anonymous
03:17 Reply: The article "35% Faster Than The Filesystem" needs filesystem specification artifact: 1b42db0445 user: stephan
03:13 Post: The article "35% Faster Than The Filesystem" needs filesystem specification artifact: caa3888123 user: anonymous
02:53 Reply: Errno 2 No such file or directory artifact: 0b58d5b517 user: kmedcalf
01:48 Post: Errno 2 No such file or directory artifact: 1ecfea1d0e user: Digitek
01:27 Post: ext/fts5/fts5_tokenize: not handle tokens that contain embedded nul characters artifact: 28682c3972 user: zxh0420