SQLite Forum

Timeline
Login

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

50 most recent forum posts by user drh

2024-04-16
14:05 Reply: How can I compile and use ZIPVFS with System.Data.SQLite for Linux/iOS/Android ? (artifact: aac6975345 user: drh)
13:58 Reply: Crowdstrike falcond and Sqlite3 (artifact: 290bfad302 user: drh)
13:54 Reply: Is table creation linear-time operation with respect to the number of objects in the schema table? (artifact: 6c349f2754 user: drh)
12:14 Reply: Is table creation linear-time operation with respect to the number of objects in the schema table? (artifact: 63331dda27 user: drh)
11:05 Reply: Crowdstrike falcond and Sqlite3 (artifact: 4151cdfde6 user: drh)
2024-04-15
20:07 Reply: Sqlite on S390x architecture? (artifact: 368749dd09 user: drh)
2024-04-13
12:31 Reply: changed objectlabel format in path output of json_tree() (artifact: 878ddb72bc user: drh)
2024-04-12
19:51 Reply: (Deleted) (artifact: 1c668a4195 user: drh)
15:53 Reply: Inconsistent values in trigger from UPSERT (artifact: 735b465dd2 user: drh)
01:39 Reply: Inconsistent values in trigger from UPSERT (artifact: ed031e8e3e user: drh)
2024-04-11
23:42 Edit reply: Inconsistent values in trigger from UPSERT (artifact: ad1e2c9aa7 user: drh)
23:21 Reply: Inconsistent values in trigger from UPSERT (artifact: 7fae9f4735 user: drh)
15:20 Reply: sqlite3_bind_blob unable to bind empty byte array (artifact: 9416328a51 user: drh)
10:43 Reply: sqlite3_bind_blob unable to bind empty byte array (artifact: 1390db31d0 user: drh)
09:38 Reply: Wrong SHA256 for current downloads (artifact: 50f700c36c user: drh)
2024-04-10
13:47 Reply: Blocked IP range (artifact: 64d61454ec user: drh)
13:34 Reply: Blocked IP range (artifact: 957dab7983 user: drh)
2024-04-09
14:36 Reply: WAL on network filesystems (artifact: 1d43eb1914 user: drh)
14:11 Reply: VACUUM INTO fails on DB with virtual colums (artifact: ef21284814 user: drh)
14:06 Reply: WAL on network filesystems (artifact: b9742cf8d4 user: drh)
2024-04-08
08:09 Reply: Slow query not using primary key for group by min/max (artifact: d80e187835 user: drh)
08:07 Edit: Slow query not using primary key for group by min/max (artifact: 60e33b0e9f user: drh)
2024-04-07
15:19 Reply: Who is the culpit? (artifact: d0a74ac398 user: drh)
2024-04-05
13:08 Reply: .mode html (artifact: d69cf53059 user: drh)
2024-04-03
18:25 Reply: Rootpage and sqlite_master (artifact: 11af6e8a66 user: drh)
14:15 Reply: attaching database while restoring from hot journal yields SQLITE_BUSY (artifact: 403da46366 user: drh)
2024-04-02
00:30 Reply: views based on cte (artifact: d570db6918 user: drh)
2024-04-01
22:21 Reply: Create Table Foreign Key Clause Syntax Diagram Issue? (artifact: 547774ad38 user: drh)
10:09 Reply: SQLite Tcl interface: Where to place the commit? (artifact: 5354ffb531 user: drh)
2024-03-30
13:19 Reply: sqlite3 API: Inconsistency in size limits? (artifact: 3a2e5df51c user: drh)
2024-03-29
00:26 Reply: Variant values (artifact: 14a6577671 user: drh)
2024-03-28
15:37 Reply: ROW_NUMBER() and ORDER BY (artifact: eac641c1b8 user: drh)
12:39 Reply: Lock-Byte Page Size (artifact: c84f915f79 user: drh)
2024-03-27
16:30 Reply: Incorrect query result caused by large number comparison (artifact: a577499529 user: drh)
2024-03-25
19:06 Reply: VACUUM after ALTER TABLE (artifact: 2a8121c756 user: drh)
11:37 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 20883b9597 user: drh)
11:10 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 84634ed443 user: drh)
2024-03-24
22:13 Edit reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 2ffa2c528d user: drh)
22:12 Reply: Why do I need to LEFT JOIN pragma_table_info() ? (artifact: 5923058bd9 user: drh)
19:14 Reply: Coverity issue (artifact: cb728b71a8 user: drh)
2024-03-23
12:16 Reply: sqlite3_analyzer.exe as a standalone executable? (artifact: 6d7fd48e53 user: drh)
12:02 Delete reply: CLI - JSON odd? (artifact: 8940e5c711 user: drh)
12:02 Reply: CLI - JSON odd? (artifact: 9a0997c3e4 user: drh)
12:01 Reply: CLI - JSON odd? (artifact: 2a24b3a9fa user: drh)
2024-03-22
16:27 Reply: In-place VACUUM 20x slower than VACUUM INTO (artifact: d9f82b4dff user: drh)
14:00 Reply: Any documentation about .stats on ? (artifact: 9f183f7305 user: drh)
2024-03-21
00:54 Reply: UDF running own SQL (artifact: 0f8ad18165 user: drh)
00:44 Reply: Does SQLite have HOT updates, and optimized non-blob field updates? (artifact: e139405b1f user: drh)
2024-03-19
16:24 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: 4421827feb user: drh)
16:05 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: 9aee75cc7a user: drh)