SQLite User Forum

Today In History
Login

This Day In History For 2025-10-16

1 Year Ago (more context)

2024-10-16
22:55 Edit [8f701a2946b3034a|8f701a2946]: Add propagating "closed". artifact: 69c77fbd06 user: stephan
17:55 Reply: The name of the new utility program: "sqlite3-rsync" artifact: f965ac987b user: spindrift
16:52 Reply: Is `pragma mmap_size` still considered dangerous on macOS? artifact: 81458ae1ef user: drh
16:37 Reply: Is `pragma mmap_size` still considered dangerous on macOS? artifact: bda51e22c9 user: snej
14:15 Reply: List Columns that are INTEGER type artifact: 099bc07fe5 user: jameshoty
14:07 Reply: List Columns that are INTEGER type artifact: 4b78be44fb user: jameshoty
13:35 Reply: The name of the new utility program: "sqlite3-rsync" artifact: ee1f8e2510 user: jicman
13:18 Reply: List Columns that are INTEGER type artifact: db7ebd5888 user: jameshoty
13:05 Reply: The name of the new utility program: "sqlite3-rsync" artifact: 208a121f45 user: knu
13:04 Reply: The name of the new utility program: "sqlite3-rsync" artifact: b7c03ba99f user: holgerj
12:46 Reply: List Columns that are INTEGER type artifact: bd727870e8 user: punkish
12:28 Post: List Columns that are INTEGER type artifact: 120408f0fe user: jameshoty
12:02 Edit reply: pragma functions for a specific schema artifact: f127cab38d user: curmudgeon
11:54 Reply: The name of the new utility program: "sqlite3-rsync" artifact: 1620d00329 user: lexfiend
11:52 Reply: pragma functions for a specific schema artifact: b0393ec315 user: curmudgeon
11:16 Reply: Is SQLite safe as a transferable document format? artifact: 0b5b39ed94 user: anonymous
10:58 Reply: Is `pragma mmap_size` still considered dangerous on macOS? artifact: 3ce1ee7624 user: drh
10:51 Reply: pragma functions for a specific schema artifact: 1a6d5d8554 user: drh
10:26 Reply: pragma functions for a specific schema artifact: ef00e13b27 user: curmudgeon
10:25 Reply: The sqlite3 CLI under Windows artifact: 95bf6c35e2 user: AAsk1902
10:15 Reply: pragma functions for a specific schema artifact: b2231189d5 user: curmudgeon
10:15 Reply: Is SQLite safe as a transferable document format? artifact: 3b2a8e100d user: drh
09:57 Edit reply: pragma functions for a specific schema artifact: ec0a3a7eb4 user: ddevienne
09:56 Reply: pragma functions for a specific schema artifact: 043627fb52 user: ddevienne
09:52 Reply: pragma functions for a specific schema artifact: e90cb23979 user: ddevienne
09:46 Reply: pragma functions for a specific schema artifact: e782551fe7 user: curmudgeon
09:44 Reply: vtab offset to sub selection combine by union has bug artifact: d72885c7f0 user: drh
09:41 Reply: vtab offset to sub selection combine by union has bug artifact: d4bfefe627 user: ddevienne
09:33 Reply: pragma functions for a specific schema artifact: 9aba9dfd3c user: ddevienne
09:22 Reply: vtab offset to sub selection combine by union has bug artifact: b6a6276e0d user: superzmy
08:51 Reply: pragma functions for a specific schema artifact: 6d19fea04a user: curmudgeon
08:35 Reply: pragma functions for a specific schema artifact: 11294044db user: curmudgeon
08:34 Reply: The name of the new utility program: "sqlite3-rsync" artifact: b581f6c839 user: anonymous
08:24 Reply: The name of the new utility program: "sqlite3-rsync" artifact: c4dd46da1f user: hanche
04:07 Reply: The name of the new utility program: "sqlite3-rsync" artifact: 926ca1554d user: wisej12
00:25 Reply: The name of the new utility program: "sqlite3-rsync" artifact: b85728001e user: weirdo12

