SQLite User Forum

Today In History
Login

This Day In History For 2025-06-30

1 Year Ago (more context)

2024-06-30
21:30 Reply: XDG base directory specification artifact: 7cded6c660 user: larrybr
21:26 Reply: XDG base directory specification artifact: 6e4faafd34 user: larrybr
20:32 Edit reply: XDG base directory specification artifact: b181fad043 user: hanche
20:10 Reply: XDG base directory specification artifact: 3c5eb39798 user: hanche
18:32 Reply: XDG base directory specification artifact: c41e5d8b63 user: drh
16:44 Reply: XDG base directory specification artifact: 5d1083f2a5 user: hanche
15:51 Reply: XDG base directory specification artifact: f815dcc94d user: vman59
15:39 Edit reply: XDG base directory specification artifact: 15f3d05bf1 user: Hawk777
15:31 Reply: XDG base directory specification artifact: 6d46d59b29 user: Hawk777
15:14 Reply: XDG base directory specification artifact: 5c4c83bb4f user: Hawk777
10:33 Reply: XDG base directory specification artifact: 1a91e37380 user: drh
09:45 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: ab4fe1770a user: chrisjlocke1
09:27 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: 21ab238496 user: anonymous
09:22 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: 8b8b16250b user: anonymous
09:10 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: 71eefbb41f user: anonymous
09:08 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: ae71bb1cf7 user: anonymous
08:45 Edit reply: XDG base directory specification artifact: ba3a0054ac user: stephan
08:05 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: fc5e8ad85a user: anonymous
07:51 Reply: XDG base directory specification artifact: 83c593028e user: stephan
07:47 Reply: Changing columns in a table that has foreign keys, views and triggers artifact: 29cea9a89c user: anonymous
07:38 Reply: XDG base directory specification artifact: f26664d786 user: Hawk777
07:31 Post: Changing columns in a table that has foreign keys, views and triggers artifact: 3d3b6121bf user: anonymous
07:28 Reply: XDG base directory specification artifact: cb0b8a3631 user: stephan
02:19 Reply: SQLITE ON WASM: Trying to write through two tabs simultaneously, Database Error: Attempt to Write a Readonly Database artifact: fdee16e25b user: anonymous
01:30 Post: XDG base directory specification artifact: 5cc6d059e9 user: Hawk777

2 Years Ago (more context)

