This Day In History For 2024-03-18
1 Year Ago (more context)
|
2023-03-18
| ||
| 19:10 | • Reply: SELECT * FROM tab1 WHERE a=?1 artifact: bd32d119ca user: stephan | |
| 19:06 | • Post: SELECT * FROM tab1 WHERE a=?1 artifact: 7ecd9aa086 user: AAsk1902 | |
| 16:36 | • Reply: Close all open connections artifact: bc23485d14 user: chrisjlocke1 | |
| 16:19 | • Edit reply: How to create a custom function that imitates LEFT() from MySQL? artifact: 93c68da020 user: kmedcalf | |
| 16:10 | • Reply: Close all open connections artifact: 282b4a82ba user: kmedcalf | |
| 15:48 | • Reply: How to create a custom function that imitates LEFT() from MySQL? artifact: 05f9cf80ae user: kmedcalf | |
| 15:47 | • Edit reply: Close all open connections artifact: 2ec9b3e245 user: AAsk1902 | |
| 15:44 | • Reply: Close all open connections artifact: cbcbed88db user: AAsk1902 | |
| 15:30 | • Reply: Close all open connections artifact: 2997ea72c0 user: kmedcalf | |
| 15:16 | • Reply: Close all open connections artifact: 476e0eb473 user: jkreibich | |
| 14:29 | • Edit reply: Close all open connections artifact: 85d38a2795 user: AAsk1902 | |
| 14:25 | • Reply: Close all open connections artifact: 00eecb1abd user: AAsk1902 | |
| 14:08 | • Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: ce375163ae user: curmudgeon | |
| 12:12 | • Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 7ef29b7fc5 user: kmedcalf | |
| 12:08 | • Reply: Close all open connections artifact: 5fd584f1c5 user: slavin | |
| 11:51 | • Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 2fca17c602 user: kmedcalf | |
| 11:27 | • Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 10906d7ed6 user: curmudgeon | |
| 09:26 | • Post: understanding / improving lempar skeleton file - stack (for using lemon in RefPerSys) artifact: 265ee57b50 user: bstarynk | |
| 07:36 | • Reply: sqlite3 and O_CREAT artifact: d828762d9b user: valery | |
| 06:52 | • Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 4d499113c5 user: marcobambini | |
| 06:51 | • Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: dec3514516 user: marcobambini | |
| 01:01 | • Reply: cli.html needs to link csv.html artifact: a5dabee86f user: larrybr | |
| 00:47 | • Post: Link flowchart keywords artifact: 17ff4cdca8 user: jidanni | |
| 00:45 | • Post: cli.html needs to link csv.html artifact: d9744a9144 user: jidanni | |
2 Years Ago (more context)
|
2022-03-18
| ||
| 22:53 | • Reply: Open database given only file descriptor (vs. filename)? artifact: d4ed1b197e user: anonymous | |
| 21:13 | • Reply: Just curious: Bytecode generation - non SQL input? artifact: 2a182ca228 user: larrybr | |
| 21:07 | • Edit reply: Best way to enforce a query time limit? artifact: f37ae374cc user: larrybr | |
| 21:07 | • Reply: Best way to enforce a query time limit? artifact: 8b19b223a6 user: larrybr | |
| 20:59 | • Reply: New Feature Select ... as JSON artifact: 10222fcfd7 user: dCipher | |
| 20:41 | • Reply: .mode column artifact: f1245069ef user: anonymous | |
| 20:38 | • Post: Just curious: Bytecode generation - non SQL input? artifact: d7a40462f5 user: midijohnny | |
| 20:30 | • Edit reply: Best way to enforce a query time limit? artifact: 9d821f6b3b user: simonw | |
| 20:26 | • Reply: Best way to enforce a query time limit? artifact: b1185d5609 user: simonw | |
| 20:25 | • Edit reply: New Feature Select ... as JSON artifact: 008563c176 user: midijohnny | |
| 20:23 | • Reply: Open database given only file descriptor (vs. filename)? artifact: 57aaaf20cf user: larrybr | |
| 20:21 | • Edit reply: New Feature Select ... as JSON artifact: 2856954241 user: midijohnny | |
| 20:20 | • Edit reply: New Feature Select ... as JSON artifact: 474d910c99 user: midijohnny | |
| 20:20 | • Reply: New Feature Select ... as JSON artifact: d750ba8e98 user: midijohnny | |
| 20:02 | • Post: Open database given only file descriptor (vs. filename)? artifact: c15bf2e7df user: anonymous | |
| 20:00 | • Reply: Best way to enforce a query time limit? artifact: 36103c02bc user: larrybr | |
| 19:55 | • Reply: .mode column artifact: 9e91df7cd2 user: larrybr | |
| 19:26 | • Reply: Best way to enforce a query time limit? artifact: 81f96d60b7 user: simonw | |
| 18:59 | • Reply: .mode column artifact: d9c2e8d04f user: anonymous | |
| 18:55 | • Post: New Feature Select ... as JSON artifact: d3ac318baa user: dCipher | |
| 18:38 | • Reply: Installing in Visual Studio 2022 artifact: a8142d88a6 user: anonymous | |
| 18:18 | • Reply: Best way to enforce a query time limit? artifact: db91901823 user: slavin | |
| 18:15 | • Reply: JSON_Object() Argument Limit artifact: 9fe23907ea user: midijohnny | |
| 17:52 | • Reply: Installing in Visual Studio 2022 artifact: 6dc589a8ad user: mistachkin | |
| 17:52 | • Reply: .mode column artifact: 8c666f12a2 user: dfgriggs | |
| 17:28 | • Post: Best way to enforce a query time limit? artifact: 73b7979496 user: simonw | |
| 17:04 | • Reply: Installing in Visual Studio 2022 artifact: 34c7a09f7e user: anonymous | |
| 16:25 | • Reply: JSON_Object() Argument Limit artifact: 2c4b2ff0c3 user: dCipher | |
| 10:52 | • Reply: Dump and insert instead of vacuum artifact: cb78360ff3 user: slavin | |
| 10:45 | • Reply: Inconsistent error codes after SQLITE_DENY from authorization callback artifact: 966dfffee6 user: slavin | |
| 06:51 | • Reply: Performance Analysis artifact: 4b6ee2a416 user: dan | |
| 01:25 | • Reply: Is there a curated list of extensions for SQLite? artifact: f9c1ac5769 user: anonymous | |
3 Years Ago (more context)
|
2021-03-18
| ||
| 23:55 | • Post: Cancelling the query artifact: 93ce7a6500 user: oneeyeman | |
| 22:33 | • Reply: Updating a value with one from another table? artifact: 2e12af7db8 user: Gilles | |
| 21:15 | • Reply: Updating a value with one from another table? artifact: 77b901dce1 user: Gilles | |
| 21:13 | • Reply: Updating a value with one from another table? artifact: 8862b4dc9c user: kmedcalf | |
| 21:09 | • Reply: Updating a value with one from another table? artifact: fbad1e84e1 user: kmedcalf | |
| 20:52 | • Reply: Updating a value with one from another table? artifact: c1eb1f2001 user: larrybr | |
| 20:31 | • Post: Updating a value with one from another table? artifact: 115255fe1b user: Gilles | |
| 17:56 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 63a80f5ecf user: anonymous | |
| 17:52 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: fcc7206112 user: dvdraymond | |
| 17:10 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: d970ec92a5 user: anonymous | |
| 16:58 | • Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 6e2b05ad62 user: drh | |
| 16:47 | • Reply: Proper set up for working with SQLite, C, Tcl/Tk? artifact: 171410dc21 user: mbenningfield1 | |
| 16:45 | • Reply: Proper set up for working with SQLite, C, Tcl/Tk? artifact: 8ae14ac950 user: curmudgeon | |
| 15:05 | • Reply: Find rows not in other sub query? artifact: 7a615bf210 user: larrybr | |
| 14:33 | • Reply: Find rows not in other sub query? artifact: a6be0b61d7 user: Gilles | |
| 13:30 | • Reply: Serious problems with STORED columns artifact: e72d3930a1 user: anonymous | |
| 13:24 | • Reply: Getting the error artifact: cf98f29453 user: oneeyeman | |
| 12:08 | • Reply: Find rows not in other sub query? artifact: 5f77b04d19 user: cuz | |
| 12:06 | • Reply: Find rows not in other sub query? artifact: 0de4e167e0 user: Gilles | |
| 11:54 | • Reply: Find rows not in other sub query? artifact: 533825760c user: Gilles | |
| 11:48 | • Reply: Serious problems with STORED columns artifact: 63498263ee user: cuz | |
| 11:25 | • Reply: Find rows not in other sub query? artifact: 9678f465a6 user: dan | |
| 11:18 | • Post: Find rows not in other sub query? artifact: 72f62ad19d user: Gilles | |
| 11:11 | • Reply: Update SQLITE with Count and condtions artifact: 4db9d0c93c user: gunter_hick | |
| 11:06 | • Reply: Serious problems with STORED columns artifact: 52675c5fa8 user: RichardDamon | |
| 10:50 | • Post: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: a41295d743 user: mzm2021 | |
| 10:35 | • Post: Bug report: CTE can report "circular reference" for an actual column count issue artifact: aa5a0431c9 user: mzm2021 | |
| 09:42 | • Reply: Possible Bug - View behaves differently to Table in SELECT artifact: 1a547a020a user: dpratten | |
| 09:27 | • Reply: SQL to return list of PRAGMAs artifact: c4626dd38a user: kmedcalf | |
| 09:20 | • Reply: SQL to return list of PRAGMAs artifact: 1daff211d2 user: ddevienne | |
| 08:21 | • Reply: SQL to return list of PRAGMAs artifact: 409a616141 user: anonymous | |
| 07:13 | • Reply: Serious problems with STORED columns artifact: 3f7907a234 user: doug9forester | |
| 06:59 | • Reply: Getting the error artifact: 005793c04a user: gunter_hick | |
| 06:29 | • Post: Update SQLITE with Count and condtions artifact: 05d96b0368 user: Gideon | |
| 05:00 | • Post: Proper set up for working with SQLite, C, Tcl/Tk? artifact: 6bf4ceaac1 user: 1codedebugger | |
| 02:02 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 3ae169eeb3 user: RichardDamon | |
| 01:18 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: c0f2fc8a6f user: kmedcalf | |
| 01:13 | • Reply: SQL to return list of PRAGMAs artifact: 44c912d109 user: kmedcalf | |
| 01:04 | • Reply: SQL to return list of PRAGMAs artifact: ff76d026c7 user: kmedcalf | |
| 00:46 | • Reply: Serious problems with STORED columns artifact: 6a881ec9c1 user: kmedcalf | |
| 00:23 | • Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 9efaa9631a user: larrybr | |
| 00:01 | • Reply: Minor typo in documentation artifact: 62f8899687 user: larrybr | |
4 Years Ago (more context)
|
2020-03-18
| ||
| 22:55 | • Reply: ESCAPE '%' artifact: 724f9752c1 user: slavin | |
| 22:49 | • Reply: ESCAPE '%' artifact: bf9cae02c1 user: slavin | |
| 20:22 | • Reply: To and From Hex Conversion Methods artifact: a880760df0 user: kmedcalf | |
| 19:52 | • Reply: SQLite on 64 Bit windows machine artifact: eb00d9b8fb user: anonymous | |
| 19:22 | • Post: ESCAPE '%' artifact: 11e9ac5a80 user: anonymous | |
| 18:30 | • Post: To and From Hex Conversion Methods artifact: 5ac74b6383 user: StephenC | |
| 18:21 | • Reply: SQLite on 64 Bit windows machine artifact: 61575e16b3 user: wyoung | |
| 17:58 | • Post: SQLite on 64 Bit windows machine artifact: 1a3f09650b user: anonymous | |
| 17:04 | • Edit reply: Request for comment: New ANALYZE syntax artifact: 4a00be4360 user: kmedcalf | |
| 17:03 | • Reply: Request for comment: New ANALYZE syntax artifact: 60ae35d1a9 user: kmedcalf | |
| 16:35 | • Reply: Renaming a database artifact: 3e62dce4e8 user: dfgriggs | |
| 15:54 | • Reply: columnName function artifact: 25129e3d07 user: gunter_hick | |
| 15:51 | • Edit reply: columnName function artifact: 44dcae0c73 user: curmudgeon | |
| 15:45 | • Edit reply: columnName function artifact: 707fb1f718 user: curmudgeon | |
| 15:44 | • Reply: columnName function artifact: 67cc6cd864 user: curmudgeon | |
| 15:44 | • Reply: columnName function artifact: 541f6a4677 user: stephan | |
| 15:39 | • Reply: columnName function artifact: ee92c859fb user: doug9forester | |
| 15:23 | • Reply: Request for comment: New ANALYZE syntax artifact: 9897bfb062 user: TripeHound | |
| 15:19 | • Reply: Renaming a database artifact: fef112992d user: skywalk | |
| 15:15 | • Reply: Request for comment: New ANALYZE syntax artifact: b3c7e850d7 user: TripeHound | |
| 15:04 | • Edit reply: Request for comment: New ANALYZE syntax artifact: b40213de64 user: slavin | |
| 15:03 | • Edit reply: columnName function artifact: d3475ff66f user: kmedcalf | |
| 15:03 | • Reply: Request for comment: New ANALYZE syntax artifact: 0563ab5514 user: slavin | |
| 14:58 | • Edit reply: columnName function artifact: bc1e90234f user: drh | |
| 14:56 | • Reply: columnName function artifact: 15f2fafec6 user: kmedcalf | |
| 14:54 | • Reply: Renaming a database artifact: e3b79ec5eb user: anonymous | |
| 14:47 | • Reply: Request for comment: New ANALYZE syntax artifact: ec6e48d0c0 user: drh | |
| 14:39 | • Reply: Request for comment: New ANALYZE syntax artifact: f901b6270e user: dvdraymond | |
| 14:36 | • Reply: Request for comment: New ANALYZE syntax artifact: f62c1076d5 user: anonymous | |
| 14:25 | • Post: columnName function artifact: ba0b54e4d4 user: curmudgeon | |
| 13:58 | • Reply: Request for comment: New ANALYZE syntax artifact: 24a324e8e2 user: vman59 | |
| 13:37 | • Reply: Request for comment: New ANALYZE syntax artifact: 760b8b21ed user: mark | |
| 13:24 | • Edit reply: Request for comment: New ANALYZE syntax artifact: 71a6ea8000 user: crustyoz | |
| 13:23 | • Reply: Request for comment: New ANALYZE syntax artifact: fdbccfd475 user: crustyoz | |
| 13:21 | • Reply: Request for comment: New ANALYZE syntax artifact: 72b45343d3 user: TripeHound | |
| 13:16 | • Reply: Request for comment: New ANALYZE syntax artifact: 70ea881e08 user: stephan | |
| 13:03 | • Post: Request for comment: New ANALYZE syntax artifact: 4167948754 user: drh | |
| 11:42 | • Reply: Renaming a database artifact: 4eb9d9f6ba user: Clothears | |
| 11:10 | • Reply: Renaming a database artifact: 01ee57059c user: drh | |
| 10:13 | • Reply: Renaming a database artifact: 551f258c26 user: tobydickenson | |
| 08:28 | • Reply: Renaming a database artifact: fb72deb58f user: gunter_hick | |
| 08:24 | • Reply: Renaming a database artifact: 0fb1970c06 user: gunter_hick | |
| 03:12 | • Reply: Renaming a database artifact: 3c672b918f user: anonymous | |
| 02:51 | • Reply: Slow query (~20x faster when run as two separate queries) artifact: 6684096c27 user: Izkata | |
| 00:32 | • Reply: Renaming a database artifact: 224445acbf user: anonymous | |