This Day In History For 2025-06-21
1 Year Ago (more context)
|
2024-06-21
| ||
| 22:55 | • Reply: Help understanding the effect of BEGIN IMMEDIATE artifact: 650a97c05c user: ncruces | |
| 22:54 | • Reply: GCC bug? artifact: 9e455e8179 user: vman59 | |
| 22:17 | • Post: Help understanding the effect of BEGIN IMMEDIATE artifact: 119e937367 user: simonw | |
| 19:19 | • Reply: How does SQLite handles precision in queries? Issue in > query. artifact: dfd0112b6f user: jkreibich | |
| 18:38 | • Reply: Install version 3.46.0 artifact: 940dac77b3 user: wyoung | |
| 18:07 | • Post: How does SQLite handles precision in queries? Issue in > query. artifact: b97e5d7dd9 user: Itanta | |
| 18:07 | • Reply: Install version 3.46.0 artifact: c7a611ad1f user: jicman | |
| 17:29 | • Post: FTS5 error messge with joined-words artifact: ead2179a8a user: rogerbinns | |
| 16:10 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: 30c35ab2a2 user: jicman | |
| 15:15 | • Post: Install version 3.46.0 artifact: cf2dfbb0b8 user: guszato | |
| 14:49 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: d0f44b1e27 user: slavin | |
| 11:15 | • Reply: Virtual table xShadowName lacking any context information artifact: 3300aa61aa user: ncruces | |
| 05:34 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: 99cdf1aad9 user: larrybr | |
| 04:12 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: a6e287c38a user: sqlitening | |
| 03:53 | • Reply: I would like to know if SQLite is a DBMS in the strict sense? artifact: 4762588986 user: AAsk1902 | |
| 01:04 | • Reply: Can I select a computed vs. stored value in an expression index side by side artifact: 227d063af0 user: _blgl_ | |
2 Years Ago (more context)
|
2023-06-21
| ||
| 22:58 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: eb75594581 user: mukeshsharma | |
| 22:53 | • Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: 00afe6c65a user: anonymous | |
| 21:20 | • Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: aaf33fd448 user: kmedcalf | |
| 21:01 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 60f4cac687 user: kmedcalf | |
| 20:10 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: ae4cb61312 user: sqlitening | |
| 19:59 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: c048dbee59 user: kmedcalf | |
| 19:39 | • Reply: How is rank and bm25 related? artifact: 61c42ec846 user: dan | |
| 19:31 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 13b37443ae user: anonymous | |
| 18:58 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: adb8a31578 user: kmedcalf | |
| 18:22 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: a9cd442385 user: anonymous | |
| 18:15 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 405b0aae5a user: kmedcalf | |
| 18:00 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 570f320070 user: anonymous | |
| 17:58 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 0413db0518 user: anonymous | |
| 17:39 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: fb33df77f8 user: kmedcalf | |
| 17:31 | • Post: SQLite and PGO results artifact: 19870fae95 user: zamazan4ik | |
| 17:29 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 9e4838958d user: sqlitening | |
| 16:48 | • Post: How is rank and bm25 related? artifact: 2fc481fcb6 user: 961679 | |
| 16:16 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 8c845b9e20 user: anonymous | |
| 16:02 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 3f0c161755 user: anonymous | |
| 16:01 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 4350638e78 user: kmedcalf | |
| 15:09 | • Post: "database is locked": detecting deadlock vs. busy timeout? artifact: ecc5ed460e user: anonymous | |
| 14:55 | • Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: 1c99320a45 user: sqlitening | |
| 13:48 | • Edit reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 949da59e6a user: slavin | |
| 13:48 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 739c12bc14 user: slavin | |
| 13:37 | • Edit reply: Need help with building SQLite for Android with ICU enabled artifact: 41d9e70a91 user: stephan | |
| 13:36 | • Edit [12ad213dfe170a7f|12ad213dfe]: Add propagating "closed". artifact: 22883ae9ef user: stephan | |
| 13:27 | • Reply: Need help with building SQLite for Android with ICU enabled artifact: f8cde052f9 user: anonymous | |
| 13:05 | • Post: Need help with building SQLite for Android with ICU enabled artifact: 12ad213dfe user: aeroxr1 | |
| 12:53 | • Edit reply: postgres ilike operator artifact: 93a43d3f0b user: holgerj | |
| 12:52 | • Reply: postgres ilike operator artifact: 420f032653 user: holgerj | |
| 09:33 | • Reply: postgres ilike operator artifact: d71dd38195 user: spindrift | |
| 07:54 | • Edit reply: postgres ilike operator artifact: 70963361a2 user: hanche | |
| 07:53 | • Reply: postgres ilike operator artifact: 4a4835d03d user: hanche | |
| 06:57 | • Reply: postgres ilike operator artifact: f6f309a6e4 user: renerene | |
| 06:45 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: ac17ef94fa user: larrybr | |
| 05:41 | • Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: c036d2ffb2 user: gunter_hick | |
| 05:27 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 1906f2d515 user: paulclinger | |
| 05:24 | • Reply: How to recover from "freelist leaf count too big" integrity check warning? artifact: 3b8285e345 user: paulclinger | |
| 05:21 | • Reply: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 974c490b23 user: gunter_hick | |
| 00:06 | • Reply: sqlite3_load_extension not linked artifact: 984fe08edb user: larrybr | |
3 Years Ago (more context)
|
2022-06-21
| ||
| 19:37 | • Reply: Encrypt and decrypt SQLite database artifact: bdbfd31306 user: chrisjlocke1 | |
| 19:06 | • Reply: Values not always same artifact: 690a1fda82 user: HB9FIH | |
| 18:39 | • Reply: "NOT INDEXED" ineffective with multicolumn WHERE artifact: cfb96d1a80 user: drh | |
| 18:21 | • Reply: Encrypt and decrypt SQLite database artifact: 757c79436c user: SarahLeroy | |
| 17:42 | • Post: "NOT INDEXED" ineffective with multicolumn WHERE artifact: 454d706296 user: anonymous | |
| 17:18 | • Reply: Values not always same artifact: 8cfad0c0aa user: cuz | |
| 17:15 | • Reply: XCommit called without xBegin artifact: 7a8c93565a user: CGamesPlay | |
| 17:07 | • Reply: Values not always same artifact: 1719652f52 user: Clothears | |
| 17:05 | • Reply: Values not always same artifact: 4ad97b45cc user: larrybr | |
| 16:52 | • Reply: Values not always same artifact: 878e2e4376 user: cuz | |
| 16:50 | • Reply: Values not always same artifact: e2ecbbbba8 user: cuz | |
| 16:37 | • Reply: Encrypt and decrypt SQLite database artifact: 0c89b1f22d user: SarahLeroy | |
| 16:35 | • Reply: Values not always same artifact: 334e0e000a user: chrisjlocke1 | |
| 16:14 | • Reply: Values not always same artifact: a6f8f39b06 user: stephan | |
| 16:05 | • Post: Values not always same artifact: 53794184ed user: HB9FIH | |
| 15:13 | • Post: Importing csv Files artifact: 887bfaedc1 user: gjroos | |
| 14:30 | • Reply: Unexpected Parse Error artifact: b27c979f3d user: dfgriggs | |
| 14:16 | • Reply: Unexpected Parse Error artifact: 6498a00369 user: bajinsheng | |
| 13:45 | • Reply: Special language signs in output artifact: cf1ad3eee4 user: florian.balmer | |
| 13:43 | • Reply: Unexpected Parse Error artifact: b10273b1d2 user: drh | |
| 13:33 | • Reply: Special language signs in output artifact: 7d49ef614c user: RandomCoder | |
| 13:28 | • Reply: Output to file problem resolved artifact: 0672012769 user: dkfellows | |
| 13:21 | • Edit reply: Special language signs in output artifact: 81f0b87c67 user: dkfellows | |
| 13:21 | • Reply: Special language signs in output artifact: 7a098f9be5 user: dkfellows | |
| 13:20 | • Edit: Special language signs in output artifact: 1d27b12df1 user: 102022 | |
| 13:14 | • Post: XCommit called without xBegin artifact: 21b7a234d6 user: anonymous | |
| 13:00 | • Reply: Special language signs in output artifact: d0c20cc6da user: kjames3411 | |
| 12:33 | • Edit: Special language signs in output artifact: 53a60edfe1 user: 102022 | |
| 11:54 | • Edit: Output to file problem resolved artifact: f491259b0a user: 102022 | |
| 11:39 | • Reply: Special language signs in output artifact: a33af8633e user: florian.balmer | |
| 11:30 | • Reply: Special language signs in output artifact: 8265e9357a user: chrisjlocke1 | |
| 11:24 | • Reply: Special language signs in output artifact: 79d2ab2425 user: florian.balmer | |
| 11:06 | • Edit: Output to file problem resolved artifact: 2a5e6a946e user: 102022 | |
| 11:05 | • Edit: Output to file problem resolved artifact: c01d3fd82d user: 102022 | |
| 10:59 | • Post: Unexpected Parse Error artifact: 1a7fea4651 user: bajinsheng | |
| 10:53 | • Post: Output to file problem resolved artifact: 5c829ac67f user: 102022 | |
| 10:41 | • Reply: Special language signs in output artifact: d7917769ae user: 102022 | |
| 08:57 | • Reply: Special language signs in output artifact: ecfaf47696 user: gunter_hick | |
| 08:49 | • Reply: Special language signs in output artifact: 805ae3e361 user: dkfellows | |
| 07:43 | • Post: Special language signs in output artifact: f86013a3a5 user: 102022 | |
| 01:20 | • Reply: Unexpected Expression Result by FULL OUTER JOIN artifact: f4b6caf75c user: bajinsheng | |
| 01:19 | • Reply: Unexpected Expression on ON clause artifact: 4e9e77e05c user: bajinsheng | |
| 00:18 | • Post: Tip: using sqlite3 to execute CLI one-liner queries against CSV files artifact: 7ec9d9e4eb user: simonw | |
4 Years Ago (more context)
|
2021-06-21
| ||
| 23:53 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: efe44bfd1f user: kmedcalf | |
| 23:48 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: f5ddde7a75 user: kmedcalf | |
| 21:56 | • Reply: Integer overflow risk in sqlite3_changes and underlying counter? artifact: 49dd5912f4 user: anonymous | |
| 21:55 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: dab7d1eddc user: anonymous | |
| 21:28 | • Edit: dense ranking artifact: be33fdd41b user: GertVA | |
| 21:15 | • Reply: Extension Wraping functions with ability to throw error and abort query artifact: 8d9dce875a user: drh | |
| 21:01 | • Post: dense ranking artifact: 6d139779b7 user: GertVA | |
| 19:52 | • Post: Extension Wraping functions with ability to throw error and abort query artifact: ee2e9d0070 user: anonymous | |
| 17:32 | • Post: Integer overflow risk in sqlite3_changes and underlying counter? artifact: ae43b57338 user: anonymous | |
| 15:08 | • Reply: Connection Pool always empty? artifact: ef586152fa user: gunter_hick | |
| 14:56 | • Post: Connection Pool always empty? artifact: 066b4fda6e user: Flohack | |
| 13:45 | • Reply: FILTER clause with window functions artifact: 8e1ecfe02d user: dan | |
| 12:10 | • Reply: 3.36.0 changed visibility of CTEs, intentionally? artifact: 33b42c65b6 user: drh | |
| 11:48 | • Post: 3.36.0 changed visibility of CTEs, intentionally? artifact: f3bc922a14 user: MarkusWinand | |
| 07:36 | • Edit: FILTER clause with window functions artifact: e3d91ae798 user: RoboManni | |
| 07:18 | • Reply: Help with compiling extension artifact: 79853ca24c user: anonymous | |
| 04:48 | • Reply: CLI Documentation Error artifact: 70b578b4ff user: larrybr | |
| 04:33 | • Edit: CLI Documentation Error artifact: 86da48bff8 user: kmedcalf | |
| 04:33 | • Post: CLI Documentation Error artifact: 869c380198 user: kmedcalf | |
| 03:54 | • Edit reply: Non-existent function lsname() in cli artifact: 67dc8ee015 user: larrybr | |
| 03:50 | • Reply: Feature request, PRAGMA for setting default transaction mode artifact: 9a9a90e1ff user: little-pan | |
| 03:35 | • Reply: Help with compiling extension artifact: 040c052e32 user: larrybr | |
| 03:20 | • Reply: Non-existent function lsname() in cli artifact: 9bec67ed5a user: larrybr | |
| 02:34 | • Post: Non-existent function lsname() in cli artifact: 4cb73f3c26 user: EricTsau | |
| 01:52 | • Reply: Bug Use «RETURNING» in transaction cause error 5 on commit. artifact: 52f001ddd5 user: kmedcalf | |
| 01:43 | • Reply: Bug Use «RETURNING» in transaction cause error 5 on commit. artifact: a9318e2f70 user: kmedcalf | |
| 00:58 | • Post: Help with compiling extension artifact: d393c070f5 user: anonymous | |
| 00:42 | • Post: Bug Use «RETURNING» in transaction cause error 5 on commit. artifact: a51918ee28 user: ELKirill | |
5 Years Ago (more context)
|
2020-06-21
| ||
| 23:16 | • Reply: Decimal128 artifact: bd8c1d5dcb user: LarryBrasfield | |
| 23:13 | • Reply: Newbie question: Decision for database model artifact: 5d4dbd00a9 user: LarryBrasfield | |
| 22:51 | • Reply: What reading wal can result in `BusyError: database is locked`? artifact: 13e20d7ec4 user: drh | |
| 22:42 | • Reply: What reading wal can result in `BusyError: database is locked`? artifact: ca4409f86d user: 6kEs4Majrd | |
| 22:35 | • Reply: Newbie question: Decision for database model artifact: e740da5c97 user: slavin | |
| 22:31 | • Reply: C API for holding shm file in cache memory on Mac OS X and Linux? artifact: aa37336ac6 user: slavin | |
| 22:29 | • Reply: What reading wal can result in `BusyError: database is locked`? artifact: aa9e01d680 user: slavin | |
| 19:30 | • Reply: Decimal128 artifact: c0fa5a4a34 user: kmedcalf | |
| 19:15 | • Reply: Decimal128 artifact: 198b151166 user: kmedcalf | |
| 19:02 | • Edit reply: Decimal128 artifact: 569ff2dca0 user: kmedcalf | |
| 18:58 | • Reply: Decimal128 artifact: c690c360d2 user: kmedcalf | |
| 17:16 | • Reply: Decimal128 artifact: 2263871a25 user: anonymous | |
| 16:49 | • Reply: Decimal128 artifact: df376d319f user: wmertens | |
| 16:02 | • Reply: Decimal128 artifact: 8bda7a0373 user: kmedcalf | |
| 15:52 | • Reply: Decimal128 artifact: 562f129178 user: kmedcalf | |
| 15:45 | • Reply: Decimal128 artifact: 9c3890fd04 user: kmedcalf | |
| 15:34 | • Reply: What reading wal can result in `BusyError: database is locked`? artifact: 48e2342508 user: kmedcalf | |
| 14:38 | • Reply: Decimal128 artifact: cf735cb9ca user: doug9forester | |
| 12:03 | • Reply: temp storage within triggers artifact: a1fe6813a3 user: ingo | |
| 11:19 | • Reply: Decimal128 artifact: 96f418fad5 user: RichardDamon | |
| 10:35 | • Reply: table locked when dropping a temp table artifact: dd94114eff user: olivluca | |
| 08:52 | • Reply: table locked when dropping a temp table artifact: 5c238047de user: wmertens | |
| 08:46 | • Reply: Decimal128 artifact: d1c08ee2e8 user: wmertens | |
| 08:36 | • Post: What reading wal can result in `BusyError: database is locked`? artifact: 8b05f1adf7 user: 6kEs4Majrd | |
| 08:26 | • Reply: Decimal128 artifact: fada9f1079 user: wmertens | |
| 04:29 | • Reply: C API for holding shm file in cache memory on Mac OS X and Linux? artifact: 71594772ff user: stephan | |
| 00:36 | • Reply: Decimal128 artifact: 3eba6b6c98 user: RichardDamon | |