SQLite Forum

Timeline
Login

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

49 forum posts by user ahtoh_

2024-04-26
00:00 Reply: Connection.Close() not releasing database file quickly enough (artifact: e8c8c266f7 user: ahtoh_)
2024-04-24
07:58 Reply: Connection.Close() not releasing database file quickly enough (artifact: 3948657cdb user: ahtoh_)
2024-04-23
18:02 Reply: Connection.Close() not releasing database file quickly enough (artifact: d417c57387 user: ahtoh_)
2024-04-22
20:05 Reply: Question about Multithreaded Writes (artifact: 1c56705cb4 user: ahtoh_)
2024-04-16
09:22 Reply: Connection.Close() not releasing database file quickly enough (artifact: 521db966e2 user: ahtoh_)
2024-02-27
19:54 Reply: synchronous OFF and application close (artifact: effefc18a3 user: ahtoh_)
2024-02-06
19:53 Reply: Best practice for a query over an app-defined set of input values? (artifact: 60dd928839 user: ahtoh_)
03:30 Reply: Prepare/Step/Finalize Loop (artifact: 4acbbe0e3e user: ahtoh_)
2024-01-30
20:27 Reply: Older pre-compiled windows versions (artifact: 41ef83dd33 user: ahtoh_)
2024-01-26
03:10 Reply: I need to be able deleting db files while they still opened by sqlite on Windows (artifact: dfd1144b30 user: ahtoh_)
2024-01-25
01:14 Reply: Run /usr/bin/sqlite3 -help, return value is not 0 (artifact: 67d5f7729f user: ahtoh_)
2024-01-24
22:46 Post: I need to be able deleting db files while they still opened by sqlite on Windows (artifact: 04ad5bdd7b user: ahtoh_)
2024-01-17
23:30 Reply: SQLite sharding/partitioning performance (artifact: 231d10bfa4 user: ahtoh_)
18:58 Reply: Copy two database files locally from master to slave (artifact: a31d5fac6f user: ahtoh_)
2024-01-12
19:20 Reply: db locked error on concurrent write during an open transaction that has already read (artifact: e8990ba02a user: ahtoh_)
2024-01-05
21:51 Reply: Are the functions from the SQLite library thread-safe? (artifact: dbb4a7df0b user: ahtoh_)
2024-01-04
19:58 Reply: Unclear documentation - some suggestions (artifact: ccc48e7966 user: ahtoh_)
19:30 Reply: Are the functions from the SQLite library thread-safe? (artifact: 27218ed131 user: ahtoh_)
2024-01-03
22:34 Reply: Some Queries are 40 times slower after v3.39.1 (artifact: 1e9f481725 user: ahtoh_)
2024-01-02
23:29 Reply: Some Queries are 40 times slower after v3.39.1 (artifact: eec565b597 user: ahtoh_)
20:25 Reply: Some Queries are 40 times slower after v3.39.1 (artifact: fd1f94b3e3 user: ahtoh_)
2023-12-21
22:24 Edit reply: WAL using shared memory (artifact: b2778b6169 user: ahtoh_)
22:21 Reply: WAL using shared memory (artifact: aa633d64e7 user: ahtoh_)
21:21 Reply: WAL using shared memory (artifact: e82efcf58c user: ahtoh_)
19:10 Reply: WAL using shared memory (artifact: f7f1b18c19 user: ahtoh_)
2023-12-19
06:29 Reply: round() doesn't work as expected after 3.42 (artifact: 330a1e18ac user: ahtoh_)
04:47 Edit reply: round() doesn't work as expected after 3.42 (artifact: 740a92a9d2 user: ahtoh_)
04:45 Reply: round() doesn't work as expected after 3.42 (artifact: 2c9508dd44 user: ahtoh_)
2023-12-14
22:06 Reply: Inserting/deleting versus Creating table as/dropping for in-memory database? (artifact: 74938247cb user: ahtoh_)
2023-12-11
18:29 Reply: MacOS 14 (Sonoma) failed to find attached database (artifact: c8449abe97 user: ahtoh_)
2023-12-08
20:41 Reply: (Deleted) (artifact: ebfc354013 user: ahtoh_)
20:22 Reply: (Deleted) (artifact: c8c53abf54 user: ahtoh_)
2023-11-30
22:28 Reply: no error if db being attached doesn't exist (artifact: ba2ada86e3 user: ahtoh_)
2023-11-22
05:17 Reply: conditional ATTACH (artifact: a2673f3a01 user: ahtoh_)
2023-11-14
18:54 Reply: virtual table overloaded function not taken into account for group by (artifact: a38bba9ab9 user: ahtoh_)
2023-11-13
19:46 Reply: virtual table overloaded function not taken into account for group by (artifact: ac2a8322e0 user: ahtoh_)
2023-10-26
20:06 Reply: Eponymous virtual table for attached database? (artifact: 0d56bfdd89 user: ahtoh_)
2023-10-23
20:14 Reply: Rare Corruption using SQLite WASM (artifact: 6fc11f07a6 user: ahtoh_)
2023-10-09
02:46 Edit: BUG/Feature request: vtab can't be accessed in its own schema (artifact: 655f90853d user: ahtoh_)
00:31 Post: BUG/Feature request: vtab can't be accessed in its own schema (artifact: fc699ddc6b user: ahtoh_)
2023-10-05
20:13 Reply: Will undo a changset(of session ext) restore the databse file at every byte? (artifact: 1b00e3b4ab user: ahtoh_)
2023-09-28
04:41 Reply: where clause in on conflict upsert statement is ignored (artifact: 86c4bce162 user: ahtoh_)
03:45 Reply: shared in memory db: :memory:+shared cache OR memdb VFS? (artifact: 21a21a3f58 user: ahtoh_)
2023-09-27
21:56 Reply: Bug in sqlite3LoadExtension that causing crash in sqlite3VtabModuleUnref (artifact: b0bdbf6001 user: ahtoh_)
2023-09-26
01:41 Edit: Bug in sqlite3LoadExtension that causing crash in sqlite3VtabModuleUnref (artifact: e2436de536 user: ahtoh_)
2023-09-25
21:57 Post: Bug in sqlite3LoadExtension that causing crash in sqlite3VtabModuleUnref (artifact: 7636e29fa8 user: ahtoh_)
2023-02-20
23:27 Reply: CTEs in triggers (artifact: 143da76b4c user: ahtoh_)
2023-02-02
22:56 Post: where clause in on conflict upsert statement is ignored (artifact: c1aa88a766 user: ahtoh_)
2021-11-17
03:50 Post: ROWID primary key works slower than index (artifact: dad0630f50 user: ahtoh_)