SQLite User Forum

Today In History
Login

This Day In History For 2025-06-28

1 Year Ago (more context)

2024-06-28
23:46 Reply: String-op overread warning with GCC 14.1 at -O3 optimization artifact: 5079b745cb user: drh
21:03 Edit reply: String-op overread warning with GCC 14.1 at -O3 optimization artifact: 1016f9f835 user: drh
21:03 Reply: String-op overread warning with GCC 14.1 at -O3 optimization artifact: e98381312b user: drh
20:45 Reply: String-op overread warning with GCC 14.1 at -O3 optimization artifact: 377c2b0ccc user: anonymous
19:50 Edit reply: How to perform Regex Update query? artifact: 5f87174c2f user: paul1149
19:06 Reply: How to perform Regex Update query? artifact: 898cd9bdb3 user: paul1149
18:16 Reply: FTS5: xPhraseFirst/Next order artifact: 48d67f1f0d user: dan
16:39 Reply: FTS5: xPhraseFirst/Next order artifact: 24d1c71385 user: rogerbinns
16:06 Reply: FTS5: xPhraseFirst/Next order artifact: 920f298f5b user: _blgl_
15:51 Reply: FTS5: xPhraseFirst/Next order artifact: 9d238d00a6 user: rogerbinns
15:06 Reply: FTS5: xPhraseFirst/Next order artifact: 3279dae63e user: _blgl_
14:37 Reply: FTS5: xPhraseFirst/Next order artifact: c31689870d user: spindrift
14:14 Reply: SQL logic error on SICK Safety Designer software artifact: 9565da136b user: Chromedome
13:57 Reply: FTS5: xPhraseFirst/Next order artifact: b93f5d9d93 user: rogerbinns
13:49 Reply: FTS5: xPhraseFirst/Next order artifact: 001d68e954 user: rogerbinns
13:43 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: 0589ea6d86 user: stephan
13:36 Reply: SQL logic error on SICK Safety Designer software artifact: d4df4d88df user: LurkingKiwi
13:30 Edit reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: ebd9d0ac3e user: ananyaa220791
13:30 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: b2402667af user: ananyaa220791
13:21 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: c700a598a3 user: stephan
13:16 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: 92fe9d3be2 user: ananyaa220791
13:02 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: a90a016fd9 user: ananyaa220791
12:55 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: fcc12ecf4d user: stephan
12:21 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: f6a350a6c1 user: ananyaa220791
11:46 Reply: SQL logic error on SICK Safety Designer software artifact: 271d311cb8 user: Chromedome
11:16 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: e6c138849b user: stephan
11:03 Reply: SQL logic error on SICK Safety Designer software artifact: f7e8595a93 user: stephan
11:01 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: 78364a5b27 user: ananyaa220791
11:01 Reply: SQL logic error on SICK Safety Designer software artifact: b5bbb547c7 user: Chromedome
10:46 Reply: SQL logic error on SICK Safety Designer software artifact: d945474611 user: stephan
10:41 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: 3e35acb985 user: stephan
10:35 Post: SQL logic error on SICK Safety Designer software artifact: c563861e0b user: Chromedome
10:04 Post: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: cfa1047e2f user: ananyaa220791
09:28 Reply: Calculating using times (HH:MM) format artifact: 2e85215b10 user: spindrift
09:04 Reply: Calculating using times (HH:MM) format artifact: 5d53d01919 user: andydoc1
07:25 Reply: FTS5: xPhraseFirst/Next order artifact: 9ba5b248dc user: _blgl_
07:14 Edit reply: Calculating using times (HH:MM) format artifact: d57dccaf54 user: stephan
07:14 Reply: Calculating using times (HH:MM) format artifact: 10a3d62871 user: stephan
05:58 Reply: FTS5: xPhraseFirst/Next order artifact: b667cf683e user: spindrift
05:32 Reply: Calculating using times (HH:MM) format artifact: d2d154667f user: larrybr
04:08 Reply: Calculating using times (HH:MM) format artifact: 17bd8548b7 user: anonymous
03:43 Reply: Calculating using times (HH:MM) format artifact: 2be311d031 user: anonymous
01:15 Reply: How to perform Regex Update query? artifact: afbc134a60 user: alexgarciaxyz
01:01 Reply: How to perform Regex Update query? artifact: be63a3dc15 user: paul1149
00:02 Reply: How to perform Regex Update query? artifact: c776dc9799 user: paul1149

2 Years Ago (more context)

