SQLite User Forum

Today In History
Login

This Day In History For 2025-06-03

1 Year Ago (more context)

2024-06-03
19:51 Reply: How to Append Database that Already Exists? artifact: 049960f55a user: martin2020
18:55 Reply: DROP COLUMN artifact: 5cad1d09d4 user: chrisjlocke1
18:11 Reply: DROP COLUMN artifact: dbdfb86bc0 user: larrybr
16:32 Reply: CAST AS NUMERIC returns REAL for a float apparently convertible o an integer artifact: 4f946fb680 user: lexfiend
16:20 Post: artificial intelligence as indexing artifact: 95d6c9b775 user: moskvich412
16:20 Edit reply: Inconsistent docs for the ->> operator artifact: 8e0417f020 user: lexfiend
16:18 Edit reply: Inconsistent docs for the ->> operator artifact: d1546517c7 user: lexfiend
16:14 Edit reply: Inconsistent docs for the ->> operator artifact: f75670b5fd user: lexfiend
16:12 Reply: Inconsistent docs for the ->> operator artifact: 90ef861679 user: lexfiend
14:54 Reply: Handling of empty, zero-length files artifact: 713bc3e1ba user: slavin
13:34 Reply: Fairness in SQLite3 Transactions artifact: a753916e61 user: jicman
08:45 Reply: Can we use SQLite wasm directly from c-interface instead of javascript files artifact: 961cd68325 user: stephan
08:24 Edit reply: Fairness in SQLite3 Transactions artifact: 638fdaec26 user: abharora
08:14 Reply: Fairness in SQLite3 Transactions artifact: 1d90f4397c user: abharora
08:12 Reply: Fairness in SQLite3 Transactions artifact: acab236918 user: abharora
07:14 Reply: Access to sqlite3_sql / sqlite3_normalized_sql APIs from an authorization callback artifact: 5ec625d782 user: gunter_hick
05:35 Post: Access to sqlite3_sql / sqlite3_normalized_sql APIs from an authorization callback artifact: c05ab77d6a user: PChemGuy
04:08 Post: DROP COLUMN artifact: a9afd95fd8 user: anonymous

2 Years Ago (more context)

2023-06-03
22:35 Reply: Suggestion: JSON support artifact: c856536758 user: jckodel
13:57 Reply: Report bugs against SQLite. artifact: 19f55ef73b user: 740931
12:39 Reply: Reverse function seems to work, missing in documentation? artifact: adbc2e6ca5 user: mccon01

3 Years Ago (more context)

2022-06-03
23:22 Reply: Experience with SQLite as a store of Files and Images artifact: ac34037604 user: drh
22:41 Reply: Experience with SQLite as a store of Files and Images artifact: 3b146fb265 user: stephan
21:14 Reply: no such function: UNIXEPOCH artifact: 1cc64a9fe0 user: PeterV
21:14 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: fe8ae5eccf user: dan
20:56 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: 9adbb8e848 user: RandomCoder
20:54 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: cb2ba2e61c user: dan
19:38 Post: Experience with SQLite as a store of Files and Images artifact: e18c43fc79 user: oezmaster
19:30 Edit: Anybody got Sqlite3 running on Microcontroller? (RPI-2040) artifact: 88537f4c5f user: midijohnny
19:30 Post: Anybody got Sqlite3 running on Microcontroller? (RPI-2040) artifact: 9cf99400cd user: midijohnny
17:48 Reply: Considering using SQLite, question about support artifact: 71d16ed88b user: anonymous
17:45 Reply: Considering using SQLite, question about support artifact: 600f3857a2 user: drh
17:32 Post: Considering using SQLite, question about support artifact: 7cb4ec23bf user: FBumpus
15:54 Reply: Operator precedence bug artifact: ff4cb82835 user: larrybr
15:45 Reply: Question about sqlite thread safe mode? artifact: a71e5be930 user: drh
15:26 Reply: Question about sqlite thread safe mode? artifact: f28c0b11c0 user: anonymous
13:38 Edit: Database is locking under Lazarus artifact: a387615efe user: stephan
13:35 Reply: Database is locking under Lazarus artifact: 8849724a27 user: olivluca
12:10 Reply: Database is locking under Lazarus artifact: bf04f74d59 user: cuz
12:00 Reply: Question about sqlite thread safe mode? artifact: 2ca2c85d44 user: dkfellows
11:10 Post: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: f47bd22541 user: vinser
09:10 Reply: Unexpected Result by WHERE Again artifact: f2c84d75d7 user: bajinsheng
05:57 Post: Database is locking under Lazarus artifact: ebc9972140 user: Graham77
04:30 Reply: Question about sqlite thread safe mode? artifact: ab1501a543 user: anonymous
04:22 Reply: Question about sqlite thread safe mode? artifact: 16aeedc5d4 user: anonymous

4 Years Ago (more context)

