SQLite User Forum

Today In History
Login

This Day In History For 2024-03-25

1 Year Ago (more context)

2023-03-25
23:59 Reply: Assertion failure in Indexed Expression (2) artifact: 9afc4dd96e user: drh
23:54 Reply: Sharing a database across processes and threads. artifact: 0cae386513 user: mkorobkom
23:24 Reply: Assertion failure in Cast Zeroblob artifact: 7ddcd79fb0 user: songliu
22:47 Reply: Schema-less SQLite artifact: ee25090681 user: mandolyte
21:14 Reply: Create table, where is the file?? artifact: 712b7a24bb user: mhnsqlite
20:47 Reply: Sharing a database across processes and threads. artifact: 74e5fae006 user: codehz
19:59 Reply: Assertion failure in NATURAL JOIN artifact: f2384bd703 user: songliu
19:53 Reply: Assertion failure in sqlite3OsDlOpen function artifact: 04002f9a5c user: songliu
19:47 Reply: Sharing a database across processes and threads. artifact: 8c49aad2b7 user: RichardDamon
19:27 Post: Assertion failure in Indexed Expression (2) artifact: 9b491e1deb user: songliu
19:05 Reply: Schema-less SQLite artifact: 3198f88d8e user: dkruspb
19:00 Post: Assertion failure in Cast Zeroblob artifact: 5275207102 user: songliu
18:55 Reply: Sharing a database across processes and threads. artifact: d9421bee1b user: mkorobkom
18:47 Reply: Sharing a database across processes and threads. artifact: 6d6c81185f user: anonymous
18:44 Reply: Schema-less SQLite artifact: 8d8f98f7f5 user: steida
18:42 Reply: Assertion failure in ANALYZE for STAT4 artifact: 77c4f79270 user: songliu
18:39 Reply: Assertion failure in ANALYZE for STAT4 artifact: 5804aaf406 user: drh
18:16 Reply: Sharing a database across processes and threads. artifact: 9bac363c0f user: codehz
17:37 Reply: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: 760b1c365b user: 1codedebugger
17:18 Post: Assertion failure in NATURAL JOIN artifact: 5522082cfc user: songliu
17:01 Reply: Segmentation fault in sqlite3_complete function artifact: b8b3cf676a user: songliu
16:24 Post: Sharing a database across processes and threads. artifact: 17dd02d190 user: mkorobkom
16:23 Reply: Segmentation fault in sqlite3_complete function artifact: 36c65618fe user: spindrift
16:22 Post: Assertion failure in ANALYZE for STAT4 artifact: 83cb4a95a0 user: songliu
14:57 Reply: Schema-less SQLite artifact: d3aae4a707 user: slavin
07:23 Reply: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: ec4595da93 user: dan
07:08 Edit reply: Schema-less SQLite artifact: 2f5a87c3c9 user: spindrift
07:08 Reply: Schema-less SQLite artifact: 9aad8f6171 user: spindrift
04:54 Reply: SQLite crashes when running SQL function `shell_int32` artifact: 538c1dada4 user: LY1598773890
04:47 Reply: Schema-less SQLite artifact: e3c5c97a6e user: codehz
03:22 Reply: Segmentation fault in sqlite3_complete function artifact: 635cd5c54c user: larrybr
03:17 Edit reply: Segmentation fault in sqlite3_complete function artifact: 5eefddd81c user: songliu
03:14 Reply: Segmentation fault in sqlite3_complete function artifact: 9251b07f6c user: songliu
03:11 Reply: Options to the eval method of the Tcl interface to SQLite? artifact: 5d6e56ed3c user: larrybr
03:00 Reply: Assertion failure in sqlite3OsDlOpen function artifact: a43074729e user: songliu
02:57 Post: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: 2b79174d67 user: 1codedebugger
02:53 Post: Assertion failure in sqlite3OsDlOpen function artifact: 24083b579d user: songliu
02:46 Reply: Options to the eval method of the Tcl interface to SQLite? artifact: 29e11f72ce user: 1codedebugger
02:23 Reply: Segmentation fault in sqlite3_complete function artifact: 4fd9681e46 user: larrybr
02:12 Reply: Assertion failure in cursor artifact: 452c3ac1b6 user: songliu
02:09 Reply: Assertion failure in cursor artifact: c82394ce83 user: drh
01:51 Reply: Options to the eval method of the Tcl interface to SQLite? artifact: 5297d57c76 user: larrybr
01:45 Edit: Assertion failure in cursor artifact: d34ad68c36 user: songliu
01:44 Post: Assertion failure in cursor artifact: 31da0fe1fe user: songliu
01:30 Post: Options to the eval method of the Tcl interface to SQLite? artifact: 45caeeb2f5 user: 1codedebugger
01:07 Edit reply: Segmentation fault in sqlite3_complete function artifact: 6872514e04 user: songliu
01:04 Reply: Segmentation fault in sqlite3_complete function artifact: 846ca80319 user: songliu
00:23 Post: Segmentation fault in sqlite3_complete function artifact: 1d9ac01fce user: songliu

