SQLite User Forum

Today In History
Login

This Day In History For 2023-07-19

1 Year Ago (more context)

2022-07-19
22:15 Edit reply: Decimal extension in amalgamation? artifact: cc57b9f5ec user: kmedcalf
22:05 Reply: Regarding julianday() precision artifact: 2353dfc938 user: kmedcalf
21:48 Reply: Cannot load lsm1 extension artifact: c0a5983a8a user: anonymous
21:41 Reply: Cannot load lsm1 extension artifact: 36ec9bd73a user: anonymous
21:15 Reply: Regarding julianday() precision artifact: 2144b45441 user: larrybr
20:07 Reply: Cannot load lsm1 extension artifact: 1518c1b58a user: larrybr
19:56 Reply: Decimal extension in amalgamation? artifact: 05dfba7554 user: kmedcalf
19:51 Post: Cannot load lsm1 extension artifact: e4a3490fe0 user: anonymous
18:54 Reply: Regarding julianday() precision artifact: ed0d6903c5 user: kmedcalf
17:18 Reply: Decimal extension in amalgamation? artifact: 24b4a0fbe9 user: SeverKetor
17:11 Edit reply: Regarding julianday() precision artifact: d7746c6e05 user: kmedcalf
17:07 Edit reply: Regarding julianday() precision artifact: 6611fbadd9 user: kmedcalf
17:05 Reply: Regarding julianday() precision artifact: 7e0413c680 user: kmedcalf
17:01 Reply: Decimal extension in amalgamation? artifact: 396cf83567 user: larrybr
16:42 Reply: Failing to ATTACH to an external database using URI artifact: 636eecb74f user: JohnSmith
14:13 Reply: Regarding julianday() precision artifact: 98b208c6e5 user: stephancb
14:08 Edit: problem attaching the database file:/etc/db/abc-db.sqlite?mode=ro?, unable to open database file artifact: 2e2737d7bc user: adil587
13:47 Post: Decimal extension in amalgamation? artifact: db56916b5d user: poundifdef
13:05 Reply: Failing to ATTACH to an external database using URI artifact: c1c1edee6a user: stephan
13:00 Reply: Failing to ATTACH to an external database using URI artifact: 29e971c5b6 user: anonymous
12:01 Post: Failing to ATTACH to an external database using URI artifact: e45b0c5751 user: JohnSmith
11:39 Edit: problem attaching the database file:/etc/db/abc-db.sqlite?mode=ro?, unable to open database file artifact: 3dfda6ad3b user: adil587
11:18 Reply: RSS feed for news artifact: c571018d73 user: anonymous
11:02 Reply: Regarding julianday() precision artifact: b6115e6ded user: hanche
11:01 Reply: Need double quotes in scv export artifact: 2b043f8fc4 user: andreas-kupries
10:43 Reply: Need double quotes in scv export artifact: 37d130f999 user: hanche
10:28 Post: problem attaching the database file:/etc/db/abc-db.sqlite?mode=ro?, unable to open database file artifact: ca53fac399 user: adil587
10:25 Reply: Need double quotes in scv export artifact: 37804286ce user: cuz
08:22 Reply: Regarding julianday() precision artifact: e74412f30e user: stephancb
07:27 Reply: How can I access db from two different processes? artifact: e6474b110d user: dkfellows
07:06 Reply: The URI parser doesn't handle spaces encoded as plus characters in parameters artifact: ed376c3e7c user: dkfellows
06:12 Reply: Need double quotes in scv export artifact: b191718657 user: Dutch123

2 Years Ago (more context)

