SQLite User Forum

Today In History
Login

This Day In History For 2025-10-21

1 Year Ago (more context)

2024-10-21
23:40 Post: typedef issue for sqlite3 3.47.0 tcl extension artifact: cf658663b1 user: mschamschula
23:20 Reply: System.Data.SQLite: SQLiteDataReader.GetSchemaTable() and UNIQUEness of columns artifact: ab9779d7b9 user: mistachkin
23:12 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 0573974be8 user: drh
23:07 Reply: Announce: migration of the build system to autosetup artifact: b04ef35fe4 user: rogerbinns
22:58 Reply: Announce: migration of the build system to autosetup artifact: 52a140d681 user: stephan
22:50 Reply: Announce: migration of the build system to autosetup artifact: 28efc2eae4 user: rogerbinns
22:43 Reply: Announce: migration of the build system to autosetup artifact: a3669f3d7d user: stephan
22:23 Reply: Announce: migration of the build system to autosetup artifact: 8f70866ef5 user: rogerbinns
22:20 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 4183e5e9c3 user: _blgl_
22:08 Reply: Announce: migration of the build system to autosetup artifact: d406db4c27 user: stephan
21:54 Reply: Announce: migration of the build system to autosetup artifact: 75cb317921 user: rogerbinns
21:26 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 4948865b99 user: DennisDoesEverything
21:08 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 2e4c991897 user: DennisDoesEverything
20:38 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 54315d03ee user: drh
20:30 Edit reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: ad533ced7f user: DennisDoesEverything
20:29 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: 0e55150666 user: DennisDoesEverything
20:21 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: e0c7566977 user: DennisDoesEverything
19:32 Reply: Can't build Windows sqlite3.exe using cygwin artifact: 9a53853b12 user: jicman
19:30 Reply: VTab Auto Index artifact: d06d9d5b91 user: drh
19:24 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: ce5a58dc4f user: drh
19:17 Reply: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: ac0f365207 user: stephan
19:16 Reply: VTab Auto Index artifact: 2070919b78 user: arobincaron
19:13 Post: sqlite3-rsync returns error, "Unknown message 0x8c 148 bytes into conversation" artifact: a4c1432e8a user: DennisDoesEverything
19:11 Reply: VTab Group By Speed Improvement artifact: 8e7cd78ce1 user: arobincaron
18:53 Post: Announce: migration of the build system to autosetup artifact: b7e2d83c0b user: stephan
18:27 Reply: Feature Request: 'Compact' JSON Support from CLI artifact: d24f2e02fc user: alexgarciaxyz
17:48 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: a3c1ed7489 user: anonymous
17:01 Reply: Feature Request: 'Compact' JSON Support from CLI artifact: f2fc41f2dd user: stephan
16:47 Reply: Feature Request: 'Compact' JSON Support from CLI artifact: b81aade356 user: llawrence
15:34 Edit: System.Data.SQLite: SQLiteDataReader.GetSchemaTable() and UNIQUEness of columns artifact: 858cf4eef9 user: Lemmes
15:26 Reply: Three very minor documentation nits artifact: 414d6e59d7 user: stephan
15:09 Post: Three very minor documentation nits artifact: 232622ca16 user: dfgriggs
15:04 Reply: Feature Request: Increase Maximum Page Limit artifact: 053039fe09 user: dan
15:03 Reply: Tiny documentation nit artifact: c469e5301b user: stephan
14:44 Reply: Feature Request: Increase Maximum Page Limit artifact: c240095c51 user: nuclight
14:14 Reply: CVE-2021-31239 artifact: 2dbc81761a user: drh
13:56 Post: CVE-2021-31239 artifact: f15f2ab0b2 user: anonymous
13:45 Post: System.Data.SQLite: SQLiteDataReader.GetSchemaTable() and UNIQUEness of columns artifact: 2842d72c23 user: Lemmes
13:08 Reply: SQLITE_ERROR: sqlite3 result code 1: no such column: artifact: 95cd5cc9a1 user: bombshell
13:08 Reply: SQLITE_ERROR: sqlite3 result code 1: no such column: artifact: 69f9036a88 user: bombshell
10:40 Post: Tiny documentation nit artifact: b7b72b74c1 user: _blgl_
09:40 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: 8562353d68 user: Maxulite
09:23 Edit reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: 89a363525a user: hanche
09:09 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: 393c651ce1 user: hanche
09:08 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: 2ed0ae979c user: gunter_hick
08:55 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: efcbe99d32 user: gunter_hick
07:05 Reply: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: 49ff64cbdc user: AAsk1902
06:11 Edit: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: c05a71941e user: stephan
06:05 Post: Unnamed columns in CTE match values when used with IN and 'id' as column name artifact: b999e98704 user: anonymous
05:48 Reply: SQLITE_ERROR: sqlite3 result code 1: no such column: artifact: e12ce82db3 user: gunter_hick
05:36 Reply: Relation: token, token pairs and try select artifact: f2877b21a2 user: gunter_hick

