SQLite Forum

Timeline
Login

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

50 most recent forum posts by user _blgl_

2024-04-13
00:44 Reply: Fairness in SQLite3 Transactions (artifact: 5d41a6a12e user: _blgl_)
2024-04-10
09:43 Reply: Optimize get last page of table (artifact: 97db771bdf user: _blgl_)
2024-04-09
16:39 Reply: Slow query not using primary key for group by min/max (artifact: 244c7a4522 user: _blgl_)
2024-04-08
19:31 Reply: Slow query not using primary key for group by min/max (artifact: 65a8ebedab user: _blgl_)
15:51 Reply: Slow query not using primary key for group by min/max (artifact: c1e7640bc1 user: _blgl_)
2024-03-30
12:19 Reply: What does first parameter in sqlite3_keyword_name relate to? (artifact: bb5bb58938 user: _blgl_)
2024-03-27
18:12 Reply: VACUUM after ALTER TABLE (artifact: 397638f151 user: _blgl_)
2024-03-25
23:36 Reply: VACUUM after ALTER TABLE (artifact: 4ae94a6823 user: _blgl_)
17:07 Reply: sqlite3_backup_finish() leaves open file (artifact: b7d55bb188 user: _blgl_)
03:20 Reply: VACUUM after ALTER TABLE (artifact: 20a2326663 user: _blgl_)
2024-03-24
15:05 Reply: Column count mismatch when self-inserting after ADD COLUMN (artifact: e5d6fe9ca0 user: _blgl_)
2024-03-23
17:51 Reply: Column count mismatch when self-inserting after ADD COLUMN (artifact: 14cea0bb17 user: _blgl_)
2024-03-20
01:55 Reply: DB Locking Issue with single threaded writes (artifact: cf4481bfbe user: _blgl_)
2024-03-19
19:52 Reply: Pack (artifact: f2211dca50 user: _blgl_)
17:19 Reply: Pack (artifact: 45cb6c2906 user: _blgl_)
16:12 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: b34874daea user: _blgl_)
15:52 Reply: Corruption on reboot of MacBook Pro during db activity (artifact: e4daf2117f user: _blgl_)
2024-03-14
09:10 Post: .import column name disambiguation failure (artifact: 52fe2c0a8e user: _blgl_)
2024-03-09
23:42 Reply: Mode bits of created files (artifact: 186440c192 user: _blgl_)
2024-03-06
18:42 Reply: Non-breaking space character breaks regexp (artifact: 966b2f9a96 user: _blgl_)
00:52 Reply: Non-breaking space character breaks regexp (artifact: 9142ab5974 user: _blgl_)
2024-03-05
08:22 Post: Fiddle typo (artifact: 196e19196c user: _blgl_)
2024-03-02
15:17 Reply: Dates in the past (artifact: ef6bc7f003 user: _blgl_)
2024-02-22
18:36 Reply: "sqlite_sequence" table is not initialized before 1st insert is executed (artifact: 352f60a771 user: _blgl_)
2024-02-17
07:18 Reply: Novice query question: trying to identify missing rows without first building all possible combinations? (artifact: 75d7c9b5a4 user: _blgl_)
2024-02-16
07:40 Reply: How to handle fork()s? (artifact: 9ee754ca3b user: _blgl_)
2024-02-15
17:15 Reply: How to handle fork()s? (artifact: ee072d310a user: _blgl_)
2024-02-13
11:17 Reply: db filenames: why UTF-8? (artifact: 0977a357ac user: _blgl_)
2024-02-12
03:21 Reply: db filenames: why UTF-8? (artifact: 76a74ac3fa user: _blgl_)
2024-02-11
08:30 Reply: WITH RECURSIVE -- depth-first (artifact: 3b733e5160 user: _blgl_)
2024-02-06
20:16 Reply: Unexpected semantics of a CTE query (artifact: 4aca8e07c1 user: _blgl_)
20:02 Reply: Best practice for a query over an app-defined set of input values? (artifact: 8f71a8f29e user: _blgl_)
2024-02-02
07:59 Reply: Detecting database changes (artifact: e3be416dca user: _blgl_)
05:01 Reply: Detecting database changes (artifact: 92e8120dd7 user: _blgl_)
2024-01-30
17:49 Reply: erroneous language in documentation for CREATE TABLE AS… (artifact: 2720aa7a3b user: _blgl_)
2024-01-29
16:45 Reply: drop view if existsx fails if x is the name of a table (artifact: 7c8e30f8de user: _blgl_)
16:18 Reply: Find name of table column that is same as rowid (artifact: 1a4d7c9502 user: _blgl_)
2024-01-28
01:53 Reply: Start of day in localtime (artifact: 0eee3a49f9 user: _blgl_)
2024-01-27
16:26 Reply: Enhancement requests for this forum (artifact: 96b6e66921 user: _blgl_)
2024-01-24
17:12 Reply: Modified pages in the WAL? Why? (artifact: 6c87d49dc7 user: _blgl_)
2024-01-22
04:09 Reply: Documentation nits (artifact: 652b0c41bc user: _blgl_)
04:05 Reply: Missing ORDER BY in .dump? (artifact: 55431aee13 user: _blgl_)
2024-01-21
22:56 Reply: Missing ORDER BY in .dump? (artifact: 05e57e855c user: _blgl_)
19:01 Reply: JSON functions stopped working with blobs in 3.45 (artifact: 9ff24dd26a user: _blgl_)
17:50 Post: Documentation nits (artifact: 46fdd8d847 user: _blgl_)
2024-01-20
14:05 Reply: sqlite3_serialize cannot serialize an empty memory database (artifact: b88d90eb98 user: _blgl_)
2024-01-19
07:47 Reply: Malformed Database upon Index Creation (artifact: 305ce6e030 user: _blgl_)
2024-01-18
18:10 Reply: CLI Stops Output On Null Bytes (artifact: e05854622e user: _blgl_)
2024-01-16
00:09 Reply: subqueries prohibited in CHECK constraints (artifact: bbdbdfa8bd user: _blgl_)
2024-01-14
16:48 Reply: Send context to VFS (artifact: e4cf0f313c user: _blgl_)