SQLite Forum

Timeline
Login

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

50 most recent forum posts by user knu

2024-03-15
19:46 Reply: calculate the hamming distance between a table column signed integer and a provided signed integer (artifact: 6eae4a3659 user: knu)
13:34 Reply: How do I know if a db file has registered the sqlite3_update_hook callback? (artifact: 390ef6ca3e user: knu)
2024-03-03
15:06 Reply: pretty print JSON (artifact: 38654ed07a user: knu)
2024-02-20
00:15 Delete reply: Using a SQLite DB as a file system ? Mount it ! (artifact: f252b98113 user: knu)
2024-02-19
14:59 Reply: Using a SQLite DB as a file system ? Mount it ! (artifact: 0e10108efa user: knu)
2024-02-02
14:17 Reply: Existing table not found with PHP query (artifact: 3af919a8c9 user: knu)
2024-02-01
13:12 Reply: Existing table not found with PHP query (artifact: 8a9ba4941f user: knu)
2024-01-31
02:22 Reply: Generated field(s) contraint not copied to new table (artifact: 567b851a92 user: knu)
2024-01-29
14:54 Reply: Feature Request : Get table name alias from prepared statement (artifact: 150e2465e9 user: knu)
2024-01-27
13:46 Reply: SQLite3.EXE at the command prompt (artifact: f8ca4cfa1c user: knu)
2024-01-22
15:43 Reply: SQLite sharding/partitioning performance (artifact: a9cbd06da1 user: knu)
2024-01-14
12:19 Reply: CLI inserting blank lines between each row (artifact: 3a0a9b5fef user: knu)
2024-01-10
16:20 Reply: Lock database file (artifact: 44576f4ae9 user: knu)
2024-01-05
20:53 Reply: Upcoming SQLite 3.45.0 release (artifact: 60e8c2f42e user: knu)
2023-12-25
17:03 Reply: Using names for variables for table and field names (artifact: 9c088790a1 user: knu)
15:52 Reply: Using names for variables for table and field names (artifact: 0c5f6ff14b user: knu)
2023-11-23
18:04 Reply: WAL help: database deleted, but SQLite doesn't return SQLITE_READONLY_DBMOVED (artifact: c89e0ee3fe user: knu)
2023-09-14
09:47 Reply: Disabling recursive triggers not working (artifact: c7987d2c69 user: knu)
2023-09-07
08:46 Reply: forum capability upgrade request, "mark favorites" (artifact: e3a1d9d5b2 user: knu)
2023-09-01
16:23 Reply: SQLite and SQL Guru Keith (artifact: bfdacde236 user: knu)
14:30 Reply: SQLite and SQL Guru Keith (artifact: a994bf86c9 user: knu)
2023-07-20
16:05 Reply: timediff() (artifact: d2157f6ae1 user: knu)
14:53 Reply: timediff() (artifact: 6980f38826 user: knu)
2023-07-13
08:05 Reply: Upsert - is there a way to find out if an insert or update happened? (artifact: 938cf9fc50 user: knu)
2023-06-14
09:52 Reply: "PRAGMA journal_mode" without effect ? (artifact: 87df483758 user: knu)
2023-06-13
08:02 Reply: File is encrypted or is not a database (artifact: 5be39562af user: knu)
2023-06-01
11:05 Reply: Forcing read only access (artifact: 770478c03f user: knu)
2023-05-30
23:05 Reply: Forcing read only access (artifact: c3a72ea490 user: knu)
2023-05-28
14:19 Reply: Why is DuckDB's window function more than 20 times faster than SQLite? (artifact: a5e27d8060 user: knu)
11:40 Reply: Missing metadata (artifact: b2fa778c01 user: knu)
2023-05-27
12:51 Reply: Column Default value (artifact: 0fa08e054b user: knu)
2023-05-25
14:27 Edit reply: Performance of REPLACE (artifact: 15ef16e182 user: knu)
12:51 Reply: Performance of REPLACE (artifact: 1d4d7d8a9a user: knu)
2023-05-20
12:01 Reply: SEE DecryptLegacyDatabase and few queston (artifact: b59f6a073e user: knu)
2023-05-14
10:16 Reply: Secure delete/overwrite data (artifact: 0573cb1900 user: knu)
2023-05-13
11:57 Reply: malformed database error when creating a view with an explicit database name and reattaching under a different name (artifact: b99debbc39 user: knu)
2023-05-09
14:27 Reply: System.Data.SQLite Help File Unreadable (artifact: a931372164 user: knu)
2023-05-08
21:53 Reply: System.Data.SQLite Help File Unreadable (artifact: f18085be1d user: knu)
2023-04-22
14:49 Reply: UPSERT oddity (artifact: 24877c1ad2 user: knu)
2023-04-06
10:38 Reply: Uniqueidentifier column (artifact: 480b68b503 user: knu)
2023-03-30
23:12 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 (artifact: cfaa9a4ee0 user: knu)
22:24 Reply: before insert trigger (artifact: 59cb085a27 user: knu)
20:34 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 (artifact: 3ac2059ce5 user: knu)
11:18 Reply: before insert trigger (artifact: 2878946194 user: knu)
2023-03-29
22:35 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 (artifact: 2669911f24 user: knu)
14:42 Reply: Dot Commands (artifact: cd4dc0b61f user: knu)
2023-03-28
12:42 Reply: Uniqueidentifier column (artifact: f8048b93b1 user: knu)
2023-03-27
20:04 Reply: Uniqueidentifier column (artifact: f4b620ef42 user: knu)
2023-03-15
13:48 Reply: Subtract in select (artifact: 8e635cd157 user: knu)
2023-02-27
12:30 Reply: JSON_GROUP_ARRAY behaviour change in 3.39.0 (artifact: e5999a1493 user: knu)