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 | |