SQLite Forum

Timeline
Login

34 events by 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