SQLite User Forum

Today In History
Login

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