SQLite User Forum

Today In History
Login

This Day In History For 2024-04-09

1 Year Ago (more context)

2023-04-09
21:44 Post: Missed optimisation: consolidation of automatic indices artifact: f7ebff9d71 user: bjoern
20:05 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: ca9a388732 user: punkish
18:52 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 1f173cd9ea user: mgrmgr
18:04 Post: ANN DBHub.io - Share database with commits and/or live databases artifact: a7bdcebaf6 user: chrisjlocke1
17:36 Edit reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 279af2cb3f user: larrybr
17:07 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 91899e83c4 user: RichardDamon
16:11 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: f6ba5335e2 user: larrybr
15:35 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: b08e4e77b3 user: simonw
15:21 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: b254e322eb user: kmedcalf
14:56 Reply: WASM kvvfs in browser extension's background service workers artifact: 8895f63b0b user: tantaman
14:44 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 45f389d4d5 user: macsql20
14:43 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 178d5c9aa8 user: macsql20
14:28 Edit reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: bd3e36c1ec user: punkish
14:25 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: fdfeb7194d user: punkish
13:52 Reply: WASM kvvfs in browser extension's background service workers artifact: f19191a509 user: stephan
13:04 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 37ada671af user: RichardDamon
12:37 Edit reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 451c61ff63 user: punkish
12:23 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 3b7b47dfed user: simonw
12:22 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 70014e250f user: simonw
12:11 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 1328b51eb3 user: punkish
12:09 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: dff9c6cc93 user: punkish
11:21 Edit reply: WASM kvvfs in browser extension's background service workers artifact: 1ad1e66d2e user: tantaman
11:20 Reply: WASM kvvfs in browser extension's background service workers artifact: 0df8d5a9eb user: tantaman
11:16 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 8b4fbe715b user: RichardDamon
10:28 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 89d0e4b713 user: SeverKetor
10:20 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 143fd19861 user: punkish
09:31 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 4dd95b8768 user: SeverKetor
08:30 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 4c1b911f98 user: wzrlpy
08:16 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: bcdbf89e9c user: punkish
08:03 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: ee09f00a04 user: punkish
06:22 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: e1c39eb1fb user: simonw
05:59 Post: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: f1a9dd1e5f user: alexgarciaxyz

2 Years Ago (more context)

2022-04-09
20:12 Reply: .show artifact: 312e6f46b7 user: larrybr
18:58 Edit reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: b442fba047 user: larrybr
18:53 Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: c0be3a3419 user: larrybr
17:51 Reply: High level C interface to sqlite3 artifact: 98b9795ede user: vman59
17:46 Reply: High level C interface to sqlite3 artifact: 2cff462de4 user: bjoern
16:21 Reply: High level C interface to sqlite3 artifact: aa689c1522 user: dkfellows
15:55 Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 8e2441cbc2 user: mark
15:52 Edit reply: caching SQLite database. artifact: d07b95a55e user: sqlitening
15:51 Edit reply: caching SQLite database. artifact: a409d0dd02 user: sqlitening
15:50 Edit reply: caching SQLite database. artifact: 3977a11c67 user: sqlitening
15:49 Edit reply: caching SQLite database. artifact: e1c65c5add user: sqlitening
15:43 Edit reply: caching SQLite database. artifact: a4f9ecb996 user: sqlitening
15:40 Edit reply: caching SQLite database. artifact: d5d55584f1 user: sqlitening
15:38 Reply: caching SQLite database. artifact: 70cdfcd3f0 user: sqlitening
15:19 Reply: caching SQLite database. artifact: 3628e243a8 user: larrybr
15:03 Edit reply: caching SQLite database. artifact: 8b38fac64c user: larrybr
14:47 Reply: caching SQLite database. artifact: ff8e404616 user: slavin
14:43 Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 7136c07977 user: anonymous
03:53 Reply: caching SQLite database. artifact: 4b17a8c5d4 user: larrybr
00:21 Reply: Virtual Table Joins with Repeated calls to xFilter artifact: e8c9fb0bf1 user: anonymous

3 Years Ago (more context)