2 Years Ago (more context)

2022-03-25
20:05 Reply: Excel formulas in SQLITE artifact: e66e5b6a1e user: anonymous
19:48 Reply: Buried in the documents artifact: 61228d69a4 user: anonymous
19:11 Post: Deserialize in-memory database and Write-Ahead Logging artifact: 04e98da43d user: anonymous
17:38 Reply: Attach file to in-memory database artifact: 2fb5f87d89 user: anonymous
17:29 Reply: Attach file to in-memory database artifact: 4da5960fab user: kmedcalf
16:16 Reply: Possible Bug in 3.38.1 artifact: 1e042e012d user: dschmeer
15:57 Reply: New Feature Select ... as JSON artifact: c07aa636dd user: anonymous
15:47 Reply: Buried in the documents artifact: 0ec4ead6f3 user: larrybr
15:16 Reply: Buried in the documents artifact: c9199f13c0 user: ThanksRyan
15:14 Post: Attach file to in-memory database artifact: c4811d9eaf user: anonymous
13:54 Post: Buried in the documents artifact: 3c896fcb58 user: anonymous
11:04 Edit reply: Possible Bug in 3.38.1 artifact: 8457f06905 user: drh
10:05 Edit reply: New Feature Select ... as JSON artifact: fea51b75ca user: bokwoon
10:02 Reply: New Feature Select ... as JSON artifact: 15b952c536 user: bokwoon
01:39 Reply: Possible Bug in 3.38.1 artifact: 1f164e3738 user: drh
00:40 Edit reply: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: 0760d01f69 user: mistachkin
00:40 Reply: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: 6a4317bc7f user: mistachkin
00:04 Reply: Possible Bug in 3.38.1 artifact: eeb57e103d user: drh
00:02 Reply: Excel formulas in SQLITE artifact: cb1bfbb1aa user: anonymous

3 Years Ago (more context)

