Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user bjoern
|
2024-02-18
| ||
| 21:54 | • Reply: SQLite extensions for API access (artifact: aad185c467 user: bjoern) | |
|
2023-05-03
| ||
| 18:09 | • Reply: concat, concat_ws, T-SQL (artifact: de410c1fb6 user: bjoern) | |
|
2023-04-29
| ||
| 13:42 | • Reply: Howto: Containment tests whether one json document has contained within it another one (artifact: f7acd07f1e user: bjoern) | |
|
2023-04-17
| ||
| 20:13 | • Post: Bug: Bad SQLITE_STMTSTATUS_RUN value for insert into "instead of" trigger (artifact: 76005b897c user: bjoern) | |
|
2023-04-10
| ||
| 18:07 | • Reply: random() in a subquery produces a column with an inconsistent value (artifact: f2497d5002 user: bjoern) | |
|
2023-04-09
| ||
| 21:44 | • Post: Missed optimisation: consolidation of automatic indices (artifact: f7ebff9d71 user: bjoern) | |
|
2023-04-05
| ||
| 17:15 | • Reply: Selecting different columns and different rows from subquery (artifact: 6115fcdb3e user: bjoern) | |
|
2023-03-31
| ||
| 20:44 | • Reply: Optimizing JSON filter by syntheszing a LIKE (artifact: 6b3f8a5c63 user: bjoern) | |
| 16:04 | • Reply: Optimizing JSON filter by syntheszing a LIKE (artifact: e2d1a8e470 user: bjoern) | |
|
2023-03-29
| ||
| 19:47 | • Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: e9f6b843ad user: bjoern) | |
| 18:35 | • Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: 25b6588b11 user: bjoern) | |
| 14:49 | • Edit reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: acb1d37375 user: bjoern) | |
| 14:43 | • Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: ce7e50e242 user: bjoern) | |
| 14:31 | • Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: cfca52e26b user: bjoern) | |
| 12:28 | • Edit: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: a6ffe28e5f user: bjoern) | |
| 12:28 | • Edit: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: abff40ba62 user: bjoern) | |
| 12:19 | • Post: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text (artifact: e21eb92eaa user: bjoern) | |
|
2023-03-28
| ||
| 20:50 | • Reply: CROSS JOIN doc bug? (artifact: fe6013a487 user: bjoern) | |
| 20:47 | • Reply: Very slow query needs help to be faster (artifact: 4256368054 user: bjoern) | |
|
2023-03-27
| ||
| 00:05 | • Post: Bug: vtab xSync/xCommit called without xBegin (artifact: e97aa532cf user: bjoern) | |
|
2023-03-26
| ||
| 19:00 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables (artifact: 29176bea3c user: bjoern) | |
| 16:43 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables (artifact: 840d122227 user: bjoern) | |
| 15:50 | • Reply: Telescoping the integer primary keys? (artifact: 322eed4a91 user: bjoern) | |
| 15:40 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables (artifact: 8485004b9d user: bjoern) | |
|
2023-03-24
| ||
| 23:22 | • Reply: Schema-less SQLite (artifact: da9241a75e user: bjoern) | |
|
2023-03-22
| ||
| 12:28 | • Reply: What am I doing wrong to cause the table scan order in query plans to differ? (artifact: 8abc5168f6 user: bjoern) | |
|
2023-03-16
| ||
| 16:23 | • Reply: Option to enable sqlite3_mutex_... API with SQLITE_THREADSAFE=0 (artifact: 2d73e14964 user: bjoern) | |
| 02:23 | • Reply: FYI: LD_PRELOAD library to exfiltrate queries with query plans and statistics (artifact: 25f69cf776 user: bjoern) | |
| 00:21 | • Reply: RFE: add pragma_schema_version.schema column (artifact: 96086d129d user: bjoern) | |
|
2023-03-15
| ||
| 04:53 | • Reply: Bug: schema hidden column of pragma tables always null (artifact: f7827d4dfa user: bjoern) | |
| 04:50 | • Reply: RFE: add pragma_schema_version.schema column (artifact: 23ae9ada55 user: bjoern) | |
|
2023-03-14
| ||
| 21:05 | • Reply: FYI: LD_PRELOAD library to exfiltrate queries with query plans and statistics (artifact: ad5981c62f user: bjoern) | |
| 15:12 | • Edit reply: Option to enable sqlite3_mutex_... API with SQLITE_THREADSAFE=0 (artifact: bba893698d user: bjoern) | |
| 15:11 | • Reply: Option to enable sqlite3_mutex_... API with SQLITE_THREADSAFE=0 (artifact: bd6f8def2c user: bjoern) | |
| 03:26 | • Post: GROUP BY is better than DISTINCT in some cases. (artifact: 10e8028020 user: bjoern) | |
|
2023-03-13
| ||
| 21:39 | • Reply: shared in memory db: :memory:+shared cache OR memdb VFS? (artifact: 5c4b93c24a user: bjoern) | |
|
2023-03-11
| ||
| 17:35 | • Reply: Storing numeric vectors (artifact: 35ac4ef58e user: bjoern) | |
|
2023-03-10
| ||
| 02:02 | • Reply: Help with query plan (artifact: 75f9efc438 user: bjoern) | |
|
2023-03-09
| ||
| 17:41 | • Reply: CLI option processing request (artifact: f4ba8a1e42 user: bjoern) | |
|
2023-03-07
| ||
| 00:51 | • Post: Could .mode json repspect JSON subtype for results? (artifact: 55065d2a28 user: bjoern) | |
|
2023-03-06
| ||
| 04:41 | • Reply: rtree and geopoly enabled by default, but docs say otherwise (artifact: a228b4522b user: bjoern) | |
| 04:37 | • Reply: ANALYZE needed after CREATE INDEX? (artifact: 8898018d28 user: bjoern) | |
|
2023-03-05
| ||
| 22:59 | • Reply: RFE: SQLITE_TRACE_FINALIZE (artifact: 2da33ba7aa user: bjoern) | |
| 22:55 | • Reply: ANALYZE needed after CREATE INDEX? (artifact: d4820f6c07 user: bjoern) | |
|
2023-03-04
| ||
| 02:31 | • Reply: ANALYZE needed after CREATE INDEX? (artifact: 901798a215 user: bjoern) | |
| 02:21 | • Post: ANALYZE needed after CREATE INDEX? (artifact: c18fb50276 user: bjoern) | |
|
2023-03-03
| ||
| 02:00 | • Post: How does SQLite compute estimated cost and rows for actual tables? (artifact: a3a9ed70f2 user: bjoern) | |
| 00:09 | • Reply: load from memfd (artifact: 72d1a2776b user: bjoern) | |
|
2023-03-02
| ||
| 15:53 | • Reply: Virtual Table Joins with Repeated calls to xFilter (artifact: 46a38d9396 user: bjoern) | |
|
2023-03-01
| ||
| 02:44 | • Post: RFE: SQLITE_TRACE_FINALIZE (artifact: ea56dc802b user: bjoern) | |