Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user knu
2024-04-16
| ||
12:12 | • Reply: Is table creation linear-time operation with respect to the number of objects in the schema table? (artifact: 5d92e8a6c9 user: knu) | |
2024-04-07
| ||
15:28 | • Reply: Who is the culpit? (artifact: e1204377cc user: knu) | |
2024-04-05
| ||
20:52 | • Reply: pointers on structuring data (artifact: b38867acf9 user: knu) | |
13:17 | • Reply: .mode html (artifact: fa6853d528 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) | |