SQLite User Forum

Today In History
Login

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