2023-06-30
20:18 Reply: Column/Cell level storage report artifact: c4782d56e3 user: kmedcalf
19:30 Reply: Upgrading to latest SQLite with SEE not backwards compatible artifact: 809975ec0a user: anonymous
17:43 Reply: Upgrading to latest SQLite with SEE not backwards compatible artifact: bec8f78bf9 user: mistachkin
16:56 Reply: Upgrading to latest SQLite with SEE not backwards compatible artifact: eed0a82aef user: anonymous
16:30 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: ec01435172 user: spindrift
16:28 Reply: SQLite and PGO results artifact: 43f675e36e user: spindrift
16:04 Reply: Column/Cell level storage report artifact: ad473526b0 user: deonb
15:46 Reply: Column/Cell level storage report artifact: ce810390f3 user: kmedcalf
15:45 Reply: SQLite and PGO results artifact: 1caf270c5e user: zamazan4ik
15:35 Post: Column/Cell level storage report artifact: 74b10d4f83 user: deonb
15:26 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: f6eb7ee29b user: jicman
15:08 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: 50fa029e0e user: stephan
15:04 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: 19d1fb856e user: jicman
15:02 Reply: Inaccurate Statement artifact: a730ae1928 user: kmedcalf
14:56 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: 2445dcfed6 user: stephan
14:51 Reply: Could Fossil's email subsystem be taught to send the digests as a thread view? artifact: 210f386a46 user: sqlitevexee
13:16 Edit: counting word frequency (IDF) artifact: b527d78caf user: punkish
13:15 Edit: counting word frequency (IDF) artifact: aadcfe10b0 user: punkish
13:12 Post: counting word frequency (IDF) artifact: 51670692c2 user: punkish
12:04 Edit reply: Conversion msaccess mdb to SQLite artifact: 3cbd0d3801 user: sqlitening
11:57 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: e4991faeae user: chrisjlocke1
11:48 Edit reply: Conversion msaccess mdb to SQLite artifact: 73272ebc19 user: sqlitening
11:43 Reply: Conversion msaccess mdb to SQLite artifact: c123e38d85 user: sqlitening
11:34 Edit reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: f99b5caf75 user: AAsk1902
11:33 Edit reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: e5e943c75b user: AAsk1902
11:28 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: d28d8a8fa7 user: AAsk1902
11:16 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: f34c2c24a2 user: chrisjlocke1
10:11 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: 85bf2c8d99 user: AAsk1902
09:55 Reply: PRAGMA integrity_check artifact: 2434bbf28e user: dvospierre
09:50 Reply: Conversion msaccess mdb to SQLite artifact: 63be148955 user: sqlitening
09:40 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: d651b96aab user: chrisjlocke1
09:24 Edit reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: fb481df906 user: AAsk1902
09:15 Reply: Trivial C# shell to use winsqlite3.dll (sample code) artifact: fea062f7b0 user: AAsk1902
07:43 Reply: Inaccurate Statement artifact: fe6975f772 user: jchd18
05:42 Reply: Confused about concurrency and sychronization artifact: 4f5605865d user: Helios
03:16 Reply: Confused about concurrency and sychronization artifact: 0f78b452df user: sqweek
00:43 Reply: Inaccurate Statement artifact: 3898c52670 user: kmedcalf
00:33 Reply: Inaccurate Statement artifact: 67f3edb41c user: kmedcalf
00:20 Reply: Inaccurate Statement artifact: a12a86d60c user: larrybr
00:14 Edit reply: Inaccurate Statement artifact: 5f31b2569e user: larrybr
00:04 Reply: Inaccurate Statement artifact: 5352e87fac user: larrybr

3 Years Ago (more context)

