SQLite User Forum

Today In History
Login

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