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