SQLite Forum

Timeline
Login

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

50 most recent forum posts by user billwade

2024-03-11
12:12 Reply: UTF16 string binding issue (artifact: 644b0e11f2 user: billwade)
2024-03-06
13:42 Reply: Index doesn't have expected performance benefit (artifact: f2bb9c53de user: billwade)
2024-02-19
17:29 Reply: Requested function: strhash (artifact: 5cd09cd952 user: billwade)
2024-01-25
15:00 Reply: Modified pages in the WAL? Why? (artifact: 44ca5475e6 user: billwade)
2024-01-24
21:02 Reply: Modified pages in the WAL? Why? (artifact: 743ebbb75c user: billwade)
2024-01-23
14:21 Reply: high performance mode for sqlite (artifact: 31d3a30691 user: billwade)
2024-01-17
13:45 Reply: high performance mode for sqlite (artifact: a901ccfbfb user: billwade)
13:06 Reply: Copy two database files locally from master to slave (artifact: ecb36b99a6 user: billwade)
2024-01-03
15:28 Post: RAISE(IGNORE) documentation (artifact: 315f6b260d user: billwade)
2024-01-02
20:55 Edit reply: Is Insert Many Rows atomic operation? (artifact: a86e7484dc user: billwade)
19:45 Delete reply: Is Insert Many Rows atomic operation? (artifact: 39a577f2ac user: billwade)
19:44 Reply: Is Insert Many Rows atomic operation? (artifact: 8b25400d4e user: billwade)
19:39 Reply: Is Insert Many Rows atomic operation? (artifact: 9b357d646b user: billwade)
2023-11-10
13:06 Reply: date function is broken (artifact: bd44cb48e0 user: billwade)
2023-11-07
14:28 Reply: Sqlite as a backend of IPC mechanism. (artifact: fb7bcda7cd user: billwade)
2023-10-02
12:01 Reply: Incorrect result with TOTAL Function on rtree table (artifact: e3d5faad95 user: billwade)
2023-07-24
13:10 Post: Copy with shell (artifact: b04005bc65 user: billwade)
2022-11-17
12:53 Reply: WAL Mode Concurrent Read/Writes via JNI in the same process (artifact: c8648dc610 user: billwade)
2022-10-20
13:29 Reply: strftime and CHECK (artifact: 3bc8fb80a6 user: billwade)
2022-10-19
14:48 Post: strftime and CHECK (artifact: d3f235e5e6 user: billwade)
2022-07-26
13:06 Reply: Deterministic and consistent .schema of the CLI (artifact: d9a39dc43f user: billwade)
2022-06-27
11:58 Reply: Why UPDATEs are faster when WHERE key is sorted? How to improve performance? (artifact: 865b4d5184 user: billwade)
2022-05-23
12:09 Reply: Ambiguous Reference Error for Right Join (artifact: 8c88174f0a user: billwade)
2022-05-16
19:23 Reply: Inserting into two tables in one statement, one of which requires a foreign key reference to the other? (artifact: bd651b735f user: billwade)
2022-04-26
11:20 Reply: sqlite db design question (artifact: 0917f9a9c8 user: billwade)
2022-04-20
12:36 Reply: Integer division (artifact: 9f9c8f2342 user: billwade)
2022-04-19
14:12 Reply: How do I remove column wraps? (artifact: a7efd03377 user: billwade)
2022-04-18
20:42 Reply: Integer division (artifact: 4351d21810 user: billwade)
18:56 Post: Integer division (artifact: ea04405b27 user: billwade)
2022-04-15
19:12 Reply: Order of Unique constraint has influence of insert speed? (artifact: 4f4ca87e43 user: billwade)
17:48 Reply: Order of Unique constraint has influence of insert speed? (artifact: f4cfc420e6 user: billwade)
2022-03-23
11:22 Reply: strftime and utc (artifact: 8a6131e532 user: billwade)
2022-03-03
15:55 Reply: (Deleted) (artifact: 22fe750012 user: billwade)
2022-03-01
19:41 Reply: IEEE 754 canonicalization in SQLite (artifact: 3ada74e29b user: billwade)
2022-02-10
15:38 Reply: sqlite3_open_v2 not failing for non-SQLite file. (artifact: 4d036559ee user: billwade)
14:58 Reply: A name disambiguation challenge (artifact: a1bb4cae2f user: billwade)
14:41 Reply: A name disambiguation challenge (artifact: 9ed084bdc9 user: billwade)
2022-02-09
13:27 Reply: sqlite3_open_v2 not failing for non-SQLite file. (artifact: 00ad3fee01 user: billwade)
2022-02-08
03:40 Reply: Natural sort order (artifact: ee6f83e27e user: billwade)
2022-01-10
21:35 Reply: How do you determine if a row/column is holding a DATETIME value (artifact: 2ef616c772 user: billwade)
2022-01-07
16:41 Reply: autovacuum in sqlite VS autovacuum in PG (artifact: f4378448f8 user: billwade)
14:25 Reply: Windows nanosecond file times to accurate presentable format and back (artifact: ba1d9bd0f6 user: billwade)
2021-12-23
12:47 Reply: Select entries based on date/time plus one before and one after (artifact: a186e2b5e7 user: billwade)
2021-12-15
14:04 Reply: Backup API with network filesystem copy (artifact: bd3429959e user: billwade)
2021-12-03
15:39 Edit reply: In perspective of disk usage, is the sizeof 'a' < INT ? (artifact: c298110998 user: billwade)
15:38 Edit reply: In perspective of disk usage, is the sizeof 'a' < INT ? (artifact: ad9ee3e69d user: billwade)
15:37 Reply: In perspective of disk usage, is the sizeof 'a' < INT ? (artifact: c54d3f6566 user: billwade)
2021-11-30
16:57 Reply: Faster way to insert into WITHOUT ROWID table? (artifact: 58657fb221 user: billwade)
2021-11-29
15:02 Reply: Faster way to insert into WITHOUT ROWID table? (artifact: 838c0d8577 user: billwade)
2021-11-13
15:16 Reply: Usage of application_id and magic.txt (artifact: 9ec939e080 user: billwade)