2022-06-30
23:10 Reply: Speed up this query, if possible artifact: e2c551bc57 user: cuz
21:07 Post: Speed up this query, if possible artifact: 3b877d831a user: jicman
20:06 Reply: Does Sqlite Forum use Sqlite? artifact: dfb56a6bf5 user: ThanksRyan
20:03 Reply: Does Sqlite Forum use Sqlite? artifact: a32cb92570 user: larrybr
19:39 Reply: Does Sqlite Forum use Sqlite? artifact: c62e3c8154 user: anonymous
19:30 Reply: Does Sqlite Forum use Sqlite? artifact: 7ecf289d32 user: larrybr
19:28 Post: Does Sqlite Forum use Sqlite? artifact: b6d456390b user: anonymous
18:05 Reply: sqlite3_prepare_v2() fails on string literal with a semicolon on Android artifact: 8530f973b2 user: larrybr
17:25 Reply: 'image is malformed' in in-memory database artifact: 3722deb766 user: mistachkin
16:30 Reply: sqlite3_prepare_v2() error on Android artifact: e6ece82456 user: chrisjlocke1
16:06 Reply: sqlite3_prepare_v2() fails on string literal with a semicolon on Android artifact: d95bd3dff7 user: dan
15:23 Reply: sqlite3_prepare_v2() error on Android artifact: 3215ef79ec user: anonymous
14:28 Reply: sqlite3_prepare_v2() error on Android artifact: bda993fe2b user: cuz
14:27 Reply: (Deleted) artifact: 8ad7f33351 user: nmmnmm
14:10 Reply: (Deleted) artifact: 356b6bddeb user: drh
14:08 Reply: (Deleted) artifact: 9c558d43d3 user: nmmnmm
13:59 Edit: (Deleted) artifact: e65db5c820 user: drh
13:55 Reply: (Deleted) artifact: 047d4080b1 user: drh
13:54 Reply: sqlite3_prepare_v2() fails on string literal with a semicolon on Android artifact: bc8a5f34c1 user: nmmnmm
13:53 Edit: (Deleted) artifact: d8c0d12cd7 user: drh
13:51 Reply: DB Abstraction/validation artifact: 6067f2936b user: gunter_hick
13:48 Reply: DB Abstraction/validation artifact: 7905635da6 user: dkfellows
13:40 Post: sqlite3_prepare_v2() error on Android artifact: 5fe4c05608 user: nmmnmm
13:39 Post: (Deleted) artifact: 84644b5ba5 user: nmmnmm
13:37 Reply: sqlite3_prepare_v2() fails on string literal with a semicolon on Android artifact: 9e5520db83 user: dkfellows
13:33 Post: sqlite3_prepare_v2() fails on string literal with a semicolon on Android artifact: 21dd4e4bd1 user: nmmnmm
13:32 Reply: DB Abstraction/validation artifact: 428d4a7d86 user: 11091109
13:22 Reply: Is there a way to change a column type from INTEGER to TEXT without copying of the table? artifact: 7c387fda1d user: drh
13:10 Edit reply: Is there a way to change a column type from INTEGER to TEXT without copying of the table? artifact: 6007e6d1f5 user: curmudgeon
13:07 Reply: Is there a way to change a column type from INTEGER to TEXT without copying of the table? artifact: 365d02a310 user: curmudgeon
12:58 Reply: Is there a way to change a column type from INTEGER to TEXT without copying of the table? artifact: 1cafc2f51c user: gunter_hick
12:44 Reply: DB Abstraction/validation artifact: 8a92417c80 user: gunter_hick
12:39 Reply: DB Abstraction/validation artifact: 83f0b0ce96 user: knu
12:37 Post: Is there a way to change a column type from INTEGER to TEXT without copying of the table? artifact: b639da02ad user: 164896512
12:21 Reply: Numerical stability of AVG and SUM artifact: 30c7531b3d user: dkfellows
12:08 Reply: Besides the page, what is SQLite flushing? artifact: 0d484d7e48 user: Timhe95
11:31 Post: DB Abstraction/validation artifact: 29e0921442 user: 11091109
09:47 Reply: 'image is malformed' in in-memory database artifact: 0f65cc11a6 user: cmgain
09:41 Reply: Besides the page, what is SQLite flushing? artifact: 085de7f03f user: sqweek
09:19 Reply: Besides the page, what is SQLite flushing? artifact: 422d9bc925 user: Timhe95
07:11 Reply: 'image is malformed' in in-memory database artifact: 7faf1d2b9e user: sqweek
04:49 Reply: Besides the page, what is SQLite flushing? artifact: 6d8d6b4843 user: sqweek
02:47 Edit reply: Besides the page, what is SQLite flushing? artifact: 18f5d30d0b user: Timhe95
02:29 Reply: Besides the page, what is SQLite flushing? artifact: 325cc200a0 user: Timhe95
01:31 Reply: Prevent prefixes in column artifact: 8d869f53d3 user: kmedcalf
01:19 Reply: Prevent prefixes in column artifact: 497002cad9 user: kmedcalf

4 Years Ago (more context)

