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 | |