2 Years Ago (more context)

2023-10-21
21:45 Reply: Timediff not working artifact: 3d091cd350 user: anonymous
21:30 Post: Unexpected result with journal_mode=WAL and attached read-only DB artifact: ad0e4d64c4 user: paulclinger
20:42 Reply: Timediff not working artifact: b110f97a71 user: larrybr
20:40 Reply: Timediff not working artifact: 5d2148535a user: drh
20:13 Post: Timediff not working artifact: 7e1bf4c81b user: anonymous
16:41 Reply: An event based system to avoid frequent sleeps in my busy handler? artifact: eee51b0565 user: Eduardo
14:39 Reply: Can the views pro week be done with a weeknumber artifact: e894963dea user: CecilWesterhof
13:53 Reply: Can the views pro week be done with a weeknumber artifact: e149d2c1d2 user: cuz
10:33 Reply: Can the views pro week be done with a weeknumber artifact: 769478d338 user: CecilWesterhof
07:40 Reply: concat, concat_ws, T-SQL artifact: 0120d9d811 user: SeverKetor
00:46 Reply: Is changeset feature available in System.Data.SQLite? any document/tutorial? artifact: 2aaa6a20fa user: larrybr

3 Years Ago (more context)

2022-10-21
21:02 Reply: Listing two tables in the same row artifact: a52996f5a4 user: jicman
20:36 Reply: Listing two tables in the same row artifact: cb719a0439 user: kmedcalf
20:27 Reply: Listing two tables in the same row artifact: 3050c243e2 user: jicman
20:26 Edit reply: Listing two tables in the same row artifact: 129703fb76 user: kmedcalf
20:23 Reply: Listing two tables in the same row artifact: fd4511c040 user: jicman
20:17 Reply: Listing two tables in the same row artifact: c4a11a544c user: kmedcalf
19:50 Reply: Listing two tables in the same row artifact: 859ae9a977 user: kmedcalf
19:45 Reply: Listing two tables in the same row artifact: a5a2413fbf user: kmedcalf
18:44 Reply: Listing two tables in the same row artifact: 6bd210825e user: jicman
18:33 Reply: Listing two tables in the same row artifact: eed5ea5a9c user: jicman
18:30 Reply: Listing two tables in the same row artifact: da0771fb34 user: kmedcalf
18:29 Reply: Listing two tables in the same row artifact: e37bcf3dcf user: kmedcalf
18:19 Reply: Listing two tables in the same row artifact: 98f8a57f6d user: kmedcalf
18:04 Post: Listing two tables in the same row artifact: 9ecc88356a user: jicman
17:55 Reply: Documentation to compile specific configuration artifact: d80f34caf8 user: stephan
17:23 Reply: export/import of binary data in csv artifact: 09a370f412 user: kmedcalf
17:07 Post: export/import of binary data in csv artifact: 7e4830def7 user: anonymous
17:06 Reply: CLI Non fatal error artifact: 9158f86401 user: AAsk1902
16:58 Edit reply: CLI Non fatal error artifact: 7c81ca299c user: AAsk1902
16:57 Reply: CLI Non fatal error artifact: 6a4d9459e3 user: AAsk1902
16:44 Edit reply: CLI parameter multi-valued? artifact: 9a8d0c3db5 user: AAsk1902
16:42 Edit reply: CLI parameter multi-valued? artifact: cf3cb4e4e4 user: AAsk1902
16:16 Reply: Contentless trigram indexes and GLOB/LIKE in FTS artifact: 804054ff28 user: dan
15:43 Reply: CLI Non fatal error artifact: 40966fa27a user: jicman
15:11 Reply: CLI parameter multi-valued? artifact: c23a3fdd76 user: dfgriggs
15:08 Reply: CLI Non fatal error artifact: 40e3f0d489 user: kmedcalf
14:55 Reply: CLI Non fatal error artifact: 63f677f9c5 user: knu
14:33 Reply: CLI Non fatal error artifact: 90e6534a87 user: kmedcalf
13:35 Edit: CLI Non fatal error artifact: 95555365f7 user: AAsk1902
13:27 Edit reply: CLI parameter multi-valued? artifact: e8dec8f923 user: AAsk1902
13:25 Edit reply: CLI parameter multi-valued? artifact: 026ef7e334 user: AAsk1902
13:24 Edit reply: CLI parameter multi-valued? artifact: 642b242226 user: AAsk1902
13:21 Post: CLI Non fatal error artifact: 216fb6db01 user: AAsk1902
13:17 Reply: CLI parameter multi-valued? artifact: 41d70d0c5e user: AAsk1902
10:55 Reply: PRAGMA journal_mode = TRUNCATE;Permission change of log file after writing configuration artifact: 361068c49d user: anonymous
10:50 Reply: CLI parameter multi-valued? artifact: 8c27ce740c user: chrisjlocke1
10:40 Reply: CLI parameter multi-valued? artifact: 98dcc9b21d user: gunter_hick
10:37 Edit reply: Generate SHA for a table artifact: 476e8e6601 user: lexfiend
10:27 Reply: Contentless trigram indexes and GLOB/LIKE in FTS artifact: 6bc0bc173d user: punkish
10:20 Reply: CLI parameter multi-valued? artifact: 24a28eaf26 user: AAsk1902
09:58 Reply: soliciting ideas on how to store and query XMLs artifact: 5934596290 user: punkish
09:54 Reply: CLI parameter multi-valued? artifact: 379bcf1c8d user: jdennis
09:52 Post: PRAGMA journal_mode = TRUNCATE;Permission change of log file after writing configuration artifact: 09ae5cf623 user: 1121246596
09:46 Reply: Generate SHA for a table artifact: 26fca3caec user: lexfiend
09:45 Post: PRAGMA journal_mode = TRUNCATE; Permission change of log file after writing configuration artifact: 7c9608a97c user: anonymous
09:15 Reply: Documentation to compile specific configuration artifact: 96b5e56038 user: zaknabbit
09:04 Reply: CLI parameter multi-valued? artifact: 84c67fcbdf user: gunter_hick
08:48 Edit: CLI parameter multi-valued? artifact: 15d757e9af user: jdennis
08:47 Post: CLI parameter multi-valued? artifact: bc60dceac4 user: jdennis
07:05 Reply: ALTER TABLE x DROP COLUMN y; fails with error message about unrelated view column artifact: 18d3cc1934 user: stephan
07:02 Reply: Documentation to compile specific configuration artifact: 8b71ade163 user: stephan
06:41 Post: Documentation to compile specific configuration artifact: d0d19ae388 user: zaknabbit
06:02 Reply: ALTER TABLE x DROP COLUMN y; fails with error message about unrelated view column artifact: 8b1060122b user: daniel
04:47 Reply: Additional Column Metadata? artifact: 73cb75a274 user: anonymous
01:05 Reply: Additional Column Metadata? artifact: 2cf340cc6e user: swillits
00:24 Reply: sqlite separator artifact: 70ab14808b user: anonymous

