This Day In History For 2024-03-23
1 Year Ago (more context)
2023-03-23
| ||
22:07 | • Reply: Feature request: Stored Procedures artifact: 532bb36306 user: anonymous | |
21:42 | • Reply: WASM opfs & multiple tabs artifact: 2a72ae5020 user: scafaria | |
20:58 | • Reply: Suggestions of tools to handle database migrations (using raw SQL)? artifact: a8e85e411c user: anonymous | |
20:38 | • Reply: How can I check if a database is valid? artifact: 6844e0503a user: LcccXmm | |
20:35 | • Edit reply: "Nested" "prepare" function calls artifact: bdd3b8e906 user: larrybr | |
20:33 | • Reply: "Nested" "prepare" function calls artifact: 443795548b user: larrybr | |
20:30 | • Reply: Performance regression in version 3.40.2 using views on indexed tables artifact: a284a63124 user: anonymous | |
20:16 | • Post: Suggestions of tools to handle database migrations (using raw SQL)? artifact: 32997c5704 user: joeljuca | |
20:14 | • Post: "Nested" "prepare" function calls artifact: 20ea9f2c48 user: lea12345 | |
19:59 | • Reply: Feature request: Stored Procedures artifact: 10dffa8112 user: jicman | |
18:39 | • Edit reply: Feature request: Stored Procedures artifact: 370b4948aa user: kmedcalf | |
18:37 | • Reply: Feature request: Stored Procedures artifact: 84ec1a684a user: kmedcalf | |
17:49 | • Reply: Feature request: Stored Procedures artifact: e8ce6c3b46 user: anonymous | |
17:38 | • Edit reply: How can I check if a database is valid? artifact: 4a38f2d670 user: Clothears | |
17:37 | • Reply: How can I check if a database is valid? artifact: e3be904b45 user: Clothears | |
17:30 | • Reply: SQlite encryption artifact: 5b3724ea91 user: anonymous | |
17:30 | • Reply: How can I check if a database is valid? artifact: 07aef6f28b user: kmedcalf | |
17:15 | • Reply: Performance regression in version 3.40.2 using views on indexed tables artifact: 0899502198 user: Jibalamy | |
16:38 | • Reply: Changes in json since 3.39.0? artifact: 46e7fc6a49 user: codehz | |
16:29 | • Edit reply: How can I check if a database is valid? artifact: bf2f30dd5c user: kmedcalf | |
16:28 | • Reply: How can I check if a database is valid? artifact: 51a1ab5199 user: kmedcalf | |
16:25 | • Reply: How can I check if a database is valid? artifact: c74653614c user: codehz | |
16:12 | • Edit reply: Research questions about how sqlite works artifact: 5be52afeea user: pepijnve | |
16:12 | • Edit reply: How can I check if a database is valid? artifact: 5bc8463ff8 user: LcccXmm | |
16:11 | • Reply: How can I check if a database is valid? artifact: 2cfffff79e user: LcccXmm | |
15:31 | • Reply: Research questions about how sqlite works artifact: d580a3cd7e user: pepijnve | |
15:31 | • Edit reply: sqlite 3.41: major performance regression in views selecting from a TEXT column and a literal artifact: f9346b11a6 user: drh | |
15:30 | • Reply: sqlite 3.41: major performance regression in views selecting from a TEXT column and a literal artifact: acaa188004 user: drh | |
15:26 | • Reply: Performance regression in version 3.40.2 using views on indexed tables artifact: c3ef454d06 user: drh | |
14:55 | • Reply: Feature request: Stored Procedures artifact: f1928ccdc8 user: kmedcalf | |
14:43 | • Reply: Research questions about how sqlite works artifact: dc43571b2a user: kmedcalf | |
14:33 | • Reply: Problem with recursive CTE traversing a graph with loops artifact: 9013376697 user: seriousken | |
14:30 | • Post: Performance regression in version 3.40.2 using views on indexed tables artifact: 3a180ba0d4 user: Jibalamy | |
13:41 | • Reply: Feature request: Stored Procedures artifact: aee4569aac user: anonymous | |
13:00 | • Reply: Changes in json since 3.39.0? artifact: c934fa7cf2 user: anonymous | |
12:34 | • Post: Problem with recursive CTE traversing a graph with loops artifact: ba9d77ef90 user: seriousken | |
12:32 | • Reply: SQlite encryption artifact: 4d57c005ed user: aloys | |
12:19 | • Reply: Changes in json since 3.39.0? artifact: 37c04f7330 user: drh | |
12:12 | • Reply: Changes in json since 3.39.0? artifact: 879598dcf9 user: ddevienne | |
11:38 | • Reply: Changes in json since 3.39.0? artifact: 8af7738fc4 user: stephan | |
11:37 | • Reply: Changes in json since 3.39.0? artifact: 8bac5d0655 user: drh | |
11:22 | • Edit reply: An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option artifact: bc8ebe1e80 user: ChiZhang | |
11:16 | • Reply: An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option artifact: 74c1490f54 user: ChiZhang | |
11:12 | • Post: Changes in json since 3.39.0? artifact: 3d4386bc87 user: anonymous | |
11:03 | • Reply: Research questions about how sqlite works artifact: 6c1ed62b11 user: pepijnve | |
09:36 | • Reply: Hooks invoked when modifications done from another connection? artifact: cfa973ae90 user: dkfellows | |
09:33 | • Reply: An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option artifact: 1e84b23106 user: dkfellows | |
09:28 | • Reply: Feature request: Stored Procedures artifact: 4c68ede48b user: dkfellows | |
09:12 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: db4b7747f8 user: dkfellows | |
07:49 | • Reply: SQlite encryption artifact: 151b0519ec user: hanche | |
07:46 | • Reply: SQlite encryption artifact: a0fc2437e0 user: wyoung | |
07:43 | • Post: An assertion failure only triggers in JDBC driver with -DSQLITE_DEBUG=1 compile option artifact: dc4854437b user: ChiZhang | |
07:26 | • Reply: SQlite encryption artifact: 836120fefa user: anonymous | |
06:00 | • Reply: SQlite encryption artifact: 4ede76657c user: wyoung | |
05:11 | • Reply: SQlite encryption artifact: 07fbc5c9c5 user: anonymous | |
04:05 | • Edit reply: Building sqlite_analyzer.exe with just GCC commands artifact: 44fd9041d2 user: kmedcalf | |
04:04 | • Edit reply: Building sqlite_analyzer.exe with just GCC commands artifact: 2cc1b86c0d user: kmedcalf | |
04:01 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 8fc98fb9ee user: kmedcalf | |
03:41 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 52f4b58462 user: wlhmnrrd | |
03:32 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 9e0c41562d user: kmedcalf | |
03:30 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 312b2c6ca6 user: wlhmnrrd | |
03:28 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 8495982dcc user: kmedcalf | |
03:25 | • Edit reply: Building sqlite_analyzer.exe with just GCC commands artifact: 5829eb0fa6 user: wlhmnrrd | |
03:22 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: c09bbd050e user: wlhmnrrd | |
02:48 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: f2c5b08a23 user: kmedcalf | |
01:35 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 09bcf1ee0b user: larrybr | |
01:25 | • Edit reply: Building sqlite_analyzer.exe with just GCC commands artifact: 5189bc2983 user: wlhmnrrd | |
01:11 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 2ed8437b89 user: wlhmnrrd | |
01:04 | • Reply: DLL load failed %1 is not a valid Win32 application artifact: 45afa3d2f2 user: wkwkwk | |
00:39 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 0710d10f2e user: larrybr | |
00:12 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: c9d4e059ff user: kmedcalf | |
00:01 | • Reply: Building sqlite_analyzer.exe with just GCC commands artifact: 83ecf723a4 user: wlhmnrrd | |
2 Years Ago (more context)
2022-03-23
| ||
23:42 | • Reply: temporary table in SQLITE artifact: 2b89603459 user: kmedcalf | |
23:30 | • Reply: temporary table in SQLITE artifact: 7b70c81a35 user: kmedcalf | |
22:19 | • Edit: CVE-2020-9794 -- OOB Read Vulnerability artifact: f05f166e19 user: jhawkins1 | |
22:13 | • Reply: temporary table in SQLITE artifact: 8331aa5d33 user: wyoung | |
22:05 | • Post: temporary table in SQLITE artifact: 4a1220b9f1 user: anonymous | |
21:09 | • Post: CVE-2020-9794 -- OOB Read Vulnerability artifact: 6b29e0672f user: jhawkins1 | |
18:57 | • Reply: Excel formulas in SQLITE artifact: 91bd25d645 user: anonymous | |
18:56 | • Reply: Create and attach multiple in-memory DBs artifact: dc41847342 user: RickyLeRoi | |
18:38 | • Reply: Create and attach multiple in-memory DBs artifact: ce54b9c9e7 user: andse-t610 | |
18:20 | • Edit: os_unix.c: potential Integer overflow artifact: 0e72364f2e user: Martijn81 | |
18:18 | • Post: os_unix.c: potential Integer overflow artifact: 8144cee0c7 user: Martijn81 | |
18:15 | • Reply: Create and attach multiple in-memory DBs artifact: 37e27018c7 user: kmedcalf | |
17:54 | • Edit reply: strftime and utc artifact: 5a23b1bb6e user: kmedcalf | |
17:48 | • Delete reply: Create and attach multiple in-memory DBs artifact: fd81f80753 user: RickyLeRoi | |
17:48 | • Reply: Create and attach multiple in-memory DBs artifact: d345180db4 user: RickyLeRoi | |
17:47 | • Reply: Create and attach multiple in-memory DBs artifact: 58b5068ffd user: RickyLeRoi | |
17:39 | • Reply: Excel formulas in SQLITE artifact: b864443f49 user: cuz | |
17:37 | • Reply: strftime and utc artifact: 546188cb5f user: kmedcalf | |
17:25 | • Reply: Create and attach multiple in-memory DBs artifact: d8077a39f1 user: andse-t610 | |
16:30 | • Reply: Create and attach multiple in-memory DBs artifact: 75fa82f0ad user: andse-t610 | |
16:27 | • Reply: Excel formulas in SQLITE artifact: 5037bfae21 user: anonymous | |
16:25 | • Reply: strftime and utc artifact: e62617b674 user: drh | |
16:13 | • Edit reply: Create and attach multiple in-memory DBs artifact: 48d354040d user: RickyLeRoi | |
16:10 | • Reply: Create and attach multiple in-memory DBs artifact: 2f796043c4 user: RickyLeRoi | |
16:08 | • Reply: Create and attach multiple in-memory DBs artifact: 485b09d57e user: RickyLeRoi | |
15:57 | • Reply: Create and attach multiple in-memory DBs artifact: c39427e689 user: RickyLeRoi | |
15:51 | • Post: Excel formulas in SQLITE artifact: cc251397fc user: anonymous | |
15:30 | • Post: Efficient Min/Max using window functions? artifact: 364075e743 user: mark | |
15:10 | • Post: Saving the JSon data returned from SQLServer directly to the Sqlite table artifact: f499576370 user: OgzArk | |
14:54 | • Reply: Create and attach multiple in-memory DBs artifact: 6ab1200e4e user: andse-t610 | |
14:53 | • Reply: strftime and utc artifact: ba2de993b5 user: anonymous | |
13:19 | • Reply: Create and attach multiple in-memory DBs artifact: 04edf8ebfb user: gunter_hick | |
12:30 | • Edit reply: strftime and utc artifact: 03af2a3bf5 user: drh | |
12:30 | • Reply: strftime and utc artifact: 6683dad72d user: drh | |
12:28 | • Reply: Create and attach multiple in-memory DBs artifact: e726c71ea6 user: stephan | |
12:07 | • Post: Create and attach multiple in-memory DBs artifact: a1954d00aa user: RickyLeRoi | |
11:48 | • Reply: strftime and utc artifact: bd718ae091 user: cuz | |
11:41 | • Reply: strftime and utc artifact: 41c8c1aca8 user: cuz | |
11:41 | • Reply: strftime and utc artifact: 39264da7ec user: anonymous | |
11:35 | • Reply: Corrupt FTS5 table after declaring triggers a certain way artifact: 93be31a44a user: dan | |
11:35 | • Reply: strftime and utc artifact: 2f8aa56afd user: drh | |
11:22 | • Reply: strftime and utc artifact: 8a6131e532 user: billwade | |
11:03 | • Reply: CLI - wonky tables with BLOB columns artifact: 8e15986db6 user: missinglink | |
10:52 | • Post: strftime and utc artifact: a149afe480 user: anonymous | |
10:25 | • Reply: CLI - wonky tables with BLOB columns artifact: 8cec152e77 user: drh | |
09:46 | • Post: CLI - wonky tables with BLOB columns artifact: 5835247787 user: missinglink | |
06:21 | • Edit: Corrupt FTS5 table after declaring triggers a certain way artifact: 390693ee49 user: marcardar | |
02:52 | • Post: Corrupt FTS5 table after declaring triggers a certain way artifact: 58344c9e1b user: marcardar | |
02:05 | • Reply: New Feature Select ... as JSON artifact: f63df61b27 user: bjoern | |
01:46 | • Reply: Virtual Table without rowid artifact: cadc35335e user: bjoern | |
3 Years Ago (more context)
2021-03-23
| ||
23:58 | • Reply: null character sorts greater than 0x7f and less than 0x80 artifact: 41a7b02d11 user: resuna | |
23:55 | • Reply: Select distinct from most recent record artifact: 9418bd79ed user: anonymous | |
23:46 | • Edit reply: Select distinct from most recent record artifact: e5aeb398e4 user: kmedcalf | |
23:45 | • Edit reply: Select distinct from most recent record artifact: 4422f03ab9 user: kmedcalf | |
23:42 | • Reply: Select distinct from most recent record artifact: 7d7b5e84c1 user: kmedcalf | |
22:50 | • Edit reply: DROP TABLE failure - is it intentional or a bug? artifact: 537f0aea78 user: kmedcalf | |
22:36 | • Edit reply: DROP TABLE failure - is it intentional or a bug? artifact: 14ca232195 user: kmedcalf | |
22:30 | • Reply: DROP TABLE failure - is it intentional or a bug? artifact: 09dbb19de6 user: kmedcalf | |
22:30 | • Reply: Select distinct from most recent record artifact: d734a19b0c user: anonymous | |
22:20 | • Reply: Change Default ORDER BY to descending. artifact: afc6eeda9c user: larrybr | |
22:10 | • Post: Change Default ORDER BY to descending. artifact: 6fe44ff958 user: anonymous | |
22:06 | • Reply: DROP TABLE failure - is it intentional or a bug? artifact: c3620cde73 user: larrybr | |
21:37 | • Reply: Select distinct from most recent record artifact: df97cf872c user: cuz | |
21:29 | • Reply: DROP TABLE failure - is it intentional or a bug? artifact: 5fba669965 user: kmedcalf | |
21:18 | • Reply: The opposite of AUTOINCREMENT artifact: 187012a513 user: cuz | |
21:01 | • Post: Select distinct from most recent record artifact: 540f79eafb user: anonymous | |
18:54 | • Reply: incremental_vacuum and WAL size artifact: f6ad72c8c6 user: abarr5 | |
17:33 | • Reply: The opposite of AUTOINCREMENT artifact: 3b46d302c5 user: wyoung | |
17:17 | • Reply: The opposite of AUTOINCREMENT artifact: aafa097f45 user: GSnyder | |
17:09 | • Reply: The opposite of AUTOINCREMENT artifact: 1ce38ae611 user: jimmorris33215 | |
17:02 | • Reply: Sum data query request artifact: aae86025fa user: cuz | |
16:29 | • Reply: DROP TABLE failure - is it intentional or a bug? artifact: 68a4d03b80 user: cuz | |
15:53 | • Post: The opposite of AUTOINCREMENT artifact: 2d5cf2fa83 user: anonymous | |
15:12 | • Reply: Sum data query request artifact: 32155b0287 user: stephan | |
14:42 | • Post: Sum data query request artifact: 4bbbcade7a user: anonymous | |
13:28 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: fcb26719db user: dvdraymond | |
13:16 | • Reply: Strange CLI .exit issue artifact: 79c7c11eea user: anonymous | |
12:47 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: a9dd9bede2 user: larrybr | |
12:30 | • Edit reply: Strange CLI .exit issue artifact: 415b921383 user: drh | |
12:29 | • Reply: Strange CLI .exit issue artifact: a002b17ac0 user: drh | |
12:08 | • Reply: 3.25 math functions vs. extension-functions.c artifact: 6e243a2068 user: MarkusWinand | |
11:28 | • Reply: incremental_vacuum and WAL size artifact: 390af9ab9a user: dan | |
11:12 | • Reply: Strange CLI .exit issue artifact: 14044f2061 user: anonymous | |
11:10 | • Reply: Strange CLI .exit issue artifact: 8f047145ef user: anonymous | |
11:09 | • Reply: Strange CLI .exit issue artifact: 4b7418e007 user: anonymous | |
11:07 | • Reply: Strange CLI .exit issue artifact: f1ecabfa8a user: TripeHound | |
10:29 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: edb167d7eb user: jdennis | |
10:23 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: 9cf9de6e84 user: ddevienne | |
10:12 | • Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: c56b2f0f61 user: gunter_hick | |
09:21 | • Reply: Strange CLI .exit issue artifact: 689292a7db user: kmedcalf | |
09:16 | • Reply: Strange CLI .exit issue artifact: da1853af1d user: larrybr | |
09:10 | • Reply: Strange CLI .exit issue artifact: c947e2b98a user: anonymous | |
08:59 | • Reply: Strange CLI .exit issue artifact: e0bb039222 user: anonymous | |
08:52 | • Reply: 3.25 math functions vs. extension-functions.c artifact: c790b71799 user: MBS | |
08:47 | • Reply: 3.25 math functions vs. extension-functions.c artifact: 7bd48efa2b user: larrybr | |
08:11 | • Reply: Strange CLI .exit issue artifact: 1eeb7da0a5 user: larrybr | |
07:21 | • Post: 3.25 math functions vs. extension-functions.c artifact: 02061aac66 user: MarkusWinand | |
03:33 | • Reply: Strange CLI .exit issue artifact: b513c5b7f4 user: sqweek | |
00:40 | • Reply: Strange CLI .exit issue artifact: d28b288130 user: larrybr | |
00:28 | • Edit reply: Strange CLI .exit issue artifact: aa19ba40c5 user: kmedcalf | |
00:20 | • Reply: Strange CLI .exit issue artifact: f4f8a3df76 user: anonymous | |
00:03 | • Reply: DROP TABLE failure - is it intentional or a bug? artifact: c9c3299320 user: younique | |
4 Years Ago (more context)
2020-03-23
| ||
12:04 | • Reply: Renaming a database artifact: d67528727d user: cuz | |
11:33 | • Reply: Renaming a database artifact: 64c854682c user: wmertens | |
10:38 | • Reply: Renaming a database artifact: 33ff5204bc user: tobydickenson | |
09:25 | • Edit reply: Help:Could I use SQLite in-memory database with WAL mode? artifact: 1d7f50652d user: ddevienne | |
09:19 | • Edit reply: Help:Could I use SQLite in-memory database with WAL mode? artifact: 3506661568 user: ddevienne | |
09:12 | • Reply: Help:Could I use SQLite in-memory database with WAL mode? artifact: efb34ad463 user: ddevienne | |
04:14 | • Reply: Using parser to do extra work artifact: e4c7072318 user: daniel_xu_forever | |
03:11 | • Reply: Request for comment: New ANALYZE syntax artifact: f2dc71efe6 user: anonymous | |