SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 forum posts by user simonw occurring on or before 2021-04-04 23:40:35.

2021-04-04
23:40 Edit: For a given SQL query, mechanisms for figuring out which physical columns would be returned? (artifact: 81976ebc35 user: simonw)
23:37 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? (artifact: 061b8bf9f9 user: simonw)
23:19 Post: For a given SQL query, mechanisms for figuring out which physical columns would be returned? (artifact: 0180277fb7 user: simonw)
2021-03-12
23:52 Reply: Inserting the image as BLOB (artifact: b396eeccd2 user: simonw)
23:26 Edit: "SQL Features That SQLite Does Not Implement" needs updating (artifact: 6690bfb7d3 user: simonw)
23:26 Post: "SQL Features That SQLite Does Not Implement" needs updating (artifact: d6dff461f9 user: simonw)
2021-02-19
22:30 Edit: SQLite database in space? (artifact: d623ddc90e user: simonw)
22:29 Post: SQLite database in space? (artifact: b61c0395ba user: simonw)
2020-11-17
17:12 Reply: FYI: Personal Data Warehouses: Reclaiming Your Data (artifact: eb151f3a30 user: simonw)
2020-11-08
18:14 Edit: sqlite-utils 3.0: CLI tool can now execute FTS seaches against a .db file (artifact: 3712b1f43d user: simonw)
17:50 Post: sqlite-utils 3.0: CLI tool can now execute FTS seaches against a .db file (artifact: 8467b73d34 user: simonw)
2020-10-12
22:17 Reply: Most efficient way to tell if any database content has changed (artifact: 6cbd42a6bf user: simonw)
18:55 Edit: Most efficient way to tell if any database content has changed (artifact: 34b89f2ff1 user: simonw)
18:55 Edit: Most efficient way to tell if any database content has changed (artifact: e879702045 user: simonw)
18:54 Post: Most efficient way to tell if any database content has changed (artifact: 337bf94e26 user: simonw)
2020-10-08
03:06 Reply: Insert ("slurp" ?) JSON documents (artifact: 3733efdcb6 user: simonw)
03:06 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: a7624e9747 user: simonw)
2020-10-06
01:10 Reply: Insert ("slurp" ?) JSON documents (artifact: f20e8b409b user: simonw)
2020-09-28
16:33 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: 67b08938fe user: simonw)
01:45 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: 6952c2332c user: simonw)
2020-09-27
20:43 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: b445365ed0 user: simonw)
20:29 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: b4179cb0b6 user: simonw)
20:22 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: 054532e0ce user: simonw)
20:20 Edit reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: efea14aa4f user: simonw)
20:17 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: 5a669534c3 user: simonw)
05:02 Edit reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: 20bdcda226 user: simonw)
05:02 Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: d9ab9a47e7 user: simonw)
2020-09-26
17:43 Post: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) (artifact: ab0dcd66ef user: simonw)
2020-09-24
17:52 Reply: sqlite-utils transform - command-line tool implementing the advanced ALTER TABLE pattern (artifact: e65caafb51 user: simonw)
2020-09-23
17:48 Reply: sqlite-utils transform - command-line tool implementing the advanced ALTER TABLE pattern (artifact: 125001b7aa user: simonw)
03:04 Edit: sqlite-utils transform - command-line tool implementing the advanced ALTER TABLE pattern (artifact: 16412b1c5f user: simonw)
01:54 Post: sqlite-utils transform - command-line tool implementing the advanced ALTER TABLE pattern (artifact: 447f11d6fe user: simonw)
2020-09-18
23:19 Reply: Concurrent Multiple Write Transactions (artifact: 92a3c9808a user: simonw)
20:58 Reply: Trigram indexes for SQLite (artifact: 69731fbe35 user: simonw)
20:56 Reply: Trigram indexes for SQLite (artifact: c9134df64e user: simonw)
2020-09-17
14:59 Reply: Trigram indexes for SQLite (artifact: ca5e2aa8dd user: simonw)
01:52 Reply: Trigram indexes for SQLite (artifact: 0909d9f483 user: simonw)
01:49 Reply: Trigram indexes for SQLite (artifact: 36e0d67867 user: simonw)
2020-09-16
22:07 Edit: Trigram indexes for SQLite (artifact: c230760fdf user: simonw)
22:06 Post: Trigram indexes for SQLite (artifact: 0387aa9b10 user: simonw)
2020-09-08
23:41 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: d9ed879935 user: simonw)
17:08 Reply: sqlite-utils: a command-line tool and Python utility library (artifact: 76cc460c6c user: simonw)
2020-09-07
23:16 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: c6b2477889 user: simonw)
22:52 Post: sqlite-utils: a command-line tool and Python utility library (artifact: ff5b6198eb user: simonw)
20:48 Edit reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: 58364d06b8 user: simonw)
20:18 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: 61ef49c3aa user: simonw)
20:00 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: 857cedf396 user: simonw)
19:53 Edit reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: d7f0ea4e66 user: simonw)
19:53 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: 927889ee3b user: simonw)
19:11 Reply: SQLite FTS5 table with 7 rows has _fts_docsize table with 9,141 rows (artifact: 619b428c37 user: simonw)