SQLite Forum

Timeline
Login

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

50 most recent forum posts

2025-11-20
11:26 Post: SQLite not showing what i type in windows powershell (artifact: 3e22d6f829 user: anonymous)
11:26 Reply: is sqlite3_clear_bindings a no-op if the givent stmt contains no parameters? (artifact: 9838b65f74 user: stephan)
10:20 Post: is sqlite3_clear_bindings a no-op if the givent stmt contains no parameters? (artifact: 70082ef07a user: anonymous)
08:23 Reply: Opening database file directly with WAL mode without creation of journal file (artifact: 0fe482eb63 user: anonymous)
08:13 Reply: Inconsistent comparison results between CTE and identical TABLE when comparing TEXT and BOOLEAN/INTEGER types (artifact: 9fc202b253 user: 666666)
07:48 Reply: NULLIF(X,Y) return X when X equals to Y, but may not the same (artifact: 0c3fb5bd87 user: John-Jove)
02:24 Reply: Proposal: specific error code when start a transaction within a transaction (artifact: 18d98011f3 user: sqlitening)
2025-11-19
21:22 Reply: Proposal: specific error code when start a transaction within a transaction (artifact: 71fd456ca7 user: leahko)
20:33 Reply: Poor Query Plan Chosen (artifact: 6fb51b69c0 user: anonymous)
19:07 Reply: Store dates as integer in format YYYYMMDD (artifact: 69d755fa32 user: sqlitening)
18:26 Reply: Store dates as integer in format YYYYMMDD (artifact: be9dfde4dc user: GSnyder)
16:11 Reply: Store dates as integer in format YYYYMMDD (artifact: 3890a08e82 user: doug9forester)
15:23 Post: Poor Query Plan Chosen (artifact: b6e13f8670 user: anonymous)
15:10 Post: Minor Typo in Website Page (artifact: c836252bd5 user: athkishore)
14:34 Reply: Opening database file directly with WAL mode without creation of journal file (artifact: 51de9eed87 user: dan)
14:32 Reply: NULLIF(X,Y) return X when X equals to Y, but may not the same (artifact: 05061ce008 user: dan)
14:24 Reply: Inconsistent comparison results between CTE and identical TABLE when comparing TEXT and BOOLEAN/INTEGER types (artifact: ca0f6456ac user: dan)
13:37 Reply: How to combine SQLite with native application logic and run in browser (artifact: 7f302307dd user: whereswaldon)
13:33 Reply: Missing native runtime libraries (SQLite.Interop.dll) in System.Data.SQLite.Core 2.0.2.0 for .NET Framework (artifact: b8a2adf62b user: ericsink)
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)