SQLite User Forum

Today In History
Login

This Day In History For 2025-06-27

1 Year Ago (more context)

2024-06-27
23:57 Reply: How to perform Regex Update query? artifact: 89579360bc user: alexgarciaxyz
23:30 Post: Possible virtual table bug: result_subtype is passed to INSERT values but not UPDATE values artifact: 65317ce9c6 user: alexgarciaxyz
23:06 Post: FTS5: xPhraseFirst/Next order artifact: f4e6bb64ee user: rogerbinns
22:14 Post: How to perform Regex Update query? artifact: 7c7360b99c user: paul1149
21:51 Reply: Calculating using times (HH:MM) format artifact: b2baf804b4 user: anonymous
15:56 Edit reply: Calculating using times (HH:MM) format artifact: d592e3acac user: holgerj
15:56 Reply: Calculating using times (HH:MM) format artifact: d2cdade27d user: holgerj
15:15 Post: Datetime function format modifier (a proposal) artifact: 404396d40e user: dmausner
15:06 Reply: Calculating using times (HH:MM) format artifact: 3ae77e98ac user: stephan
14:56 Reply: Calculating using times (HH:MM) format artifact: 02b2c82e72 user: punkish
14:42 Reply: simple request, many db and variables, speed question artifact: a0e1c5da26 user: mark
14:36 Reply: simple request, many db and variables, speed question artifact: 876945e75d user: mark
13:34 Reply: Calculating using times (HH:MM) format artifact: c176254c08 user: anonymous
11:33 Edit reply: Calculating using times (HH:MM) format artifact: b98d8d9bd8 user: spindrift
11:29 Reply: simple request, many db and variables, speed question artifact: 19cc0909f3 user: spindrift
11:07 Reply: simple request, many db and variables, speed question artifact: da6a9d4f6a user: Pogzy321
10:30 Reply: simple request, many db and variables, speed question artifact: ce47458432 user: spindrift
10:29 Reply: Calculating using times (HH:MM) format artifact: 7377e201e9 user: andydoc1
10:17 Reply: simple request, many db and variables, speed question artifact: e9aae947ac user: gunter_hick
09:52 Reply: Ask for the "PrivacyInfo.xcprivacy" required by Apple artifact: 6555ac13b8 user: baihao_buaa
09:50 Post: simple request, many db and variables, speed question artifact: 04e6095f4d user: Pogzy321
08:40 Reply: Calculating using times (HH:MM) format artifact: 73a0ff3213 user: spindrift
07:11 Reply: Calculating using times (HH:MM) format artifact: 4419848924 user: larrybr
06:47 Reply: Calculating using times (HH:MM) format artifact: 1f75dce053 user: anonymous
06:46 Reply: Calculating using times (HH:MM) format artifact: 803c9b8f8c user: spindrift
06:43 Reply: Calculating using times (HH:MM) format artifact: 60321cdd52 user: spindrift
06:08 Reply: Calculating using times (HH:MM) format artifact: bc4b0b8a56 user: andydoc1
05:56 Reply: Calculating using times (HH:MM) format artifact: 09a41a05d3 user: gunter_hick
05:42 Reply: Calculating using times (HH:MM) format artifact: c11311e695 user: andydoc1
05:01 Reply: Calculating using times (HH:MM) format artifact: 088b2d09ce user: anonymous
04:50 Reply: Calculating using times (HH:MM) format artifact: e0b234398f user: larrybr

2 Years Ago (more context)

