SQLite User Forum

Today In History
Login

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_