SQLite Forum

Timeline
Login

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

52 events for the month beginning 2023-04-01 by user drh

Following month ↑
2023-04-30
22:28 Edit reply: JSON5 support - feedback request artifact: e7948cf870 user: drh
22:22 Edit: JSON5 support - feedback request artifact: dbd4dc723c user: drh
22:17 Reply: JSON5 support - feedback request artifact: 7a105c00ca user: drh
2023-04-29
18:41 Edit: JSON5 support - feedback request artifact: 6106ace7cc user: drh
18:34 Post: JSON5 support - feedback request artifact: 3044b3db95 user: drh
2023-04-26
20:37 Reply: Should SQLite support JSON5? artifact: ace1c19caf user: drh
14:03 Reply: Should SQLite support JSON5? artifact: c7d244483c user: drh
12:45 Reply: Improve initial insert performance of rtree index artifact: 06ea47ca01 user: drh
2023-04-25
12:13 Reply: Inconsistance between CLI and JDBC on JOIN artifact: 637e99e5d4 user: drh
2023-04-24
19:42 Reply: Improve initial insert performance of rtree index artifact: 58b4933575 user: drh
17:43 Post: Should SQLite support JSON5? artifact: d16d4e7154 user: drh
15:59 Reply: Improve initial insert performance of rtree index artifact: b0ce89838e user: drh
2023-04-23
15:42 Reply: Assertion failure in sqlite3BtreeInsert function artifact: 3269106c91 user: drh
2023-04-22
13:20 Reply: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: cdad60b640 user: drh
2023-04-21
18:53 Reply: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: 65a1979efc user: drh
15:46 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 867adfcdbd user: drh
11:25 Reply: A possible resource leak in shell.c artifact: 2bd11fbf3d user: drh
2023-04-20
17:27 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 473ea1d30b user: drh
16:10 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 1c9e8bd645 user: drh
12:36 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 57ca09794e user: drh
12:35 Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 0d3926a2b7 user: drh
11:25 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 4e3b0ec234 user: drh
10:41 Reply: SQLITE_PRIVATE declaration missing on sqlite3VdbeGetLastOp? artifact: 4ddbd9429e user: drh
2023-04-19
22:21 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: f20a7f6a11 user: drh
14:02 Edit reply: Hi, I don't know SQL but I need to contact an admin on this site artifact: 0091a53a75 user: drh
13:53 Reply: Hi, I don't know SQL but I need to contact an admin on this site artifact: 990d8cf5a6 user: drh
12:48 Reply: No download file for Apple Silicon exists in the download page artifact: ad56855141 user: drh
12:07 Reply: Different behavior between insert and prepare commands artifact: 253995f302 user: drh
00:51 Edit: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 9aae136689 user: drh
2023-04-18
17:02 Reply: Assertion failure in sqlite3_test_control function artifact: 274262a016 user: drh
14:18 Reply: Bug in 3.41.2: Index on expression causes query to return wrong result artifact: 7b05031344 user: drh
12:35 Reply: where clause in on conflict upsert statement is ignored artifact: 1195dfcd19 user: drh
2023-04-14
11:11 Reply: Heap buffer overflow in sqlite3StrICmp function artifact: 0d3bbc22a9 user: drh
2023-04-12
14:39 Reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: 43f9b849f4 user: drh
2023-04-11
17:28 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: e6d4341491 user: drh
11:08 Reply: Possible to turn off "defensive" mode using a SQL query? artifact: 8a3ac5481a user: drh
10:22 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 5e4c6bb455 user: drh
2023-04-10
22:47 Reply: Planner chooses slow index scan over fast nested search artifact: a395e45123 user: drh
22:40 Reply: Planner chooses slow index scan over fast nested search artifact: 75a41cf096 user: drh
18:49 Reply: Assertion failure in sqlite3VdbeExec function artifact: 4d62fac9fa user: drh
11:36 Reply: Planner chooses slow index scan over fast nested search artifact: 9f662e9489 user: drh
10:56 Reply: Accessing schema table for attached db artifact: c8ef4fade0 user: drh
10:49 Reply: random() in a subquery produces a column with an inconsistent value artifact: adcaf02266 user: drh
2023-04-08
12:19 Edit reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 0ca0a21514 user: drh
12:17 Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 5ff3a97c62 user: drh
2023-04-07
21:09 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: b2e2e66e5c user: drh
18:01 Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 3e0aba736f user: drh
2023-04-05
12:15 Reply: A question about CAST artifact: 6bb41eaf50 user: drh
2023-04-03
10:49 Reply: On secondary indexes is rowid automatically sorted artifact: aea4c60cc1 user: drh
10:45 Reply: Is SHM needed for Main DB? artifact: 101de816f3 user: drh
10:37 Reply: base64.c is executable? artifact: 85a2ad5da5 user: drh
2023-04-01
15:33 Reply: Optimizing JSON filter by syntheszing a LIKE artifact: b5b77f8f4f user: drh
Previous month ↓