2023-06-27
20:50 Reply: Confused about concurrency and sychronization artifact: 11f9e983b3 user: Helios
20:46 Reply: Confused about concurrency and sychronization artifact: c324e6c21f user: Helios
20:34 Edit reply: Resolve hyperlink path from field name artifact: 219c26611b user: kmedcalf
20:31 Edit reply: Resolve hyperlink path from field name artifact: 5610828f6a user: kmedcalf
20:30 Reply: Resolve hyperlink path from field name artifact: 29c2cd9f8b user: kmedcalf
20:25 Reply: Resolve hyperlink path from field name artifact: 1ec947cbe6 user: kmedcalf
20:21 Edit reply: Resolve hyperlink path from field name artifact: b69a7e4987 user: kmedcalf
20:21 Reply: Resolve hyperlink path from field name artifact: 1662a10740 user: kmedcalf
20:14 Reply: Confused about concurrency and sychronization artifact: abf3798bd7 user: kmedcalf
20:12 Reply: Confused about concurrency and sychronization artifact: f8a6866ebd user: kmedcalf
19:45 Reply: Resolve hyperlink path from field name artifact: f1fd22ee68 user: Poco90
18:41 Reply: Confused about concurrency and sychronization artifact: 60f7501cb9 user: Helios
18:26 Reply: Confused about concurrency and sychronization artifact: 4040daabcb user: kmedcalf
18:24 Reply: Confused about concurrency and sychronization artifact: 175b10eadd user: kmedcalf
17:26 Reply: Confused about concurrency and sychronization artifact: fe132a7a7a user: kmedcalf
17:20 Reply: Confused about concurrency and sychronization artifact: f9a190d9f9 user: kmedcalf
16:29 Reply: Confused about concurrency and sychronization artifact: 9d82cf0215 user: Helios
15:53 Edit: sqlite3GlobalConfig.m.xMalloc gets back to null after initializing it to the default artifact: 7a2c1b6a0c user: marcob
15:29 Reply: Confused about concurrency and sychronization artifact: b0341efb0f user: gunter_hick
15:13 Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 1a587e3e55 user: gunter_hick
14:54 Reply: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: c6bf5a859f user: anshumap
14:48 Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: f0d671e343 user: scasaletto
14:29 Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 89a317c727 user: scasaletto
14:20 Post: sqlite3GlobalConfig.m.xMalloc gets back to null after initializing it to the default artifact: 21da853c1e user: marcob
13:52 Reply: Confused about concurrency and sychronization artifact: 22818b4a52 user: Helios
13:31 Reply: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: a0d5565bc0 user: drh
13:19 Reply: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: 7bb7ef0161 user: jicman
13:15 Edit: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: c705d8fe77 user: anshumap
11:11 Reply: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: fa5637f6a8 user: anonymous
11:00 Post: Observed drastic performance degradation in UPDATE..FROM...WHERE query after moving from 3.36.0 to 3.42.0 artifact: 1aa9b0a520 user: anshumap
08:47 Reply: .sha3sum failed on tables with specific contents artifact: 8052a5bfee user: sorcix
06:56 Reply: Confused about concurrency and sychronization artifact: c465b3f9f3 user: gunter_hick
06:21 Reply: Confused about concurrency and sychronization artifact: 3fcb28104c user: Helios
05:34 Reply: Confused about concurrency and sychronization artifact: fdea00efe5 user: gunter_hick
03:25 Post: Confused about concurrency and sychronization artifact: 735371d954 user: Helios
00:14 Reply: Reading SQL from Windows Clipboard artifact: 109572547e user: larrybr

3 Years Ago (more context)

2022-06-27
22:08 Reply: Unclear why join is so much slower than separate queries artifact: af57b56a0f user: jimmorris33215
22:05 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: ed6ba7ce56 user: kmedcalf
21:56 Reply: Status of wal2 branch artifact: 52ed11b87e user: pgregory
21:54 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 37741fdece user: kmedcalf
21:52 Reply: question about json_quote artifact: e9b46a818f user: younique
21:47 Reply: Status of wal2 branch artifact: 2c30cddf94 user: dan
21:42 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 6cc7262cad user: greglearns
20:58 Reply: Unclear why join is so much slower than separate queries artifact: b5166e2d57 user: anonymous
20:30 Post: Unclear why join is so much slower than separate queries artifact: ad5efebc88 user: christoph
20:24 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: b0da75a947 user: anonymous
20:23 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 4507b8ad1d user: anonymous
20:22 Reply: question about wal EXCLUSIVE mode artifact: 4ad4f3cb3c user: anonymous
20:22 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: dd09427fb3 user: anonymous
19:42 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 78005e3435 user: 164896512
19:41 Reply: parallel buils broken artifact: dd8b9be2d1 user: andyrtr
19:32 Post: Request for ENH. XML in the CLI - but only a bit. artifact: 8fd9d9b7d3 user: midijohnny
19:15 Post: question about wal EXCLUSIVE mode artifact: d2adbd9d8b user: anonymous
19:07 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 04457fd0e9 user: 164896512
19:05 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 8fc0e0aed1 user: 164896512
18:28 Reply: Numerical stability of AVG and SUM artifact: a0b458d8ef user: kmedcalf
18:03 Reply: Database does not update artifact: a3add27308 user: hanche
16:49 Reply: Status of wal2 branch artifact: 228884971d user: pgregory
16:24 Reply: combining 2 tables artifact: 607efdcd4d user: larrybr
15:50 Reply: Status of wal2 branch artifact: 270ab832f9 user: pgregory
15:40 Post: combining 2 tables artifact: 2ca29f58c2 user: anonymous
15:36 Reply: WHERE NOT IN query plan optimization artifact: cd12a52b30 user: ddevienne
15:16 Edit reply: Database does not update artifact: d23455c362 user: chrisjlocke1
15:14 Reply: Database does not update artifact: c9e510bd01 user: chrisjlocke1
15:11 Reply: WHERE NOT IN query plan optimization artifact: 27c605852c user: dan
14:31 Post: Database does not update artifact: 56d6e66ad8 user: gagsters888
13:56 Reply: Status of wal2 branch artifact: 49cef62bba user: dan
12:56 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 5bb7988ca4 user: kjames3411
12:29 Edit reply: Status of wal2 branch artifact: 3c67f1b456 user: pgregory
12:25 Reply: parallel buils broken artifact: 98df1a61b9 user: drh
12:18 Reply: Numerical stability of AVG and SUM artifact: d9b60ada09 user: dkfellows
12:03 Edit reply: Status of wal2 branch artifact: 47676c1a26 user: pgregory
11:58 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 865b4d5184 user: billwade
11:35 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: a1365bdf7b user: gunter_hick
10:58 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: d954124f6b user: dkfellows
10:45 Edit reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 819c49b937 user: dkfellows
10:45 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: a5c2116028 user: dkfellows
09:57 Reply: Status of wal2 branch artifact: 34086bd44a user: pgregory
09:54 Post: WHERE NOT IN query plan optimization artifact: b8aab3d863 user: ddevienne
09:32 Edit: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: 252355ed7d user: 164896512
08:58 Post: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? artifact: c106c6ccd2 user: 164896512
07:12 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy artifact: 18628420b5 user: ddevienne
00:50 Reply: Two flaws in the design of SQLite, which should be easily to be fixed artifact: 7434e0100d user: anonymous

