SQLite User Forum

Today In History
Login

This Day In History For 2024-03-24

1 Year Ago (more context)

2023-03-24
23:48 Reply: Create table, where is the file?? artifact: 0391d3abce user: larrybr
23:22 Reply: Schema-less SQLite artifact: da9241a75e user: bjoern
23:13 Reply: Create table, where is the file?? artifact: 3d3b1af862 user: mhnsqlite
22:30 Reply: Assertion failure in accessPayload function artifact: 76fdd39059 user: songliu
22:29 Reply: Assertion failure in Indexed Expression artifact: edbded9c8c user: songliu
22:21 Reply: Schema-less SQLite artifact: 3b2ea35b6b user: larrybr
22:04 Reply: Schema-less SQLite artifact: 94c220d2c0 user: Clothears
21:17 Post: SQLite crashes when running SQL function `shell_int32` artifact: be9c294ee0 user: LY1598773890
21:06 Edit reply: Schema-less SQLite artifact: b544ee2f32 user: steida
21:04 Edit reply: Schema-less SQLite artifact: c72192656e user: steida
21:01 Reply: Schema-less SQLite artifact: ee7fa626e4 user: steida
21:00 Reply: Schema-less SQLite artifact: 1c0e9c928c user: steida
20:57 Reply: Schema-less SQLite artifact: 2733b2dfa7 user: deonb
20:48 Reply: Schema-less SQLite artifact: 324d43bb60 user: steida
20:22 Post: Assertion failure in accessPayload function artifact: 8cc1dc0fe9 user: songliu
20:21 Reply: Schema-less SQLite artifact: 6464c0af29 user: larrybr
20:07 Reply: Assertion failure in RIGHT JOIN artifact: c2b7dcdb31 user: songliu
19:56 Reply: Schema-less SQLite artifact: d72c537ed7 user: kmedcalf
19:55 Reply: Schema-less SQLite artifact: ddff4732d4 user: anonymous
19:40 Reply: Create table, where is the file?? artifact: 5c76646e64 user: wyoung
19:38 Reply: Create table, where is the file?? artifact: 4a9686a686 user: larrybr
19:28 Reply: Create table, where is the file?? artifact: 6944b56d66 user: stephan
19:27 Edit reply: Schema-less SQLite artifact: c53af8e455 user: steida
19:27 Edit reply: Schema-less SQLite artifact: 7fcf291bb0 user: steida
19:26 Edit reply: Schema-less SQLite artifact: 4b370a8130 user: steida
19:25 Reply: Create table, where is the file?? artifact: 7c9bed643d user: mhnsqlite
19:23 Edit reply: Schema-less SQLite artifact: a216628f70 user: steida
19:22 Reply: Assertion failure in RIGHT JOIN artifact: cde0cc9d5b user: drh
19:21 Reply: Create table, where is the file?? artifact: 8cdf85377c user: mhnsqlite
19:20 Reply: Schema-less SQLite artifact: acbf44e59b user: steida
19:12 Reply: Connection pooling vs Message passing artifact: 0f99699dbf user: anonymous
19:05 Post: Assertion failure in Indexed Expression artifact: 79cf371080 user: songliu
19:02 Reply: Schema-less SQLite artifact: c522e1e78d user: kmedcalf
18:52 Reply: Connection pooling vs Message passing artifact: 611a700ffd user: kmedcalf
18:43 Reply: SQLite WASM pragma table_info artifact: 158e1a049d user: mmomtchev
18:20 Post: Assertion failure in RIGHT JOIN artifact: 591006b1cc user: songliu
17:20 Reply: SQLite WASM pragma table_info artifact: ade9f18e3d user: stephan
17:15 Reply: Create table, where is the file?? artifact: af2f2ec499 user: florian.balmer
17:13 Reply: SQLite WASM pragma table_info artifact: 8d8b76dfb4 user: mmomtchev
17:13 Reply: Assertion failure when enable/disable optimizations artifact: f58617043f user: songliu
17:03 Reply: Assertion failure when enable/disable optimizations artifact: ff89f08c13 user: drh
16:58 Edit reply: Schema-less SQLite artifact: 345400b8cb user: steida
16:42 Reply: Schema-less SQLite artifact: fc18ce8845 user: steida
16:41 Reply: Schema-less SQLite artifact: c6a826cfb4 user: steida
16:35 Reply: Connection pooling vs Message passing artifact: 088b2f465a user: anonymous
16:21 Reply: SQLite WASM pragma table_info artifact: e7cd8d6401 user: stephan
16:11 Reply: Connection pooling vs Message passing artifact: 047ad1ecc3 user: kmedcalf
16:04 Post: SQLite WASM pragma table_info artifact: 895425b49a user: mmomtchev
16:04 Post: Assertion failure when enable/disable optimizations artifact: bc39e531e5 user: songliu
16:04 Reply: Schema-less SQLite artifact: 8f2a7a21b6 user: codehz
15:57 Reply: Schema-less SQLite artifact: 4644aa34b5 user: kmedcalf
15:40 Reply: Create table, where is the file?? artifact: cdcc3d602a user: larrybr
15:32 Reply: Connection pooling vs Message passing artifact: 3e794242b9 user: anonymous
15:26 Edit reply: wrong result from PRAGMA foreign_key_list? artifact: 26093a2cee user: drh
15:25 Reply: wrong result from PRAGMA foreign_key_list? artifact: 5925a07863 user: drh
15:15 Post: wrong result from PRAGMA foreign_key_list? artifact: 6a59f2d7c1 user: chund1
14:21 Reply: Importing csv Files artifact: a462451d03 user: hanche
14:17 Post: Schema-less SQLite artifact: 5764b8535c user: steida
14:06 Reply: Connection pooling vs Message passing artifact: 3bac9f9b15 user: coleifer
13:46 Edit reply: Suggestions of tools to handle database migrations (using raw SQL)? artifact: bcdacf23a7 user: stephan
13:43 Reply: Suggestions of tools to handle database migrations (using raw SQL)? artifact: a86b0f61ef user: rogerbinns
13:36 Reply: Suggestions of tools to handle database migrations (using raw SQL)? artifact: aa16597a38 user: joeljuca
13:26 Reply: "Nested" "prepare" function calls artifact: 047f9bd223 user: lea12345
13:25 Edit reply: Stable / latest download links? artifact: 87e9a5e34d user: wyoung
13:23 Reply: Stable / latest download links? artifact: c24afc2df5 user: wyoung
13:15 Reply: Stable / latest download links? artifact: 3206e66ee1 user: justinclift
12:38 Reply: Stable / latest download links? artifact: f562d117aa user: wyoung
12:31 Reply: Stable / latest download links? artifact: 38c9cfde6d user: justinclift
12:28 Reply: Stable / latest download links? artifact: 413cc7ccdb user: justinclift
12:27 Reply: Stable / latest download links? artifact: 5096f1a037 user: justinclift
12:26 Reply: Stable / latest download links? artifact: b4a56200f7 user: drh
12:23 Reply: Stable / latest download links? artifact: 9df7ceca9c user: justinclift
11:51 Reply: Stable / latest download links? artifact: 641602627b user: drh
11:43 Reply: Stable / latest download links? artifact: 9e4be4e779 user: wyoung
11:43 Reply: Importing csv Files artifact: 3f4ecfba12 user: anonymous
11:38 Reply: DROP VIEW IF EXISTS failure artifact: 5dd6600614 user: neubauer
11:17 Post: Help with sqllogictest util artifact: 36b1c1fd70 user: dmsysolyatin
10:44 Reply: Stable / latest download links? artifact: a15245a545 user: justinclift
10:08 Reply: Create table, where is the file?? artifact: e342fe8ef1 user: wyoung
09:27 Edit reply: Create table, where is the file?? artifact: ee2e2e4699 user: AAsk1902
09:24 Reply: Create table, where is the file?? artifact: 4884097e3e user: AAsk1902
09:06 Reply: Stable / latest download links? artifact: f0fb6a1004 user: wyoung
09:02 Reply: Create table, where is the file?? artifact: b9ab1df11d user: hanche
09:01 Reply: Create table, where is the file?? artifact: 6564e995e3 user: wyoung
08:58 Reply: Importing csv Files artifact: 175dba020b user: hanche
07:34 Post: Create table, where is the file?? artifact: f35967dbc2 user: mhnsqlite
07:14 Post: Stable / latest download links? artifact: 03e26e24b7 user: justinclift
05:32 Reply: Importing csv Files artifact: 3ad6f37182 user: larrybr
05:13 Reply: Importing csv Files artifact: 667ee58f2c user: anonymous
01:32 Post: Possibly don't check F2FS_FEATURE_ATOMIC_WRITE when database is readonly artifact: 944a227977 user: anonymous
01:28 Reply: Hooks invoked when modifications done from another connection? artifact: 782eb86bbd user: sqweek
01:24 Post: Connection pooling vs Message passing artifact: fcbec334c9 user: anonymous

