This Day In History For 2025-06-20
1 Year Ago (more context)
2024-06-20
| ||
23:31 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: c1b7eaa64b user: knu | |
20:11 | • Reply: Can I select a computed vs. stored value in an expression index side by side artifact: 9f65e870f7 user: drh | |
20:02 | • Post: Can I select a computed vs. stored value in an expression index side by side artifact: 5bb7e00cdc user: deonb | |
19:57 | • Reply: help for login artifact: f51808d73f user: jicman | |
19:30 | • Post: help for login artifact: a0ca5621c2 user: konjed | |
19:09 | • Reply: How to integrate with Node.js? artifact: 503377e140 user: anonymous | |
18:23 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: 26e6aa36d3 user: anonymous | |
16:03 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: d620a0c2c6 user: punkish | |
14:00 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: c3ddc17ba1 user: stephan | |
13:58 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: eaf5edba66 user: gunter_hick | |
13:23 | • Post: I would like to know if SQLite is a DBMS in the strict sense? artifact: a7d0df081f user: anonymous | |
11:40 | • Reply: How to integrate with Node.js? artifact: bd92e5e9cd user: benjamingr | |
07:05 | • Reply: How to integrate with Node.js? artifact: b8b9e840c5 user: punkish | |
01:53 | • Reply: WASM: Error getting sync handle for xWrite artifact: ff6b0f6583 user: ajitk0 | |
2 Years Ago (more context)
2023-06-20
| ||
23:50 | • Reply: sqlite3_load_extension not linked artifact: 249013b544 user: schmedward | |
22:08 | • Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 770daf31a1 user: scasaletto | |
21:15 | • Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: b9ed5e617d user: scasaletto | |
20:55 | • Reply: postgres ilike operator artifact: c19d357add user: kmedcalf | |
20:51 | • Reply: postgres ilike operator artifact: fff5b10e81 user: kmedcalf | |
19:07 | • Edit reply: postgres ilike operator artifact: e2d1cd8e30 user: kmedcalf | |
19:04 | • Reply: postgres ilike operator artifact: 23a6ce193c user: kmedcalf | |
18:33 | • Reply: postgres ilike operator artifact: 74aa3b69c3 user: holgerj | |
18:23 | • Edit reply: postgres ilike operator artifact: 1144e45d14 user: holgerj | |
17:13 | • Reply: postgres ilike operator artifact: 5e526b79ef user: kmedcalf | |
16:57 | • Reply: postgres ilike operator artifact: 59cacdbc9f user: holgerj | |
16:44 | • Edit reply: postgres ilike operator artifact: 456e4440f1 user: kmedcalf | |
16:43 | • Reply: postgres ilike operator artifact: 2ba9cb41a5 user: kmedcalf | |
16:06 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 2e9eba19b0 user: slavin | |
13:52 | • Reply: NDK compiling issue with -DSQLITE_ENABLE_ICU artifact: d3729c5396 user: aeroxr1 | |
13:04 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 57368b2087 user: jicman | |
12:12 | • Reply: postgres ilike operator artifact: 66eb999741 user: spindrift | |
10:28 | • Reply: postgres ilike operator artifact: 4babd83e39 user: renerene | |
10:27 | • Reply: SQLite used in a Xamarin app developed with Visual Studio artifact: 6ab00bc366 user: chrisjlocke1 | |
09:35 | • Reply: postgres ilike operator artifact: fe6b114861 user: spindrift | |
09:33 | • Reply: postgres ilike operator artifact: 932994c12e user: spindrift | |
09:27 | • Edit reply: postgres ilike operator artifact: cff8ac8ae3 user: hanche | |
09:23 | • Reply: postgres ilike operator artifact: 64077a06c5 user: hanche | |
09:21 | • Reply: postgres ilike operator artifact: a4efc65eb1 user: spindrift | |
09:12 | • Reply: How can I make SQLITE run slower? artifact: 2851431548 user: dkfellows | |
09:10 | • Reply: postgres ilike operator artifact: 3da902607f user: renerene | |
09:05 | • Post: SQLite used in a Xamarin app developed with Visual Studio artifact: 078a961d23 user: anonymous | |
08:45 | • Edit reply: postgres ilike operator artifact: f9a19aaa2f user: gunter_hick | |
08:44 | • Reply: postgres ilike operator artifact: 16f0fd6a4d user: gunter_hick | |
08:40 | • Reply: postgres ilike operator artifact: 5170005a27 user: spindrift | |
08:10 | • Post: postgres ilike operator artifact: baedee6060 user: renerene | |
07:31 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: ff74cebb41 user: ddevienne | |
07:21 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 5d3f240403 user: paulclinger | |
06:47 | • Edit reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 17bc51885e user: ddevienne | |
06:44 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 3ced6cf972 user: ddevienne | |
06:14 | • Post: How to recover from "freelist leaf count too big" integrity check warning? artifact: c6ced6ef3f user: paulclinger | |
05:42 | • Reply: How can I make SQLITE run slower? artifact: 4231a914cf user: anonymous | |
01:22 | • Reply: Can I tell the difference between and int and an int64? artifact: 7b844c4339 user: deonb | |
00:56 | • Reply: How can I make SQLITE run slower? artifact: 545e0bd4f7 user: doug9forester | |
3 Years Ago (more context)
2022-06-20
| ||
23:10 | • Reply: Encrypt and decrypt SQLite database artifact: 2754cd9cf9 user: chrisjlocke1 | |
22:18 | • Reply: Integer type conversion issue artifact: 0b90f91d37 user: chrisjlocke1 | |
21:59 | • Reply: Encrypt and decrypt SQLite database artifact: 75770166e9 user: chrisjlocke1 | |
20:49 | • Reply: Integer type conversion issue artifact: a5aabdf65c user: chibuikemoptimus | |
19:38 | • Reply: Encrypt and decrypt SQLite database artifact: e96fdef752 user: SarahLeroy | |
18:37 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: b88a2f5701 user: drh | |
18:03 | • Edit reply: Basic info request artifact: 5a9c635f8d user: chrisjlocke1 | |
18:02 | • Edit reply: Basic info request artifact: 7555777ede user: chrisjlocke1 | |
18:00 | • Reply: Encrypt and decrypt SQLite database artifact: 73b20db5ea user: chrisjlocke1 | |
17:42 | • Reply: Basic info request artifact: a1650222dc user: FBumpus | |
16:42 | • Edit reply: The "sqlite_schema" name is not fully first-class artifact: e6cd010d05 user: kmedcalf | |
16:35 | • Reply: The "sqlite_schema" name is not fully first-class artifact: 1a3993432b user: kmedcalf | |
16:24 | • Reply: how to download older version artifact: 2d7a61b48d user: anonymous | |
14:24 | • Post: The "sqlite_schema" name is not fully first-class artifact: d9bcd7471f user: anonymous | |
12:49 | • Reply: Unexpected Expression on ON clause artifact: 887a32bceb user: drh | |
12:25 | • Reply: Encrypt and decrypt SQLite database artifact: 936db8fe95 user: SarahLeroy | |
12:18 | • Reply: Proposed JSON enhancements. artifact: d25d36dd1b user: drjdpowell | |
11:09 | • Reply: Encrypt and decrypt SQLite database artifact: 7a984045ed user: chrisjlocke1 | |
10:28 | • Reply: Encrypt and decrypt SQLite database artifact: 5b1525c200 user: SarahLeroy | |
10:02 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: 8f6790b053 user: drh | |
10:00 | • Reply: Integer type conversion issue artifact: f7f64faa3d user: cuz | |
09:51 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: 10a616f905 user: ddevienne | |
09:28 | • Reply: Encrypt and decrypt SQLite database artifact: 323b02b388 user: SarahLeroy | |
09:09 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: fac11bdd16 user: cuz | |
08:52 | • Reply: Integer type conversion issue artifact: 37d577b04f user: chibuikemoptimus | |
08:50 | • Reply: Integer type conversion issue artifact: 3255514b97 user: chibuikemoptimus | |
08:12 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: 92783873cb user: ddevienne | |
08:10 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: 8ea80186ad user: chrisjlocke1 | |
07:29 | • Post: Unexpected Expression Result by FULL OUTER JOIN artifact: 6650cd40b5 user: bajinsheng | |
07:23 | • Post: Unexpected Expression on ON clause artifact: 57bdf2217d user: bajinsheng | |
4 Years Ago (more context)
2021-06-20
| ||
21:14 | • Reply: Feature request, PRAGMA for setting default transaction mode artifact: 06aded1153 user: kmedcalf | |
20:47 | • Reply: Feature request, PRAGMA for setting default transaction mode artifact: 0110ffe339 user: anonymous | |
18:47 | • Reply: Feature request, PRAGMA for setting default transaction mode artifact: 856f63cca7 user: RichardDamon | |
17:41 | • Post: Feature request, PRAGMA for setting default transaction mode artifact: 69d3e812f3 user: anonymous | |
17:32 | • Post: FILTER clause with window functions artifact: 8eac9c99e2 user: RoboManni | |
14:09 | • Reply: How to ReadUncommitted for c# .net framework 4.5 artifact: a85312ad15 user: anonymous | |
13:03 | • Reply: Division by decimals wrongly returning a rounded int result (works fine when casting to real) artifact: 3b2148a78d user: bellini | |
5 Years Ago (more context)
2020-06-20
| ||
22:55 | • Reply: Decimal128 artifact: 591f15f9b3 user: kmedcalf | |
21:57 | • Post: C API for holding shm file in cache memory on Mac OS X and Linux? artifact: 772444b72b user: 6kEs4Majrd | |
20:55 | • Reply: table locked when dropping a temp table artifact: 352ccef3d1 user: olivluca | |
20:40 | • Reply: table locked when dropping a temp table artifact: 33c7f0e489 user: olivluca | |
19:59 | • Reply: Decimal128 artifact: 57a0646019 user: RichardDamon | |
19:59 | • Reply: Decimal128 artifact: 7e1a5ea68a user: RichardDamon | |
19:45 | • Reply: Decimal128 artifact: bfbc850065 user: RichardDamon | |
18:49 | • Reply: table locked when dropping a temp table artifact: fdad9a1497 user: cuz | |
18:42 | • Reply: Decimal128 artifact: c854718027 user: LarryBrasfield | |
18:18 | • Reply: Decimal128 artifact: ce6886f64d user: kmedcalf | |
18:07 | • Edit reply: Decimal128 artifact: b3afd73cc5 user: LarryBrasfield | |
18:03 | • Reply: Decimal128 artifact: 100935b28e user: LarryBrasfield | |
17:26 | • Reply: Decimal128 artifact: 28a7ce1735 user: RichardDamon | |
17:13 | • Reply: table locked when dropping a temp table artifact: 69b2da4580 user: olivluca | |
17:10 | • Reply: table locked when dropping a temp table artifact: 8e16b9e0bf user: olivluca | |
16:56 | • Reply: Decimal128 artifact: 9c8399275e user: kmedcalf | |
15:37 | • Reply: Decimal128 artifact: c21cead993 user: anonymous | |
13:59 | • Reply: Decimal128 artifact: 469bef74e2 user: RichardDamon | |
13:29 | • Reply: Decimal128 artifact: dbafc5ddad user: naklers | |
13:26 | • Edit reply: Decimal128 artifact: ef6109d9a4 user: naklers | |
13:25 | • Edit reply: Decimal128 artifact: 3c73cb32bb user: naklers | |
13:19 | • Reply: Decimal128 artifact: bcee2945e4 user: naklers | |
13:17 | • Reply: Decimal128 artifact: 6bfad961e6 user: naklers | |
12:54 | • Reply: Decimal128 artifact: 496dbc3a0a user: cuz | |
12:28 | • Reply: table locked when dropping a temp table artifact: 505c5ab8a8 user: cuz | |
10:38 | • Reply: warning: function may return address of local variable -Wreturn-local-addr artifact: 9d21046eab user: chriscarson | |
10:21 | • Reply: Performance issues with query parameters vs. static strings artifact: 7fe4b41710 user: Flohack | |
10:01 | • Edit: Newbie question: Decision for database model artifact: 136ec43c24 user: nji9nji9 | |
10:00 | • Reply: Newbie question: Decision for database model artifact: 075e58ed3a user: nji9nji9 | |
09:48 | • Reply: Newbie question: Decision for database model artifact: 9c0fec9fff user: LarryBrasfield | |
09:40 | • Reply: Visualizing r-tree structure artifact: c0ebf20ebe user: andrea.aime | |
09:28 | • Reply: Using coalesce in where clause artifact: dddd3a1f8e user: anonymous | |
09:14 | • Post: Newbie question: Decision for database model artifact: 107ff73451 user: nji9nji9 | |
08:35 | • Edit reply: Performance issues with query parameters vs. static strings artifact: a177d6e22c user: wmertens | |
08:35 | • Reply: Performance issues with query parameters vs. static strings artifact: ec3527101e user: wmertens | |
08:29 | • Reply: Add win32 resource file to amalgamation archive artifact: 873839407e user: nnemkin | |
07:42 | • Reply: Decimal128 artifact: 34eee56332 user: doug9forester | |
07:35 | • Reply: Performance issues with query parameters vs. static strings artifact: 6fee60c8c0 user: Clothears | |
07:07 | • Reply: Decimal128 artifact: 1e8decae4a user: luuk | |
06:33 | • Reply: Performance issues with query parameters vs. static strings artifact: 30997d5452 user: stephan | |
06:25 | • Reply: table locked when dropping a temp table artifact: c2f34e1874 user: olivluca | |
02:47 | • Reply: Decimal128 artifact: c82232d79f user: kmedcalf | |
02:07 | • Reply: Decimal128 artifact: 0c86cefeba user: wyoung | |
01:04 | • Reply: Querying first of each month artifact: ab9baa502d user: bsingman | |
00:33 | • Reply: Decimal128 artifact: c9263cbdfd user: drh | |
00:04 | • Reply: Performance issues with query parameters vs. static strings artifact: 24cf33cb3d user: _Neal_ | |