2021-06-30
23:46 Reply: SQLite3.exe Command shell: Iterate over table of csv files? artifact: 8a6f565af4 user: kmedcalf
21:31 Reply: Very Newbie Question artifact: 2f002143f6 user: larrybr
21:17 Edit reply: Better download file naming artifact: 7d354175e8 user: larrybr
21:13 Edit reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: 2345d136e4 user: hanche
21:09 Reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: f6d3273fb1 user: hanche
21:09 Reply: SQLite3.exe Command shell: Iterate over table of csv files? artifact: 13f6280799 user: larrybr
20:27 Post: SQLite3.exe Command shell: Iterate over table of csv files? artifact: fa247cc1ad user: GavinHolt
20:21 Reply: Should we recreate database for these error codes SQLITE_INTERNAL/SQLITE_FORMAT/SQLITE_EMPTY/SQLITE_NOLFS ? artifact: a9b7c4d722 user: larrybr
20:12 Reply: Compiling 3.36 source code artifact: 4f68229671 user: larrybr
20:06 Reply: Better download file naming artifact: 8182a1560e user: larrybr
19:47 Reply: 4 automatically generated tests that trigger UBSAN interger related errors artifact: 006d569c84 user: drh
18:59 Post: Compiling 3.36 source code artifact: 11ce5ad9d2 user: anonymous
18:23 Post: 4 automatically generated tests that trigger UBSAN interger related errors artifact: 65660d3a74 user: LostBenjamin
18:09 Reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: 195d361259 user: dvdraymond
17:47 Reply: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: 7ff119ccca user: mingodad
17:35 Post: Should we recreate database for these error codes SQLITE_INTERNAL/SQLITE_FORMAT/SQLITE_EMPTY/SQLITE_NOLFS ? artifact: 78adc2ac16 user: Shikha
17:17 Post: Duplicated rows (and missing rows) when SELECTing with ORDER BY artifact: 828703321b user: marius.shekow
17:03 Reply: cannot create tables in sqlitestudio than other apps can see artifact: b9d95bed6a user: steveinalabama
16:33 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 2d7395e4ea user: larrybr
16:10 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 2cc8f61f48 user: steveinalabama
15:56 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 7d8ccde631 user: steveinalabama
14:49 Reply: Is there a 64 bit sqlite3.exe available to avoid out of memory error? artifact: 48ed69cbeb user: slavin
13:15 Reply: Loading bundled extensions in dotnet on linux artifact: b7e78a4fd0 user: holgerj
13:11 Reply: Very Newbie Question artifact: 535bdf3bd5 user: holgerj
12:42 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 9d62d2740b user: wyoung
12:16 Reply: ThreadSantizer warning for sqlite3_enable_shared_cache() artifact: 53186246c1 user: drh
11:57 Edit reply: fts5 rowid peculiarity in UPDATE FROM artifact: 02564bc926 user: Maxulite
11:57 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 35fa8d1e5f user: drh
11:56 Reply: fts5 rowid peculiarity in UPDATE FROM artifact: e1962fd1d4 user: Maxulite
11:31 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 0b81c3e32f user: wyoung
11:25 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 6d11f3b161 user: anonymous
11:23 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: cc1757bd91 user: cuz
11:15 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 72c640bdb5 user: cuz
11:13 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: d1a9fafcd0 user: wyoung
11:09 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 891699e083 user: cuz
10:58 Post: Loading bundled extensions in dotnet on linux artifact: e1f567e4b9 user: marco6
10:50 Reply: cannot create tables in sqlitestudio than other apps can see artifact: faa4d5d9ce user: cuz
10:33 Post: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 17735aa21f user: wyoung
05:29 Reply: php sqlite3_create_window_function artifact: b6077e33be user: lexfiend
03:19 Edit reply: Crashed at sqlite3LeaveMutexAndCloseZombie+452 artifact: 672fc7481b user: EricYeh
03:17 Reply: Crashed at sqlite3LeaveMutexAndCloseZombie+452 artifact: 1a819b97f4 user: EricYeh
01:57 Reply: cannot create tables in sqlitestudio than other apps can see artifact: b5b82f17b8 user: steveinalabama
01:05 Reply: Better download file naming artifact: 2205cf1864 user: larrybr
00:37 Reply: Better download file naming artifact: 9f84e8f5f0 user: RandomCoder
00:21 Reply: Better download file naming artifact: 30e9f69450 user: larrybr
00:06 Reply: Better download file naming artifact: e7f2232c32 user: larrybr

5 Years Ago (more context)

