This Day In History For 2024-04-07
1 Year Ago (more context)
|
2023-04-07
| ||
| 23:59 | • Reply: ANN Database Designer artifact: 63ff7e3585 user: Emily-Elizabeth | |
| 23:46 | • Edit reply: ANN Database Designer artifact: 28c8d18733 user: chrisjlocke1 | |
| 23:44 | • Reply: ANN Database Designer artifact: 813a667070 user: chrisjlocke1 | |
| 22:29 | • Reply: How to get the local timezone offset and name? artifact: 653c20e894 user: anonymous | |
| 22:16 | • Reply: ANN Database Designer artifact: fae88553b4 user: Emily-Elizabeth | |
| 22:03 | • Reply: ANN Database Designer artifact: 4093deb8c4 user: chrisjlocke1 | |
| 21:56 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: f77dff3a3e user: punkish | |
| 21:20 | • Reply: How to get the local timezone offset and name? artifact: f7b944d37f user: spindrift | |
| 21:09 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: b2e2e66e5c user: drh | |
| 21:02 | • Post: ANN Database Designer artifact: 513ee652ea user: Emily-Elizabeth | |
| 18:11 | • Reply: Are the lemon lalr In public domain? artifact: 7efed4df0f user: punkish | |
| 18:08 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: a64727b71d user: punkish | |
| 18:01 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 3e0aba736f user: drh | |
| 17:51 | • Post: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 77bf713c1c user: punkish | |
| 16:08 | • Reply: How to get the local timezone offset and name? artifact: a8554c6151 user: kmedcalf | |
| 13:45 | • Reply: How to get the local timezone offset and name? artifact: f480af2557 user: kmedcalf | |
| 13:42 | • Reply: WASM kvvfs in browser extension's background service workers artifact: 8d8b6fc827 user: stephan | |
| 10:34 | • Reply: WASM kvvfs in browser extension's background service workers artifact: f3cde41064 user: sneakytin | |
| 08:43 | • Post: How to get the local timezone offset and name? artifact: 5277127f73 user: anonymous | |
2 Years Ago (more context)
|
2022-04-07
| ||
| 23:58 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: fbd1920d3a user: kmedcalf | |
| 23:29 | • Reply: How do I remove column wraps? artifact: 0eb2b53e15 user: anonymous | |
| 22:05 | • Reply: integrity_check(100) calls progress callback millions of times. artifact: 97eed01b2f user: anonymous | |
| 22:00 | • Edit: pragma_table_info - JOIN/FROM order - different behaviour. artifact: dd89484a24 user: midijohnny | |
| 21:58 | • Reply: SQL for update lat lon for same addresses artifact: ddf32b8dca user: midijohnny | |
| 21:51 | • Reply: SQL for update lat lon for same addresses artifact: 06b020fe60 user: RBSmissaert | |
| 21:51 | • Reply: SQL for update lat lon for same addresses artifact: ebc9dba6f0 user: hanche | |
| 21:47 | • Reply: SQL for update lat lon for same addresses artifact: c98ef36203 user: midijohnny | |
| 21:40 | • Edit reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: c129c61766 user: midijohnny | |
| 21:38 | • Edit reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: d8e94065c0 user: midijohnny | |
| 21:35 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 8936d4d919 user: midijohnny | |
| 21:30 | • Post: pragma_table_info - JOIN/FROM order - different behaviour. artifact: af73f18a81 user: midijohnny | |
| 21:23 | • Post: Is it actually possible to limit SQLITE3 memory usage? artifact: 66a592942c user: chaircrusher | |
| 21:21 | • Reply: How do I remove column wraps? artifact: e5e6cefb2f user: midijohnny | |
| 20:45 | • Post: caching SQLite database. artifact: 56f3894501 user: den-t8 | |
| 19:35 | • Reply: How do I remove column wraps? artifact: 513e36ffc6 user: anonymous | |
| 19:18 | • Reply: How do I remove column wraps? artifact: 3ba859bdfa user: anonymous | |
| 19:10 | • Post: SQL for update lat lon for same addresses artifact: 61cb0da8d1 user: RBSmissaert | |
| 18:43 | • Reply: How do I remove column wraps? artifact: aee17dfadc user: kmedcalf | |
| 18:35 | • Reply: How do I remove column wraps? artifact: 0f519cea4f user: kmedcalf | |
| 18:33 | • Reply: How do I remove column wraps? artifact: e28a3612fa user: anonymous | |
| 17:49 | • Reply: How do I remove column wraps? artifact: 16dae257a9 user: anonymous | |
| 17:27 | • Reply: How do I remove column wraps? artifact: 44e7573bf6 user: anonymous | |
| 17:16 | • Reply: How do I remove column wraps? artifact: e7b7535a0c user: larrybr | |
| 17:16 | • Edit reply: How do I remove column wraps? artifact: 520541c55e user: kmedcalf | |
| 17:14 | • Reply: How do I remove column wraps? artifact: 38b705a5cc user: kmedcalf | |
| 16:44 | • Reply: integrity_check(100) calls progress callback millions of times. artifact: b4f7f6ab6d user: macsql20 | |
| 16:39 | • Post: How do I remove column wraps? artifact: 35a96cd769 user: anonymous | |
| 16:07 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: 3619760999 user: agrothberg | |
| 15:34 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: 66b2059315 user: gunter_hick | |
| 15:17 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: df6beb09ca user: SeverKetor | |
| 15:03 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: aaaef8caee user: agrothberg | |
| 13:52 | • Reply: Import a SQLite table/query result directly into BlueSky Statistics (GUI for R) artifact: 3909cd1304 user: anonymous | |
| 13:47 | • Reply: sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value artifact: 804cc92a00 user: dan | |
| 13:18 | • Post: Import a SQLite table/query result directly into BlueSky Statistics (GUI for R) artifact: 9e85be8eaa user: anonymous | |
| 13:08 | • Post: Lemon get lost with a comment /*/=*/ artifact: b6edc69548 user: mingodad | |
| 05:27 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: ecaca2cb33 user: gunter_hick | |
3 Years Ago (more context)
|
2021-04-07
| ||
| 23:29 | • Reply: impact of cache_size artifact: ea98e4cb08 user: kmedcalf | |
| 23:03 | • Reply: Error with upsert and trigger WHEN clause? artifact: 94848734b0 user: itandetnik | |
| 22:56 | • Edit: Table scan and json_tree artifact: e9bcd00e75 user: skelter | |
| 22:22 | • Reply: Query triggers Segmentation Fault artifact: 5c67692e78 user: drh | |
| 22:19 | • Reply: Saving Wikipedia to SQLite artifact: f735ac99a9 user: GSnyder | |
| 21:21 | • Post: impact of cache_size artifact: 1b19dbc1de user: kasztelan77 | |
| 21:20 | • Post: Query triggers Segmentation Fault artifact: 174ffb6948 user: LY1598773890 | |
| 20:46 | • Reply: Saving Wikipedia to SQLite artifact: 69afac78aa user: jkreibich | |
| 16:12 | • Reply: Compiling sqlite3 with readline support artifact: 22381e80f8 user: danshearer | |
| 16:08 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: a39339732b user: casaderobison | |
| 15:54 | • Reply: Command line option '.read' - Windows version artifact: ba95c40625 user: anonymous | |
| 15:47 | • Reply: Error with upsert and trigger WHEN clause? artifact: 882b6eba03 user: miasuji | |
| 15:06 | • Post: Possible WINDOW optimization opportunity artifact: 2451f0c193 user: anonymous | |
| 14:39 | • Reply: Command line option '.read' - Windows version artifact: e89d6c97b3 user: larrybr | |
| 14:31 | • Reply: segfault in sqlite3 (3.35.4) artifact: d9fce1a89b user: drh | |
| 14:27 | • Post: Command line option '.read' - Windows version artifact: 89deaae8c3 user: anonymous | |
| 14:22 | • Reply: segfault in sqlite3 (3.35.4) artifact: e8853ff189 user: larrybr | |
| 14:10 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 80f22fa892 user: ThanksRyan | |
| 13:30 | • Reply: segfault in sqlite3 (3.35.4) artifact: 34fa9ecd2e user: anonymous | |
| 13:26 | • Reply: segfault in sqlite3 (3.35.4) artifact: cb76672fda user: anonymous | |
| 09:46 | • Reply: segfault in sqlite3 (3.35.4) artifact: d76613f7e2 user: larrybr | |
| 09:06 | • Reply: books / papers on "one sqlite per user" design ? artifact: f002442fba user: anonymous | |
| 08:48 | • Post: Saving Wikipedia to SQLite artifact: 198e1a104a user: andreas-kupries | |
| 07:28 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: a95725f36b user: nickgammon | |
| 07:12 | • Post: segfault in sqlite3 (3.35.4) artifact: ce6be65f6b user: tsiming | |
| 05:18 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 9ba1033f71 user: kmedcalf | |
| 05:06 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 910f423b19 user: wyoung | |
| 05:04 | • Reply: deploying 1_000_000 sqlitedb on AWS? artifact: 87bd3ea0b2 user: RandomCoder | |
| 04:57 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 0e6f5b81f1 user: kmedcalf | |
| 04:51 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 3cff1d4422 user: kmedcalf | |
| 04:12 | • Edit reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 4bb63c2bf8 user: nickgammon | |
| 04:06 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: c0e158618b user: nickgammon | |
| 03:58 | • Edit reply: Error with upsert and trigger WHEN clause? artifact: 1fbd7715ba user: kmedcalf | |
| 03:57 | • Reply: Error with upsert and trigger WHEN clause? artifact: 66d8f21fd1 user: kmedcalf | |
| 03:52 | • Reply: Error with upsert and trigger WHEN clause? artifact: c3ff89d18b user: kmedcalf | |
| 03:43 | • Reply: Error with upsert and trigger WHEN clause? artifact: 32b714eeec user: kmedcalf | |
| 02:59 | • Post: Error with upsert and trigger WHEN clause? artifact: c43ccb25a8 user: miasuji | |
| 02:10 | • Reply: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: 3f93e95e08 user: LY1598773890 | |
| 02:01 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 4695074a14 user: wyoung | |
| 01:50 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: fb1a4c8259 user: orf123 | |
| 01:36 | • Post: Please avoid all use of the "LL" suffix for long-long integer literals artifact: e4ea2366b1 user: nickgammon | |
| 01:34 | • Post: Typo in docs artifact: c661cf4fcb user: anonymous | |
| 01:34 | • Edit reply: Growing WAL-File artifact: 72703ef8bd user: kmedcalf | |
| 01:30 | • Edit reply: Growing WAL-File artifact: 7ffd82d23d user: kmedcalf | |
| 01:28 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 35ae1aabfd user: drh | |
| 01:25 | • Reply: Growing WAL-File artifact: 406988435d user: kmedcalf | |
| 00:41 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: a64953e91c user: anonymous | |
| 00:40 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: cbb488244c user: anonymous | |
| 00:30 | • Edit reply: open db in read only; explicitly store diff as WAL ? artifact: 38caef7f9c user: kmedcalf | |
| 00:29 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 46bb5762da user: kmedcalf | |
| 00:22 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 9a9647c2a8 user: kmedcalf | |
| 00:12 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: ad5b4291a7 user: orf123 | |
| 00:05 | • Reply: Bug in Sqlite >3.35.0 when using WHERE(EXISTS) artifact: 42aa1084fe user: drh | |
| 00:01 | • Post: deploying 1_000_000 sqlitedb on AWS? artifact: 00c0465605 user: anonymous | |
4 Years Ago (more context)
|
2020-04-07
| ||
| 22:44 | • Edit reply: alter table RENAME COLUMN took 3 hours artifact: 00f10ebf67 user: LarryBrasfield | |
| 22:41 | • Reply: alter table RENAME COLUMN took 3 hours artifact: 2754ba0380 user: LarryBrasfield | |
| 22:13 | • Reply: alter table RENAME COLUMN took 3 hours artifact: 0146dc0b6a user: lcarlp | |
| 21:59 | • Edit reply: 3.31.1: docs as PDF? artifact: 65e8aaf338 user: gisbert | |
| 20:19 | • Reply: 3.31.1: docs as PDF? artifact: 796f1ae8cc user: wmertens | |
| 20:13 | • Reply: Trivial typo in the documentation artifact: 3b8dd9552d user: gisbert | |
| 19:44 | • Reply: 3.31.1: docs as PDF? artifact: dbb774c9c1 user: drh | |
| 19:26 | • Reply: Trivial typo in the documentation artifact: 10e71583d8 user: gisbert | |
| 18:56 | • Reply: Select every nth record from table artifact: 76d8c2829d user: anonymous | |
| 18:41 | • Reply: Select every nth record from table artifact: 05f0deb25f user: cuz | |
| 18:35 | • Edit reply: Select every nth record from table artifact: 3fc26327de user: cuz | |
| 18:29 | • Reply: Select every nth record from table artifact: 100cb16f6e user: cuz | |
| 18:24 | • Post: Select every nth record from table artifact: ef0d35cb1f user: anonymous | |
| 17:56 | • Post: Quick lookup of like terms in FS5 index artifact: 2f174ed98a user: bbtmike | |
| 17:31 | • Reply: 3.31.1: docs as PDF? artifact: d09cce532b user: LarryBrasfield | |
| 17:23 | • Reply: shell's .load is pathSep picky artifact: 72b4d82b88 user: LarryBrasfield | |
| 16:58 | • Reply: shell's .load is pathSep picky artifact: 110ccf5653 user: gisbert | |
| 16:50 | • Reply: 3.31.1: docs as PDF? artifact: 1d9d14844a user: gisbert | |
| 16:45 | • Reply: 3.31.1: docs as PDF? artifact: b2d8f6d31c user: gisbert | |
| 12:12 | • Reply: 3.31.1: docs as PDF? artifact: 31b89150c4 user: drh | |
| 02:13 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: 9a049682f1 user: kmedcalf | |
| 01:17 | • Reply: 3.31.1: docs as PDF? artifact: 888ac6f905 user: wyoung | |