This Day In History For 2024-04-15
1 Year Ago (more context)
|
2023-04-15
| ||
| 23:10 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 82641f0e77 user: larrybr | |
| 21:48 | • Reply: SQL logic error from a simple CREATE TRIGGER statement artifact: 52d4abf6c3 user: kmedcalf | |
| 21:46 | • Reply: SQL logic error from a simple CREATE TRIGGER statement artifact: 1b4b7aec10 user: joeljuca | |
| 21:16 | • Reply: Problems with using index to find range artifact: eefda360c9 user: RichardDamon | |
| 20:48 | • Reply: Problems with using index to find range artifact: fb1c4032f1 user: anonymous | |
| 20:27 | • Post: SQL logic error from a simple CREATE TRIGGER statement artifact: 44dc372598 user: joeljuca | |
| 20:02 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 1d792ac9cb user: kmedcalf | |
| 19:55 | • Reply: Problems with using index to find range artifact: 3b07ce7864 user: kmedcalf | |
| 19:48 | • Reply: Problems with using index to find range artifact: 121d8b9d88 user: kmedcalf | |
| 18:59 | • Edit: A new option, possibly, for CLI: -utf8 artifact: 9628c8f663 user: larrybr | |
| 18:55 | • Reply: Problems with using index to find range artifact: 9b5b4d8fe1 user: anonymous | |
| 16:08 | • Post: Add support for -quiet option? artifact: 0ad1813ded user: davidjmalan | |
| 15:08 | • Reply: Compilation guides for sqlite_analyzer artifact: 77eb646663 user: larrybr | |
| 14:40 | • Post: Compilation guides for sqlite_analyzer artifact: b02c4ed3d4 user: wlhmnrrd | |
| 13:47 | • Reply: Problems with using index to find range artifact: 7f50ce10d1 user: RichardDamon | |
| 10:48 | • Post: Problems with using index to find range artifact: 8248675316 user: anonymous | |
| 10:01 | • Reply: Dealing with a larger database artifact: 5f783012b4 user: TimKendal | |
| 02:51 | • Edit: A new option, possibly, for CLI: -utf8 artifact: 934a839aca user: larrybr | |
| 01:11 | • Reply: Minor error from current trunk artifact: 9b9c2ca78d user: anonymous | |
2 Years Ago (more context)
|
2022-04-15
| ||
| 21:44 | • Reply: Need Help Constructing a Query artifact: 80c95a0cda user: kmedcalf | |
| 21:15 | • Reply: Need Help Constructing a Query artifact: e11d62be90 user: Tomel51 | |
| 20:53 | • Reply: Need Help Constructing a Query artifact: 01df45c16c user: kmedcalf | |
| 20:49 | • Reply: Need Help Constructing a Query artifact: c862b80403 user: kmedcalf | |
| 20:24 | • Post: Trying to recover lost notes from MacBook by reading sqlite files artifact: c02fa5a017 user: anonymous | |
| 19:45 | • Reply: Order of Unique constraint has influence of insert speed? artifact: b511a0191a user: kmedcalf | |
| 19:37 | • Reply: Need Help Constructing a Query artifact: 84a528aa56 user: Tomel51 | |
| 19:25 | • Edit reply: Order of Unique constraint has influence of insert speed? artifact: b9cbb4a1b6 user: kmedcalf | |
| 19:22 | • Reply: Order of Unique constraint has influence of insert speed? artifact: b0d9254f47 user: kmedcalf | |
| 19:14 | • Edit reply: Order of Unique constraint has influence of insert speed? artifact: 3476b428d2 user: kmedcalf | |
| 19:12 | • Reply: Order of Unique constraint has influence of insert speed? artifact: 4f4ca87e43 user: billwade | |
| 18:39 | • Reply: Order of Unique constraint has influence of insert speed? artifact: 53a484323a user: kmedcalf | |
| 18:17 | • Reply: Order of Unique constraint has influence of insert speed? artifact: 94defbcc0a user: larrybr | |
| 17:58 | • Reply: Order of Unique constraint has influence of insert speed? artifact: 65d68d2555 user: slavin | |
| 17:48 | • Reply: Order of Unique constraint has influence of insert speed? artifact: f4cfc420e6 user: billwade | |
| 17:37 | • Reply: Order of Unique constraint has influence of insert speed? artifact: 5113f73140 user: kmedcalf | |
| 17:09 | • Post: Order of Unique constraint has influence of insert speed? artifact: a4c3b458bf user: anonymous | |
| 15:53 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 1a5d621a46 user: parker_lutron1101 | |
| 14:57 | • Reply: integrity_check(100) calls progress callback millions of times. artifact: 9588d7367c user: macsql20 | |
| 11:28 | • Edit reply: Learning SQLite Virtual tables artifact: 104eb71b4a user: AAsk1902 | |
| 11:27 | • Reply: Learning SQLite Virtual tables artifact: a50e3736aa user: AAsk1902 | |
| 09:23 | • Reply: Learning SQLite Virtual tables artifact: 27298fa2a9 user: UserMBL | |
| 09:06 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 244891b41a user: ddevienne | |
| 03:13 | • Reply: shared in memory db: :memory:+shared cache OR memdb VFS? artifact: 89377c3ce1 user: anonymous | |
| 01:12 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: a20cc714ca user: kmedcalf | |
| 01:00 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: e8bb608c3e user: drh | |
| 00:34 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 9297687e04 user: wyoung | |
| 00:13 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 84983e9df4 user: kmedcalf | |
3 Years Ago (more context)
|
2021-04-15
| ||
| 21:19 | • Reply: Question About Command Line Backup of Locked DB artifact: a252371d80 user: drh | |
| 21:01 | • Post: Question About Command Line Backup of Locked DB artifact: 77b3c9106a user: anonymous | |
| 20:18 | • Reply: Pragma compile_options does not show some options artifact: 5651099630 user: larrybr | |
| 20:09 | • Reply: How to run SQLite shell program on Android artifact: ec7370398b user: SeverKetor | |
| 18:02 | • Reply: Feature request: support sqlite3_mem_methods.xSize = NULL artifact: cf61f92970 user: anonymous | |
| 17:08 | • Post: Inconsistant output when likely/unlikely and join keyword is applied artifact: c38462ab5e user: LY1598773890 | |
| 16:46 | • Reply: Proposal: Implement the MOD(x, y) function artifact: 938474793f user: ThanksRyan | |
| 16:06 | • Reply: Proposal: Implement the MOD(x, y) function artifact: ee7b54a87e user: anonymous | |
| 14:48 | • Reply: SQLite the only database you will ever need in most cases artifact: 8544ffd786 user: anonymous | |
| 14:43 | • Reply: Pragma compile_options does not show some options artifact: f9c46e640f user: larrybr | |
| 14:28 | • Reply: Pragma compile_options does not show some options artifact: 8f8a6e8cc3 user: skywalk | |
| 14:09 | • Post: SQLite the only database you will ever need in most cases artifact: ead3c5f5f8 user: ThanksRyan | |
| 13:43 | • Reply: How to run SQLite shell program on Android artifact: 705f348437 user: anonymous | |
| 12:21 | • Reply: programming sqlite bytecode directly ? artifact: f5a05923b2 user: anonymous | |
| 12:09 | • Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: f8941a24a8 user: drh | |
| 12:07 | • Reply: programming sqlite bytecode directly ? artifact: 7313ba5cb6 user: drh | |
| 11:58 | • Post: programming sqlite bytecode directly ? artifact: 83578adea8 user: anonymous | |
| 11:32 | • Post: Feature request: support sqlite3_mem_methods.xSize = NULL artifact: 554ab25226 user: anonymous | |
| 11:15 | • Post: Proposed addition to the sqlite3_result_XX API artifact: e97e1e5a91 user: mbenningfield1 | |
| 11:12 | • Reply: Pragma compile_options does not show some options artifact: 36a6a18ca9 user: gonzus | |
| 10:57 | • Reply: How to run SQLite shell program on Android artifact: 184328ca66 user: anonymous | |
| 10:38 | • Reply: Noob Question artifact: 5e21f1543c user: cuz | |
| 10:27 | • Post: How to run SQLite shell program on Android artifact: 85479d92b5 user: anonymous | |
| 10:22 | • Reply: Proposal: Implement the MOD(x, y) function artifact: 1ac414ede1 user: larrybr | |
| 10:15 | • Edit: Proposal: Implement the MOD(x, y) function artifact: f7335228d0 user: tarest | |
| 10:15 | • Edit: Proposal: Implementing TRIM, SUBSTRING and POSITION standard SQL string functions artifact: 6a4182587a user: tarest | |
| 10:13 | • Edit: Proposal: Add the SUBSTRING alias to the SUBSTR function artifact: 609ecf9cc3 user: tarest | |
| 10:13 | • Reply: Delete columns?? artifact: 35e453ad1f user: cuz | |
| 10:11 | • Reply: Pragma compile_options does not show some options artifact: b7799ffc67 user: larrybr | |
| 10:02 | • Reply: Pragma compile_options does not show some options artifact: f2a8ff2b10 user: gonzus | |
| 09:38 | • Reply: Noob Question artifact: 71fdd2830e user: ddevienne | |
| 09:35 | • Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: 19be634a1b user: gonzus | |
| 09:24 | • Reply: Noob Question artifact: 9e0b478fdf user: cuz | |
| 09:21 | • Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: e28b13c50e user: larrybr | |
| 08:54 | • Reply: sql error:INSERT INTO tbl_des SELECT v1,v2.. FROM tbl_src on conflict(vehicle_id,begin_time) do nothing artifact: e92d9c7b66 user: kmedcalf | |
| 07:58 | • Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: 5452f3fb4c user: gonzus | |
| 07:49 | • Post: sql error:INSERT INTO tbl_des SELECT v1,v2.. FROM tbl_src on conflict(vehicle_id,begin_time) do nothing artifact: d13058284b user: yh2216 | |
| 07:32 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 25868ce88e user: stephancb | |
| 06:06 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 3450be8217 user: yh2216 | |
| 02:18 | • Reply: suggest:for geopoly,advice to add primary key like rtree artifact: 6c76e17267 user: yh2216 | |
| 02:17 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: a1788f41e1 user: kmedcalf | |
| 02:04 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 568251652a user: larrybr | |
| 01:54 | • Reply: Pragma compile_options does not show some options artifact: 1f373364d8 user: larrybr | |
| 01:52 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 0bfeaef26d user: yh2216 | |
| 01:47 | • Delete reply: bug:update from virtual table (geopoly),and no return received artifact: eae3bb655e user: yh2216 | |
| 01:43 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: b522ac258f user: yh2216 | |
| 01:39 | • Reply: Pragma compile_options does not show some options artifact: 188cfec077 user: kmedcalf | |
| 01:24 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 29a1ecb776 user: yh2216 | |
| 01:12 | • Reply: Pragma compile_options does not show some options artifact: fc7f0eeaae user: larrybr | |
4 Years Ago (more context)
|
2020-04-15
| ||
| 23:21 | • Reply: How do create the neat flow diagrams for SQLite? artifact: 5d34a18775 user: anonymous | |
| 22:30 | • Reply: can not subscribe artifact: b40f65b780 user: jicman | |
| 22:21 | • Reply: can not subscribe artifact: 142d8852b1 user: knu | |
| 20:21 | • Reply: How do create the neat flow diagrams for SQLite? artifact: ca52ff18ea user: doug9forester | |
| 19:55 | • Reply: How do create the neat flow diagrams for SQLite? artifact: 97724813b7 user: drh | |
| 18:55 | • Reply: How do create the neat flow diagrams for SQLite? artifact: 9d4f2e79cd user: wyoung | |
| 18:24 | • Post: Bad schema no biscuit artifact: d7de698a40 user: slavin | |
| 17:00 | • Reply: How do create the neat flow diagrams for SQLite? artifact: 1416593c28 user: doug9forester | |
| 16:36 | • Reply: sqlite3_bind_text16 & weird AI artifact: 20c2ac2c5e user: anonymous | |
| 16:16 | • Edit reply: sqlite3_bind_text16 & weird AI artifact: e4aae2d1dd user: LarryBrasfield | |
| 16:14 | • Reply: sqlite3_bind_text16 & weird AI artifact: c055d9f129 user: LarryBrasfield | |
| 16:05 | • Reply: How do create the neat flow diagrams for SQLite? artifact: e8572345f1 user: drh | |
| 15:48 | • Reply: How do create the neat flow diagrams for SQLite? artifact: a1bd2d58b9 user: doug9forester | |
| 15:45 | • Reply: Retrieve match context with FTS5 artifact: 71f654365b user: ddevienne | |
| 15:21 | • Reply: sqlite3_bind_text16 & weird AI artifact: 0587f50911 user: drh | |
| 15:09 | • Reply: sqlite3_bind_text16 & weird AI artifact: 87282ee565 user: anonymous | |
| 15:06 | • Reply: can not subscribe artifact: 23d4676c93 user: drh | |
| 14:50 | • Reply: can not subscribe artifact: 3a46eebfa3 user: TripeHound | |
| 14:37 | • Reply: Retrieve match context with FTS5 artifact: ff452c5e08 user: dan | |
| 14:19 | • Edit reply: can not subscribe artifact: f44c64ea82 user: jicman | |
| 14:15 | • Reply: can not subscribe artifact: cb8e6c0e24 user: jicman | |
| 13:44 | • Reply: Update Crashed my Program artifact: 68f6b42987 user: anonymous | |
| 13:38 | • Reply: sqlite3_bind_text16 & weird AI artifact: 5f498fe04b user: drh | |
| 13:26 | • Reply: can not subscribe artifact: b9c5662ded user: drh | |
| 12:58 | • Post: can not subscribe artifact: 3fedad83da user: anonymous | |
| 12:44 | • Reply: sqlite3_bind_text16 & weird AI artifact: 29fb652b5f user: anonymous | |
| 12:21 | • Edit reply: length function for BLOB out of sync with documentation artifact: 6aa929f2f7 user: kmedcalf | |
| 12:20 | • Reply: length function for BLOB out of sync with documentation artifact: c676b9a79a user: kmedcalf | |
| 11:27 | • Post: File .db always locked using EF6 / WebApi (.Net) artifact: 9540e5adaf user: marantz | |
| 11:26 | • Edit reply: Retrieve match context with FTS5 artifact: adf78bb20e user: drh | |
| 09:20 | • Reply: length function for BLOB out of sync with documentation artifact: b36996e1d2 user: troyski | |
| 09:04 | • Reply: Retrieve match context with FTS5 artifact: bb87bad637 user: ddevienne | |
| 08:16 | • Reply: Speed optimization for big single tabel searches artifact: abb549fbdf user: ddevienne | |
| 07:44 | • Reply: Memory leak when calling sqlite3_exec() artifact: faa1bcc913 user: anonymous | |
| 06:07 | • Reply: How do create the neat flow diagrams for SQLite? artifact: cb7a52f3f8 user: wyoung | |
| 04:58 | • Post: How do create the neat flow diagrams for SQLite? artifact: d1a45a9a79 user: doug9forester | |
| 03:53 | • Reply: Method to delete all unreferenced rows from a parent table? artifact: dd2d9ef085 user: anonymous | |
| 01:42 | • Edit reply: Method to delete all unreferenced rows from a parent table? artifact: 8e6e405e18 user: kmedcalf | |
| 01:38 | • Reply: Method to delete all unreferenced rows from a parent table? artifact: 8f3d459e33 user: kmedcalf | |
| 01:25 | • Reply: Update Crashed my Program artifact: 3b2d8059d9 user: anonymous | |
| 00:49 | • Post: Method to delete all unreferenced rows from a parent table? artifact: a44b8ba0af user: anonymous | |