Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
73 events by user billwade occurring around 2021-05-11 15:06:51.
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 | |
2021-11-04
| ||
11:41 | • Reply: Is this inherent casting by design? artifact: 7cdefb118d user: billwade | |
2021-10-26
| ||
13:20 | • Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: e51d19f8e6 user: billwade | |
12:20 | • Reply: No ".open" option in version 3.7.17 2013-05-20 artifact: 79e6f32064 user: billwade | |
2021-08-11
| ||
12:04 | • Reply: Increasing insert performance of an in-memory db artifact: 1bb589490b user: billwade | |
2021-07-29
| ||
12:12 | • Edit reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: 8322376593 user: billwade | |
12:11 | • Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: d36af8770e user: billwade | |
2021-07-13
| ||
14:49 | • Reply: How much would you trust a page-level checksum ? artifact: 963cca6d27 user: billwade | |
13:11 | • Edit reply: How much would you trust a page-level checksum ? artifact: 411774f14a user: billwade | |
12:02 | • Reply: How much would you trust a page-level checksum ? artifact: fb88f25e1f user: billwade | |
2021-07-12
| ||
12:30 | • Reply: How much would you trust a page-level checksum ? artifact: ee13af799e user: billwade | |
2021-07-09
| ||
13:18 | • Reply: How to handle collation version changes artifact: 833cd2181f user: billwade | |
2021-07-08
| ||
19:59 | • Reply: Deleted rows not in FreeList artifact: 53b6112c8e user: billwade | |
2021-07-07
| ||
20:40 | • Reply: transient indices vs. LIMIT artifact: 3b493dc1c0 user: billwade | |
13:29 | • Reply: transient indices vs. LIMIT artifact: 2b5821f5ed user: billwade | |
2021-06-28
| ||
12:04 | • Reply: High cpu usage of System.Data.SQLite.SQLiteConnection..ctor artifact: 1566872abd user: billwade | |
2021-06-16
| ||
13:28 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: e5ffa711ab user: billwade | |
2021-06-15
| ||
16:19 | • Reply: Opening a DB with SQLITE_OPEN_EXCLUSIVE artifact: b861a9afc5 user: billwade | |
2021-05-27
| ||
16:36 | • Reply: Is there a way to optimize this UPDATE command to run faster? artifact: aa88c9752d user: billwade | |
2021-05-11
| ||
15:06 | • Reply: Fast way to insert rows in SQLite artifact: c98ce8c601 user: billwade | |
2021-04-23
| ||
12:53 | • Post: unqualified rowid as a SELECT column artifact: 9f3a654f99 user: billwade | |
2021-04-13
| ||
17:58 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: d5524555e5 user: billwade | |
2021-04-12
| ||
12:28 | • Reply: find in b+-tree node artifact: 65ffbad0c8 user: billwade | |
2021-03-30
| ||
15:03 | • Post: Atomically initialize database artifact: 6d397b8f9a user: billwade | |