2021-03-25
23:51 Reply: possible to use output of a SELECT-query for ordering? artifact: 54867a15e3 user: larrybr
23:46 Edit reply: possible to use output of a SELECT-query for ordering? artifact: 6b35f11ffc user: GSnyder
23:44 Reply: possible to use output of a SELECT-query for ordering? artifact: f08d53b58b user: GSnyder
23:36 Reply: DROP TABLE failure - is it intentional or a bug? artifact: 946d615bf5 user: younique
23:31 Post: possible to use output of a SELECT-query for ordering? artifact: 09f7ed2e1d user: younique
22:36 Edit reply: json_tree documentation improvement: change type "string" to "text" artifact: e56a7597e7 user: TripeHound
22:35 Reply: json_tree documentation improvement: change type "string" to "text" artifact: 3e86be3c6d user: TripeHound
20:54 Edit reply: json_tree documentation improvement: change type "string" to "text" artifact: 2c7b60db49 user: larrybr
20:45 Reply: json_tree documentation improvement: change type "string" to "text" artifact: 2f619489ca user: larrybr
20:05 Reply: json_tree documentation improvement: change type "string" to "text" artifact: 109c981af3 user: hanche
18:09 Reply: json_tree documentation improvement: change type "string" to "text" artifact: df0cfed45c user: larrybr
17:52 Post: json_tree documentation improvement: change type "string" to "text" artifact: 112a466acb user: anonymous
16:42 Reply: SQLite Version 3.35.0 - Beta 1 artifact: 4bfd97c5ce user: malbrain
15:46 Reply: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: 3ced4d2525 user: jimmorris33215
14:03 Reply: R*Tree table constraints artifact: 54707a57b6 user: anonymous
14:03 Reply: Thousands of SQLite Databases for each user artifact: 33cd50514c user: danshearer
14:03 Reply: Error when trying to add a column (Error checking foreign keys after table modification) artifact: c0579f412b user: cuz
13:45 Reply: Thousands of SQLite Databases for each user artifact: 2c8a225f03 user: cuz
13:39 Reply: Error: no such column: x artifact: 0dc5949bcd user: jicman
13:26 Reply: Views in LEFT JOIN queries not using index artifact: d7d581270d user: kmedcalf
13:18 Reply: R*Tree table constraints artifact: 981ee72f6d user: kmedcalf
13:17 Reply: Views in LEFT JOIN queries not using index artifact: b32ad52731 user: gunter_hick
13:15 Reply: Error when trying to add a column (Error checking foreign keys after table modification) artifact: b9f6df3bf5 user: dfgriggs
13:12 Reply: R*Tree table constraints artifact: 37bdcbeffb user: anonymous
13:05 Edit reply: Views in LEFT JOIN queries not using index artifact: 444abe5a10 user: kmedcalf
13:04 Reply: Views in LEFT JOIN queries not using index artifact: ba13977b2b user: kmedcalf
13:02 Reply: R*Tree table constraints artifact: 7d06015a9e user: drh
13:01 Reply: Database Independent Queries artifact: 9f8e6f923c user: drh
13:00 Reply: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: ede3a9b22f user: drh
12:59 Reply: Generating random test data using SQL artifact: 7e144ab1ee user: slavin
12:43 Reply: CVE-2021-20227 / Flaw in SQLite's Select Query functionality artifact: 30497fb626 user: drh
12:41 Post: Error when trying to add a column (Error checking foreign keys after table modification) artifact: e05a35fca9 user: zappfinger
12:10 Post: CVE-2021-20227 / Flaw in SQLite's Select Query functionality artifact: 244e1d6bd5 user: anonymous
11:21 Post: R*Tree table constraints artifact: 95141f8632 user: anonymous
09:22 Reply: Generating random test data using SQL artifact: dfdf12a0df user: anonymous
09:02 Post: Database Independent Queries artifact: 023d1b6199 user: anonymous
08:08 Reply: Views in LEFT JOIN queries not using index artifact: 501b1e00ef user: gunter_hick
07:43 Reply: Thousands of SQLite Databases for each user artifact: 29ba0391b2 user: anonymous
07:34 Reply: Thousands of SQLite Databases for each user artifact: d571a625a9 user: anonymous
07:19 Edit: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: 1c15f1ddf1 user: stnshr
06:39 Post: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: 7ce5c901fd user: stnshr
06:13 Post: Views in LEFT JOIN queries not using index artifact: f26dae0592 user: frodrig3
01:20 Reply: Can sqlite blob field be appended with data? artifact: cd1a2b5308 user: maxbad
00:36 Edit reply: DROP TABLE failure - is it intentional or a bug? artifact: c386ed187f user: cuz
00:09 Reply: DROP TABLE failure - is it intentional or a bug? artifact: 01e090683b user: cuz

4 Years Ago (more context)

2020-03-25
22:59 Reply: Request for comment: New ANALYZE syntax artifact: 7bdeaa3afe user: jicman
18:42 Reply: Searches in the forum artifact: 00db7b2a1d user: jicman
18:35 Reply: Searches in the forum artifact: bd79f08c34 user: dvdraymond
18:29 Reply: Searches in the forum artifact: 29939b5ebe user: jicman
18:19 Post: Searches in the forum artifact: a30fcaa99a user: jicman
15:55 Post: Patch to raise SQLITE_MAX_ATTACHED above 125 artifact: 7c5950701e user: anonymous
15:11 Reply: Password Reset for Forum artifact: 2122bf459a user: drh
14:57 Reply: Can I do this as one liner? artifact: 3b54ae09d3 user: anonymous
13:50 Post: Password Reset for Forum artifact: a89597f124 user: anonymous
12:52 Reply: feature request dump multiple tables at once artifact: 503ca1afa1 user: drh
12:14 Reply: Can I do this as one liner? artifact: c09a2acd1e user: jake
12:10 Reply: Can I do this as one liner? artifact: e802fd692a user: mark
12:06 Post: feature request dump multiple tables at once artifact: 6a56131ec5 user: mark
11:53 Reply: Can I do this as one liner? artifact: 2beefb5e3a user: luuk
11:30 Post: Can I do this as one liner? artifact: 92f75c1e0a user: anonymous
08:17 Post: Broken link for past checklists artifact: 39f3e3135c user: tsafin
01:49 Reply: Welcome artifact: 108b693ea5 user: wyoung
01:06 Post: Patch to fix compilation on Mac Catalyst artifact: 803387a1c5 user: chrisballinger