SQLite Forum

Timeline
Login

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

50 most recent forum posts

2025-11-21
20:01 Reply: ON CONFLICT clause does not work with CHECK constraint (artifact: 8685634710 user: yapmaster)
19:45 Reply: ON CONFLICT clause does not work with CHECK constraint (artifact: e3083144af user: drh)
19:38 Reply: Are indexes sorted by ROWID automatically? (artifact: 017ba21dfd user: dan)
19:21 Reply: ON CONFLICT clause does not work with CHECK constraint (artifact: 6355e4c36d user: yapmaster)
18:30 Reply: ON CONFLICT clause does not work with CHECK constraint (artifact: 5a6589adbd user: drh)
18:23 Post: Are indexes sorted by ROWID automatically? (artifact: 110ccebd29 user: joaopaulobdac)
18:16 Post: ON CONFLICT clause does not work with CHECK constraint (artifact: ea5d5fed20 user: yapmaster)
16:05 Reply: Poor Query Plan Chosen (artifact: b3c8311a47 user: jicman)
16:01 Reply: Poor Query Plan Chosen (artifact: 1a309ce65f user: mark)
11:05 Reply: is sqlite3_clear_bindings a no-op if the givent stmt contains no parameters? (artifact: 4c374396a8 user: stephan)
08:44 Reply: Request to support open and connect to a memory db from bytes with existing data pre-populated (artifact: 1a39aa209a user: ncruces)
08:19 Reply: Request to support open and connect to a memory db from bytes with existing data pre-populated (artifact: bfa8661955 user: wyalchemy)
05:31 Reply: is sqlite3_clear_bindings a no-op if the givent stmt contains no parameters? (artifact: 9a2f7c433d user: anonymous)
02:55 Reply: Hctree is an experimental high-concurrency database backend for SQLite. (artifact: 97d901e104 user: athkishore)
00:19 Edit: Free Native Android SQLite Browser App available for testing (artifact: 22a5f94ff6 user: told888)
00:17 Post: Free Native Android SQLite Browser App available for testing (artifact: 68453e62a3 user: told888)
00:12 Reply: Proposal: file control opcode for write transaction (artifact: 87b7d59fef user: anonymous)
2025-11-20
15:03 Reply: Are the Windows UTF-8 conversion functions supported? (artifact: 653a64800a user: stephan)
14:42 Post: Are the Windows UTF-8 conversion functions supported? (artifact: 0461ce7cf8 user: mbenningfield1)
14:22 Reply: SQLite not showing what i type in windows powershell (artifact: 00ae142aa7 user: jicman)
14:10 Reply: Opening database file directly with WAL mode without creation of journal file (artifact: b2f23f047b user: dan)
13:57 Reply: Inconsistent comparison results between CTE and identical TABLE when comparing TEXT and BOOLEAN/INTEGER types (artifact: 69f149ea00 user: dan)
12:23 Reply: How to combine SQLite with native application logic and run in browser (artifact: e8e5f2885d user: stephan)
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)