SQLite Forum

Timeline
Login

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

50 most recent forum posts

2024-05-05
02:28 Edit reply: prepare_step_finalize loop (artifact: 236b418737 user: AAsk1902)
02:19 Reply: prepare_step_finalize loop (artifact: 45c8835266 user: AAsk1902)
01:33 (Awaiting Moderator Approval) Post: The lemon parser test failed (artifact: f0ad095705 user: ismagilov (unpublished))
2024-05-04
23:52 (Awaiting Moderator Approval) Post: Mr. (artifact: 4d57409c14 user: anonymous (unpublished))
22:50 Post: prepare_step_finalize loop (artifact: 9213ba0e98 user: AAsk1902)
21:59 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 9f1f5534b1 user: mlpranav)
21:09 Reply: Typo found on the "SQLite Copyright" page in sub section "Warranty of Title" (artifact: fa81904680 user: frectonz)
20:58 Reply: Typo found on the "SQLite Copyright" page in sub section "Warranty of Title" (artifact: b04df12055 user: frectonz)
20:55 Reply: Typo found on the "SQLite Copyright" page in sub section "Warranty of Title" (artifact: 8322176696 user: stephan)
20:51 Post: Typo found on the "SQLite Copyright" page in sub section "Warranty of Title" (artifact: da076f2ace user: frectonz)
20:27 Reply: Queries are slow when LIKE-querying for non existing values (artifact: 863a163b1c user: anonymous)
19:04 Edit: Disk I/O error with Demo VFS when SQLITE_DEFAULT_PAGE_SIZE<2048 bytes (artifact: 424c190f59 user: bluluiss)
18:50 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 8a8934afec user: stephan)
18:25 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 8f4fc72283 user: lcarlp)
18:07 Post: Disk I/O error with Demo VFS when SQLITE_DEFAULT_PAGE_SIZE<2048 bytes (artifact: 582bb45184 user: bluluiss)
15:53 Post: Amalgamation: "sqlite_cfg.h" is included too late (artifact: 21a44bf11b user: tnodir)
13:32 Reply: Always true/false IIF (case when) must be optimized (artifact: 896ffea6e6 user: drh)
13:06 Reply: Queries are slow when LIKE-querying for non existing values (artifact: 32394bfb79 user: drh)
12:58 Post: Always true/false IIF (case when) must be optimized (artifact: cbf8658511 user: vorimi)
12:14 Post: Queries are slow when LIKE-querying for non existing values (artifact: 86191d0b61 user: anonymous)
11:37 Reply: DB file size increases 10x size of data added with FTS5 table (artifact: 1aed8b3e46 user: anonymous)
01:34 Post: DB file size increases 10x size of data added with FTS5 table (artifact: 3ef2ebd994 user: anonymous)
2024-05-03
23:50 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 264b5b32a8 user: anonymous)
18:34 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 07f1f957c3 user: stephan)
17:16 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 8b89372e67 user: anonymous)
17:10 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: db507c2ab1 user: lcarlp)
16:41 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 19f9cfb830 user: lexfiend)
13:39 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 286d818d7f user: dan)
11:42 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 10c1078f7e user: stephan)
10:39 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 1bd699cb1e user: drh)
10:36 Reply: Smalltime as primary key (artifact: 70546b1d23 user: punkish)
08:25 Reply: Casting a column in ORDER BY of UNION ALL doesn't recognize column name (artifact: 88af44ad68 user: anonymous)
03:52 Post: Casting a column in ORDER BY of UNION ALL doesn't recognize column name (artifact: 03912b5617 user: anonymous)
01:55 Post: Result of JSON aggregate functions when WHERE clause is false (artifact: ca2ed111bb user: anonymous)
2024-05-02
22:44 Reply: Smalltime as primary key (artifact: 9e05525ac7 user: stephancb)
19:51 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: bc099bd847 user: stephan)
19:39 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 16444e95c2 user: NickCrews)
19:24 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 49964f06d4 user: NickCrews)
19:21 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: c499fd1ceb user: drh)
19:16 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 924fa80c47 user: NickCrews)
18:55 Reply: Smalltime as primary key (artifact: ffc2139f05 user: punkish)
16:51 Reply: sha3_query Result (artifact: f6ed3d5741 user: shep87)
16:36 Reply: sha3_query Result (artifact: 619d6148c6 user: shep87)
16:25 Reply: sqlite3.exe: multiple statements (artifact: e2f05f02a2 user: AAsk1902)
16:25 Reply: sha3_query Result (artifact: 3691672e51 user: RichardDamon)
16:21 Reply: sha3_query Result (artifact: e39b103c80 user: dan)
16:21 Edit: sqlite3.exe: multiple statements (artifact: 0376313677 user: AAsk1902)
16:12 Reply: sqlite3.exe: multiple statements (artifact: 91162933f1 user: shep87)
15:52 Post: sha3_query Result (artifact: eecc7c1fed user: shep87)
15:50 Post: sqlite3.exe: multiple statements (artifact: ee146bbc42 user: AAsk1902)