2 Years Ago (more context)

2022-03-24
23:37 Reply: Possible Bug in 3.38.1 artifact: 4c490f2150 user: drh
22:57 Post: Possible Bug in 3.38.1 artifact: 031e262a89 user: dschmeer
19:56 Reply: CVE-2020-9794 -- OOB Read Vulnerability artifact: b32fc29097 user: slavin
18:53 Reply: CVE-2020-9794 -- OOB Read Vulnerability artifact: 4040776db7 user: jhawkins1
18:44 Reply: Excel formulas in SQLITE artifact: 15dc641430 user: wzrlpy
18:22 Reply: database disk image is malformed when SELECT instruction artifact: 09531ef560 user: wyoung
15:37 Reply: CVE-2020-9794 -- OOB Read Vulnerability artifact: ab02357b1b user: slavin
15:09 Reply: CVE-2020-9794 -- OOB Read Vulnerability artifact: 642eb87ee3 user: gunter_hick
15:00 Reply: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: f2bc9758ae user: dhorodniczy
13:59 Reply: Excel formulas in SQLITE artifact: cf652d1f89 user: anonymous
13:02 Reply: CVE-2020-9794 -- OOB Read Vulnerability artifact: e48a2ce14e user: anonymous
11:46 Reply: database disk image is malformed when SELECT instruction artifact: d84144ed7e user: gunter_hick
07:51 Post: database disk image is malformed when SELECT instruction artifact: 440bb3aab9 user: 765226177
05:49 Post: How to group SQLite multiple rows (having similar value for id or any other column) into JSON artifact: bc8d011ff7 user: anonymous
04:25 Edit reply: Efficient Min/Max using window functions? artifact: d6e68194ac user: rmariani
04:17 Edit reply: Efficient Min/Max using window functions? artifact: 7e3d4719a6 user: rmariani
04:13 Reply: Efficient Min/Max using window functions? artifact: 9e7dc67415 user: rmariani
03:18 Edit reply: Corrupt FTS5 table after declaring triggers a certain way artifact: ace2fa79e8 user: marcardar
02:59 Edit reply: Corrupt FTS5 table after declaring triggers a certain way artifact: 5506aa694b user: marcardar
02:56 (Awaiting Moderator Approval) Edit reply: Corrupt FTS5 table after declaring triggers a certain way artifact: 597922a812 user: marcardar (unpublished)
02:46 Reply: Corrupt FTS5 table after declaring triggers a certain way artifact: da59bf102d user: marcardar

