This Day In History For 2024-03-26
1 Year Ago (more context)
|
2023-03-26
| ||
| 23:18 | • Reply: Import csv file artifact: 222681c5f8 user: mhnsqlite | |
| 21:12 | • Reply: Telescoping the integer primary keys? artifact: 7265d012da user: kmedcalf | |
| 20:14 | • Reply: Telescoping the integer primary keys? artifact: edcf4a2899 user: nji9nji9 | |
| 19:26 | • Edit reply: SQLite Wasm for Safari And Firefox progress artifact: 3021e4b099 user: stephan | |
| 19:24 | • Reply: SQLite Wasm for Safari And Firefox progress artifact: 8485e5e1b3 user: stephan | |
| 19:16 | • Reply: SQLite Wasm for Safari And Firefox progress artifact: d3dda5c27b user: anonymous | |
| 19:00 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 29176bea3c user: bjoern | |
| 18:23 | • Reply: Telescoping the integer primary keys? artifact: 7e099ee5da user: kmedcalf | |
| 18:03 | • Reply: update two columns on another table when an update happen on the table artifact: 9204d5515f user: kmedcalf | |
| 17:30 | • Reply: SQLite Wasm for Safari And Firefox progress artifact: 8b872282d1 user: anonymous | |
| 16:56 | • Reply: Assertion failure in ANALYZE for STAT4 (2) artifact: d4eba8a430 user: songliu | |
| 16:43 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 840d122227 user: bjoern | |
| 16:35 | • Reply: Telescoping the integer primary keys? artifact: b665d47703 user: kmedcalf | |
| 16:12 | • Post: update two columns on another table when an update happen on the table artifact: 06d35016a1 user: yanalroot | |
| 15:58 | • Reply: Telescoping the integer primary keys? artifact: 34c4a3253b user: kmedcalf | |
| 15:50 | • Reply: Telescoping the integer primary keys? artifact: 322eed4a91 user: bjoern | |
| 15:44 | • Reply: Telescoping the integer primary keys? artifact: 90d6c31591 user: kmedcalf | |
| 15:40 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 8485004b9d user: bjoern | |
| 15:27 | • Edit reply: Telescoping the integer primary keys? artifact: 4eea32103f user: kmedcalf | |
| 15:20 | • Reply: Telescoping the integer primary keys? artifact: 3028780000 user: kmedcalf | |
| 14:36 | • Reply: Telescoping the integer primary keys? artifact: 367f5f4ec7 user: ddevienne | |
| 14:24 | • Reply: Import csv file artifact: 824ce35fac user: larrybr | |
| 14:01 | • Post: Telescoping the integer primary keys? artifact: a5d6e72a6c user: nji9nji9 | |
| 13:21 | • Reply: Schema-less SQLite artifact: 68b98ca230 user: slavin | |
| 05:55 | • Reply: query plan for "is null" on column defined as "not null" artifact: 77500c3512 user: markxwagner | |
| 04:53 | • Post: Assertion failure in ANALYZE for STAT4 (2) artifact: 07de5f6216 user: songliu | |
| 04:40 | • Edit reply: Import csv file artifact: 7eb50076da user: kmedcalf | |
| 04:38 | • Reply: Import csv file artifact: 68176aa455 user: kmedcalf | |
| 02:18 | • Reply: Import csv file artifact: 83d898ee48 user: larrybr | |
| 02:00 | • Reply: wrong result from PRAGMA foreign_key_list? artifact: 8c07b44f86 user: slavin | |
| 01:55 | • Reply: Import csv file artifact: ee765d1501 user: slavin | |
| 01:11 | • Reply: Assertion failure in Indexed Expression (2) artifact: 705037ab7a user: songliu | |
| 01:10 | • Reply: Import csv file artifact: 65671d2956 user: larrybr | |
| 01:07 | • Reply: Import csv file artifact: 74179eec44 user: kmedcalf | |
| 00:38 | • Edit: Import csv file artifact: e26950eed1 user: mhnsqlite | |
| 00:29 | • Edit: Import csv file artifact: b0dde50eb4 user: mhnsqlite | |
| 00:26 | • Edit: Import csv file artifact: 29da26b174 user: mhnsqlite | |
| 00:18 | • Edit reply: Sharing a database across processes and threads. artifact: 6e16110171 user: mkorobkom | |
| 00:11 | • Edit: Import csv file artifact: ae9da66b71 user: mhnsqlite | |
| 00:09 | • Reply: Sharing a database across processes and threads. artifact: 0cf582178b user: mkorobkom | |
| 00:06 | • Post: Import csv file artifact: 0a91be57f8 user: mhnsqlite | |
2 Years Ago (more context)
|
2022-03-26
| ||
| 21:45 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: f7db2e0632 user: anonymous | |
| 21:41 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: 4f54882ea3 user: anonymous | |
| 21:06 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: f44a701a0d user: SeverKetor | |
| 21:05 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: fabfa5dbba user: anonymous | |
| 20:59 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: 63961b3346 user: larrybr | |
| 20:41 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: 8df6c29f78 user: anonymous | |
| 19:39 | • Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: f25b5e865d user: drh | |
| 19:19 | • Post: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: ca40175a3f user: anonymous | |
| 17:11 | • Reply: How to escape parameters artifact: 1b8825e529 user: anonymous | |
| 15:26 | • Reply: How to escape parameters artifact: f55de37b9e user: stephan | |
| 15:20 | • Reply: How to escape parameters artifact: 44ff05c325 user: anonymous | |
| 15:19 | • Post: integrity_check(100) calls progress callback millions of times. artifact: 4e4de2410f user: macsql20 | |
| 12:57 | • Reply: How to escape parameters artifact: cdba7ac21e user: larrybr | |
| 10:19 | • Post: How to escape parameters artifact: 2b27a2b26b user: anonymous | |
3 Years Ago (more context)
|
2021-03-26
| ||
| 14:09 | • Post: Audacity using SQLite now artifact: 496b68a88a user: anonymous | |
| 06:34 | • Edit: Views in LEFT JOIN queries not using index artifact: a357959b31 user: frodrig3 | |
| 06:10 | • Reply: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: 5ac7da17e6 user: stnshr | |
| 06:04 | • Reply: Why sqlite sometimes prefers "SCAN TABLE"-index over a "SEARCH TABLE"-index? artifact: 3bc2b5a7a0 user: stnshr | |
| 02:44 | • Edit reply: possible to use output of a SELECT-query for ordering? artifact: ae7c03afe5 user: kmedcalf | |
| 02:41 | • Edit reply: possible to use output of a SELECT-query for ordering? artifact: d0ad858c00 user: kmedcalf | |
| 02:38 | • Edit reply: possible to use output of a SELECT-query for ordering? artifact: 88172e7259 user: kmedcalf | |
| 02:32 | • Reply: possible to use output of a SELECT-query for ordering? artifact: 318ba84d8a user: kmedcalf | |
4 Years Ago (more context)
|
2020-03-26
| ||
| 23:34 | • Post: the fallback column affinity should be BLOB, not NUMERIC artifact: 3ab105a078 user: hanshenrik | |
| 20:38 | • Reply: Searching www.sqlite.org options artifact: 486ac30854 user: jicman | |
| 19:59 | • Reply: Insert or ignore in a trigger artifact: 7f8a6d4c80 user: kmedcalf | |
| 19:39 | • Reply: Convert datetime string to second since Epoch with millisecond precision artifact: a71d61fd43 user: kmedcalf | |
| 19:34 | • Edit reply: Convert datetime string to second since Epoch with millisecond precision artifact: 8742abd5bb user: kmedcalf | |
| 19:33 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 987b0b37f5 user: msa | |
| 19:31 | • Reply: Searching www.sqlite.org options artifact: 67f1bc2b45 user: dfgriggs | |
| 19:10 | • Post: Insert or ignore in a trigger artifact: 45d4dafb23 user: Jan | |
| 18:22 | • Post: Searching www.sqlite.org options artifact: 0fd3690b91 user: jicman | |
| 17:47 | • Edit reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 5a4c752e8e user: drh | |
| 17:46 | • Edit reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 9f921825eb user: drh | |
| 16:40 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 98ca159bb5 user: anonymous | |
| 15:24 | • Reply: Request for comment: New ANALYZE syntax artifact: 0b64f011cb user: resuna | |
| 12:39 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 60ed177e2f user: anonymous | |
| 12:30 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: d5ef1df15e user: anonymous | |
| 12:28 | • Reply: Query to make timestamp to readable date artifact: 23fa3648e8 user: gunter_hick | |
| 12:24 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: eb35aeaa50 user: drh | |
| 12:16 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: fb4e48258d user: slavin | |
| 12:15 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 6109760e25 user: anonymous | |
| 12:07 | • Reply: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: efa0e092d9 user: drh | |
| 11:42 | • Post: sqlite3 CLI on macOS not cleaning up wal and shm files on exit artifact: 1fdfc1a0e7 user: anonymous | |
| 10:55 | • Reply: Query to make timestamp to readable date artifact: 831e473be2 user: cladisch | |
| 10:48 | • Reply: Query to make timestamp to readable date artifact: 12db1b1f37 user: cladisch | |
| 09:49 | • Reply: Query to make timestamp to readable date artifact: 93a64940a4 user: gunter_hick | |
| 09:43 | • Reply: Query to make timestamp to readable date artifact: a76456af07 user: gunter_hick | |
| 09:35 | • Reply: Query to make timestamp to readable date artifact: 3f18ed177f user: gunter_hick | |
| 08:57 | • Post: Query to make timestamp to readable date artifact: 1c68c42139 user: europa | |
| 07:21 | • Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 95b67d0511 user: jmcm54ac | |