SQLite User Forum

Today In History
Login

This Day In History For 2024-04-05

1 Year Ago (more context)

2023-04-05
23:54 Edit: Segmentation fault in sqlite3_db_config function artifact: 1cde90ec5b user: songliu
23:06 Edit: Heap buffer overflow in zipfileColumn function artifact: b15f5e3ad8 user: songliu
23:02 Post: Heap buffer overflow in zipfileColumn function artifact: d6f3070dd3 user: songliu
23:01 Edit: Heap buffer overflow in shell_error_context function artifact: ab93a23ba1 user: songliu
22:44 Reply: research part 2 artifact: b25392210c user: spindrift
22:41 Post: Heap buffer overflow in shell_error_context function artifact: cbbdd5ca3c user: songliu
22:22 Post: Segmentation fault in sqlite3_db_config function artifact: 6e26dcf544 user: songliu
21:17 Reply: research part 2 artifact: f15119fcbf user: slavin
21:14 Reply: Selecting different columns and different rows from subquery artifact: 2e61143783 user: anonymous
21:01 Post: research part 2 artifact: b1d74d2b1e user: sgarcia
20:45 Post: Assertion failure due to invalid Btree Cursor artifact: cae4367d9b user: songliu
17:23 Reply: Distinguishing page limit from disk full artifact: fa25fcbf10 user: richardwhitehead
17:21 Reply: Selecting different columns and different rows from subquery artifact: c64284db35 user: kmedcalf
17:20 Reply: Distinguishing page limit from disk full artifact: b900c871c8 user: richardwhitehead
17:18 Reply: Distinguishing page limit from disk full artifact: 9380f9583e user: richardwhitehead
17:15 Reply: Selecting different columns and different rows from subquery artifact: 6115fcdb3e user: bjoern
17:12 Reply: Distinguishing page limit from disk full artifact: 2608e544dd user: richardwhitehead
17:10 Reply: Distinguishing page limit from disk full artifact: 608c192a4a user: richardwhitehead
16:05 Reply: sqlite on SLES15 SP4 artifact: b9271de8c4 user: bstarynk
15:46 Reply: sqlite on SLES15 SP4 artifact: 7dbdc6a2e7 user: madhug
14:56 Post: Selecting different columns and different rows from subquery artifact: 3725a84ac5 user: anonymous
14:43 Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: 252ac3a2e2 user: kmedcalf
14:35 Reply: sqlite on SLES15 SP4 artifact: 480d9defab user: wyoung
14:27 Post: ANN SQLite News artifact: 8071a3a322 user: marcobambini
14:13 Reply: sqlite on SLES15 SP4 artifact: e827635d92 user: madhug
14:11 Edit reply: How to secure and change location of the SQLite database in react native for windows platform artifact: 39909c93be user: AAsk1902
14:05 Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: c356111beb user: AAsk1902
13:48 Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: 54fc05953d user: stephan
13:48 Reply: Distinguishing page limit from disk full artifact: 92a2481bed user: dkfellows
13:34 Reply: Are the lemon lalr In public domain? artifact: 52cb0a5ae0 user: dkfellows
13:15 Reply: sqlite on SLES15 SP4 artifact: 3ef84bfce7 user: brickviking
12:15 Reply: A question about CAST artifact: 6bb41eaf50 user: drh
12:09 Edit reply: sqlite on SLES15 SP4 artifact: cc05130d51 user: wyoung
12:08 Reply: sqlite on SLES15 SP4 artifact: 6ea5577d48 user: wyoung
11:32 Post: How to secure and change location of the SQLite database in react native for windows platform artifact: 3b4f5f891e user: ksnmurthy
11:30 Reply: sqlite on SLES15 SP4 artifact: 54eee79848 user: madhug
10:20 Reply: sqlite on SLES15 SP4 artifact: 7b371b9c8b user: brickviking
09:50 Reply: Are the lemon lalr In public domain? artifact: 7a5fd78a1b user: brickviking
09:41 Post: sqlite on SLES15 SP4 artifact: a0a03df941 user: madhug
09:39 Reply: Are the lemon lalr In public domain? artifact: d5babf0110 user: bstarynk
08:56 Reply: Tcl Interface: allow a function to return NULL? artifact: c615108676 user: chwchw
08:45 Post: Are the lemon lalr In public domain? artifact: 6e89e4be94 user: anonymous
08:43 Reply: Support Binary representation like 0b01 artifact: 047ed03262 user: dkfellows
08:32 Reply: Tcl Interface: allow a function to return NULL? artifact: 0b07c3f309 user: dkfellows
06:23 Delete reply: Tcl Interface: allow a function to return NULL? artifact: 072b1b27a9 user: wyoung
05:31 Reply: Tcl Interface: allow a function to return NULL? artifact: 5e72fa95f9 user: wyoung
05:26 Edit: Tcl Interface: allow a function to return NULL? artifact: 585ebac2c4 user: chwchw
04:50 Edit: Tcl Interface: allow a function to return NULL? artifact: eb4f76ef4f user: chwchw
04:39 Post: Tcl Interface: allow a function to return NULL? artifact: 7102acba08 user: chwchw
04:11 Post: A question about CAST artifact: d1113ada1f user: ChiZhang
01:37 Post: Assertion failure in sqlite3ExprCollSeq function artifact: 0713a16a44 user: songliu
00:01 Reply: Distinguishing page limit from disk full artifact: 6ec99508e0 user: slavin