3 Years Ago (more context)

2021-03-24
22:26 Reply: Generating random test data using SQL artifact: e430b0435b user: anonymous
21:57 Reply: DROP TABLE failure - is it intentional or a bug? artifact: 51c667a08a user: younique
21:45 Reply: Generating random test data using SQL artifact: a9793d05b7 user: cuz
21:39 Reply: Thousands of SQLite Databases for each user artifact: 939c555dae user: cuz
21:22 Reply: DROP TABLE failure - is it intentional or a bug? artifact: 98238526b1 user: cuz
21:06 Reply: Generating random test data using SQL artifact: 7bc398e49a user: kmedcalf
20:59 Post: Msys2 Windows 64 bit build issues artifact: c26fad96ab user: JohnGa
20:50 Reply: 3.25 math functions vs. extension-functions.c artifact: 58f887946a user: utelle
20:46 Post: Generating random test data using SQL artifact: 7a1c18f75c user: slavin
20:16 Reply: Thousands of SQLite Databases for each user artifact: 3e1cdcba27 user: jicman
18:22 Reply: DROP TABLE failure - is it intentional or a bug? artifact: fc15814690 user: younique
17:48 Reply: 3.25 math functions vs. extension-functions.c artifact: ab0bfaeca4 user: kmedcalf
17:47 Post: Thousands of SQLite Databases for each user artifact: 5f8fa28870 user: anonymous
17:44 Reply: Strange CLI .exit issue artifact: dbc2c10de3 user: larrybr
17:37 Reply: Help rewriting a query to match the speed of a 2nd query artifact: f5f61bf672 user: kmedcalf
17:33 Reply: Help rewriting a query to match the speed of a 2nd query artifact: b123b05f9a user: kmedcalf
15:12 Reply: Maybe fossil problem ? artifact: 0d704e0f82 user: stephan
15:01 Reply: Strange CLI .exit issue artifact: 21cb16739f user: anonymous
14:28 Reply: Help rewriting a query to match the speed of a 2nd query artifact: 7cb60a51af user: jicman
14:28 Reply: Strange CLI .exit issue artifact: d367232cae user: larrybr
14:09 Reply: Help rewriting a query to match the speed of a 2nd query artifact: bec274b1de user: dvdraymond
14:07 Reply: Maybe fossil problem ? artifact: 56fa8d5800 user: mingodad
13:39 Post: Help rewriting a query to match the speed of a 2nd query artifact: a5711a3943 user: jicman
13:33 Reply: 3.25 math functions vs. extension-functions.c artifact: 3865a83e28 user: utelle
13:13 Reply: Strange CLI .exit issue artifact: 533fffa0d5 user: anonymous
11:31 Reply: Maybe fossil problem ? artifact: a1e9315a9e user: anonymous
11:13 Reply: 3.25 math functions vs. extension-functions.c artifact: caabc90e9e user: stephancb
11:07 Reply: Maybe fossil problem ? artifact: b18fe14da3 user: drh
11:05 Reply: 3.25 math functions vs. extension-functions.c artifact: 06eec0a736 user: drh
10:43 Reply: 3.25 math functions vs. extension-functions.c artifact: 3d5a13ceb2 user: stephancb
10:06 Reply: 3.25 math functions vs. extension-functions.c artifact: bb9bdf30b4 user: utelle
09:28 Reply: Minor typo in documentation artifact: 4b4f5c5583 user: kbilleter
09:10 Post: Maybe fossil problem ? artifact: 6c08297094 user: mingodad
07:17 Reply: 3.25 math functions vs. extension-functions.c artifact: e514265253 user: stephancb
05:19 Reply: Select distinct from most recent record artifact: 14ab049504 user: ThanksRyan
02:00 Reply: DROP TABLE failure - is it intentional or a bug? artifact: 54d2c4d5b9 user: kmedcalf
01:59 Reply: Can sqlite blob field be appended with data? artifact: b8fbf59182 user: larrybr
01:43 Post: Can sqlite blob field be appended with data? artifact: c696f497f4 user: maxbad
00:52 Reply: null character sorts greater than 0x7f and less than 0x80 artifact: 8a72053f51 user: RichardDamon
00:23 Reply: Select distinct from most recent record artifact: 455a7d1172 user: cuz

