SQLite Forum

Timeline
Login

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

50 events by user cuz occurring around 2021-06-30 11:15:58.

2021-07-21
20:09 Reply: SELECT optimization for constant expression artifact: cdc8efd3f2 user: cuz
11:24 Reply: SELECT optimization for constant expression artifact: fdcfff048d user: cuz
11:03 Reply: SELECT optimization for constant expression artifact: 10c25d97ea user: cuz
2021-07-20
14:45 Reply: ROWID in compound SELECT artifact: cec8eb3f47 user: cuz
2021-07-19
12:52 Reply: Populating a tree from a flat table of subcategories artifact: 3bff990360 user: cuz
2021-07-17
22:54 Reply: (Deleted) artifact: 557c89d139 user: cuz
22:27 Edit reply: (Deleted) artifact: 89ee54c961 user: cuz
22:26 Reply: (Deleted) artifact: 1d51f050b1 user: cuz
2021-07-15
23:57 Reply: Should SQLite be able to optimize this query? artifact: 19acdf0b27 user: cuz
2021-07-14
14:15 Reply: Help with a query artifact: 8c6e211067 user: cuz
2021-07-13
13:40 Reply: My Database is being deleted after each restart of my code. How can I fix it? artifact: e7663192aa user: cuz
2021-07-11
11:19 Reply: Unstack one column to multiple artifact: a3726af92d user: cuz
10:12 Reply: Why can you write triggers using functions from extensions? How does that work? artifact: 5479482659 user: cuz
2021-07-10
21:33 Reply: Why can you write triggers using functions from extensions? How does that work? artifact: a9f795200b user: cuz
2021-07-09
15:19 Reply: not able to update rows artifact: 0c85689007 user: cuz
2021-07-07
14:17 Reply: Shortcut to change a non changing update or upsert in a noop artifact: 581da19742 user: cuz
12:42 Reply: Shortcut to change a non changing update or upsert in a noop artifact: f521b099e7 user: cuz
12:29 Reply: Repeat values n times artifact: 5164c386d1 user: cuz
2021-07-06
16:10 Reply: Shortcut to change a non changing update or upsert in a noop artifact: d7ad3388b1 user: cuz
13:47 Edit reply: Shortcut to change a non changing update or upsert in a noop artifact: 1c6520321a user: cuz
13:44 Reply: Shortcut to change a non changing update or upsert in a noop artifact: a33cdb887a user: cuz
12:46 Reply: Shortcut to change a non changing update or upsert in a noop artifact: af6b15dcf1 user: cuz
2021-07-02
10:30 Reply: Incorrect Result From SQLite Query artifact: a2a5608d9f user: cuz
2021-06-30
11:23 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: cc1757bd91 user: cuz
11:15 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 72c640bdb5 user: cuz
11:09 Reply: Defense against dark arts doc pitfall: ALTER TABLE RENAME COLUMN requires function arg limit > 8 artifact: 891699e083 user: cuz
10:50 Reply: cannot create tables in sqlitestudio than other apps can see artifact: faa4d5d9ce user: cuz
2021-06-29
21:14 Reply: Best practice: Save partial dates artifact: 36c3c6b043 user: cuz
18:03 Reply: Best practice: Save partial dates artifact: 7775aefef5 user: cuz
17:46 Reply: Best practice: Save partial dates artifact: c2dd0c03a9 user: cuz
10:31 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 912539ad9d user: cuz
01:27 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 5eadf7a7c6 user: cuz
00:01 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 82d4eae770 user: cuz
2021-06-28
19:50 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 5a43637b48 user: cuz
13:17 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 01c62713af user: cuz
11:16 Reply: Am I doing SQL wrong? artifact: 72a0b08203 user: cuz
11:06 Reply: Am I doing SQL wrong? artifact: c24e36b098 user: cuz
2021-06-19
00:40 Reply: Division by decimals wrongly returning a rounded int result (works fine when casting to real) artifact: dc8b003e8f user: cuz
2021-06-18
18:02 Reply: Division by decimals wrongly returning a rounded int result (works fine when casting to real) artifact: c383472562 user: cuz
17:09 Reply: Division by decimals wrongly returning a rounded int result (works fine when casting to real) artifact: a0db2ca60a user: cuz
2021-06-11
17:19 Reply: Using an alias in queries artifact: f963011a06 user: cuz
2021-06-10
21:55 Reply: Using an alias in queries artifact: 47b918909a user: cuz
2021-06-09
19:55 Reply: Using an alias in queries artifact: faa579a3b9 user: cuz
2021-06-01
14:19 Reply: SQLITE_IOERR on `pragma journal_mode=wal;` artifact: 5503a42b0a user: cuz
2021-05-28
23:21 Reply: Bug of json_each if object has value field. artifact: 1ba5bfc29a user: cuz
01:49 Reply: nested case statement not working artifact: 5fe7dccb7b user: cuz
2021-05-27
01:56 Reply: index to help with selection and ordering artifact: 34144546c5 user: cuz
2021-05-21
11:22 Reply: long runtime for sqlite3_prepare_v2 artifact: 109f90593f user: cuz
2021-05-20
22:21 Reply: long runtime for sqlite3_prepare_v2 artifact: ebb460fa3e user: cuz
2021-05-14
14:25 Reply: Special characters * and ? are not supported in Database Names on Windows? artifact: 1a7a230679 user: cuz