2023-06-28
21:45 Reply: Improve initial insert performance of rtree index artifact: a134237110 user: kmedcalf
21:08 Edit reply: Improve initial insert performance of rtree index artifact: fe0cd0a9fa user: theroggy
21:02 Reply: Improve initial insert performance of rtree index artifact: b4a6318dde user: theroggy
20:01 Reply: Confused about concurrency and sychronization artifact: dda0ef4def user: kmedcalf
19:56 Edit reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: fec16a0e0c user: kmedcalf
19:47 Edit reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 0ddb652ead user: kmedcalf
19:44 Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 5b5705eb50 user: kmedcalf
19:37 Reply: Confused about concurrency and sychronization artifact: 3a6c20fb75 user: Helios
19:32 Reply: Incorrect SUM values artifact: 8f9c2db2b5 user: kmedcalf
19:22 Edit reply: Incorrect SUM values artifact: b6ea5fc40b user: kmedcalf
19:12 Reply: Incorrect SUM values artifact: fed3b519ce user: drh
19:03 Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 23aa1bf419 user: scasaletto
18:51 Edit reply: Incorrect SUM values artifact: b2f9fe461f user: kmedcalf
18:49 Reply: Incorrect SUM values artifact: 8f916d7767 user: kmedcalf
18:42 Reply: Confused about concurrency and sychronization artifact: b3d9dd9401 user: kmedcalf
18:40 Reply: Confused about concurrency and sychronization artifact: 0e49f4cbbb user: kmedcalf
18:38 Reply: Pragma journal_mode=memory forces reset from WAL to delete artifact: ba2524c7a8 user: kmedcalf
15:50 Reply: Incorrect SUM values artifact: a860eb6d38 user: drh
15:49 Reply: Incorrect SUM values artifact: 020cf4c134 user: John-Jove
15:45 Edit reply: Incorrect SUM values artifact: 3cdec07490 user: John-Jove
15:44 Reply: Incorrect SUM values artifact: 8619e5f6c6 user: John-Jove
15:42 Edit: Incorrect SUM values artifact: f13d6918a7 user: John-Jove
15:37 Edit: Incorrect SUM values artifact: 683ac6087a user: John-Jove
15:27 Reply: Incorrect SUM values artifact: 7878ebf4d0 user: drh
15:17 Edit reply: Incorrect SUM values artifact: 5ab7d703f8 user: chrisjlocke1
15:14 Edit reply: Incorrect SUM values artifact: ee7c363d26 user: chrisjlocke1
15:13 Reply: Incorrect SUM values artifact: 9d5ece558e user: chrisjlocke1
14:59 Reply: Incorrect SUM values artifact: 43ab3fe6c6 user: anonymous
14:39 Post: Incorrect SUM values artifact: 9946b62bb2 user: John-Jove
13:33 Reply: Confused about concurrency and sychronization artifact: 46830bb78c user: Helios
13:26 Reply: Confused about concurrency and sychronization artifact: 0e954377c2 user: Helios
13:21 Post: Pragma journal_mode=memory forces reset from WAL to delete artifact: e34cc492d5 user: anonymous
12:53 Edit reply: sqlite3GlobalConfig.m.xMalloc gets back to null after initializing it to the default artifact: 1436d22d67 user: marcob
12:48 Reply: Confused about concurrency and sychronization artifact: 7cda0dcb53 user: sqlitening
10:57 Reply: Confused about concurrency and sychronization artifact: f8a907c017 user: Helios
09:07 Reply: new connection with SQLITE_OPEN_READONLY flag query error after the db changed journal mode to WAL artifact: f33f610996 user: maying09
07:39 Reply: sqlite3GlobalConfig.m.xMalloc gets back to null after initializing it to the default artifact: a05ed36741 user: marcob
07:20 Reply: Confused about concurrency and sychronization artifact: 8ff118ba34 user: sqlitening
06:30 Edit reply: Resolve hyperlink path from field name artifact: de5bea0c39 user: spindrift
06:29 Edit reply: Resolve hyperlink path from field name artifact: a894c4db18 user: spindrift
06:28 Reply: Resolve hyperlink path from field name artifact: 2b67455354 user: spindrift
05:18 Reply: Confused about concurrency and sychronization artifact: 902d21b574 user: gunter_hick
04:54 Reply: Confused about concurrency and sychronization artifact: c914f069a7 user: sqweek
04:23 Reply: sqlite3GlobalConfig.m.xMalloc gets back to null after initializing it to the default artifact: 54f389081e user: sqweek
04:14 Reply: Confused about concurrency and sychronization artifact: 8238e1db78 user: Helios
03:38 Reply: Confused about concurrency and sychronization artifact: 60c965a2d1 user: sqweek
02:55 Reply: Confused about concurrency and sychronization artifact: cbab684a68 user: sqlitening

3 Years Ago (more context)