4 Years Ago (more context)

2021-10-21
23:32 Reply: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: 8b1051f010 user: kmedcalf
22:06 Post: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: 5adbcde819 user: anonymous
17:28 Reply: Truncated Words bug with fts5vocab artifact: fb1e6b3c25 user: drh
17:11 Reply: Column names and aliases in expressions artifact: a09ec9b2d0 user: lcarlp
16:59 Post: Truncated Words bug with fts5vocab artifact: 5618045371 user: occultus73
15:06 Reply: Inconsistency in BETWEEN Query artifact: 0eaf895da7 user: gunter_hick
14:43 Reply: Inconsistency in BETWEEN Query artifact: 9deb80dec8 user: larrybr
13:49 Reply: Inconsistency in BETWEEN Query artifact: 09df8cd9e2 user: anonymous
13:40 Reply: Inconsistency in BETWEEN Query artifact: 1f9ff2c06c user: curmudgeon
12:38 Post: Inconsistency in BETWEEN Query artifact: e7c9c8b21b user: anonymous
02:38 Edit reply: I need a little help with UPDATE? artifact: 35117e44c3 user: kmedcalf
02:32 Reply: I need a little help with UPDATE? artifact: de7f14b20f user: kmedcalf
00:17 Reply: How do i submit a bug report artifact: cc490e5902 user: larrybr

