Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user simonw
2024-02-17
| ||
20:13 | • Reply: best way to replace a database that's serving queries (artifact: 2e6878e80a user: simonw) | |
20:05 | • Post: best way to replace a database that's serving queries (artifact: d0c953ef11 user: simonw) | |
2023-11-01
| ||
15:55 | • Reply: "Why you should probably be using SQLite" (artifact: a3eb31c9db user: simonw) | |
2023-09-21
| ||
17:13 | • Edit: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 3ca42d99e7 user: simonw) | |
17:12 | • Edit: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: c8afac9b14 user: simonw) | |
17:03 | • Reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 36cac35714 user: simonw) | |
16:53 | • Reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 2dfa4ca556 user: simonw) | |
2023-09-20
| ||
21:58 | • Edit reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 999a7874f0 user: simonw) | |
21:56 | • Edit reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 6c1692830d user: simonw) | |
21:55 | • Reply: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: 225f06504a user: simonw) | |
21:50 | • Post: SQLITE_CREATE_INDEX and SQLITE_CREATE_TABLE authorizer operations (artifact: cf4d6dea04 user: simonw) | |
2023-09-18
| ||
20:06 | • Reply: Are the rowid values in a Geopoly table stable? (artifact: 9e82192137 user: simonw) | |
2023-09-12
| ||
01:25 | • Reply: Are the rowid values in a Geopoly table stable? (artifact: 9834724f0f user: simonw) | |
00:14 | • Post: Are the rowid values in a Geopoly table stable? (artifact: abf82ebb53 user: simonw) | |
2023-07-24
| ||
17:15 | • Post: sqlite-utils now supports plugins (artifact: d03ed032bd user: simonw) | |
2023-04-12
| ||
01:56 | • Edit reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" (artifact: 2e0136b727 user: simonw) | |
01:56 | • Reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" (artifact: 59b4475b76 user: simonw) | |
2023-04-11
| ||
23:37 | • Post: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" (artifact: 793a2ed75b user: simonw) | |
23:17 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: b478c10072 user: simonw) | |
22:05 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: fcd2b3eab7 user: simonw) | |
22:05 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: b91d165dc7 user: simonw) | |
14:15 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: c858a0de0c user: simonw) | |
14:14 | • Reply: Possible to turn off "defensive" mode using a SQL query? (artifact: a621d9baf3 user: simonw) | |
02:55 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: bac984946a user: simonw) | |
02:45 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: fc9d80cd2a user: simonw) | |
02:40 | • Edit: Possible to turn off "defensive" mode using a SQL query? (artifact: 29393af809 user: simonw) | |
02:39 | • Post: Possible to turn off "defensive" mode using a SQL query? (artifact: 91f2fe5049 user: simonw) | |
2023-04-09
| ||
15:35 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: b08e4e77b3 user: simonw) | |
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) | |
06:22 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: e1c39eb1fb user: simonw) | |
2023-01-19
| ||
22:58 | • Reply: One base and several applications (artifact: 81238533ce user: simonw) | |
2022-11-16
| ||
19:44 | • Post: Is rootpage a stable identifier for a table? (artifact: 29bbe40e25 user: simonw) | |
2022-09-20
| ||
03:30 | • Edit reply: Tips for debugging a "SQL logic error"? (artifact: 348d481b7a user: simonw) | |
03:22 | • Edit reply: Tips for debugging a "SQL logic error"? (artifact: 1c3b17d80b user: simonw) | |
03:20 | • Reply: Tips for debugging a "SQL logic error"? (artifact: 151e21b023 user: simonw) | |
2022-09-19
| ||
16:43 | • Edit: Tips for debugging a "SQL logic error"? (artifact: 8c6eacc291 user: simonw) | |
16:43 | • Post: Tips for debugging a "SQL logic error"? (artifact: a7573a5f8f user: simonw) | |
2022-09-16
| ||
21:29 | • Edit reply: Avoiding {"tag": null} in results from a json_group_array() aggregation (artifact: 5804b03c6a user: simonw) | |
21:28 | • Reply: Avoiding {"tag": null} in results from a json_group_array() aggregation (artifact: cbbcd1b32a user: simonw) | |
20:04 | • Edit: Avoiding {"tag": null} in results from a json_group_array() aggregation (artifact: a8866487df user: simonw) | |
19:59 | • Post: Avoiding {"tag": null} in results from a json_group_array() aggregation (artifact: 430dd60b42 user: simonw) | |
2022-09-07
| ||
21:46 | • Edit reply: Inserting rows of varying lengths into SQLite3 Database with Python (artifact: e663a27d08 user: simonw) | |
21:45 | • Reply: Inserting rows of varying lengths into SQLite3 Database with Python (artifact: 33575b6e57 user: simonw) | |
00:49 | • Reply: Dense vector search in SQLite? (artifact: 3f6ddc34dc user: simonw) | |
00:14 | • Reply: Dense vector search in SQLite? (artifact: 37b710f2da user: simonw) | |
2022-09-06
| ||
14:33 | • Reply: Dense vector search in SQLite? (artifact: 2289c8082e user: simonw) | |
2022-09-05
| ||
18:12 | • Post: Dense vector search in SQLite? (artifact: cfd91b9366 user: simonw) | |
2022-08-01
| ||
01:21 | • Reply: New tutorial: Cleaning data with sqlite-utils and Datasette (artifact: bcec3281fa user: simonw) | |
2022-07-31
| ||
23:08 | • Post: New tutorial: Cleaning data with sqlite-utils and Datasette (artifact: af260ae0d0 user: simonw) | |