2 Years Ago (more context)

2022-04-05
23:56 Post: Build for iOS? artifact: 8266806385 user: wiverson
16:33 Reply: Many-To-Many problem artifact: 1e6168ac0b user: cuz
16:15 Reply: json_extract zero-length key string artifact: 4778faac10 user: larrybr
16:12 Reply: Many-To-Many problem artifact: aa5f620e7e user: larrybr
15:59 Reply: Many-To-Many problem artifact: 2886cf3c05 user: BertilE
15:14 Reply: Many-To-Many problem artifact: 5018ddab1a user: dvdraymond
14:31 Post: Many-To-Many problem artifact: 7d5d9b7e35 user: BertilE
14:19 Reply: Awkward data for your toy music database artifact: 131fd5b19c user: SeverKetor
13:21 Post: Awkward data for your toy music database artifact: 63365a7307 user: slavin
12:41 Edit reply: howto combine rows with recursive query artifact: f59ebc0ad7 user: midijohnny
12:26 Reply: Repeated rows in select loop artifact: 6bd1a51737 user: midijohnny
12:24 Reply: howto combine rows with recursive query artifact: 1009b86746 user: MaikScholz
12:06 Reply: Repeated rows in select loop artifact: 5aa6ee9ced user: drh
11:59 Reply: Repeated rows in select loop artifact: 7ef7f97dd4 user: drh
11:54 Reply: Repeated rows in select loop artifact: c7a146811a user: ddevienne
11:47 Reply: Repeated rows in select loop artifact: 5cc7fb2334 user: drh
11:10 Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: d6d20966fb user: gunter_hick
09:47 Reply: howto combine rows with recursive query artifact: 19322d8da8 user: midijohnny
09:10 Reply: MSVC 2022 v17.0.6 warnings on amalgamated v3.37.2 in release artifact: e463e018ae user: anonymous
09:03 Post: sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value artifact: fa35fca3d9 user: anonymous
08:00 Reply: Disk i/o metrics? artifact: 8d4c7ed53d user: bucweat
07:50 Post: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 1ad0d6abb4 user: riyaz-ali
06:38 Reply: json_extract zero-length key string artifact: 306a6c6ca1 user: anonymous
06:30 Reply: json_extract zero-length key string artifact: dc287fe861 user: ddevienne
06:27 Reply: Repeated rows in select loop artifact: bb5eda7203 user: gunter_hick
06:03 Reply: howto combine rows with recursive query artifact: 5ee6bef5da user: MaikScholz
05:53 Delete reply: Return auto-generated value for columns after inserting into virtual table artifact: 3a22e8bdcd user: gunter_hick
05:52 Reply: Return auto-generated value for columns after inserting into virtual table artifact: 85ee733292 user: gunter_hick
05:52 Reply: Return auto-generated value for columns after inserting into virtual table artifact: 52cd84c024 user: gunter_hick
05:40 Reply: json_extract zero-length key string artifact: cbb7d2c65c user: larrybr
05:07 Reply: json_extract zero-length key string artifact: ab5dbedd66 user: anonymous
04:04 Post: Return auto-generated value for columns after inserting into virtual table artifact: e1bb866b90 user: riyaz-ali
02:44 Reply: Creating an empty table with no columns artifact: bfea485472 user: jkreibich
01:45 Reply: Creating an empty table with no columns artifact: 1bab448a2b user: RichardDamon
00:39 Edit reply: Repeated rows in select loop artifact: 0a3f7e5c6d user: kmedcalf
00:13 Edit reply: Repeated rows in select loop artifact: b4aa1902b7 user: kmedcalf
00:08 Reply: Repeated rows in select loop artifact: a034d368cf user: kmedcalf