2021-06-03
22:46 Post: Anton Dyachenko artifact: 6989cefa6e user: anonymous
22:41 Post: Typo on the draft release notes? artifact: 07d3668d82 user: jicman
19:31 Reply: pragma_.. fails artifact: 980c4693d6 user: acromarco
19:20 Reply: pragma_.. fails artifact: f8da633d39 user: acromarco
18:53 Reply: Delete all rows from a "without rowid" table will get a wrong number of changed rows artifact: c6762f736c user: drh
17:52 Reply: Delete all rows from a "without rowid" table will get a wrong number of changed rows artifact: 290d17d72d user: anonymous
16:06 Reply: SQLite DB corrupt while inserting the data in iOS application. artifact: b5062871db user: slavin
15:31 Reply: SQLite DB corrupt while inserting the data in iOS application. artifact: f6e1f45385 user: knu
13:58 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: e75c22b979 user: drh
12:52 Reply: pragma_.. fails artifact: 69a92fb06f user: drh
12:49 Reply: pragma_.. fails artifact: b9483d3dae user: anonymous
12:37 Post: SQLite DB corrupt while inserting the data in iOS application. artifact: 5a46109077 user: Ritesh
12:33 Post: pragma_.. fails artifact: 76f2816656 user: acromarco
12:16 Edit: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 3511f8364f user: andse-t610
12:15 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: d58f873133 user: andse-t610
10:51 Post: Delete all rows from a "without rowid" table will get a wrong number of changed rows artifact: 07dedbf9a1 user: anonymous
10:27 Edit: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 983b43ef8e user: andse-t610
00:35 Reply: DBSTAT docs example potentially misleading artifact: 52f0639686 user: dnamlin

5 Years Ago (more context)

2020-06-03
23:37 Reply: Is there a way to wait until the database is available? artifact: 2180c2edb7 user: stephan
23:33 Reply: Is there a way to wait until the database is available? artifact: b557e6542e user: 6kEs4Majrd
23:31 Reply: Is there a way to wait until the database is available? artifact: a1fd2899d8 user: 6kEs4Majrd
22:17 Delete reply: Is there a way to wait until the database is available? artifact: 718627a0fa user: stephan
22:17 Reply: Is there a way to wait until the database is available? artifact: 8a87426788 user: stephan
22:15 Reply: Is there a way to wait until the database is available? artifact: fb6f21788e user: drh
22:12 Edit: Problem with select from Sqlite Expo. I can't save the array returned by the query through the hook function artifact: 672844a007 user: drh
22:09 Post: Is there a way to wait until the database is available? artifact: 6e6acaef86 user: 6kEs4Majrd
21:25 Reply: Expo Problem with Select * in ReactNative. I can’t save the returned query value artifact: 2524fd8121 user: stephan
21:16 Post: Problem with select from Sqlite Expo. I can't save the array returned by the query through the hook function artifact: 0da4384a4c user: 001533
21:08 Post: Expo Problem with Select * in ReactNative. I can’t save the returned query value artifact: 45b44a46c5 user: 001533
20:58 Reply: Unexepected commit result with two threads application artifact: cfbd2df7e3 user: Maxulite
19:33 Reply: Unexepected commit result with two threads application artifact: c3b6c8c615 user: drh
19:28 Reply: Unexepected commit result with two threads application artifact: e071a20218 user: Maxulite
18:49 Edit reply: Unexepected commit result with two threads application artifact: 3dab82a775 user: drh
18:49 Edit reply: Unexepected commit result with two threads application artifact: 4e82d11c2d user: drh
17:57 Reply: Unexepected commit result with two threads application artifact: 39abc7cc0f user: drh
17:16 Reply: SQLite turns 20 artifact: 3ebe6b187f user: jicman
17:12 Reply: SQLite turns 20 artifact: c3d6195f5b user: jicman
17:10 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 866e87dffc user: anonymous
15:44 Reply: Version 3.32.1 Compilation Failures artifact: afa003d4fe user: ddevienne
15:33 Reply: Version 3.32.1 Compilation Failures artifact: 750b4407f0 user: protter
15:05 Reply: Unexepected commit result with two threads application artifact: 160fa3b474 user: Maxulite
14:55 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: b6f6e76fac user: cuz
14:48 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 5b0691f8eb user: cuz
14:46 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: ed110dc70e user: cuz
14:19 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 7e09d2a045 user: rhb327
14:06 Reply: Version 3.32.1 Compilation Failures artifact: 0ba6a7dda8 user: protter
13:56 Reply: Version 3.32.1 Compilation Failures artifact: 70c157fb81 user: stephan
13:48 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 4aded6f899 user: vman59
13:41 Reply: Version 3.32.1 Compilation Failures artifact: 41bccfd653 user: protter
13:34 Reply: Version 3.32.1 Compilation Failures artifact: 6789bee126 user: ddevienne
13:26 Reply: Version 3.32.1 Compilation Failures artifact: 5e0e849ef4 user: stephan
13:21 Post: Version 3.32.1 Compilation Failures artifact: edc01d0ea1 user: protter
12:51 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 22c06f45ce user: cladisch
11:49 Edit reply: Unexepected commit result with two threads application artifact: be57c0169a user: wyoung
11:48 Reply: Unexepected commit result with two threads application artifact: 05a9fb2d2b user: wyoung
09:05 Reply: Opening Huaiwei android notes artifact: 46e704ea23 user: anonymous
08:36 Post: Need Help Conpiling Sqlite.Interop artifact: 22bdf4f9bb user: Ynsano
08:14 Reply: Unexepected commit result with two threads application artifact: c4ebc044b0 user: anonymous
08:13 Reply: Unexepected commit result with two threads application artifact: 30571e714a user: anonymous
03:37 Reply: json_append array with multiple values artifact: c0f2429efb user: jake
00:43 Reply: Why is this query giving results below 100 artifact: 9eab247b68 user: slavin
00:40 Reply: Feature Request: pragma to curb bad column expectations artifact: 8426eb2b20 user: slavin
00:19 Reply: json_append array with multiple values artifact: 69a63e854b user: drh
00:07 Post: json_append array with multiple values artifact: 794cbe5eef user: anonymous