This Day In History For 2025-06-12
1 Year Ago (more context)
2024-06-12
| ||
22:28 | • Reply: Did the Variable opcode change recently? artifact: e22eb76929 user: simonw | |
22:15 | • Reply: Did the Variable opcode change recently? artifact: e771692064 user: _blgl_ | |
21:59 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 61c7c6082b user: stephan | |
21:10 | • Reply: Read replica on same host artifact: 9bb1898230 user: multifasciatus | |
21:00 | • Post: SQLite and SQLite Cloud artifact: fb955c91ed user: slavin | |
20:56 | • Reply: Read replica on same host artifact: 400d25026b user: slavin | |
17:50 | • Edit reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 608b47df92 user: ncruces | |
17:46 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 1b03814d4a user: ncruces | |
17:17 | • Reply: Did the Variable opcode change recently? artifact: 1cafc72100 user: drh | |
16:34 | • Reply: Did the Variable opcode change recently? artifact: a07b7d4ac3 user: simonw | |
16:09 | • Reply: SQLITE_CANTOPEN at Windows background service artifact: b90bcd468f user: skorolev1962 | |
15:53 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 0b0020b656 user: stephan | |
15:41 | • Edit reply: xCheckReservedLock doc and possible WebAssembly bug artifact: d6fde1e9b3 user: ncruces | |
15:25 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 379ab624ea user: rhashimoto | |
15:12 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: a6f3bde8a3 user: stephan | |
15:06 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 629de084fb user: ncruces | |
14:22 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 9ca6916f90 user: CompuRoot | |
14:18 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 1087559189 user: rhashimoto | |
13:36 | • Edit reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: a9ba5d6ca1 user: drh | |
13:36 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 4f12554291 user: drh | |
13:32 | • Reply: SQLITE_CANTOPEN at Windows background service artifact: 15f530cb6f user: skorolev1962 | |
13:30 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: d56ffa73a7 user: stephan | |
13:28 | • Reply: SQLITE_CANTOPEN at Windows background service artifact: 637e766211 user: skorolev1962 | |
13:28 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: b879fd1ec9 user: rhashimoto | |
13:12 | • Edit reply: xCheckReservedLock doc and possible WebAssembly bug artifact: e1817873c0 user: stephan | |
13:07 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 10b81d34d7 user: stephan | |
12:24 | • Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: 2446117496 user: stephan | |
11:52 | • Reply: SQLITE_CANTOPEN at Windows background service artifact: 15342f9ab7 user: anonymous | |
11:44 | • Edit reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: e2cafbb530 user: hanche | |
11:44 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 92bf9b8c1f user: hanche | |
10:56 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: e13d34b662 user: anonymous | |
10:47 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: c90a66c2d8 user: stephan | |
10:22 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: bd469fbcf2 user: anonymous | |
10:05 | • Edit: SQLITE_CANTOPEN at Windows background service artifact: a665acd956 user: skorolev1962 | |
09:08 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 5891219bb0 user: anonymous | |
09:02 | • Post: SQLITE_CANTOPEN at Windows background service artifact: f8da601edb user: skorolev1962 | |
08:06 | • Post: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 6aa2117bcd user: anonymous | |
07:11 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 6e80c6bcf4 user: mingodad | |
07:06 | • Reply: Did the Variable opcode change recently? artifact: 523a6f38d3 user: ddevienne | |
05:16 | • Post: TextPassword connection string property on version 1.0.113.0 artifact: f3adbcfd91 user: thebigw | |
02:24 | • Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: a191c88c79 user: ThanksRyan | |
02:02 | • Post: Read replica on same host artifact: 1f67b59059 user: multifasciatus | |
02:00 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 91139087ae user: anonymous | |
01:20 | • Edit reply: Is it possible to *completely* control WAL checkpointing? artifact: 98bf1997dc user: otoolep | |
01:20 | • Reply: Is it possible to *completely* control WAL checkpointing? artifact: 0a9dba9ee5 user: otoolep | |
01:16 | • Edit: Is it possible to *completely* control WAL checkpointing? artifact: 3251b31e1e user: otoolep | |
01:16 | • Reply: Is it possible to *completely* control WAL checkpointing? artifact: e435a47a20 user: drh | |
01:11 | • Post: Is it possible to *completely* control WAL checkpointing? artifact: 83e69f7b9e user: otoolep | |
00:42 | • Reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 5aed9f7fb6 user: drh | |
2 Years Ago (more context)
2023-06-12
| ||
23:26 | • Reply: ENABLE_FTS4 missing from compile_options, but FTS4 tables work?! artifact: c04f7e1bce user: bohwaz | |
20:55 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: d98d7e03a8 user: kmedcalf | |
20:47 | • Reply: Better explanation about Readonly and ATTACH database artifact: 1a12bb076b user: kmedcalf | |
20:44 | • Reply: Better explanation about Readonly and ATTACH database artifact: 3adb34e682 user: jbulow | |
20:40 | • Reply: Better explanation about Readonly and ATTACH database artifact: d86a6d5993 user: jbulow | |
20:38 | • Reply: Better explanation about Readonly and ATTACH database artifact: 82583b92d2 user: kmedcalf | |
20:31 | • Reply: Better explanation about Readonly and ATTACH database artifact: 8cde9a238b user: jbulow | |
20:26 | • Reply: Better explanation about Readonly and ATTACH database artifact: a3149982ad user: jbulow | |
20:20 | • Reply: Better explanation about Readonly and ATTACH database artifact: 5a1f157c83 user: kmedcalf | |
20:12 | • Reply: Better explanation about Readonly and ATTACH database artifact: 0cc68a6b8e user: kmedcalf | |
20:08 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: 3c692a4a04 user: kmedcalf | |
20:06 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: e5aaed224b user: kmedcalf | |
20:05 | • Reply: Better explanation about Readonly and ATTACH database artifact: 54bdea64c4 user: kmedcalf | |
19:59 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: 579a7ecd4e user: jbulow | |
19:52 | • Reply: Better explanation about Readonly and ATTACH database artifact: 56b250db2c user: jbulow | |
19:35 | • Reply: Better explanation about Readonly and ATTACH database artifact: 423b110b94 user: jbulow | |
19:33 | • Reply: Better explanation about Readonly and ATTACH database artifact: c95bcb33e6 user: kmedcalf | |
19:26 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: 50d14d5c6b user: kmedcalf | |
19:25 | • Reply: Better explanation about Readonly and ATTACH database artifact: 82ff197c80 user: jbulow | |
19:24 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: f368c62e90 user: kmedcalf | |
19:23 | • Reply: Better explanation about Readonly and ATTACH database artifact: 523f89a4c2 user: kmedcalf | |
18:57 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: e72750fd6a user: kmedcalf | |
18:57 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: 35da4b8415 user: kmedcalf | |
18:54 | • Edit reply: regexp bug? or brain flatulence? artifact: 99ab6b2c8f user: mark | |
18:54 | • Reply: Better explanation about Readonly and ATTACH database artifact: ae2cd185e7 user: kmedcalf | |
18:53 | • Reply: regexp bug? or brain flatulence? artifact: 785a427b2a user: mark | |
18:51 | • Edit reply: regexp bug? or brain flatulence? artifact: b9a52fc5b1 user: mark | |
18:49 | • Reply: regexp bug? or brain flatulence? artifact: 6874cbacf2 user: mark | |
18:48 | • Reply: Better explanation about Readonly and ATTACH database artifact: 43aaa589b0 user: kmedcalf | |
18:47 | • Reply: regexp bug? or brain flatulence? artifact: d1c9f5872a user: larrybr | |
18:46 | • Reply: regexp bug? or brain flatulence? artifact: 5903de0fba user: larrybr | |
18:44 | • Edit reply: Better explanation about Readonly and ATTACH database artifact: 67760aed0f user: jbulow | |
18:43 | • Reply: regexp bug? or brain flatulence? artifact: 3c2d37b749 user: dvdraymond | |
18:42 | • Reply: regexp bug? or brain flatulence? artifact: 97358fbf9c user: mark | |
18:40 | • Edit reply: regexp bug? or brain flatulence? artifact: bf7f3bee02 user: TripeHound | |
18:39 | • Reply: regexp bug? or brain flatulence? artifact: b72572d31a user: TripeHound | |
18:34 | • Reply: regexp bug? or brain flatulence? artifact: e3df5953b8 user: kmedcalf | |
18:30 | • Reply: regexp bug? or brain flatulence? artifact: d20099bae6 user: wyoung | |
18:26 | • Reply: Better explanation about Readonly and ATTACH database artifact: f0e65ba6b5 user: jbulow | |
18:06 | • Post: regexp bug? or brain flatulence? artifact: 7dcdff2b36 user: larrybr | |
17:35 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 7fe80617d8 user: drh | |
17:30 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 0e50f54a38 user: drh | |
17:24 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 9ef270ca33 user: dvdraymond | |
16:58 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 39ea3ba4d2 user: kmedcalf | |
16:48 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: f489ad73ae user: drh | |
16:35 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: d5c5126844 user: drh | |
16:30 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: f4abea281d user: drh | |
15:54 | • Edit reply: Option to make SQLite stricter with non-aggregate columns artifact: cc68a0bf56 user: kmedcalf | |
15:42 | • Edit reply: Full bloom filter blob capacity is never used? artifact: ee1a11518c user: larrybr | |
15:42 | • Edit reply: Option to make SQLite stricter with non-aggregate columns artifact: c3f512c45c user: kmedcalf | |
15:40 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: f3a452365b user: kmedcalf | |
15:33 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 513395a9ae user: kmedcalf | |
15:16 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 4c8a673560 user: drh | |
15:14 | • Reply: Full bloom filter blob capacity is never used? artifact: bd47028383 user: spindrift | |
15:00 | • Reply: System.Data.SQLite version 1.0.118.0 released artifact: 862fe4bf58 user: mistachkin | |
14:24 | • Edit reply: When does a pointer to column text become invalid? artifact: 2d89fd2d3a user: kmedcalf | |
14:23 | • Reply: When does a pointer to column text become invalid? artifact: 0c0951b79e user: kmedcalf | |
14:17 | • Post: When does a pointer to column text become invalid? artifact: aa14300eea user: baruch | |
13:52 | • Reply: Full bloom filter blob capacity is never used? artifact: d44d40c326 user: dan | |
13:41 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: d07394d751 user: jicman | |
12:47 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: bff9bd737a user: stephan | |
12:37 | • Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 76da48f074 user: anonymous | |
12:06 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 52f5664c07 user: dvdraymond | |
11:34 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: f3f1a4a09e user: mukeshsharma | |
10:43 | • Reply: System.Data.SQLite version 1.0.118.0 released artifact: 23dcfedb69 user: AAsk1902 | |
10:36 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: aca1c96550 user: chrisjlocke1 | |
10:34 | • Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: b66e4fc08d user: gunter_hick | |
10:19 | • Post: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: 64d36440e4 user: mukeshsharma | |
09:55 | • Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 5762fbffbc user: sqbright777 | |
09:23 | • Reply: ENABLE_FTS4 missing from compile_options, but FTS4 tables work?! artifact: b10cd8312f user: phil_g | |
08:32 | • Post: SQLfast v5 now available artifact: 15b363d9be user: JLHainaut | |
07:39 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 9281eab5a2 user: ddevienne | |
07:13 | • Post: ENABLE_FTS4 missing from compile_options, but FTS4 tables work?! artifact: bc88bf237f user: bohwaz | |
06:09 | • Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: e7cd0b0cfe user: gunter_hick | |
3 Years Ago (more context)
2022-06-12
| ||
15:34 | • Reply: WAL File Grows Past Auto Checkpoint Limit artifact: a188951b80 user: abarr6 | |
12:42 | • Reply: Aggregate function by multiple columns artifact: ecbdf71c2d user: burdiyan | |
04:50 | • Post: Emulating MATCH in a join artifact: f523427b68 user: dlanod | |
03:23 | • Reply: view can't find temp table artifact: 1e0fae029e user: kmedcalf | |
03:16 | • Reply: view can't find temp table artifact: 920d65a84b user: kmedcalf | |
00:46 | • Reply: view can't find temp table artifact: f2ec13660c user: anonymous | |
4 Years Ago (more context)
2021-06-12
| ||
23:49 | • Post: Extract files from sqlar with a directory prepended artifact: 4f099a2dda user: 6kEs4Majrd | |
23:48 | • Post: Doc: »generalized ALTER TABLE procedure« treatment of VIEWs artifact: 706bbd839c user: bjoern | |
22:49 | • Post: Bug: ALTER TABLE RENAME COLUM TO vs CTE VIEWs artifact: f697890752 user: bjoern | |
17:54 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: dadc5aa13b user: anonymous | |
15:28 | • Reply: Bug: `GENERATED ALWAYS` constraint ends up in column type artifact: 85d7ea4d72 user: drh | |
14:34 | • Post: Bug: `GENERATED ALWAYS` constraint ends up in column type artifact: ff3ffe0925 user: bjoern | |
09:38 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 6831c4fbf2 user: slavin | |
09:34 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 319cc731ef user: slavin | |
09:33 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 436854dfbc user: slavin | |
08:53 | • Reply: RTree on ESP32 SQLite Version artifact: 1baa823090 user: arundale | |
04:15 | • Edit reply: documention: is DISTINCT optinoal in funtion? artifact: 3ac28f03b5 user: kmedcalf | |
04:14 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: 5b48a06152 user: kmedcalf | |
04:10 | • Edit reply: documention: is DISTINCT optinoal in funtion? artifact: 6aec83b1e1 user: kmedcalf | |
04:04 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: bf544da703 user: kmedcalf | |
04:03 | • Reply: documention: is DISTINCT optinoal in funtion? artifact: 70e1d64580 user: kmedcalf | |
02:48 | • Post: documention: is DISTINCT optinoal in funtion? artifact: c8c1e5908d user: anonymous | |
5 Years Ago (more context)
2020-06-12
| ||
22:51 | • Edit reply: DROP VIEW IF EXISTS failure artifact: 65bcdebc6d user: LarryBrasfield | |
21:28 | • Reply: closure table, prevent identical childrens names per parent artifact: 8af937df5a user: ingo | |
21:17 | • Reply: current_date, etc are functions? artifact: b9a82c3660 user: LarryBrasfield | |
20:59 | • Reply: current_date, etc are functions? artifact: f60a8e9219 user: kmedcalf | |
19:26 | • Reply: Request: stored functions/procedures artifact: 078b450ac6 user: anonymous | |
19:23 | • Reply: Show duplicate rows sorted artifact: e63cef6e90 user: kmedcalf | |
19:04 | • Reply: current_date, etc are functions? artifact: 766dd73223 user: LarryBrasfield | |
18:58 | • Reply: Show duplicate rows sorted artifact: aec193f817 user: anonymous | |
18:52 | • Reply: Show duplicate rows sorted artifact: e1bab43c36 user: anonymous | |
18:43 | • Post: current_date, etc are functions? artifact: f2397f7ea6 user: tb13 | |
18:14 | • Reply: Show duplicate rows sorted artifact: e827513718 user: kmedcalf | |
18:12 | • Reply: DROP VIEW IF EXISTS failure artifact: a37fdd1f46 user: RichardDamon | |
18:11 | • Reply: Show duplicate rows sorted artifact: 50c29d1156 user: LarryBrasfield | |
18:09 | • Reply: DROP VIEW IF EXISTS failure artifact: 93cef1d325 user: kmedcalf | |
18:04 | • Reply: DROP VIEW IF EXISTS failure artifact: 97f042a50d user: LarryBrasfield | |
17:49 | • Reply: DROP VIEW IF EXISTS failure artifact: c2020838fd user: kmedcalf | |
17:22 | • Reply: DROP VIEW IF EXISTS failure artifact: 980a771bdb user: younique | |
17:18 | • Reply: Show duplicate rows sorted artifact: 05c0fca23f user: anonymous | |
16:58 | • Reply: DROP VIEW IF EXISTS failure artifact: 0046491e5c user: RichardDamon | |
16:34 | • Edit reply: sqlite user authentication in c++ project artifact: dda968eb6f user: kmedcalf | |
16:31 | • Reply: sqlite user authentication in c++ project artifact: ad09394653 user: kmedcalf | |
16:27 | • Reply: DROP VIEW IF EXISTS failure artifact: db5637f2a4 user: kmedcalf | |
16:10 | • Reply: DROP VIEW IF EXISTS failure artifact: 8963bd67ee user: sbooth | |
16:10 | • Reply: DROP VIEW IF EXISTS failure artifact: bab456d7ba user: younique | |
15:37 | • Reply: DROP VIEW IF EXISTS failure artifact: 473dd4c8d7 user: doug9forester | |
15:20 | • Reply: DROP VIEW IF EXISTS failure artifact: 8c8063274c user: cuz | |
15:10 | • Edit reply: DROP VIEW IF EXISTS failure artifact: 160297e5e3 user: cuz | |
15:03 | • Reply: DROP VIEW IF EXISTS failure artifact: 7dcb763adc user: cuz | |
14:46 | • Reply: DROP VIEW IF EXISTS failure artifact: 97f0432502 user: LarryBrasfield | |
14:12 | • Reply: DROP VIEW IF EXISTS failure artifact: ded8b766fe user: younique | |
13:47 | • Reply: closure table, prevent identical childrens names per parent artifact: 4bb0c2b2d7 user: cladisch | |
13:39 | • Reply: DROP VIEW IF EXISTS failure artifact: b58d4ee168 user: wyoung | |
13:14 | • Reply: DROP VIEW IF EXISTS failure artifact: bbc49241c8 user: drh | |
13:03 | • Edit reply: DROP VIEW IF EXISTS failure artifact: e6d4e12080 user: drh | |
12:35 | • Post: closure table, prevent identical childrens names per parent artifact: 450a274f3b user: ingo | |
12:31 | • Reply: unable to open a database file in a btrfs readonly snapshot filesystem artifact: abc0d5be33 user: ddevienne | |
11:56 | • Reply: unable to open a database file in a btrfs readonly snapshot filesystem artifact: 63dd2d06b6 user: sqweek | |
11:55 | • Reply: Show duplicate rows sorted artifact: c78b31776e user: cuz | |
11:15 | • Post: unable to open a database file in a btrfs readonly snapshot filesystem artifact: 988f8698f8 user: sprhawk | |
10:58 | • Post: Show duplicate rows sorted artifact: f3b9379a90 user: anonymous | |
09:21 | • Reply: sqlite user authentication in c++ project artifact: 412eaa51a0 user: wyoung | |
08:20 | • Reply: sqlite user authentication in c++ project artifact: a1c2dda6a1 user: zzsedward | |
08:18 | • Delete reply: DROP VIEW IF EXISTS failure artifact: 94892ccef5 user: younique | |
08:16 | • Reply: DROP VIEW IF EXISTS failure artifact: f39981302f user: younique | |
08:06 | • Reply: DROP VIEW IF EXISTS failure artifact: 3d06c2687c user: younique | |
08:04 | • Reply: DROP VIEW IF EXISTS failure artifact: 939d279bbb user: younique | |
07:53 | • Reply: DROP VIEW IF EXISTS failure artifact: 980bd63617 user: stephan | |
07:44 | • Reply: DROP VIEW IF EXISTS failure artifact: 53a8088ce0 user: younique | |
02:38 | • Reply: DROP VIEW IF EXISTS failure artifact: 88b449f7db user: LarryBrasfield | |
02:09 | • Edit reply: .mode html fails on html content artifact: 0a86957fe1 user: LarryBrasfield | |
02:06 | • Reply: DROP VIEW IF EXISTS failure artifact: 2b36267030 user: LarryBrasfield | |