SQLite User Forum

Today In History
Login

This Day In History For 2025-06-22

1 Year Ago (more context)

2024-06-22
23:24 Delete reply: (Deleted) artifact: 235631372a user: drkshadow
23:24 Edit: (Deleted) artifact: 388a3bebd1 user: drkshadow
23:24 Reply: (Deleted) artifact: 066f465ac8 user: drkshadow
21:11 Post: (Deleted) artifact: 5159da5155 user: drkshadow
18:09 Post: When will System.Data.SQLite be released for 3.46 version? artifact: e842641c6c user: anonymous
12:19 Reply: Help understanding the effect of BEGIN IMMEDIATE artifact: b6cdf4c5ec user: slavin

2 Years Ago (more context)

2023-06-22
21:25 Reply: Cheap way of doing this artifact: 5d76804931 user: drh
20:33 Reply: How is rank and bm25 related? artifact: 5130ca378e user: coleifer
19:34 Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: aab8d76817 user: holgerj
19:15 Reply: SQLite and PGO results artifact: a659ed191c user: SeverKetor
16:43 Reply: SQLite 3.8.3 or later is required (found 3.7.17) artifact: 2a1a5c3af8 user: dkfellows
14:49 Reply: SQLite and PGO results artifact: 917ec5c392 user: stephan
14:35 Reply: Cheap way of doing this artifact: 5cf6f3938b user: Clothears
14:28 Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: 9da5a8e46d user: jicman
14:17 Reply: SQLite and PGO results artifact: 7f3dc34493 user: zamazan4ik
14:14 Post: Spectre KB causes "attempt to write a readonly database" error artifact: e927eb750f user: larshf
13:55 Reply: Cheap way of doing this artifact: bd608dd412 user: dvdraymond
13:52 Reply: Cheap way of doing this artifact: 3d7843eb14 user: dvdraymond
13:49 Reply: SQLite and PGO results artifact: 63bbdb218d user: zamazan4ik
13:38 Reply: Cheap way of doing this artifact: 416ec8cf52 user: anonymous
13:19 Reply: Cheap way of doing this artifact: a07bf4bc11 user: anonymous
12:50 Post: Cheap way of doing this artifact: a669cc4924 user: Clothears
11:33 Reply: How is rank and bm25 related? artifact: 250c68ad68 user: dan
08:59 Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: b52879bbb7 user: dkfellows
07:59 Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: c6d09f12a9 user: stephan
07:15 Edit reply: SQLite and PGO results artifact: c6c21ed8ad user: ddevienne
07:13 Reply: SQLite and PGO results artifact: 75dc228777 user: ddevienne
05:34 Reply: SQLite 3.8.3 or later is required (found 3.7.17) artifact: 4af291ca03 user: gunter_hick
05:18 Reply: SQLite 3.8.3 or later is required (found 3.7.17) artifact: 0548362a8e user: anonymous
03:23 Edit reply: How is rank and bm25 related? artifact: 487493a9bc user: 961679
03:17 Reply: How is rank and bm25 related? artifact: 2e8aeb6fec user: 961679
01:35 Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: 3769b9827c user: kmedcalf
00:42 Post: SQLite 3.8.3 or later is required (found 3.7.17) artifact: ffef59a2e4 user: anonymous

3 Years Ago (more context)

