This Day In History For 2025-06-13
1 Year Ago (more context)
2024-06-13
| ||
23:33 | • Reply: FORTRAN with SQLite artifact: e1e76394ec user: larrybr | |
22:15 | • Post: FORTRAN with SQLite artifact: daa068b652 user: kcbaggett | |
20:26 | • Post: FAQ Suggestion: link to Pikchr migration directly artifact: 086a02f29f user: naesten | |
20:24 | • Edit reply: Did the Variable opcode change recently? artifact: 2180f3b5d5 user: simonw | |
20:22 | • Reply: Did the Variable opcode change recently? artifact: bfc133701d user: simonw | |
18:47 | • Post: Using EF Core vs raw SQL artifact: c0c5a532a4 user: fa2020 | |
14:54 | • Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 1072d7431f user: punkish | |
14:48 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 4d2916c538 user: rogerbinns | |
14:12 | • Reply: SQLite and SQLite Cloud artifact: 8e4f6da023 user: ThanksRyan | |
11:47 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: d44521f507 user: anonymous | |
10:56 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 3fbefdcdda user: anonymous | |
10:20 | • Edit reply: "database is locked": detecting deadlock vs. busy timeout? artifact: aa8f6e3624 user: ncruces | |
10:15 | • Edit reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 41b58036a7 user: ncruces | |
10:14 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: a980cc3e63 user: ncruces | |
09:19 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: d6d2cbe445 user: anonymous | |
08:57 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: 7168004618 user: stephan | |
08:50 | • Edit reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 576bf3f1d8 user: stephan | |
08:49 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: 47b590e3ef user: stephan | |
07:20 | • Reply: "database is locked": detecting deadlock vs. busy timeout? artifact: b5bb89da24 user: anonymous | |
06:41 | • Edit reply: BUG: round(0.15,1) = 0.1; v3.45.1 artifact: 55fa2a9092 user: mingodad | |
04:48 | • Reply: ./libtool: line 3109: 0: Bad file descriptor Error artifact: fb7ceb45bf user: anonymous | |
2 Years Ago (more context)
2023-06-13
| ||
23:05 | • Delete reply: json_extract() doesn't work on json_valid artifact: af545410d5 user: dbabits | |
22:59 | • Reply: json_extract() doesn't work on json_valid artifact: eb197c1d75 user: dbabits | |
22:59 | • Reply: json_extract() doesn't work on json_valid artifact: 5645ec2408 user: dbabits | |
20:14 | • Reply: json_extract() doesn't work on json_valid artifact: 701d02154c user: drh | |
20:12 | • Reply: json_extract() doesn't work on json_valid artifact: 45aed6c7c3 user: dvdraymond | |
19:41 | • Post: json_extract() doesn't work on json_valid artifact: d27ed3c2a3 user: dbabits | |
19:26 | • Edit reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: 9485ac653b user: jicman | |
18:58 | • Reply: ENABLE_FTS4 missing from compile_options, but FTS4 tables work?! artifact: 9b3300fb4b user: larrybr | |
17:29 | • Reply: Crash on multiple inserts artifact: ca25fa9ac9 user: drh | |
16:18 | • Post: Crash on multiple inserts artifact: 8a12f29ab3 user: davidengler | |
14:51 | • Reply: SELECT usage: unclear terms - theory questions (GROUP BY, ORDER BY). Beginner) artifact: 554e36867e user: kmedcalf | |
14:21 | • Post: xBestIndex called with nConstraint=0 when using LIKE exp ESCAPE '_' artifact: 2a0745863f user: scasaletto | |
12:57 | • Reply: Unwanted page reloading sqlite3 nodejs artifact: 9c5cc731dd user: tantaman | |
12:21 | • Edit reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: fcbd14ee00 user: jicman | |
12:20 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: 017282ac11 user: jicman | |
11:51 | • Reply: File is encrypted or is not a database artifact: f08278519d user: isuzucrewcab | |
10:50 | • Reply: Option to make SQLite stricter with non-aggregate columns artifact: 48800de2ca user: drh | |
10:50 | • Reply: Exceptions in using the 'charIndex' function in the. NET framework artifact: 45d0ec177a user: chrisjlocke1 | |
10:00 | • Reply: Performance issue after upgrading sqlite-jdbc version from 3.39.4.1 to 3.40.0.0 and onwards artifact: e69254fd53 user: mukeshsharma | |
08:02 | • Reply: File is encrypted or is not a database artifact: 5be39562af user: knu | |
04:26 | • Post: Exceptions in using the 'charIndex' function in the. NET framework artifact: 4817c9692f user: miss4826 | |
02:04 | • Reply: File is encrypted or is not a database artifact: 4a79d1fe24 user: jpbrown | |
01:01 | • Post: File is encrypted or is not a database artifact: aadbe2899a user: isuzucrewcab | |
3 Years Ago (more context)
2022-06-13
| ||
22:18 | • Reply: Unexpected Result by Complicated JOINING Again artifact: e016a97cfc user: doug9forester | |
21:54 | • Reply: strftime and utc artifact: 6faa605d8b user: younique | |
15:20 | • Reply: Unexpected Result by Complicated JOINING Again artifact: 10e4fe4eb4 user: jicman | |
14:37 | • Reply: Unexpected Result by Complicated JOINING Again artifact: 96bc4ccc66 user: doug9forester | |
12:54 | • Post: SQLite synthesizes IN construct for virtual table queries. artifact: 607c65b149 user: vman59 | |
12:43 | • Reply: Unexpected Result by Complicated JOINING Again artifact: 7ae5eaab1c user: drh | |
12:09 | • Reply: Unexpected Result by Complicated JOINING Again artifact: 765d4e7318 user: drh | |
11:29 | • Reply: Possible bug: Unable to find an entry point artifact: 0393a4cb74 user: anonymous | |
09:03 | • Reply: SQLite warnings in system journal artifact: 063115f826 user: cmgain | |
08:47 | • Reply: getting "no suck table" error artifact: 41eab65913 user: dkfellows | |
08:38 | • Reply: Emulating MATCH in a join artifact: cee87707e4 user: dkfellows | |
07:35 | • Post: Unexpected Result by Complicated JOINING Again artifact: b40696f501 user: bajinsheng | |
4 Years Ago (more context)
2021-06-13
| ||
18:49 | • Reply: Extract files from sqlar with a directory prepended artifact: 6dae5413c4 user: anonymous | |
17:50 | • Reply: Feature request: Stored Procedures artifact: dfbb2e2b57 user: RoboManni | |
16:01 | • Reply: Extract files from sqlar with a directory prepended artifact: 93cb0840b7 user: 6kEs4Majrd | |
15:42 | • Reply: INSERT with RETURNING causes duplicate rows artifact: 78c4bc6148 user: lexfiend | |
15:01 | • Reply: INSERT with RETURNING causes duplicate rows artifact: bc52d77584 user: achernow | |
14:57 | • Reply: INSERT with RETURNING causes duplicate rows artifact: ac840b5e94 user: achernow | |
14:52 | • Reply: INSERT with RETURNING causes duplicate rows artifact: 2e89679c98 user: antlor | |
14:49 | • Reply: Extract files from sqlar with a directory prepended artifact: d034f7b1f3 user: lexfiend | |
14:26 | • Reply: INSERT with RETURNING causes duplicate rows artifact: a617d14e34 user: larrybr | |
13:11 | • Post: INSERT with RETURNING causes duplicate rows artifact: aa88afd5c8 user: achernow | |
13:01 | • Reply: Extract files from sqlar with a directory prepended artifact: 7be4875762 user: 6kEs4Majrd | |
10:58 | • Reply: Bug: ALTER TABLE RENAME COLUM TO vs CTE VIEWs artifact: 2fe926277c user: drh | |
09:20 | • Reply: Bug: Incorrect archive support URL in help text artifact: b9dfad91f7 user: larrybr | |
07:39 | • Post: Bug: Incorrect archive support URL in help text artifact: 58cc3a68f6 user: lexfiend | |
07:37 | • Reply: Extract files from sqlar with a directory prepended artifact: e929b88721 user: anonymous | |
07:35 | • Reply: Extract files from sqlar with a directory prepended artifact: ad0f5049b9 user: lexfiend | |
5 Years Ago (more context)
2020-06-13
| ||
22:31 | • Reply: How db access is handled by sqlite3? artifact: 1ceccc687b user: drh | |
22:23 | • Edit reply: How db access is handled by sqlite3? artifact: bfef1d44ee user: kmedcalf | |
22:18 | • Reply: How db access is handled by sqlite3? artifact: b1f3dd0fa9 user: kmedcalf | |
21:48 | • Post: How db access is handled by sqlite3? artifact: a93fe6b498 user: 6kEs4Majrd | |
21:35 | • Edit reply: current_date, etc are functions? artifact: 1328ae35b1 user: kmedcalf | |
21:34 | • Reply: current_date, etc are functions? artifact: a5e8d469fd user: kmedcalf | |
18:44 | • Reply: Possible vulnerabilities from December 2019 artifact: 8beceed68e user: drh | |
18:16 | • Edit reply: csv import without header row artifact: 1899051f39 user: LarryBrasfield | |
17:59 | • Reply: csv import without header row artifact: d58317317e user: LarryBrasfield | |
17:37 | • Post: Possible vulnerabilities from December 2019 artifact: 10759e27d2 user: slavin | |
17:22 | • Post: Typo on https://sqlite.org/prosupport.html artifact: 20b31d9700 user: ndbroadbent | |
16:45 | • Reply: current_date, etc are functions? artifact: 1bb7b37479 user: tb13 | |
16:39 | • Reply: closure table, prevent identical childrens names per parent artifact: 268d21b808 user: cuz | |
16:19 | • Reply: DROP VIEW IF EXISTS failure artifact: 5c345deff2 user: stephan | |
14:58 | • Reply: csv import without header row artifact: 1b265d6d0f user: wyoung | |
14:17 | • Reply: ALTER TABLE ADD COLUMN problem artifact: 2338858af2 user: kmedcalf | |
14:09 | • Reply: csv import without header row artifact: 9366feb243 user: lcarlp | |
13:38 | • Reply: ALTER TABLE ADD COLUMN problem artifact: 24aa9be23b user: Clothears | |
13:31 | • Reply: current_date, etc are functions? artifact: 45d9b988a9 user: knu | |
13:23 | • Reply: ALTER TABLE ADD COLUMN problem artifact: 948baa805f user: kmedcalf | |
12:41 | • Reply: closure table, prevent identical childrens names per parent artifact: a9e08510e8 user: slavin | |
12:30 | • Edit reply: DROP VIEW IF EXISTS failure artifact: 4ffb450f5e user: slavin | |
12:28 | • Reply: DROP VIEW IF EXISTS failure artifact: b61f113f44 user: slavin | |
11:41 | • Reply: unable to open a database file in a btrfs readonly snapshot filesystem artifact: 9fc9d29f73 user: wmertens | |
11:24 | • Reply: ALTER TABLE ADD COLUMN problem artifact: 3fda139170 user: Clothears | |
10:59 | • Reply: ALTER TABLE ADD COLUMN problem artifact: ad8e6564bd user: stephan | |
10:55 | • Reply: ALTER TABLE ADD COLUMN problem artifact: a273841952 user: Clothears | |
10:44 | • Reply: ALTER TABLE ADD COLUMN problem artifact: cb541fb3dd user: stephan | |
10:36 | • Post: ALTER TABLE ADD COLUMN problem artifact: 373b88c9fe user: Clothears | |
08:12 | • Reply: DROP VIEW IF EXISTS failure artifact: 0bea6c4920 user: younique | |
06:46 | • Reply: Password-protected databases no longer work with 1.113, no rollback possible artifact: ef82267c3a user: tagelus | |
06:39 | • Reply: closure table, prevent identical childrens names per parent artifact: 647bba3156 user: anonymous | |
04:12 | • Reply: unable to open a database file in a btrfs readonly snapshot filesystem artifact: adb6213308 user: sprhawk | |
02:30 | • Reply: current_date, etc are functions? artifact: e06993a8d8 user: stephan | |
02:16 | • Reply: current_date, etc are functions? artifact: c7d2b22267 user: LarryBrasfield | |
00:45 | • Reply: current_date, etc are functions? artifact: af3e865e61 user: tb13 | |
00:26 | • Reply: DROP VIEW IF EXISTS failure artifact: 4151a5618a user: LarryBrasfield | |