3 Years Ago (more context)

2021-04-05
22:38 Reply: open db in read only; explicitly store diff as WAL ? artifact: 9a1fefe424 user: kmedcalf
21:58 Reply: Lemon - Unexpected frees artifact: 5cb6c462f7 user: SirHumphreyAppleby
20:21 Reply: Compiling sqlite3 with readline support artifact: 9048715201 user: hanche
20:21 Reply: .import csv and NULL values artifact: cf99368fe4 user: w.oertl
19:46 Reply: issue with fossil in source code README.md artifact: 19d7caef11 user: pmacdona
19:24 Reply: issue with fossil in source code README.md artifact: 3e886eac4f user: drh
19:09 Post: books / papers on "one sqlite per user" design ? artifact: 7567899112 user: anonymous
19:03 Reply: open db in read only; explicitly store diff as WAL ? artifact: cee3de06cb user: anonymous
18:53 Reply: open db in read only; explicitly store diff as WAL ? artifact: bcae9373b0 user: larrybr
18:51 Post: issue with fossil in source code README.md artifact: 51f28bb701 user: pmacdona
18:45 Post: open db in read only; explicitly store diff as WAL ? artifact: e5aae48802 user: anonymous
18:22 Reply: SQLite3 command using select to CSV or terminal does not return all rows artifact: cf530c7880 user: kmedcalf
18:18 Reply: What indexes help Window Functions artifact: dc84d47231 user: kmedcalf
18:02 Reply: Compiling sqlite3 with readline support artifact: 8e762e2343 user: larrybr
18:01 Post: SQLite3 command using select to CSV or terminal does not return all rows artifact: fbb4e0792b user: OwenMc
17:58 Reply: What indexes help Window Functions artifact: 543442cd01 user: dvdraymond
17:46 Reply: Compiling sqlite3 with readline support artifact: 7df7e477a0 user: hanche
17:43 Reply: What indexes help Window Functions artifact: 50128245d9 user: kmedcalf
17:39 Reply: What indexes help Window Functions artifact: 4b4638544f user: kmedcalf
17:22 Reply: Command Line Shell set parameter as date artifact: 1464987882 user: kmedcalf
17:01 Reply: What indexes help Window Functions artifact: bb919a1701 user: larrybr
16:54 Reply: Command Line Shell set parameter as date artifact: 00d6ea28ed user: larrybr
16:52 Reply: Views with UNION ALL artifact: d0e459fc3d user: drh
16:52 Reply: Views with UNION ALL artifact: 3af1aac1fb user: larrybr
16:46 Reply: Command Line Shell set parameter as date artifact: 1f2f69774f user: hanche
16:39 Reply: Compiling sqlite3 with readline support artifact: 39c9222f74 user: larrybr
16:17 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 691f0047be user: LY1598773890
16:14 Post: Views with UNION ALL artifact: f711e80e8f user: balaji
16:08 Reply: Command Line Shell set parameter as date artifact: 29bc1e48ef user: rchapman
15:56 Reply: Command Line Shell set parameter as date artifact: e174600a09 user: larrybr
15:54 Reply: What indexes help Window Functions artifact: 166760846b user: balaji
14:34 Reply: Command Line Shell set parameter as date artifact: 36d69073ba user: rchapman
14:16 Post: Compiling sqlite3 with readline support artifact: c3bc736b94 user: hanche
14:03 Reply: Command Line Shell set parameter as date artifact: 6429638c79 user: hanche
12:34 Edit reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: b1a4a2852e user: drh
12:33 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 57b2db7195 user: drh
06:57 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: bfed5dc019 user: jdennis
06:54 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: da426488b5 user: jdennis
06:23 Edit reply: What indexes help Window Functions artifact: b167699823 user: kmedcalf
06:22 Reply: What indexes help Window Functions artifact: 2ccbf24ab4 user: kmedcalf
06:16 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: eb2d5f8d55 user: kmedcalf
05:08 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 19bee66ece user: LY1598773890
05:00 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 17c50976bf user: stephan
04:55 Post: COUNT statement returns inconsistent values when used with UNION ALL artifact: 8ea1937ce2 user: LY1598773890
03:39 Edit reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: e20f3d0861 user: simonw
03:39 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 5b6f7e7ee5 user: simonw
03:38 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 04033829a0 user: simonw
02:58 Reply: What indexes help Window Functions artifact: 1bb2cb6115 user: slavin
02:34 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 04e4ed6168 user: knu
02:10 Reply: .import csv and NULL values artifact: 6351a2cba5 user: larrybr
01:27 Reply: .import csv and NULL values artifact: d3bad034ce user: slavin
01:17 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 2258454563 user: simonw
01:16 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 554de1fe75 user: slavin
00:09 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 482abd2e0f user: knu