2020-06-30
23:26 Post: pointer to memory as index? artifact: c7659e19c9 user: anonymous
22:53 Reply: .read with parameters... or alternative? artifact: b8d52d2096 user: LarryBrasfield
22:39 Reply: Query planner fails to use obvious index artifact: 195b7e6dcd user: LarryBrasfield
22:13 Reply: Can VACUUM rollback the db? artifact: e9d63be82d user: Flohack
21:36 Reply: Query planner fails to use obvious index artifact: c4bed2430a user: cuz
21:00 Post: .read with parameters... or alternative? artifact: 0c5c4e4a31 user: lcarlp
20:42 Edit reply: Query planner fails to use obvious index artifact: e413498cc2 user: LarryBrasfield
20:42 Edit reply: Query planner fails to use obvious index artifact: 9c2ccb66e3 user: LarryBrasfield
20:39 Reply: Query planner fails to use obvious index artifact: 8a5cd4cf43 user: LarryBrasfield
20:01 Reply: Sum precision ? artifact: 786f1d4449 user: kmedcalf
17:27 Reply: Bug with UPSERT and generated columns? artifact: 8cbbae4ecd user: iffycan
16:45 Reply: How do create the neat flow diagrams for SQLite? artifact: 43136d83a0 user: marco.m
16:39 Reply: Sum precision ? artifact: 13a427e233 user: drh
16:32 Reply: Query planner fails to use obvious index artifact: 525bf107b2 user: cuz
15:22 Edit reply: Removing not null constraint doesn't behave correctly artifact: a67c4a174f user: LarryBrasfield
15:21 Edit reply: Removing not null constraint doesn't behave correctly artifact: b3046bc953 user: LarryBrasfield
15:05 Delete reply: Removing not null constraint doesn't behave correctly artifact: b1b0f91130 user: LarryBrasfield
14:35 Reply: Removing not null constraint doesn't behave correctly artifact: 37337b150f user: LarryBrasfield
14:25 Post: Removing not null constraint doesn't behave correctly artifact: 564a24a0be user: anonymous
14:22 Edit reply: Sum precision ? artifact: 8a5bd82b42 user: LarryBrasfield
14:19 Reply: Sum precision ? artifact: 9e64ae8d16 user: RichardDamon
14:18 Reply: Sum precision ? artifact: 4319a7cdc1 user: LarryBrasfield
14:17 Reply: Sum precision ? artifact: 0bc30912c4 user: itandetnik
13:33 Post: Sum precision ? artifact: c782486361 user: mingodad
10:44 Reply: Which C standard does Sqlite's source code compatible? artifact: bb1b3b3e22 user: stephan
10:21 Reply: How do create the neat flow diagrams for SQLite? artifact: 09e67fb8b9 user: nor
10:09 Reply: Creating Database with Visual Studio artifact: 13c9025785 user: anonymous
09:59 Reply: Using a VFS shim together with another user-specified VFS artifact: 19674a9956 user: aloys
09:27 Reply: Can VACUUM rollback the db? artifact: c3b654146c user: sqweek
09:11 Reply: Can VACUUM rollback the db? artifact: defe489a63 user: kmedcalf
07:13 Reply: Can VACUUM rollback the db? artifact: e9e9db5ded user: Flohack
06:33 Edit reply: Do not auto reset after schema change artifact: e73eb1de19 user: kmedcalf
06:31 Edit reply: Do not auto reset after schema change artifact: 3d787d5ab9 user: kmedcalf
06:24 Reply: Do not auto reset after schema change artifact: a9e809065d user: kmedcalf
06:13 Post: Creating Database with Visual Studio artifact: 00f1215f41 user: Maddy2020
06:07 Reply: Do not auto reset after schema change artifact: e54182143b user: kmedcalf
05:10 Reply: Query planner fails to use obvious index artifact: 5c9159c36c user: EriccG
02:53 Reply: Can VACUUM rollback the db? artifact: f8e8969f30 user: sqweek
02:37 Reply: Do not auto reset after schema change artifact: 56e95854fd user: LarryBrasfield
02:35 Reply: Query planner fails to use obvious index artifact: fbbcddbcce user: sqweek
01:23 Reply: Do not auto reset after schema change artifact: 42e92e59fb user: RichardDamon
00:17 Edit: PATCH Add SQLITE_ENABLE_CARRAY artifact: b5ed570e4c user: Arfrever