2 Years Ago (more context)

2023-10-16
22:54 Reply: sqlite3_deserialize returning 'unable to open database file' artifact: aee949bb7e user: fmzakari
22:49 Reply: SQLite and SQL Guru Keith artifact: 145915adf4 user: anonymous
21:58 Post: sqlite3_deserialize returning 'unable to open database file' artifact: a7e272cee9 user: fmzakari
15:06 Reply: Strange behavour Window functions artifact: dc38179d53 user: sjoerd_at_westland
14:57 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: b1d6469b03 user: curmudgeon
14:35 Reply: Strange behavour Window functions artifact: e430ddfc14 user: drh
14:32 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 9a68878148 user: Clothears
14:30 Reply: Strange behavour Window functions artifact: 6cb7431076 user: sjoerd_at_westland
14:13 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 11c7780f32 user: gunter_hick
14:06 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 2beb1ec122 user: gunter_hick
14:01 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: c4cd434738 user: dkfellows
13:54 Reply: Strange behavour Window functions artifact: 3e79ed10d0 user: sjoerd_at_westland
13:52 Reply: Crazy Idea: SQLite-based HTTP Application Server That Make SQL Injection Impossible artifact: 6a0f2cd759 user: wyoung
13:51 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: f80f261a47 user: Clothears
13:47 Reply: Crazy Idea: SQLite-based HTTP Application Server That Make SQL Injection Impossible artifact: 1441851c0f user: dkfellows
13:38 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: a4facc070f user: larrybr
13:20 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 6af9b3cf6a user: anonymous
13:14 Edit: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 668405ab84 user: stephan
13:06 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 2d29a28444 user: dvdraymond
13:00 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: c975e6d5eb user: larrybr
12:55 Post: Crazy Idea: SQLite-based HTTP Application Server That Make SQL Injection Impossible artifact: 4c9622c3c3 user: drh
12:14 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 3abbbe194a user: slavin
12:12 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: b56ed93140 user: slavin
11:40 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 17af9851db user: Clothears
11:12 Reply: Sporadic crash while preparing statements artifact: b789a6464f user: anonymous
10:50 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 33528efe7a user: curmudgeon
10:42 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 2cfa74b1b6 user: curmudgeon
09:26 Reply: Sporadic crash while preparing statements artifact: fdc171bcbf user: stephan
08:14 Reply: Sporadic crash while preparing statements artifact: 934040b494 user: anonymous
07:58 Reply: Sporadic crash while preparing statements artifact: 368c0a84c2 user: stephan
07:35 Post: Sporadic crash while preparing statements artifact: 9dbde28fb8 user: anonymous
06:05 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 882def2da8 user: stephan
04:38 Post: Feature request: Support "CREATE OR REPLACE TABLE" syntax artifact: 59c86294a2 user: alexgarciaxyz
03:54 Reply: Storage of internal B-tree artifact: 50e70e1c51 user: larrybr
02:39 Reply: Storage of internal B-tree artifact: 4a3dd8164d user: anonymous
01:50 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: c43d7cdcc5 user: anonymous
00:29 Reply: Storage of internal B-tree artifact: 35cc8e7792 user: larrybr
00:16 Reply: Storage of internal B-tree artifact: d70d0cfe60 user: stephan
00:06 Post: Storage of internal B-tree artifact: 013d57bbe5 user: anonymous

3 Years Ago (more context)

