SQLite Forum

Timeline
Login

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

50 most recent forum posts

2024-05-04
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)
15:02 Reply: Smalltime as primary key (artifact: da355bc9dc user: RichardDamon)
14:40 Post: Smalltime as primary key (artifact: 5d4ef94fd9 user: anonymous)
14:01 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 837fcd8489 user: mlpranav)
12:15 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 903ef58578 user: drh)
10:53 Edit reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 2ddd68f2f4 user: stephan)
09:40 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 2a57ed27db user: stephan)
09:27 Reply: Heap Correction from SQLiteSEE.dll (artifact: 401fafb5b3 user: stephan)
08:38 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: ac54e3d9de user: mlpranav)
08:35 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 502613405d user: mlpranav)
07:44 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: ea62f32be3 user: stephan)
07:27 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 322f0a8de7 user: hanche)
06:37 Post: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 4cf69794d9 user: mlpranav)
03:04 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: d17a79a04c user: lexfiend)
02:39 Reply: Heap Correction from SQLiteSEE.dll (artifact: c1812efe58 user: Bharat90)
02:02 Post: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 6258de54e5 user: NickCrews)