This Day In History For 2024-04-06
1 Year Ago (more context)
|
2023-04-06
| ||
| 22:08 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 5ee2174ae8 user: sqlitevexee | |
| 21:45 | • Edit reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: f0d6a4f7e3 user: stephan | |
| 21:33 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 945b79a101 user: anonymous | |
| 21:17 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 7ed3774a56 user: larrybr | |
| 20:59 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 5cd1df926d user: sqlitevexee | |
| 20:48 | • Reply: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: 90df0035bb user: larrybr | |
| 20:40 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: cd5886911c user: larrybr | |
| 20:32 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 48eff914af user: sqlitevexee | |
| 20:27 | • Post: Team member Joe Mistachkin seeking full-time employment... artifact: a72dfcdee6 user: mistachkin | |
| 19:55 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 20d43fd0d6 user: kmedcalf | |
| 19:52 | • Edit: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: ac46fae04f user: sqlitevexee | |
| 19:49 | • Post: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 899425fe0d user: sqlitevexee | |
| 16:22 | • Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: 5d3c0cfc34 user: AAsk1902 | |
| 15:46 | • Reply: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: 520d28ddcc user: kmedcalf | |
| 15:36 | • Reply: How do I escape punctuation in full text queries artifact: fde912e6d3 user: larrybr | |
| 12:44 | • Post: System.EntryPointNotFoundException: Unable to find an entry point named 'SI9dbf9d88aa001ea6' in DLL 'SQLite.Interop.dll' artifact: 81081d5763 user: wisch10 | |
| 12:25 | • Reply: Possible bug: Unable to find an entry point artifact: 4f58f0438c user: wisch10 | |
| 10:50 | • Reply: Uniqueidentifier column artifact: fdb6a31fc3 user: chrisjlocke1 | |
| 10:47 | • Reply: Uniqueidentifier column artifact: 7ddc5fc825 user: chrisjlocke1 | |
| 10:38 | • Reply: Uniqueidentifier column artifact: 480b68b503 user: knu | |
| 09:40 | • Reply: Optimizing JSON filter by syntheszing a LIKE artifact: 8128754743 user: hanche | |
| 09:19 | • Reply: Uniqueidentifier column artifact: 3ce97695af user: stephan | |
| 08:42 | • Reply: Uniqueidentifier column artifact: c5d743b8f3 user: anonymous | |
| 08:34 | • Reply: Uniqueidentifier column artifact: 41453fc730 user: anonymous | |
| 06:37 | • Reply: SQlite encryption artifact: a0339ed758 user: nuclight | |
| 06:27 | • Reply: Is it bad practice to place Tcl/SQLite "eval" statements within the script of another "eval" statement? artifact: 8e2fb272e8 user: nuclight | |
| 06:02 | • Reply: How do I escape punctuation in full text queries artifact: a254d3da58 user: anonymous | |
| 04:56 | • Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: e5069bb6ba user: ksnmurthy | |
| 04:55 | • Reply: How to secure and change location of the SQLite database in react native for windows platform artifact: c592582a58 user: ksnmurthy | |
| 00:35 | • Edit reply: Segmentation fault in sqlite3_db_config function artifact: 095f87e7cf user: songliu | |
| 00:35 | • Reply: Segmentation fault in sqlite3_db_config function artifact: e66d8d06f4 user: songliu | |
2 Years Ago (more context)
|
2022-04-06
| ||
| 21:48 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 63bfb9304a user: anonymous | |
| 21:10 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: e65abffd2c user: anonymous | |
| 21:10 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 1ed072409a user: knu | |
| 20:09 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 13655a9fc3 user: dvdraymond | |
| 19:55 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 5d97ba73f2 user: anonymous | |
| 19:50 | • Edit reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 4a748fb772 user: midijohnny | |
| 19:42 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 0c00699f49 user: kmedcalf | |
| 19:40 | • Edit reply: DOT commands - Is there a way to concatenate multiple commands? artifact: b6d6fbb741 user: midijohnny | |
| 19:39 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: 7063ca00a7 user: midijohnny | |
| 19:34 | • Reply: DOT commands - Is there a way to concatenate multiple commands? artifact: daef342b02 user: larrybr | |
| 19:12 | • Post: DOT commands - Is there a way to concatenate multiple commands? artifact: 74673ec626 user: anonymous | |
| 17:53 | • Reply: Build for iOS? artifact: 7060416a67 user: wiverson | |
| 16:18 | • Reply: howto combine rows with recursive query artifact: 04bb4a4940 user: midijohnny | |
| 16:01 | • Post: Virtual Table Joins with Repeated calls to xFilter artifact: 7e2802db01 user: agrothberg | |
| 12:23 | • Reply: fyi LumoSQL/SQLite seminars today artifact: adaea6f7aa user: danshearer | |
| 11:59 | • Reply: howto combine rows with recursive query artifact: 1f63ef15cb user: midijohnny | |
| 11:58 | • Reply: Many-To-Many problem artifact: e4dd2a05fd user: BertilE | |
| 11:55 | • Reply: howto combine rows with recursive query artifact: 70658b7c6f user: midijohnny | |
| 11:53 | • Reply: howto combine rows with recursive query artifact: a8491594fc user: cuz | |
| 11:29 | • Reply: howto combine rows with recursive query artifact: a8238249e0 user: midijohnny | |
| 11:21 | • Edit reply: howto combine rows with recursive query artifact: 2e6497d6bd user: midijohnny | |
| 11:13 | • Edit reply: howto combine rows with recursive query artifact: a757a7f7e5 user: midijohnny | |
| 11:12 | • Edit reply: howto combine rows with recursive query artifact: 072c07bd40 user: midijohnny | |
| 11:03 | • Reply: howto combine rows with recursive query artifact: ef43ae9c44 user: midijohnny | |
| 10:18 | • Reply: howto combine rows with recursive query artifact: a3603f482f user: cuz | |
| 10:02 | • Edit reply: howto combine rows with recursive query artifact: 1c3b0b0a9c user: cuz | |
| 09:56 | • Reply: howto combine rows with recursive query artifact: 6baad89426 user: cuz | |
| 08:35 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 93907a6424 user: gunter_hick | |
| 07:40 | • Reply: fyi LumoSQL/SQLite seminars today artifact: 79525939b9 user: ddevienne | |
| 06:36 | • Post: fyi LumoSQL/SQLite seminars today artifact: f8099c43bf user: danshearer | |
| 06:00 | • Reply: Build for iOS? artifact: 3ad49eaf56 user: wiverson | |
| 05:40 | • Delete reply: Build for iOS? artifact: 8b52719d9d user: wiverson | |
| 05:40 | • Reply: Build for iOS? artifact: 17911eabb1 user: wiverson | |
| 05:32 | • Reply: Build for iOS? artifact: 88ce02cfa0 user: wiverson | |
| 05:08 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 351770e64e user: riyaz-ali | |
| 03:15 | • Reply: Repeated rows in select loop artifact: e380190d59 user: slavin | |
| 02:06 | • Edit reply: Awkward data for your toy music database artifact: 252e0b6899 user: slavin | |
| 02:06 | • Reply: Awkward data for your toy music database artifact: 79c9c2aa60 user: slavin | |
| 02:02 | • Reply: Build for iOS? artifact: 1f29dcaf44 user: slavin | |
| 01:40 | • Reply: Repeated rows in select loop artifact: f5ad9af2c2 user: hashbackup | |
3 Years Ago (more context)
|
2021-04-06
| ||
| 23:45 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 58006ebd08 user: orf123 | |
| 23:35 | • Post: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 452888d3b1 user: orf123 | |
| 23:33 | • Reply: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: aeb94dc8a1 user: drh | |
| 22:56 | • Post: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: 66954e9ece user: LY1598773890 | |
| 20:41 | • Reply: books / papers on "one sqlite per user" design ? artifact: c89ce9fae8 user: w.oertl | |
| 18:30 | • Reply: Lemon - Unexpected frees artifact: 112b33325f user: SirHumphreyAppleby | |
| 18:05 | • Reply: Growing WAL-File artifact: 6038b31ddb user: derhexer | |
| 17:11 | • Reply: Growing WAL-File artifact: 8b3260059a user: drh | |
| 15:59 | • Reply: Growing WAL-File artifact: ff6b4481a6 user: derhexer | |
| 15:52 | • Reply: Growing WAL-File artifact: e4fb73dc00 user: knu | |
| 14:43 | • Reply: What indexes help Window Functions artifact: 33cb2b0699 user: balaji | |
| 14:37 | • Reply: Views with UNION ALL artifact: d9482223db user: balaji | |
| 14:17 | • Post: Table scan and json_tree artifact: fafa511299 user: skelter | |
| 13:57 | • Reply: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: b3f4b6a4b8 user: anonymous | |
| 13:37 | • Reply: What indexes help Window Functions artifact: 680fa795d8 user: slavin | |
| 13:25 | • Reply: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: 24768f1c8f user: drh | |
| 13:07 | • Reply: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: 98d4fb9ced user: gunter_hick | |
| 13:05 | • Reply: Compiling sqlite3 with readline support artifact: 0e9668c612 user: danshearer | |
| 12:31 | • Reply: Compiling sqlite3 with readline support artifact: 6ee0dd92ac user: rbucker | |
| 12:28 | • Post: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: 7dfc384b33 user: anonymous | |
| 10:14 | • Reply: Lemon - Unexpected frees artifact: a541bbce8c user: drh | |
| 09:10 | • Reply: Compiling sqlite3 with readline support artifact: 024506c506 user: hanche | |
| 08:50 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: cdec30c813 user: ddevienne | |
| 08:44 | • Reply: SQLite3 command using select to CSV or terminal does not return all rows artifact: 328b504cad user: OwenMc | |
| 08:17 | • Reply: Compiling sqlite3 with readline support artifact: 4db8e9df49 user: larrybr | |
| 08:04 | • Reply: Compiling sqlite3 with readline support artifact: be524982fc user: hanche | |
| 07:53 | • Post: Growing WAL-File artifact: 7d292adea1 user: derhexer | |
| 07:32 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 260c93dc77 user: anonymous | |
| 07:26 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 49bf3378fc user: anonymous | |
| 03:53 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 8701859636 user: kmedcalf | |
| 00:24 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: e3833276d2 user: anonymous | |
4 Years Ago (more context)
|
2020-04-06
| ||
| 22:54 | • Edit reply: JOIN query behaves differently with/without trailing ON? artifact: 85738a0268 user: skywalk | |
| 22:47 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: 80cc622b7a user: skywalk | |
| 22:27 | • Reply: 3.31.1: docs as PDF? artifact: 91ad4f4a7a user: LarryBrasfield | |
| 22:09 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: ffcad64daa user: drh | |
| 22:05 | • Reply: 3.31.1: docs as PDF? artifact: cf9b3f22db user: drh | |
| 21:59 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: 3c3b1e5887 user: skywalk | |
| 21:56 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: c8f99ee0ba user: kmedcalf | |
| 21:53 | • Reply: 3.31.1: docs as PDF? artifact: a7b36933ac user: LarryBrasfield | |
| 21:45 | • Post: JOIN query behaves differently with/without trailing ON? artifact: ede763f636 user: skywalk | |
| 21:38 | • Reply: 3.31.1: docs as PDF? artifact: e010a540e4 user: wmertens | |
| 20:34 | • Reply: Rename an INDEX using sqlite_master artifact: 4a6f124d1c user: anonymous | |
| 19:26 | • Reply: shell's .load is pathSep picky artifact: aa60b7f05d user: kmedcalf | |
| 19:14 | • Reply: 3.31.1: docs as PDF? artifact: 3f55403082 user: luuk | |
| 19:05 | • Reply: Trivial typo in the documentation artifact: 459924675e user: drh | |
| 19:03 | • Reply: alter table RENAME COLUMN took 3 hours artifact: ec712861e2 user: drh | |
| 18:43 | • Edit reply: 3.31.1: docs as PDF? artifact: fd31944641 user: gisbert | |
| 18:41 | • Reply: shell's .load is pathSep picky artifact: 6c659bc1ee user: gisbert | |
| 18:37 | • Reply: Trivial typo in the documentation artifact: a0abae1eed user: gisbert | |
| 17:07 | • Reply: shell's .load is pathSep picky artifact: f3d84a8169 user: LarryBrasfield | |
| 16:52 | • Reply: shell's .load is pathSep picky artifact: 7f9802a6b4 user: gisbert | |
| 16:43 | • Reply: 3.31.1: docs as PDF? artifact: 754d8a9353 user: gisbert | |
| 15:58 | • Edit reply: Rename an INDEX using sqlite_master artifact: 80c960f59e user: PeterJanRoes | |
| 15:37 | • Edit: shell's .load is pathSep picky artifact: d572ac6d23 user: LarryBrasfield | |
| 15:37 | • Edit: shell's .load is pathSep picky artifact: 3ca103ffea user: LarryBrasfield | |
| 15:28 | • Post: shell's .load is pathSep picky artifact: 137a930da8 user: LarryBrasfield | |
| 14:52 | • Reply: alter table RENAME COLUMN took 3 hours artifact: ab30590a6c user: dvdraymond | |
| 14:52 | • Edit: a teensy .help nit artifact: 51932bd317 user: LarryBrasfield | |
| 14:41 | • Reply: alter table RENAME COLUMN took 3 hours artifact: 8ec9a29d48 user: drh | |
| 14:40 | • Reply: alter table RENAME COLUMN took 3 hours artifact: ef4b47a74b user: anonymous | |
| 14:25 | • Post: a teensy .help nit artifact: 46f281c311 user: LarryBrasfield | |
| 14:24 | • Reply: alter table RENAME COLUMN took 3 hours artifact: 5a59dce5aa user: drh | |
| 14:16 | • Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: d34937f246 user: kmedcalf | |
| 14:10 | • Reply: alter table RENAME COLUMN took 3 hours artifact: f6afeda9b6 user: gunter_hick | |
| 13:58 | • Reply: alter table RENAME COLUMN took 3 hours artifact: 77ab6c610f user: lcarlp | |
| 13:55 | • Reply: Bug in multiple Primary key inserting null. artifact: 9beb92af84 user: drh | |
| 13:50 | • Post: Bug in multiple Primary key inserting null. artifact: 01a1ba9d57 user: anonymous | |
| 13:45 | • Reply: Rename an INDEX using sqlite_master artifact: 22b1acc9e0 user: PeterJanRoes | |
| 13:28 | • Reply: alter table RENAME COLUMN took 3 hours artifact: cfcb28e0b5 user: lcarlp | |
| 13:04 | • Edit reply: Rename an INDEX using sqlite_master artifact: 39922dd983 user: ddevienne | |
| 12:59 | • Reply: Rename an INDEX using sqlite_master artifact: afef0e8415 user: ddevienne | |
| 12:26 | • Reply: Inserting multiple rows in table artifact: ddd43e6653 user: dvdraymond | |
| 12:18 | • Reply: Rename an INDEX using sqlite_master artifact: fde1f51b09 user: PeterJanRoes | |
| 12:16 | • Reply: Rename an INDEX using sqlite_master artifact: 5731ed6b88 user: PeterJanRoes | |
| 10:19 | • Reply: PSA: All books in the ACM digital library are free to download for the next 3 months artifact: b08f05a7ed user: ddevienne | |
| 09:32 | • Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 08ff33a693 user: ddevienne | |
| 07:27 | • Reply: 'no query solution' error artifact: 0a6acae198 user: curmudgeon | |
| 02:09 | • Reply: Rename an INDEX using sqlite_master artifact: c49a93c226 user: knu | |