SQLite Forum

Timeline
Login

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

143 events for the month beginning 2023-03-01 by user anonymous

Following month ↑
2023-03-31
17:49 Reply: Optimizing JSON filter by syntheszing a LIKE artifact: c9d6875f56 user: anonymous
15:22 Reply: Error when trying to add a column (Error checking foreign keys after table modification) artifact: 6c7c5c20a5 user: anonymous
11:42 Reply: Optimizing JSON filter by syntheszing a LIKE artifact: 538a0fea78 user: anonymous
10:26 Post: Optimizing JSON filter by syntheszing a LIKE artifact: 607099b02c user: anonymous
2023-03-30
13:33 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 74c3f2bf52 user: anonymous
03:56 Post: Request: Pragma to toggle DQS artifact: 4bbae0aaa2 user: anonymous
2023-03-29
20:28 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: c19f3921b6 user: anonymous
19:25 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: afb3bf833f user: anonymous
18:59 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: e29b2f50fe user: anonymous
18:06 Post: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: cbca7db7d0 user: anonymous
08:26 Reply: Dot Commands artifact: 0c31d82884 user: anonymous
05:56 Reply: Column aliases inside FROM artifact: caabdcc705 user: anonymous
04:29 Reply: Very slow query needs help to be faster artifact: 70899dbd3e user: anonymous
02:29 Post: ORDER BY in lag() window function compared to that of the containing statement? artifact: 7a239fddd8 user: anonymous
2023-03-28
18:01 Reply: Is this an incorrect optimization? artifact: 420e68fc11 user: anonymous
17:10 Reply: Order of rows in RTree query artifact: f04073e9b3 user: anonymous
14:34 Post: Order of rows in RTree query artifact: 40a0686741 user: anonymous
13:51 Post: HELP with SQL query artifact: b2299073a2 user: anonymous
13:13 Reply: Poor performance of SQLite on GCP artifact: b2853374f5 user: anonymous
06:18 Reply: Poor performance of SQLite on GCP artifact: 2841defb25 user: anonymous
04:25 Reply: Uniqueidentifier column artifact: 72787e3f6b user: anonymous
2023-03-27
23:59 Reply: A more useful sqlite3_complete artifact: bf8d2ec2e5 user: anonymous
20:01 Reply: Schema-less SQLite artifact: c08ac7e941 user: anonymous
18:53 Reply: Poor performance of SQLite on GCP artifact: feb17622d0 user: anonymous
18:47 Reply: Uniqueidentifier column artifact: 83293a169b user: anonymous
14:31 Reply: The craziest thing I ever used SQLite for: partial file deduplication artifact: c529642319 user: anonymous
14:20 Reply: subscribing to queries / an inverted database artifact: 147df7a6de user: anonymous
12:52 Reply: Uniqueidentifier column artifact: 5364c46be4 user: anonymous
07:38 Post: Column aliases inside FROM artifact: 8bb91711c8 user: anonymous
06:08 Post: Uniqueidentifier column artifact: 3b7319c608 user: anonymous
2023-03-26
19:16 Reply: SQLite Wasm for Safari And Firefox progress artifact: d3dda5c27b user: anonymous
17:30 Reply: SQLite Wasm for Safari And Firefox progress artifact: 8b872282d1 user: anonymous
2023-03-25
18:47 Reply: Sharing a database across processes and threads. artifact: 6d6c81185f user: anonymous
2023-03-24
19:55 Reply: Schema-less SQLite artifact: ddff4732d4 user: anonymous
19:12 Reply: Connection pooling vs Message passing artifact: 0f99699dbf user: anonymous
16:35 Reply: Connection pooling vs Message passing artifact: 088b2f465a user: anonymous
15:32 Reply: Connection pooling vs Message passing artifact: 3e794242b9 user: anonymous
11:43 Reply: Importing csv Files artifact: 3f4ecfba12 user: anonymous
05:13 Reply: Importing csv Files artifact: 667ee58f2c user: anonymous
01:32 Post: Possibly don't check F2FS_FEATURE_ATOMIC_WRITE when database is readonly artifact: 944a227977 user: anonymous
01:24 Post: Connection pooling vs Message passing artifact: fcbec334c9 user: anonymous
2023-03-23
22:07 Reply: Feature request: Stored Procedures artifact: 532bb36306 user: anonymous
20:58 Reply: Suggestions of tools to handle database migrations (using raw SQL)? artifact: a8e85e411c user: anonymous
20:30 Reply: Performance regression in version 3.40.2 using views on indexed tables artifact: a284a63124 user: anonymous
17:49 Reply: Feature request: Stored Procedures artifact: e8ce6c3b46 user: anonymous
17:30 Reply: SQlite encryption artifact: 5b3724ea91 user: anonymous
13:41 Reply: Feature request: Stored Procedures artifact: aee4569aac user: anonymous
13:00 Reply: Changes in json since 3.39.0? artifact: c934fa7cf2 user: anonymous
11:12 Post: Changes in json since 3.39.0? artifact: 3d4386bc87 user: anonymous
07:26 Reply: SQlite encryption artifact: 836120fefa user: anonymous
05:11 Reply: SQlite encryption artifact: 07fbc5c9c5 user: anonymous
2023-03-22
22:41 Reply: Feature request: Stored Procedures artifact: 9ac486fe45 user: anonymous
18:14 Reply: SQlite encryption artifact: 007a14e8db user: anonymous
17:44 Reply: Comments in column names artifact: b3fdae8f70 user: anonymous
17:43 Reply: SQlite encryption artifact: 9c55bba063 user: anonymous
16:17 Post: Comments in column names artifact: 9887889369 user: anonymous
2023-03-21
19:57 Reply: Feature request: Stored Procedures artifact: 932327a4d6 user: anonymous
19:52 Reply: Feature request: Stored Procedures artifact: aa39e99603 user: anonymous
18:24 Post: SQlite encryption artifact: 342c27a421 user: anonymous
11:37 Reply: unexpected result artifact: b6f2f5a65c user: anonymous
09:17 Reply: unexpected result artifact: f4e82b1426 user: anonymous
09:12 Reply: unexpected result artifact: e89c5b4dc2 user: anonymous
06:20 Reply: unexpected result artifact: 84f3b471e6 user: anonymous
06:10 Reply: unexpected result artifact: fe9db2ce00 user: anonymous
06:06 Reply: unexpected result artifact: e4c3cb8a7c user: anonymous
03:12 Reply: Feature request: Stored Procedures artifact: 285f8cccff user: anonymous
2023-03-20
21:38 Reply: unexpected result artifact: bc91869337 user: anonymous
21:30 Reply: unexpected result artifact: fdfe42fc68 user: anonymous
21:29 Reply: unexpected result artifact: e3727471f8 user: anonymous
21:03 Reply: unexpected result artifact: eb0f4636a2 user: anonymous
20:39 Reply: unexpected result artifact: 239157f96a user: anonymous
19:43 Reply: Feature request: Stored Procedures artifact: 579cbcabc0 user: anonymous
19:26 Reply: SQLite Wasm for Safari And Firefox progress artifact: e5aa4a4a21 user: anonymous
15:47 Reply: DLL load failed %1 is not a valid Win32 application artifact: a1f76fb087 user: anonymous
15:39 Post: unexpected result artifact: cb668840ac user: anonymous
14:10 Reply: DLL load failed %1 is not a valid Win32 application artifact: 185ca64b0c user: anonymous
08:59 Reply: FILTER clause with window functions artifact: 2414dce254 user: anonymous
2023-03-19
23:49 Reply: SELECT * FROM tab1 WHERE a=?1 artifact: 367d7f5f27 user: anonymous
22:53 Reply: DLL load failed %1 is not a valid Win32 application artifact: a53b937d78 user: anonymous
18:46 Post: WASM: sqlite3.capi.sqlite3_foo: Why stutter? artifact: 45ae4575a3 user: anonymous
2023-03-17
21:11 Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 37a43e78e1 user: anonymous
20:06 Post: How to use VACUUM INTO? artifact: 5bc9fadbaa user: anonymous
19:56 Reply: BLOB and Lazarus artifact: 3443aca806 user: anonymous
16:31 Reply: BLOB and Lazarus artifact: f9d8ef5938 user: anonymous
15:21 Post: BLOB and Lazarus artifact: f27bb9988f user: anonymous
2023-03-16
14:02 Reply: CLI .schema wrongly adds "IF NOT EXISTS" to "CREATE TABLE" artifact: 985c0c9fb7 user: anonymous
02:05 Reply: Incorrect deletion caused by subquery in where clause artifact: 87f6fe2686 user: anonymous
01:28 Reply: CLI .schema wrongly adds "IF NOT EXISTS" to "CREATE TABLE" artifact: 05a077b402 user: anonymous
2023-03-15
17:33 Reply: SQLite in serverless cloud container artifact: 64a84f3f2d user: anonymous
14:54 Reply: Building SQLite fails during make artifact: ad4b078dbe user: anonymous
14:16 Reply: Building SQLite fails during make artifact: 4deaa609a1 user: anonymous
13:49 Reply: Building SQLite fails during make artifact: 2acb982566 user: anonymous
13:19 Reply: Bug: schema hidden column of pragma tables always null artifact: 6600f46e5d user: anonymous
13:15 Reply: Building SQLite fails during make artifact: 854be7e859 user: anonymous
10:01 Post: Building SQLite fails during make artifact: 706f7c10f8 user: anonymous
09:47 Post: SQLite in serverless cloud container artifact: f4ac0f8eff user: anonymous
2023-03-14
14:28 Post: Transaction documentation typo artifact: 13d539fe49 user: anonymous
04:55 Reply: Question on activating the LIKE Optimization artifact: 17056d1aa7 user: anonymous
2023-03-13
10:21 Reply: Query with column name in line artifact: 9274956b6b user: anonymous
09:51 Post: Query with column name in line artifact: fc8770d4ee user: anonymous
2023-03-11
17:18 Reply: win-arm64 support artifact: eb4a8acf9e user: anonymous
16:38 Reply: Storing numeric vectors artifact: 8d50d3a780 user: anonymous
04:12 Reply: Can not download 3.41.1 version artifact: 59afba99d2 user: anonymous
03:21 Reply: Can not download 3.41.1 version artifact: 12c61e25bc user: anonymous
2023-03-10
22:41 Reply: CLI option processing request artifact: 6c4bf9e3a5 user: anonymous
20:32 Post: Can not download 3.41.1 version artifact: 5eca1ad35e user: anonymous
18:48 Reply: do not print info (version, help) at startup artifact: b7b87b7fc1 user: anonymous
15:29 Reply: Storing numeric vectors artifact: 5184f5eae4 user: anonymous
15:09 Reply: Storing numeric vectors artifact: 236b203f4d user: anonymous
13:21 Reply: CLI option processing documentation request artifact: 5e0890c9f7 user: anonymous
11:49 Post: CLI option processing documentation request artifact: cf6a4f27b8 user: anonymous
02:51 Reply: Outer query cannot make full use of the sorting information in the CTE resulting in redundant sorting artifact: 992efc30d0 user: anonymous
2023-03-09
21:30 Reply: CLI option processing request artifact: a5d8aa6d70 user: anonymous
13:53 Reply: CLI option processing request artifact: c035af3ae2 user: anonymous
13:04 Reply: CLI option processing request artifact: c96bcde4f2 user: anonymous
12:09 Post: CLI option processing request artifact: cb49605c64 user: anonymous
12:04 Reply: do not print info (version, help) at startup artifact: 7f8d238896 user: anonymous
07:52 Post: Outer query cannot make full use of the sorting information in the CTE resulting in redundant sorting artifact: cf3aec2c24 user: anonymous
2023-03-08
13:01 Reply: I love SQLite artifact: ad12136616 user: anonymous
11:30 Reply: ODBC 64bit drivers for windows download artifact: 2b401727be user: anonymous
10:56 Reply: Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT? artifact: 4152ce47d4 user: anonymous
10:31 Reply: Missing GROUP BY ROLLUP artifact: 18573eec6e user: anonymous
2023-03-07
23:36 Reply: I love SQLite artifact: 107eef8aca user: anonymous
20:33 Post: I love SQLite artifact: edb262c43b user: anonymous
2023-03-06
06:07 Reply: ANALYZE needed after CREATE INDEX? artifact: 363b80453c user: anonymous
05:58 Reply: How to generate fake rows of data based off an SQLite schema? artifact: b413cac533 user: anonymous
2023-03-05
13:36 Reply: LSM1 Crash when using compression hooks. artifact: f28fbfaf4d user: anonymous
02:19 Reply: printf: meaningfulness of the "extended precision" floating-point format artifact: 2dabe9a68f user: anonymous
00:20 Post: iPhone backup manifest.db - thank you artifact: a2d738eaa6 user: anonymous
2023-03-03
16:36 Post: Query for interrupt testing artifact: 1f5a9aef1d user: anonymous
12:30 Reply: How to .dump temporary tables? artifact: 2a15c463d9 user: anonymous
12:00 Reply: Unable to change the default file permission by setting compiler option SQLITE_DEFAULT_FILE_PERMISSIONS to 600 artifact: 390be21388 user: anonymous
10:08 Reply: sqlean – a set of widely implemented functions to add to SQLite artifact: 80c3d03bbc user: anonymous
07:22 Reply: Unable to change the default file permission by setting compiler option SQLITE_DEFAULT_FILE_PERMISSIONS to 600 artifact: a719684c27 user: anonymous
06:12 Reply: load from memfd artifact: e88d0f5a28 user: anonymous
05:54 Reply: load from memfd artifact: 7be8cf6e25 user: anonymous
2023-03-02
23:36 Post: load from memfd artifact: 02d17d1167 user: anonymous
20:05 Post: Base85 different results artifact: 2a9c9055c8 user: anonymous
17:47 Reply: Thoughts on replacing macros with static inline functions? artifact: ab095c4686 user: anonymous
17:25 Reply: Thoughts on replacing macros with static inline functions? artifact: aca7a49844 user: anonymous
16:03 Reply: Thoughts on replacing macros with static inline functions? artifact: 6f899eb096 user: anonymous
05:21 Post: Failed to attach unencrypted sqlite3 db to an encrypted sqlite3 db(RC4 encryption) artifact: 18b800b7f8 user: anonymous
2023-03-01
10:42 Reply: sqlean – a set of widely implemented functions to add to SQLite artifact: ca659a4357 user: anonymous
Previous month ↓