4 Years Ago (more context)

2020-04-05
23:29 Reply: Rename an INDEX using sqlite_master artifact: 699ba7b2e2 user: slavin
17:17 Reply: 'no query solution' error artifact: e141d3b03f user: kmedcalf
16:39 Reply: How does one search this forum? artifact: 4bd4f8f4d9 user: drh
16:36 Reply: alter table RENAME COLUMN took 3 hours artifact: b0ae8822c2 user: drh
16:12 Edit reply: 'no query solution' error artifact: c3cb7a9465 user: curmudgeon
16:12 Reply: 'no query solution' error artifact: 011f6579ef user: curmudgeon
15:52 Reply: 'no query solution' error artifact: 97a682138e user: itandetnik
15:23 Edit: 'no query solution' error artifact: 13fcab7759 user: curmudgeon
15:01 Post: alter table RENAME COLUMN took 3 hours artifact: ada0a33b31 user: lcarlp
14:55 Post: 'no query solution' error artifact: e7c69a2e20 user: curmudgeon
14:00 Reply: How does one search this forum? artifact: e9d6359c24 user: lcarlp
12:23 Reply: PSA: All books in the ACM digital library are free to download for the next 3 months artifact: f1cdee089e user: Maxulite
10:40 Post: Can't find SQLite.Interop.dll artifact: e763a7a7d4 user: 123113
07:29 Reply: Conflict using group by and partition by at the same time artifact: 659f359bdb user: anonymous
07:13 Reply: Rename an INDEX using sqlite_master artifact: d7bacc2e02 user: anonymous
00:42 Reply: -nocreate -- shell tool feature request/offer artifact: 0b3bd2ddc5 user: anonymous