2022-06-22
23:45 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: c2407619b9 user: Bazza81
22:30 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 3995ade959 user: cuz
22:15 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 0163fd9af6 user: Bazza81
21:41 Reply: Importing csv Files artifact: e27182ef17 user: knu
21:39 Edit: Help with Transaction - CLI. artifact: 4e6790916b user: midijohnny
21:30 Edit: Help with Transaction - CLI. artifact: 6e2d80bfee user: midijohnny
21:29 Post: Help with Transaction - CLI. artifact: 05c26d8014 user: midijohnny
21:05 Reply: Select only UTF8 / Unicode characters artifact: 09b2bd6e9f user: Trudge
21:03 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: ff6dda72c2 user: anonymous
20:50 Reply: Encrypt and decrypt SQLite database artifact: 7fcae37437 user: SarahLeroy
20:25 Edit reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 233b762843 user: cuz
20:25 Reply: Select only UTF8 / Unicode characters artifact: 6911717df3 user: jchd18
20:15 Reply: Select only UTF8 / Unicode characters artifact: f938869856 user: kmedcalf
20:11 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 55b85c4fe0 user: cuz
19:42 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 113f2d5e08 user: kmedcalf
19:38 Reply: Importing csv Files artifact: 5411666416 user: dfgriggs
19:37 Reply: Select only UTF8 / Unicode characters artifact: 14116cf1ee user: jchd18
18:49 Reply: Encrypt and decrypt SQLite database artifact: 5b2c761a07 user: larrybr
18:42 Reply: Restore/backup from/to shell commands? artifact: 7c8a616ab6 user: larrybr
18:35 Reply: Encrypt and decrypt SQLite database artifact: 481c2d5537 user: SarahLeroy
18:35 Edit reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: aa9b4229d3 user: ddevienne
18:24 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 7bde1d41d2 user: ddevienne
18:19 Reply: Restore/backup from/to shell commands? artifact: a3745e9449 user: mark
18:18 Reply: Importing csv Files artifact: 8b50110514 user: gjroos
18:09 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 80eb1edf40 user: cuz
17:12 Reply: Select only UTF8 / Unicode characters artifact: b46d04459b user: stephan
16:56 Reply: Select only UTF8 / Unicode characters artifact: 5ac083ebc2 user: larrybr
16:46 Reply: Select only UTF8 / Unicode characters artifact: 090b3a5fc5 user: stephan
16:20 Reply: Select only UTF8 / Unicode characters artifact: fa47f70492 user: larrybr
16:07 Reply: Select only UTF8 / Unicode characters artifact: f6d4896a9f user: hanche
16:06 Edit reply: Select only UTF8 / Unicode characters artifact: b935939c47 user: jchd18
16:05 Reply: Select only UTF8 / Unicode characters artifact: 4bbb2fad6d user: jchd18
15:56 Reply: Select only UTF8 / Unicode characters artifact: 953edbc04b user: Trudge
15:52 Reply: Add split function artifact: d6ac9458be user: alexgarciaxyz
15:35 Reply: Select only UTF8 / Unicode characters artifact: 9b4243292c user: stephan
15:24 Post: Select only UTF8 / Unicode characters artifact: 3f55b65554 user: Trudge
15:22 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: aaf038769b user: stephan
15:11 Reply: Importing csv Files artifact: 7026e0f46e user: larrybr
15:00 Reply: .head on ignored by .eqp full artifact: a8d20be02b user: larrybr
14:58 Post: Can I reserve database space to keep it working on zero fs free space? artifact: 1d803d4c81 user: anonymous
14:12 Reply: Restore/backup from/to shell commands? artifact: acc7398b22 user: drh
14:05 Reply: Restore/backup from/to shell commands? artifact: f0930d25c9 user: larrybr
14:01 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 19c969be17 user: cuz
14:00 Reply: XCommit called without xBegin artifact: 7f0cae1dee user: gunter_hick
13:51 Reply: XCommit called without xBegin artifact: 41b449dd20 user: gunter_hick
13:31 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: e47a1c6d57 user: drh
13:17 Post: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: a2938eec6a user: anonymous
13:16 Reply: Restore/backup from/to shell commands? artifact: c0a31ddc26 user: drh
13:08 Reply: Restore/backup from/to shell commands? artifact: 820e7bdcc4 user: larrybr
12:03 Reply: Encrypt and decrypt SQLite database artifact: edcd9f08bf user: chrisjlocke1
11:45 Reply: Encrypt and decrypt SQLite database artifact: 9407468699 user: chrisjlocke1
11:31 Reply: Encrypt and decrypt SQLite database artifact: 366ca1b3b1 user: SarahLeroy
10:26 Reply: Restore/backup from/to shell commands? artifact: 4130a388f1 user: kuup22
10:02 Post: Restore/backup from/to shell commands? artifact: 5f62667495 user: mark
08:47 Post: .head on ignored by .eqp full artifact: bb0bfc6410 user: kuup22
08:41 Edit reply: Special language signs in output artifact: 80253b988d user: 102022
08:40 Edit reply: Special language signs in output artifact: 7b45c9e381 user: 102022
08:40 Edit reply: Special language signs in output artifact: 20de38a3e2 user: 102022
08:15 Edit reply: Special language signs in output artifact: 3742778935 user: 102022
08:09 Reply: Special language signs in output artifact: bc10fffdf8 user: 102022
07:24 Reply: Tip: using sqlite3 to execute CLI one-liner queries against CSV files artifact: ad9d1a8f3e user: mark
02:09 Reply: Encrypt and decrypt SQLite database artifact: 4a7f34349b user: anonymous
02:00 Reply: Unexpected Parse Error artifact: 7d66c0a084 user: bajinsheng
01:42 Reply: Unexpected Parse Error artifact: 6919dff68d user: drh
00:01 Edit reply: Unexpected Parse Error artifact: e09cc4a133 user: bajinsheng
00:00 Reply: Unexpected Parse Error artifact: 0f44067d71 user: bajinsheng

