SQLite User Forum

Today In History
Login

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