2021-04-09
23:54 Post: group_concat with distinct and custom seperator artifact: 2176cb2d14 user: Cieric
23:19 Reply: meaning of "GROUP BY CONSTANT" artifact: ba02d83200 user: krking
19:16 Reply: impact of cache_size artifact: d7b2a32bfd user: kmedcalf
18:09 Reply: impact of cache_size artifact: 49f7f3f23a user: kasztelan77
18:03 Reply: meaning of "GROUP BY CONSTANT" artifact: 189a62e695 user: kmedcalf
17:15 Edit: meaning of "GROUP BY CONSTANT" artifact: 2f5e972667 user: krking
16:43 Post: meaning of "GROUP BY CONSTANT" artifact: b2c0ab740e user: krking
15:21 Reply: Question .open chinook.db artifact: 943baf3481 user: anonymous
15:15 Reply: Question .open chinook.db artifact: 50221da653 user: anonymous
14:59 Reply: Question .open chinook.db artifact: 5ee770b279 user: anonymous
14:42 Reply: Question .open chinook.db artifact: 719684ed5c user: larrybr
14:17 Post: Question .open chinook.db artifact: e9b5abf69c user: anonymous
07:18 Delete reply: json_contains Function Idea artifact: 57536f3aeb user: ddevienne
07:17 Reply: json_contains Function Idea artifact: 19e59eee76 user: ddevienne
06:26 Edit reply: index misuse? artifact: 7e7e58795f user: wulian
05:52 Edit reply: index misuse? artifact: 55acfa4cf9 user: wulian
05:21 Reply: index misuse? artifact: 14ec6dd76a user: wulian
01:01 Reply: how to pre allocate my SQLite database to a certain size artifact: 53d1e08709 user: anonymous

4 Years Ago (more context)

2020-04-09
22:53 Post: Application ID for TeXnicard artifact: 21288bfa84 user: anonymous
22:47 Post: szExtra must be at least sizeof(void*) artifact: 53ad08571e user: anonymous
22:08 Edit reply: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: 31768b9886 user: andreas-kupries
22:08 Post: Return boolean if item EXISTS in database artifact: 14b8a89edd user: PongoZ
22:03 Reply: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: 8ea5bd3498 user: andreas-kupries
21:43 Reply: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: 4c9ba4f8a0 user: pooryorick
21:37 Reply: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: ce14f3ab65 user: andreas-kupries
21:15 Post: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: 4638e41470 user: pooryorick
19:48 Reply: Forum Critique artifact: e0a108901d user: Clothears
19:47 Reply: Select Query will not work in PHP program artifact: 49d80e6847 user: gonzus
19:30 Reply: 3.31.1: docs as PDF? artifact: 6f91b37116 user: resuna
18:47 Reply: Forum Critique artifact: a21a11cc17 user: LarryBrasfield
18:41 Reply: Forum Critique artifact: ae7bafe42d user: wyoung
17:56 Reply: Forum Critique artifact: d78f10117e user: stephan
17:51 Reply: Forum Critique artifact: 254bdc407f user: pizzipie
17:08 Reply: Forum Critique artifact: 7a31136db1 user: LarryBrasfield
17:04 Reply: Select Query will not work in PHP program artifact: ddf0214433 user: pizzipie
16:28 Reply: Forum Critique artifact: 365163a320 user: pizzipie
16:27 Reply: Select Query will not work in PHP program artifact: 5031dff62b user: knu
16:16 Reply: Select Query will not work in PHP program artifact: 27c5b43dd4 user: pizzipie
11:23 Reply: Retrieve match context with FTS5 artifact: 00d53dbed1 user: dan
06:21 Post: WinRT build fixes artifact: a6344c9725 user: robux4
05:13 Edit reply: shell's .load is pathSep picky artifact: 618c868130 user: LarryBrasfield
05:11 Reply: shell's .load is pathSep picky artifact: 3f330be12e user: LarryBrasfield
04:35 Reply: Forum Critique artifact: 6023b3f97c user: wyoung
03:31 Reply: Forum Critique artifact: 01059ed212 user: wyoung
02:42 Post: Forum Critique artifact: fc5c79b7c9 user: pizzipie
02:18 Reply: Bug in ALTER TABLE ADD COLUMN artifact: b7a6dcde07 user: anonymous
02:13 Reply: Select Query will not work in PHP program artifact: 28bbec56d8 user: anonymous
01:58 Reply: Select Query will not work in PHP program artifact: a33655c3c6 user: pizzipie
01:31 Reply: Select Query will not work in PHP program artifact: 1119642f41 user: jking
01:21 Post: Select Query will not work in PHP program artifact: b0ae009d76 user: pizzipie