SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent forum posts

2025-11-19
11:02 Reply: Inconsistent comparison results between CTE and identical TABLE when comparing TEXT and BOOLEAN/INTEGER types (artifact: ef9c50b4a8 user: stephan)
10:27 Edit: Request to support open and connect to a memory db from bytes with existing data pre-populated (artifact: b9911b1a18 user: wyalchemy)
09:26 Post: Opening database file directly with WAL mode without creation of journal file (artifact: 39875e61cc user: anonymous)
09:12 Reply: Request to support open and connect to a memory db from bytes with existing data pre-populated (artifact: ba381a6355 user: ncruces)
09:07 Post: NULLIF(X,Y) return X when X equals to Y, but may not the same (artifact: d2886ebf9a user: John-Jove)
07:43 Post: Request to support open and connect to a memory db from bytes with existing data pre-populated (artifact: ead1ce7b47 user: wyalchemy)
07:00 Reply: Store dates as integer in format YYYYMMDD (artifact: 1425660305 user: sqlitening)
06:41 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 349ac43bc2 user: stephancb)
06:16 Reply: Store dates as integer in format YYYYMMDD (artifact: f6d6f1dd50 user: sqlitening)
05:50 Reply: Store dates as integer in format YYYYMMDD (artifact: ec30236530 user: stephancb)
05:27 Post: Missing native runtime libraries (SQLite.Interop.dll) in System.Data.SQLite.Core 2.0.2.0 for .NET Framework (artifact: 44b5b6637f user: sreevathsa1901)
02:19 Reply: Store dates as integer in format YYYYMMDD (artifact: 86a006cf71 user: sqlitening)
02:14 Edit reply: Store dates as integer in format YYYYMMDD (artifact: 1019b5fbab user: GSnyder)
02:10 Reply: Store dates as integer in format YYYYMMDD (artifact: ed5c1e3049 user: GSnyder)
01:39 Edit reply: Store dates as integer in format YYYYMMDD (artifact: 6d58209087 user: sqlitening)
01:36 Reply: Store dates as integer in format YYYYMMDD (artifact: 80f466ca2b user: sqlitening)
01:15 Post: Inconsistent comparison results between CTE and identical TABLE when comparing TEXT and BOOLEAN/INTEGER types (artifact: 6621839a8b user: 666666)
2025-11-18
22:21 Reply: row-level compression (artifact: 24a3beb6a6 user: punkish)
20:28 Reply: row-level compression (artifact: 8132064350 user: drh)
20:20 Post: row-level compression (artifact: 128ad4811a user: punkish)
17:26 Reply: Cell pointer array length versus count (artifact: d3beac30a1 user: dan)
15:38 Reply: A custom collation is called twice when using a cursor based pagination (artifact: 86a6d54dea user: sukei13)
15:16 Reply: Cell pointer array length versus count (artifact: 939c159c12 user: anonymous)
14:46 Edit reply: version 3.46.1 (artifact: 1f792a17e9 user: jicman)
14:24 Reply: version 3.46.1 (artifact: fed288356f user: jicman)
13:37 Post: version 3.46.1 (artifact: f4bc19ffa6 user: vijnavp)
13:18 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 9aca3f41ec user: Ben)
13:15 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 0e00959f81 user: Ben)
11:20 Reply: Cell pointer array length versus count (artifact: ef01157655 user: dan)
11:05 Reply: A custom collation is called twice when using a cursor based pagination (artifact: 033485fb02 user: dan)
10:41 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 9daaa4d87b user: ncruces)
10:04 Edit reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 46ec6155b6 user: punkish)
09:53 Reply: A custom collation is called twice when using a cursor based pagination (artifact: ff76a17a85 user: sukei13)
06:38 Edit reply: A custom collation is called twice when using a cursor based pagination (artifact: 52d9eaebe6 user: gunter_hick)
06:37 Edit reply: A custom collation is called twice when using a cursor based pagination (artifact: a04f6ac1e0 user: gunter_hick)
06:36 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 2efb5d3937 user: stephancb)
06:32 Reply: A custom collation is called twice when using a cursor based pagination (artifact: 1622086f5d user: gunter_hick)
03:08 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: e24ebab09a user: lexfiend)
00:18 Reply: Cell pointer array length versus count (artifact: dbdefd6713 user: anonymous)
00:04 Reply: Cell pointer array length versus count (artifact: 772fa8f934 user: stephan)
00:00 Edit reply: How to combine SQLite with native application logic and run in browser (artifact: 7e268b5fee user: stephan)
2025-11-17
23:54 Post: Cell pointer array length versus count (artifact: e617667e1c user: anonymous)
23:51 Edit reply: How to combine SQLite with native application logic and run in browser (artifact: 7d7609173b user: stephan)
23:47 Reply: How to combine SQLite with native application logic and run in browser (artifact: a714946cdc user: stephan)
23:33 Edit reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: c99064c725 user: punkish)
23:18 Reply: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 349cbb4f43 user: punkish)
21:38 Post: Storing dates in a DATETIME/NUMERIC-typed column (artifact: 0c1d7ab928 user: Ben)
19:47 Post: A custom collation is called twice when using a cursor based pagination (artifact: 2f955b9191 user: anonymous)
18:26 Reply: Proposal: file control opcode for write transaction (artifact: 7f14affa86 user: ncruces)
15:51 Reply: Proposal: file control opcode for write transaction (artifact: f4a6ab703e user: rhashimoto)