This Day In History For 2025-10-25
1 Year Ago (more context)
2024-10-25
| ||
23:31 | • Post: What is the expected output of "PRAGMA optimize(-1);" ? artifact: c058b50ff3 user: nexushoratio | |
20:43 | • Reply: Official support for BEGIN CONCURRENT artifact: 310e45565c user: stephan | |
20:03 | • Reply: Official support for BEGIN CONCURRENT artifact: d38ac9031e user: anonymous | |
19:41 | • Post: Removing rowid from table, will it affect sqlite journaling artifact: d777102fd8 user: Yali1986 | |
16:25 | • Reply: Aggregate/Window Functions in Lateral Join Segfault artifact: 59d28e52a5 user: drh | |
16:21 | • Edit reply: Aggregate/Window Functions in Lateral Join Segfault artifact: 405b806ad1 user: drh | |
16:14 | • Reply: Announce: migration of the build system to autosetup artifact: a0f8b59e13 user: _blgl_ | |
15:33 | • Reply: Announce: migration of the build system to autosetup artifact: 5fbbce94c6 user: mark | |
15:07 | • Reply: Announce: migration of the build system to autosetup artifact: 8aa172844f user: drh | |
14:58 | • Reply: Announce: migration of the build system to autosetup artifact: 8acbc51e40 user: stephan | |
12:35 | • Edit reply: VTab Auto Index artifact: d0d9f03a43 user: stephan | |
12:26 | • Reply: Rolling Up a json_tree Table artifact: d47aa3fe76 user: stephan | |
11:31 | • Reply: VTab Group By Speed Improvement artifact: 5f45195112 user: anonymous | |
11:29 | • Reply: VTab Auto Index artifact: ef28c879b4 user: anonymous | |
09:39 | • Reply: Transpose row tuple to column tuple artifact: b8c61a0445 user: punkish | |
06:55 | • Post: Rolling Up a json_tree Table artifact: 0e0e6a9456 user: anonymous | |
2 Years Ago (more context)
2023-10-25
| ||
21:40 | • Reply: Confirmations about the custom build documentation artifact: 37338b8234 user: rogerbinns | |
21:07 | • Reply: Confirmations about the custom build documentation artifact: e0b436e7a8 user: larrybr | |
20:43 | • Edit reply: SQLite version 3.44.0 now in beta artifact: b102dbebd6 user: SeverKetor | |
19:10 | • Reply: Foreign key constraint ignored on inserts (FK enabled) artifact: 3c02b0ce4c user: dvdraymond | |
19:06 | • Reply: Foreign key constraint ignored on inserts (FK enabled) artifact: e3028f77cf user: TripeHound | |
17:51 | • Post: minor discrepancy in database header field description artifact: 93b2ecbc00 user: rhashimoto | |
17:30 | • Reply: Foreign key constraint ignored on inserts (FK enabled) artifact: 92446b45fa user: larrybr | |
17:09 | • Reply: Foreign key constraint ignored on inserts (FK enabled) artifact: 9852560662 user: dvdraymond | |
16:55 | • Reply: Foreign key constraint ignored on inserts (FK enabled) artifact: fd2db92f4b user: jul_nicolas | |
16:27 | • Edit: Random slow queries during read (SELECT with join from FTS5 table) maybe due to caching issues artifact: 4aff972dd0 user: ncifra | |
16:26 | • Edit: Random slow queries during read (SELECT with join from FTS5 table) maybe due to caching issues artifact: 268310b1d3 user: ncifra | |
16:11 | • Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: ce4e8a5882 user: doug9forester | |
15:17 | • Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: 4f05792604 user: ddevienne | |
15:16 | • Post: Default MMAP limit on 64 bit artifact: e664376003 user: rogerbinns | |
14:53 | • Edit: Random slow queries during read (SELECT with join from FTS5 table) maybe due to caching issues artifact: ff6e8eafbd user: ncifra | |
14:50 | • Post: Random slow queries during read (SELECT with join from FTS5 table) maybe due to caching issues artifact: d0f956b934 user: ncifra | |
14:40 | • Reply: SQLite version 3.44.0 now in beta artifact: 0eafb0aa04 user: rogerbinns | |
13:38 | • Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: 3acc380b72 user: anonymous | |
12:40 | • Edit: (Deleted) artifact: 703efd7d74 user: ncifra | |
12:40 | • Edit: (Deleted) artifact: f597bd84ed user: ncifra | |
12:35 | • Reply: Can not reset forum password artifact: 9bbd5691ab user: ncifra | |
12:25 | • Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: 49cdd8b6d8 user: anonymous | |
12:21 | • Reply: Can not reset forum password artifact: bf325f702c user: drh | |
12:01 | • Reply: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: d105023f74 user: drh | |
11:58 | • Post: Can not reset forum password artifact: 0472ad6967 user: anonymous | |
11:56 | • Post: Is it safe now to use the 20 'Reserved' bytes at offset 72 in database file header? artifact: 9c5aa3a658 user: anonymous | |
11:39 | • Reply: SQLite version 3.44.0 now in beta artifact: 4431bc92e6 user: drh | |
11:27 | • Reply: SQLite version 3.44.0 now in beta artifact: a46b90d229 user: drh | |
10:57 | • Reply: Issue with with snippet() and highlight() with fts5 in trigram tokenization mode artifact: 43a61c2699 user: anonymous | |
09:59 | • Reply: SQLite version 3.44.0 now in beta artifact: 603739e863 user: mark | |
09:32 | • Reply: SQLite version 3.44.0 now in beta artifact: cf6a2c4c75 user: jchd18 | |
09:04 | • Reply: SQLite version 3.44.0 now in beta artifact: f9c75f8a72 user: mark | |
01:49 | • Edit reply: SQLite version 3.44.0 now in beta artifact: ac736e28ea user: SeverKetor | |
01:48 | • Edit reply: SQLite version 3.44.0 now in beta artifact: 8340506b26 user: SeverKetor | |
01:45 | • Reply: SQLite version 3.44.0 now in beta artifact: 3b4c014a7b user: SeverKetor | |
01:37 | • Reply: Rare Corruption using SQLite WASM artifact: f79fe73882 user: randyl | |
01:31 | • Reply: SQLite version 3.44.0 now in beta artifact: 12c8760e6a user: larrybr | |
00:59 | • Reply: SQLite version 3.44.0 now in beta artifact: d7576132b2 user: SeverKetor | |
00:00 | • Reply: SQLite version 3.44.0 now in beta artifact: 965c0d02ea user: rogerbinns | |
3 Years Ago (more context)
2022-10-25
| ||
22:35 | • Reply: store dimensions that never change in normalized form or columns? artifact: 27c76a4232 user: biodrool | |
22:20 | • Reply: Checks are not validated in strict tables artifact: 3792f20013 user: cuz | |
22:06 | • Reply: feature req VACUUM INTO trigger artifact: 677a1f5bf6 user: slavin | |
22:05 | • Reply: Access underlying rowid even when overwritten artifact: 7b1d3f6bdf user: slavin | |
21:55 | • Edit reply: Checks are not validated in strict tables artifact: f6b3aadf0c user: cuz | |
21:45 | • Reply: Checks are not validated in strict tables artifact: 616c6cbe22 user: anonymous | |
21:45 | • Reply: Checks are not validated in strict tables artifact: 183183237b user: adrian.s | |
21:43 | • Reply: Checks are not validated in strict tables artifact: fe98fc5a8f user: anonymous | |
21:09 | • Reply: Checks are not validated in strict tables artifact: 4b584ccbf6 user: cuz | |
20:47 | • Post: Checks are not validated in strict tables artifact: bd9082d1c3 user: adrian.s | |
20:04 | • Edit reply: (Deleted) artifact: 9d54547897 user: wyoung | |
20:03 | • Reply: (Deleted) artifact: 02393b0614 user: wyoung | |
19:55 | • Post: Local time zone UTC offset in SQLite query artifact: b4274ede64 user: anonymous | |
19:54 | • Reply: (Deleted) artifact: 625214961b user: kristyb8 | |
19:38 | • Reply: regression or bugfix? json_group_array over subquery double escapes quotes artifact: a94acb1224 user: iffycan2 | |
19:19 | • Post: Access underlying rowid even when overwritten artifact: c246c076e6 user: adrian.s | |
19:04 | • Reply: regression or bugfix? json_group_array over subquery double escapes quotes artifact: df15f22609 user: drh | |
19:01 | • Reply: regression or bugfix? json_group_array over subquery double escapes quotes artifact: c96206d45c user: stephan | |
18:48 | • Post: regression or bugfix? json_group_array over subquery double escapes quotes artifact: 29fae4fbf2 user: iffycan2 | |
17:32 | • Post: feature req VACUUM INTO trigger artifact: a354d0b537 user: ingo | |
17:31 | • Reply: (Deleted) artifact: 2484fc06a7 user: wyoung | |
17:27 | • Reply: (Deleted) artifact: 6bc56133c9 user: mbenningfield1 | |
16:58 | • Reply: store dimensions that never change in normalized form or columns? artifact: 11ec3d45e5 user: biodrool | |
16:54 | • Reply: store dimensions that never change in normalized form or columns? artifact: a838003f6d user: biodrool | |
15:33 | • Reply: SQLITE_READONLY for WAL Mode artifact: ef4142506f user: dan | |
15:20 | • Reply: (Deleted) artifact: a0d6768b4a user: wyoung | |
15:06 | • Reply: (Deleted) artifact: 156615593b user: mbenningfield1 | |
14:15 | • Reply: SQLITE_READONLY for WAL Mode artifact: 38034a2d54 user: benbjohnson | |
14:01 | • Reply: VACUUM INTO 'other.db' and fsync artifact: a00368874b user: willemv | |
13:47 | • Reply: Segfault in patternCompare() artifact: 4221a59c72 user: drh | |
13:35 | • Reply: export/import of binary data in csv artifact: ef3a971c4f user: cuz | |
13:06 | • Reply: export/import of binary data in csv artifact: c4f61c3041 user: kjames3411 | |
13:00 | • Post: Segfault in patternCompare() artifact: 730b554179 user: geeknik | |
12:42 | • Reply: Ignore/override a user's .sqliterc artifact: cf45b87f7f user: CristianCantoro | |
12:28 | • Reply: export/import of binary data in csv artifact: cd51a3a602 user: jicman | |
12:25 | • Reply: (Deleted) artifact: 03ae7c3c19 user: AAsk1902 | |
12:11 | • Reply: (Deleted) artifact: 04df36ae19 user: mbenningfield1 | |
11:01 | • Reply: (Deleted) artifact: 1efd755959 user: chrisjlocke1 | |
10:24 | • Edit reply: BUG Loading table dump produces malformed image artifact: 4c9a992a40 user: drh | |
10:22 | • Reply: BUG Loading table dump produces malformed image artifact: 50eda72707 user: drh | |
09:12 | • Post: (Deleted) artifact: 39a4221c93 user: mbenningfield1 | |
08:35 | • Edit reply: Impact of the big UNIX mutex lock on performance and scalability artifact: cd6eec7505 user: stephan | |
08:13 | • Reply: Impact of the big UNIX mutex lock on performance and scalability artifact: ec94fe0b7b user: ddevienne | |
08:07 | • Post: BUG Loading table dump produces malformed image artifact: 68683b2d3c user: ethanpet113 | |
07:53 | • Reply: SQLITE_READONLY for WAL Mode artifact: 9a2724a019 user: ddevienne | |
02:52 | • Edit: (Deleted) artifact: a91b473488 user: stephan | |
02:45 | • Edit: (Deleted) artifact: d5628f3509 user: stephan | |
02:01 | • Post: (Deleted) artifact: a5e19375a8 user: anonymous | |
00:05 | • Reply: Ignore/override a user's .sqliterc artifact: b41e840239 user: larrybr | |
4 Years Ago (more context)
2021-10-25
| ||
23:06 | • Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: c33881c335 user: kmedcalf | |
22:27 | • Post: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: bc0ddb7834 user: Minoru | |
12:07 | • Delete reply: 100x jump in query time with IN operator artifact: 33515d88e3 user: gunter_hick | |
12:06 | • Reply: 100x jump in query time with IN operator artifact: 5a04e3117b user: gunter_hick | |
12:06 | • Reply: 100x jump in query time with IN operator artifact: a3d68ed8b4 user: gunter_hick | |
08:00 | • Post: 100x jump in query time with IN operator artifact: e7b9a0d7db user: Prinzhorn | |
5 Years Ago (more context)
2020-10-25
| ||
19:06 | • Reply: Bad query results involving random() artifact: 21c01588a2 user: cuz | |
17:43 | • Reply: Bad query results involving random() artifact: 3792df9970 user: yorhel | |
16:23 | • Reply: Bad query results involving random() artifact: d27f5cdcc8 user: cuz | |
14:42 | • Post: Bad query results involving random() artifact: a2aebc1eb2 user: yorhel | |