2022-06-28
23:21 Reply: Prevent prefixes in column artifact: 79f3284b63 user: anonymous
22:49 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 6977099510 user: kmedcalf
21:59 Reply: Prevent prefixes in column artifact: 6c69363e88 user: kmedcalf
21:38 Reply: Prevent prefixes in column artifact: 7519302420 user: kmedcalf
21:23 Reply: Prevent prefixes in column artifact: dc69a36433 user: kmedcalf
21:21 Reply: Speedtesting PostgreSQL vs SQLite artifact: 28e48ddbb3 user: anonymous
20:51 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 0a7ff82eb4 user: anonymous
20:49 Reply: Prevent prefixes in column artifact: 9a55900673 user: anonymous
20:29 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 85f9223d85 user: anonymous
20:22 Reply: Unclear why join is so much slower than separate queries artifact: a590876089 user: anonymous
20:17 Post: Speedtesting PostgreSQL vs SQLite artifact: 92502417ab user: slavin
20:08 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 3d161d4973 user: greglearns
19:28 Reply: StrictMode wiki page should reference STRICT Tables artifact: 3935359483 user: hanche
19:27 Edit reply: Prevent prefixes in column artifact: c715cb4bdd user: kmedcalf
19:18 Reply: Prevent prefixes in column artifact: 282cf118c2 user: dvdraymond
19:14 Reply: Prevent prefixes in column artifact: 6f7787e4bd user: kmedcalf
18:13 Edit reply: Prevent prefixes in column artifact: 716a9b87cb user: kmedcalf
18:12 Edit reply: Prevent prefixes in column artifact: f25338a2a8 user: kmedcalf
18:08 Edit reply: Prevent prefixes in column artifact: 76fb05c37f user: kmedcalf
18:02 Reply: Prevent prefixes in column artifact: a9619095ba user: kmedcalf
17:49 Post: StrictMode wiki page should reference STRICT Tables artifact: f194eeed1e user: anonymous
17:47 Reply: Prevent prefixes in column artifact: c7563d0b7f user: kmedcalf
17:00 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 5958a93a28 user: kmedcalf
16:46 Reply: Numerical stability of AVG and SUM artifact: 65498ab6a2 user: kmedcalf
15:18 Reply: Prevent prefixes in column artifact: 3f5f81de3f user: dvdraymond
14:26 Reply: Unclear why join is so much slower than separate queries artifact: e23f9c6057 user: dvdraymond
14:18 Reply: The "sqlite_schema" name is not fully first-class artifact: c5dfe2d8f7 user: anonymous
12:44 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: c11b02382f user: kjames3411
11:11 Reply: Status of wal2 branch artifact: 60adeea487 user: dan
10:46 Delete reply: Integer type conversion issue artifact: c4ebb48484 user: chibuikemoptimus
09:52 Reply: Disablecontrols dos not affect on review speed for FDTable or FDQuery with lookup field on Delphi Embarcadero 10.2 or 11 artifact: 15dee4ac85 user: cuz
09:42 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: ca5d25b679 user: cuz
09:08 Reply: Numerical stability of AVG and SUM artifact: f73f5fea6a user: dkfellows
09:02 Reply: Disablecontrols dos not affect on review speed for FDTable or FDQuery with lookup field on Delphi Embarcadero 10.2 or 11 artifact: 1511452f87 user: stephan
08:57 Reply: Prevent prefixes in column artifact: 2a6b177093 user: dkfellows
08:51 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 2e53a87d35 user: dkfellows
08:05 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: bb8f3db869 user: ddevienne
07:45 Post: Disablecontrols dos not affect on review speed for FDTable or FDQuery with lookup field on Delphi Embarcadero 10.2 or 11 artifact: 12fcc3540d user: aalikazem
07:22 Post: Prevent prefixes in column artifact: eafa8d8741 user: baruch
06:28 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: e914f41db6 user: gunter_hick
04:51 Edit reply: Numerical stability of AVG and SUM artifact: fa39170455 user: justinmeiners
04:21 Reply: OperationalError: database is locked artifact: 209266b66b user: kmedcalf
04:16 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 2a4e4d6a19 user: kmedcalf
03:58 Post: OperationalError: database is locked artifact: b114377be3 user: 150599
02:57 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 911696108b user: larrybr
02:51 Reply: Database does not update artifact: 935a5d358d user: larrybr
01:56 Reply: Database does not update artifact: 2544781f65 user: slavin
01:49 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 1187ee616a user: drh
01:44 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 38a975a898 user: greglearns
00:53 Reply: Database does not update artifact: dc62d95590 user: gagsters888
00:26 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 23cd06cf5d user: cuz
00:09 Reply: Numerical stability of AVG and SUM artifact: 9210d87f40 user: justinmeiners
00:08 Reply: Numerical stability of AVG and SUM artifact: 5d4e0df0a4 user: justinmeiners
00:04 Reply: Numerical stability of AVG and SUM artifact: da9f9fa019 user: justinmeiners