4 Years Ago (more context)

2021-06-22
23:39 Reply: A crash bug in MULTI-INDEX OR artifact: 95006fb298 user: drh
23:11 Reply: Extension Wraping functions with ability to throw error and abort query artifact: f8d4c6daba user: anonymous
23:06 Reply: Integer overflow risk in sqlite3_changes and underlying counter? artifact: 9055b7a8a1 user: larrybr
17:39 Edit: A crash bug in MULTI-INDEX OR artifact: 0575376e07 user: krking
17:15 Post: A crash bug in MULTI-INDEX OR artifact: db47d1277d user: krking
13:56 Reply: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: f80d7580fc user: larrybr
12:41 Post: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: 0c471ca86a user: anonymous
11:41 Post: Extend the ZIP vtable artifact: a306810331 user: ddevienne
10:08 Reply: dense ranking artifact: 5ec1ab599a user: GertVA
01:38 Reply: Extension Wraping functions with ability to throw error and abort query artifact: 83c021ce24 user: kmedcalf
00:29 Reply: Extension Wraping functions with ability to throw error and abort query artifact: 24d6461b30 user: anonymous

5 Years Ago (more context)

2020-06-22
23:59 Reply: Decimal128 artifact: 1e80619ea6 user: LarryBrasfield
23:54 Reply: Decimal128 artifact: 3c5949d8da user: RichardDamon
22:58 Reply: Decimal128 artifact: 2e22266413 user: RichardDamon
22:33 Reply: Decimal128 artifact: 98de4a4b7e user: RichardDamon
21:58 Reply: Decimal128 artifact: 0bd8e7eda7 user: wyoung
21:49 Reply: Decimal128 artifact: 1ee3147fd7 user: kmedcalf
21:25 Reply: Decimal128 artifact: 72337a85dc user: kmedcalf
21:04 Reply: Decimal128 artifact: 2ae1467186 user: kmedcalf
20:54 Reply: Decimal128 artifact: 28a34ea38b user: LarryBrasfield
20:54 Reply: Decimal128 artifact: 8615bfa517 user: RichardDamon
20:35 Reply: Decimal128 artifact: f27b71b2b2 user: Clothears
20:27 Reply: Decimal128 artifact: 99fae35f83 user: younique
20:23 Reply: Decimal128 artifact: ce9f488a0c user: RichardDamon
20:15 Reply: Bug: Wrong/missing return value check of mmap function in lsm_unix.c artifact: 6121d5f10f user: trisbauer
20:13 Reply: Decimal128 artifact: 06462d5474 user: anonymous
17:29 Reply: Decimal128 artifact: a657f1663a user: kmedcalf
16:03 Reply: Bug: Wrong/missing return value check of mmap function in lsm_unix.c artifact: aa23e5cdfe user: dan
15:32 Edit reply: Bug: Wrong/missing return value check of mmap function in lsm_unix.c artifact: b79bc398dc user: stephan
15:32 Reply: Decimal128 artifact: cd39fb6dda user: RichardDamon
15:31 Reply: Bug: Wrong/missing return value check of mmap function in lsm_unix.c artifact: 7f3becee6a user: stephan
14:53 Edit reply: Decimal128 artifact: fa32cf7807 user: kmedcalf
14:49 Reply: Decimal128 artifact: 4cc6e84e96 user: kmedcalf
14:25 Post: Bug: Wrong/missing return value check of mmap function in lsm_unix.c artifact: 8ded7981e3 user: trisbauer
13:24 Reply: Decimal128 artifact: ac6cbd8431 user: kmedcalf
11:08 Reply: Decimal128 artifact: 57cdf7f95b user: RichardDamon
10:47 Reply: Newbie question: Decision for database model artifact: aa4adaa8ef user: cuz
07:50 Reply: Newbie question: Decision for database model artifact: 3145c8925c user: nji9nji9
00:18 Reply: Decimal128 artifact: 5af712f5f4 user: kmedcalf