SQLite Forum

Timeline
Login

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

50 events by user simonw occurring around 2020-11-08 18:14:19.

2021-07-16
18:40 Edit: Tips for getting SQLite under Python to perform better with more RAM? artifact: f6bdd6b503 user: simonw
18:26 Reply: Should SQLite be able to optimize this query? artifact: faf982aced user: simonw
18:23 Post: Tips for getting SQLite under Python to perform better with more RAM? artifact: 9e15765874 user: simonw
01:50 Reply: Should SQLite be able to optimize this query? artifact: 6ecf3cab23 user: simonw
2021-07-15
19:45 Reply: Should SQLite be able to optimize this query? artifact: 8ada395a25 user: simonw
17:52 Reply: Should SQLite be able to optimize this query? artifact: 0212439555 user: simonw
16:40 Reply: Should SQLite be able to optimize this query? artifact: 5d14ed56db user: simonw
16:32 Reply: Should SQLite be able to optimize this query? artifact: 466c8fec3b user: simonw
16:31 Reply: Should SQLite be able to optimize this query? artifact: 91c56240d2 user: simonw
16:07 Post: Should SQLite be able to optimize this query? artifact: 2d76f2bcf6 user: simonw
2021-04-11
15:05 Reply: deploying 1_000_000 sqlitedb on AWS? artifact: e529ede831 user: simonw
2021-04-05
03:39 Edit reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: e20f3d0861 user: simonw
03:39 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 5b6f7e7ee5 user: simonw
03:38 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 04033829a0 user: simonw
01:17 Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 2258454563 user: simonw
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