4 Years Ago (more context)

2021-06-28
23:27 Reply: cannot create tables in sqlitestudio than other apps can see artifact: affd885635 user: steveinalabama
22:29 Reply: php sqlite3_create_window_function artifact: 86b8740e6f user: RandomCoder
22:12 Reply: php sqlite3_create_window_function artifact: 6c2ced2859 user: anonymous
21:53 Reply: Which performance test tool should choose ? artifact: 83c65cd921 user: larrybr
21:45 Reply: Better download file naming artifact: d372e046be user: larrybr
21:21 Reply: Better download file naming artifact: b44124a792 user: nolasd
20:57 Edit: ThreadSantizer warning for sqlite3_enable_shared_cache() artifact: 5830036e09 user: timwoj
20:42 Post: php sqlite3_create_window_function artifact: 2762c4dcd8 user: anonymous
20:19 Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: d752edabe4 user: jicman
19:57 Reply: Better download file naming artifact: af25b97685 user: RandomCoder
19:56 Post: ThreadSantizer warning for sqlite3_enable_shared_cache() artifact: 54424d80ee user: timwoj
19:50 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 5a43637b48 user: cuz
19:25 Reply: cannot create tables in sqlitestudio than other apps can see artifact: d03adaefa2 user: steveinalabama
19:15 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 60b717e2f7 user: steveinalabama
18:34 Reply: CopySQLiteInteropFiles not working with dotnet build? artifact: 128ad82c9d user: jbrecher
18:30 Reply: Better download file naming artifact: 3f8cdae6e6 user: nolasd
18:23 Reply: Better download file naming artifact: fa2aa5c0f1 user: larrybr
18:20 Reply: CopySQLiteInteropFiles not working with dotnet build? artifact: 1bba094dc2 user: wyoung
18:18 Reply: Better download file naming artifact: 9dc9d4a6db user: nolasd
18:10 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 83fc360f0c user: larrybr
18:06 Reply: cannot create tables in sqlitestudio than other apps can see artifact: f75f984325 user: RichardDamon
17:45 Reply: cannot create tables in sqlitestudio than other apps can see artifact: def76174e0 user: steveinalabama
17:16 Post: CopySQLiteInteropFiles not working with dotnet build? artifact: a694aee252 user: jbrecher
16:42 Reply: DOS? artifact: a6c8e2b2a1 user: stephan
16:36 Reply: New version of app, more columns for same table artifact: 093315d301 user: anonymous
16:34 Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: 29a965c7d4 user: anonymous
14:53 Post: DOS? artifact: 42bd705e2f user: younique
13:48 Edit: Which performance test tool should choose ? artifact: 1256cc17cb user: liziqi
13:17 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 01c62713af user: cuz
12:25 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 26daf8f9e0 user: slavin
12:04 Reply: High cpu usage of System.Data.SQLite.SQLiteConnection..ctor artifact: 1566872abd user: billwade
11:53 Post: Which performance test tool should choose ? artifact: 35e4e445ff user: liziqi
11:16 Reply: Am I doing SQL wrong? artifact: 72a0b08203 user: cuz
11:14 Reply: High cpu usage of System.Data.SQLite.SQLiteConnection..ctor artifact: 9d755113f3 user: larrybr
11:07 Reply: Am I doing SQL wrong? artifact: d57f998767 user: melbourne_josh
11:06 Reply: Am I doing SQL wrong? artifact: c24e36b098 user: cuz
10:57 Reply: Am I doing SQL wrong? artifact: 3d732695f5 user: dan
09:46 Post: Am I doing SQL wrong? artifact: bcccf771e6 user: melbourne_josh
04:45 Post: ATTACH of in memory database to a database that uses custom VFS doesn't work artifact: ddaf5ff5f9 user: anonymous
04:11 Post: High cpu usage of System.Data.SQLite.SQLiteConnection..ctor artifact: d5ea01ec29 user: baislsl
03:39 Reply: cannot create tables in sqlitestudio than other apps can see artifact: e938a6d672 user: steveinalabama
03:12 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 577ee1ea79 user: steveinalabama
01:46 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 2e5f493b7f user: slavin

5 Years Ago (more context)

2020-06-28
18:44 Reply: Beginner: keep getting ...> artifact: 43e4fadc40 user: kmedcalf
15:42 Reply: Beginner: keep getting ...> artifact: ece81e2830 user: kmedcalf
15:08 Reply: Beginner: keep getting ...> artifact: 63481d9526 user: stephan
15:04 Post: Beginner: keep getting ...> artifact: 9abc641c1f user: cforput77
07:31 Reply: Build for Apple Silicon artifact: 1de0aa6242 user: slavin
05:57 Post: SQLite Android Bindings instructions are out of date artifact: 688e8ab2aa user: heathborders