2022-10-16
21:19 Reply: Some peeks in execution time artifact: 32161e1449 user: anonymous
20:21 Reply: Some peeks in execution time artifact: 60c7d75f3c user: chrisjlocke1
18:47 Reply: Build for Apple Silicon artifact: 1035861c47 user: anonymous
18:06 Post: "UNIQUE constraint failed" error with UPSERT and UPDATE trigger that does INSERT OR REPLACE artifact: 8c8de6ff91 user: rouault
17:44 Post: Some peeks in execution time artifact: d0c11e7804 user: Maryam
17:14 Reply: Split db into smaller dbs artifact: bb70a0f297 user: anonymous
17:13 Reply: Identify a transaction in a trigger artifact: 6038814d0f user: UserMBL
14:46 Edit: Identify a transaction in a trigger artifact: ed225c5175 user: berzerker
14:45 Reply: Identify a transaction in a trigger artifact: 898609439d user: berzerker
14:43 Reply: Identify a transaction in a trigger artifact: 33eaf3c73b user: berzerker
12:52 Reply: SQLite DB Not working ("No database file opened") artifact: eefe6e7d8c user: chrisjlocke1
12:52 Edit reply: SQLite DB Not working ("No database file opened") artifact: bf22a1c5cd user: chrisjlocke1
11:02 Reply: SQLite DB Not working ("No database file opened") artifact: d60237e244 user: slavin
10:59 Reply: Identify a transaction in a trigger artifact: 06220c6a43 user: slavin
09:43 Reply: Identify a transaction in a trigger artifact: a4a08570e5 user: UserMBL
08:51 Reply: SQLite DB Not working ("No database file opened") artifact: eeb6b115d2 user: AAsk1902
08:36 Reply: SQLite DB Not working ("No database file opened") artifact: a5d1de92cb user: chrisjlocke1
03:40 Post: Identify a transaction in a trigger artifact: 3ecc2766df user: berzerker
03:32 Reply: Split db into smaller dbs artifact: af269c0a8b user: adrian
03:31 Reply: Split db into smaller dbs artifact: cdace41095 user: adrian
03:21 Edit: Split db into smaller dbs artifact: 0af12cae82 user: adrian
03:18 Reply: Generate SHA for a table artifact: d0bdb9e8df user: adrian
02:24 Reply: Generate SHA for a table artifact: 3396cf5cc6 user: anonymous
01:47 Edit reply: Generate SHA for a table artifact: f87ea4089a user: adrian
01:45 Reply: Generate SHA for a table artifact: e8cf35da4a user: adrian

4 Years Ago (more context)

2021-10-16
14:47 Reply: Compiling sqlite3 with readline support artifact: c4b3ae5154 user: anonymous
09:10 Reply: Temp database artifact: 74f3e90063 user: kmedcalf
07:50 Reply: Temp database artifact: d871cfd0d9 user: anonymous
07:30 Reply: binary .dump format artifact: dd8ff6dfae user: anonymous
03:16 Reply: Temp database artifact: 9cdef47899 user: kmedcalf
03:04 Reply: Temp database artifact: dd390b9eb7 user: kmedcalf
02:41 Reply: Temp database artifact: dcdb9d6a21 user: kmedcalf

5 Years Ago (more context)

2020-10-16
20:44 Reply: Bug Report: SQLite tools .import command does not strip spaces from input .csv header column names artifact: 408a136142 user: rgward611
20:16 Reply: Bug Report: SQLite tools .import command does not strip spaces from input .csv header column names artifact: 51e8ca0432 user: drh
20:03 Edit reply: Storing invalid JSON (integer-based keys)? artifact: 100e4ca5b5 user: kmedcalf
19:59 Post: Bug Report: SQLite tools .import command does not strip spaces from input .csv header column names artifact: 415555afed user: rgward611
18:43 Reply: Storing invalid JSON (integer-based keys)? artifact: 127fb37c05 user: HashRocketSyntax
18:41 Edit reply: Storing invalid JSON (integer-based keys)? artifact: d5dab2b210 user: kmedcalf
18:39 Reply: Storing invalid JSON (integer-based keys)? artifact: e029622eba user: kmedcalf
18:26 Edit: Storing invalid JSON (integer-based keys)? artifact: dbc3e68aed user: HashRocketSyntax
17:56 Post: Storing invalid JSON (integer-based keys)? artifact: 28863dcedf user: HashRocketSyntax
03:37 Reply: WHERE a IN (SELECT non-existing column ) artifact: 06ef52aaa9 user: moskvich412