4 Years Ago (more context)

2021-06-27
22:53 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 85168394d3 user: larrybr
21:23 Post: cannot create tables in sqlitestudio than other apps can see artifact: f2a2c97b24 user: steveinalabama
21:19 Reply: New version of app, more columns for same table artifact: acada806ff user: anonymous
20:08 Reply: System.DllNotFoundException on MonoDevelop artifact: a1bda0ade0 user: larrybr
20:03 Reply: New version of app, more columns for same table artifact: b1b6f06e58 user: RichardDamon
19:51 Reply: New version of app, more columns for same table artifact: 0f22c02435 user: anonymous
19:44 Reply: New version of app, more columns for same table artifact: 012a204ebd user: larrybr
19:29 Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: 4b03ff6718 user: slavin
19:28 Delete reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: f2eaf07826 user: slavin
19:00 Reply: New version of app, more columns for same table artifact: dfc8d8b622 user: anonymous
17:39 Reply: New version of app, more columns for same table artifact: c78566ac57 user: larrybr
17:22 Post: New version of app, more columns for same table artifact: 492188cb23 user: anonymous
17:18 Post: System.DllNotFoundException on MonoDevelop artifact: 544f1b04b0 user: BanditoWalrus
15:30 Reply: Changing the checksum VFS artifact: 4f116e6af2 user: slavin
15:19 Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: b71b17cd12 user: slavin
15:04 Edit reply: Merge Data artifact: 2a25aee8ae user: larrybr
14:37 Reply: Merge Data artifact: ec7470c76f user: larrybr
11:05 Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: e463f2536f user: RoboManni
10:31 Reply: Feature request: Stored Procedures artifact: 7f55482020 user: RoboManni
02:17 Reply: Better download file naming artifact: 475d3c6dc5 user: doug9forester

5 Years Ago (more context)

2020-06-27
21:17 Reply: SQLITE_HAS_CODE is gone? artifact: 1b9e6264ed user: alaskanarcher
15:35 Edit reply: Problem with Sqlite DELETE documentation artifact: 0630cd5987 user: luuk
15:34 Reply: Problem with Sqlite DELETE documentation artifact: d436f8ab6e user: luuk
14:51 Reply: Query planner fails to use obvious index artifact: ff3a80de99 user: kmedcalf
13:56 Reply: Query planner fails to use obvious index artifact: ab94f3ad9f user: knu
12:20 Reply: Problem with Sqlite DELETE documentation artifact: a7edb11d72 user: LarryBrasfield
12:06 Reply: Problem with Sqlite DELETE documentation artifact: c2ca25c1ad user: kmedcalf
11:49 Reply: Problem with Sqlite DELETE documentation artifact: b6ae700a40 user: slavin
10:12 Reply: Query planner fails to use obvious index artifact: 1fe7488810 user: luuk