2021-07-19
23:56 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: efe43d3f6c user: simonw
23:54 Edit reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 2eebabbbb1 user: simonw
23:54 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 6c5ac6ef78 user: simonw
23:26 Edit reply: Different comparison results in WHERE and SELECT clauses artifact: cbe3e2104a user: LY1598773890
22:58 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 533d31e500 user: rogerbinns
22:29 Post: sqlite3_deserialize double memory freeing artifact: e1cbb5f450 user: rogerbinns
22:17 Reply: Different comparison results in WHERE and SELECT clauses artifact: c9eaeba734 user: LY1598773890
22:07 Post: SDS.SEE.xml artifact: b51e708779 user: TSBSoftware
22:04 Delete reply: Different comparison results in WHERE and SELECT clauses artifact: e70dc4563d user: LY1598773890
22:00 Reply: Different comparison results in WHERE and SELECT clauses artifact: e49edaa92a user: LY1598773890
22:00 Reply: Different comparison results in WHERE and SELECT clauses artifact: 1b050e6251 user: kmedcalf
21:47 Reply: operator precedence docs missing, suggested clarifications below artifact: 4897bffd19 user: larrybr
21:37 Edit reply: operator precedence docs missing, suggested clarifications below artifact: 14ae3ecc5d user: rmariani
20:54 Reply: Different comparison results in WHERE and SELECT clauses artifact: 6075b3f357 user: drh
20:43 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: faf984d13f user: andse-t610
20:29 Reply: LIKE optimization - limitation to string literals artifact: 5ac7184892 user: w.oertl
20:05 Reply: Unexpected return from the NULL column artifact: 7823fbd6e6 user: kmedcalf
19:43 Reply: Unexpected return from the NULL column artifact: 3b70b2ac1d user: dvdraymond
19:21 Reply: Unexpected return from the NULL column artifact: 57217d7f9d user: LY1598773890
19:18 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 8a5e64124d user: andse-t610
19:05 Post: Different comparison results in WHERE and SELECT clauses artifact: 2bdb86a068 user: LY1598773890
18:58 Edit reply: Unexpected return from the NULL column artifact: a46c91af8c user: kmedcalf
18:56 Reply: Unexpected return from the NULL column artifact: 48cc1c7c6b user: kmedcalf
18:36 Post: Unexpected return from the NULL column artifact: c04814903d user: LY1598773890
18:19 Reply: LIKE optimization - limitation to string literals artifact: 5eed38ae42 user: kmedcalf
18:06 Reply: Is pragma integrity_check safe during app working? artifact: f8a5f52de1 user: gguinea
17:46 Reply: Inserting One Billion Rows in SQLite Under A Minute artifact: 1bf79b031c user: ThanksRyan
17:44 Reply: Inserting One Billion Rows in SQLite Under A Minute artifact: b8770e83b1 user: ThanksRyan
17:39 Reply: Is pragma integrity_check safe during app working? artifact: 50372c92a7 user: drh
17:19 Reply: Programmatically getting information about the 'where' clause artifact: dbd5ef5850 user: anonymous
17:19 Reply: Is pragma integrity_check safe during app working? artifact: 5d70cff4a3 user: gguinea
17:05 Reply: Programmatically getting information about the 'where' clause artifact: d4b73f1cbf user: drh
16:59 Post: Programmatically getting information about the 'where' clause artifact: 88ca56bddf user: anonymous
16:10 Reply: Is pragma integrity_check safe during app working? artifact: 7cda26315a user: drh
15:50 Post: Is pragma integrity_check safe during app working? artifact: 00c2900a8e user: gguinea
15:22 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: da324cec56 user: ThanksRyan
14:59 Edit reply: upsert-clause ON CONFLICT Railway Diagram artifact: 9dfe8391d6 user: larrybr
14:43 Reply: upsert-clause ON CONFLICT Railway Diagram artifact: ad615b98bb user: larrybr
14:19 Reply: Very obscure bug involving FTS5, triggers, RETURNING, and DBCONFIG_DEFENSIVE artifact: bdeee26d9a user: dan
12:52 Reply: Populating a tree from a flat table of subcategories artifact: 3bff990360 user: cuz
12:33 Post: upsert-clause ON CONFLICT Railway Diagram artifact: 490113917a user: MarcelF
12:11 Reply: Populating a tree from a flat table of subcategories artifact: c9993bacc6 user: ddevienne
10:49 Post: Populating a tree from a flat table of subcategories artifact: f08c1c8353 user: PyDelens
10:47 Reply: Clear shared memory DB and backup problem artifact: e6e0c80210 user: rexopl
07:01 Reply: Clear shared memory DB and backup problem artifact: b581b6b536 user: gunter_hick
06:43 Reply: LIKE optimization - limitation to string literals artifact: 19b51a9035 user: w.oertl
04:39 Post: Very obscure bug involving FTS5, triggers, RETURNING, and DBCONFIG_DEFENSIVE artifact: 21127c1160 user: wisej12
02:32 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 76a9badc6c user: simonw
00:24 Reply: operator precedence docs missing, suggested clarifications below artifact: b9902fe09a user: rmariani

3 Years Ago (more context)

2020-07-19
21:40 Reply: Multiple tables artifact: f5655c8da1 user: ingo
20:56 Reply: Multiple tables artifact: 941f3c2b7d user: joey8joey8
14:46 Edit reply: Multiple tables artifact: 499a402fe3 user: joey8joey8
14:18 Reply: Possible bug in .read when a directory is specified? artifact: a566761b6a user: anonymous
13:05 Reply: Multiple tables artifact: 4d4111c665 user: ingo
09:05 Reply: Multiple tables artifact: d467c9b212 user: joey8joey8
07:28 Reply: Multiple tables artifact: 9467553ef2 user: ingo