5 Years Ago (more context)

2020-10-21
23:02 Reply: How to implement a table working like a ring buffer artifact: c2117fee2a user: kmedcalf
22:29 Reply: How to implement a table working like a ring buffer artifact: 87740c99c0 user: kmedcalf
22:19 Delete reply: How to implement a table working like a ring buffer artifact: 0d62592e7c user: derhexer
22:19 Reply: How to implement a table working like a ring buffer artifact: 8f64841eca user: derhexer
22:06 Reply: How to implement a table working like a ring buffer artifact: 4fe03c89a1 user: derhexer
21:00 Reply: How to implement a table working like a ring buffer artifact: 537ac3bfed user: derhexer
20:07 Reply: Breadth-first graph traversal artifact: 3a2ee0f66f user: younique
19:58 Reply: How to implement a table working like a ring buffer artifact: fec1c7c5a0 user: kmedcalf
18:58 Post: Test ext/session/sessionrebase.test:2.1.1 fails on HPPA architecture artifact: 51d5cfe04e user: Arfrever
18:42 Reply: Breadth-first graph traversal artifact: a4773d4186 user: drh
18:08 Edit reply: Breadth-first graph traversal artifact: 56dcb8d6b7 user: younique
18:04 Post: How to implement a table working like a ring buffer artifact: 7ece03c9fb user: derhexer
15:40 Reply: Breadth-first graph traversal artifact: faa2dcf0a7 user: younique
14:14 Reply: Multi-threaded non-serialization artifact: a6dca21e87 user: nvrudny
14:10 Reply: Multi-threaded non-serialization artifact: 7096fd222a user: nvrudny
11:33 Reply: Multi-threaded non-serialization artifact: 6e739c99e3 user: dan
11:30 Reply: In operator max list size artifact: af97338b06 user: anonymous
11:08 Reply: In operator max list size artifact: 5ae4250b54 user: drh
11:08 Reply: In operator max list size artifact: 343df5be67 user: gunter_hick
10:55 Edit: iOS 14 - table sqlite_master may not be modified artifact: 2521947534 user: JamesMc
10:40 Post: iOS 14 - table sqlite_master may not be modified artifact: 984dba6c67 user: JamesMc
10:08 Reply: SQLite in-memory database encounters SQLITE_LOCKED_SHAREDCACHE intermittently artifact: 722b0f3791 user: live_to_learn
09:48 Edit reply: Multi-threaded non-serialization artifact: 51ed2bbf74 user: gunter_hick
09:45 Reply: Multi-threaded non-serialization artifact: de867dbdff user: gunter_hick
08:46 Reply: Multi-threaded non-serialization artifact: 86913f58cf user: kmedcalf
08:35 Post: In operator max list size artifact: 4468575f26 user: anonymous
08:17 Reply: SQLite encryption with SEE - Dynamic linking artifact: c0a6be9bd6 user: foobar303
07:07 Reply: set/get last_insert_rowid - To mutex or not mutex? artifact: 89312a89a5 user: anonymous
06:55 Reply: Multi-threaded non-serialization artifact: 223f621b18 user: gunter_hick
06:24 Reply: set/get last_insert_rowid - To mutex or not mutex? artifact: cd22ea304e user: gunter_hick
03:42 Post: Multi-threaded non-serialization artifact: 5e36179c76 user: nvrudny