4 Years Ago (more context)

2020-03-24
19:21 Reply: Welcome artifact: 730a36ecb2 user: Clothears
19:19 Reply: Plan for an 64 bit binary for macosx catalina? artifact: c39a5a9ae0 user: Clothears
17:51 Reply: Welcome artifact: 5c76722275 user: kmedcalf
17:46 Post: Plan for an 64 bit binary for macosx catalina? artifact: 4820e7b3a5 user: anonymous
17:35 Post: Building System.Data.SQLite and SEE artifact: 942c66827b user: brian.heilig
16:10 Changes to wiki page "about" artifact: b6f58b0a29 user: drh
15:15 Reply: Welcome artifact: 3515efc699 user: drh
14:58 Reply: Welcome artifact: 537e76fc64 user: cuz
14:57 Reply: Welcome artifact: 8a72036a3e user: Clothears
14:40 Reply: Welcome artifact: c23e770b32 user: wmertens
14:13 Added wiki page "about" artifact: de89396538 user: drh
11:22 Reply: Feature Request: Option to store sqlite db in plain text format (e.g. csv) artifact: f2796467ac user: stephan
10:32 Reply: Feature Request: Option to store sqlite db in plain text format (e.g. csv) artifact: fc03e3b20c user: kbilleter
09:54 Reply: Welcome artifact: b432db1990 user: cuz