Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
168 events for the month beginning 2023-02-01 by user anonymous
Following month ↑
2023-02-28
| ||
19:38 | • Reply: GLOB get different results for different encodings. artifact: f80b5e5f80 user: anonymous | |
12:57 | • Reply: GLOB get different results for different encodings. artifact: 5ff7d01388 user: anonymous | |
10:29 | • Reply: GLOB get different results for different encodings. artifact: cc723b1a47 user: anonymous | |
2023-02-27
| ||
23:00 | • Reply: printf: meaningfulness of the "extended precision" floating-point format artifact: 314b170b67 user: anonymous | |
19:45 | • Reply: GLOB get different results for different encodings. artifact: 118c690dd4 user: anonymous | |
19:02 | • Reply: GLOB get different results for different encodings. artifact: 0f7fb60e59 user: anonymous | |
17:36 | • Reply: GLOB get different results for different encodings. artifact: a9e4f446a9 user: anonymous | |
17:21 | • Reply: GLOB get different results for different encodings. artifact: 9b79d59e84 user: anonymous | |
16:55 | • Reply: GLOB get different results for different encodings. artifact: c6ac489c5f user: anonymous | |
16:27 | • Reply: GLOB get different results for different encodings. artifact: 6b36be4c1e user: anonymous | |
12:25 | • Reply: GLOB get different results for different encodings. artifact: 0510cffbd3 user: anonymous | |
11:49 | • Reply: GLOB get different results for different encodings. artifact: 1d1595f1b5 user: anonymous | |
2023-02-26
| ||
20:29 | • Post: printf: meaningfulness of the "extended precision" floating-point format artifact: 47c0abe867 user: anonymous | |
18:34 | • Reply: unique constraint only if flag is set artifact: f9f6c4a02c user: anonymous | |
07:52 | • Reply: unique constraint only if flag is set artifact: ce640e661c user: anonymous | |
07:41 | • Reply: unique constraint only if flag is set artifact: 3dacf65223 user: anonymous | |
06:51 | • Post: Documentation nit artifact: e51784e1f0 user: anonymous | |
06:48 | • Reply: WITH ... AS BOUNDARY artifact: 83adad27a1 user: anonymous | |
2023-02-25
| ||
20:34 | • Post: unique constraint only if flag is set artifact: 7d3776fc92 user: anonymous | |
19:48 | • Reply: WITH ... AS BOUNDARY artifact: 415311f8de user: anonymous | |
13:46 | • Post: -echo cmdline arg does not work artifact: 7ee1182f32 user: anonymous | |
2023-02-24
| ||
15:11 | • Reply: Support for building SQLite with older Microsoft compilers, such as Visual Studio 6.0. artifact: 2b83963dd0 user: anonymous | |
04:39 | • Reply: .mode quote surprise artifact: bd0fb8a51a user: anonymous | |
04:23 | • Reply: .mode quote surprise artifact: f05804dde4 user: anonymous | |
02:43 | • Reply: .mode quote surprise artifact: 89b938599a user: anonymous | |
2023-02-23
| ||
21:37 | • Reply: v3.40.0 very slow with UNIONs (or so I think) artifact: 5c3a531b48 user: anonymous | |
19:40 | • Reply: .mode quote surprise artifact: 1b8a4e5f3d user: anonymous | |
18:32 | • Reply: .mode quote surprise artifact: 71e98b71dd user: anonymous | |
16:29 | • Reply: rel. 3.41.0 parse error using symbol "quote" in like or = artifact: 8c21b9dd36 user: anonymous | |
16:18 | • Reply: .mode quote surprise artifact: d8d8762265 user: anonymous | |
16:05 | • Reply: .mode quote surprise artifact: f77591438c user: anonymous | |
15:34 | • Reply: round() rounding behaviour artifact: 3fc4172851 user: anonymous | |
15:12 | • Reply: rel. 3.41.0 parse error using symbol "quote" in like or = artifact: 43d54ba503 user: anonymous | |
12:54 | • Post: rel. 3.41.0 parse error using symbol "quote" in like or = artifact: 4ea8d77949 user: anonymous | |
11:42 | • Post: .mode quote surprise artifact: d1387c3979 user: anonymous | |
09:45 | • Reply: HEX - What is the reverse function? artifact: faba8d041e user: anonymous | |
08:44 | • Post: error artifact: 29865f6bd0 user: anonymous | |
03:06 | • Reply: How many times is strftime calculated? artifact: d0144ac539 user: anonymous | |
02:42 | • Post: How many times is strftime calculated? artifact: 467694ffb2 user: anonymous | |
2023-02-22
| ||
23:26 | • Post: Building custom extensions into a WASM Distribution of SQLite artifact: 1e1c04f3ed user: anonymous | |
20:08 | • Reply: How to find which record triggered SQLITE_CHANGESET_FOREIGN_KEY constraint violation? artifact: e3d6fec265 user: anonymous | |
15:29 | • Reply: SQL: substr() result for 0-index artifact: 930e7c40d0 user: anonymous | |
14:26 | • Reply: SQL: substr() result for 0-index artifact: fc106fcbb0 user: anonymous | |
04:41 | • Reply: How to find which record triggered SQLITE_CHANGESET_FOREIGN_KEY constraint violation? artifact: 98d97e5580 user: anonymous | |
03:56 | • Post: SQL: substr() result for 0-index artifact: 1443675292 user: anonymous | |
03:27 | • Post: docs(lang_datefunc.in): Confusing reference to "note-1" artifact: a706e447fd user: anonymous | |
02:43 | • Reply: strftime + LIKE? artifact: 07496e3609 user: anonymous | |
2023-02-21
| ||
19:48 | • Reply: Shared memory artifact: 68658f30eb user: anonymous | |
08:55 | • Reply: CTEs in triggers artifact: 1aa507b8b7 user: anonymous | |
06:01 | • Reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 5da1b531eb user: anonymous | |
01:48 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 014401be83 user: anonymous | |
01:21 | • Reply: How to view Telegram sqlite3 database file? artifact: 445773c880 user: anonymous | |
2023-02-20
| ||
23:16 | • Reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: f744ae04d1 user: anonymous | |
20:03 | • Reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: 0215e8da61 user: anonymous | |
2023-02-19
| ||
13:05 | • Reply: More fine grained conflict detection for BEGIN CONCURRENT artifact: d801ae95e9 user: anonymous | |
04:18 | • Reply: Flatten Table of Ranges? artifact: 70f3990d1c user: anonymous | |
2023-02-18
| ||
18:28 | • Reply: Problem with opening database file created on Surface Go (windows 11) then moving to a windows 10 artifact: 8fff5c0805 user: anonymous | |
08:20 | • Post: Problem with opening database file created on Surface Go (windows 11) then moving to a windows 10 artifact: bb3c991bf9 user: anonymous | |
00:42 | • Reply: Share your use cases for SQLite artifact: 5c314fdefa user: anonymous | |
2023-02-17
| ||
22:02 | • Post: Wrong test artifact: 88a8f46d3a user: anonymous | |
18:27 | • Reply: More fine grained conflict detection for BEGIN CONCURRENT artifact: bacfcc0163 user: anonymous | |
17:27 | • Post: '.mode tabs' row separator artifact: e2ea7d4fa1 user: anonymous | |
16:50 | • Reply: How to view Telegram sqlite3 database file? artifact: e90993904f user: anonymous | |
15:54 | • Post: More fine grained conflict detection for BEGIN CONCURRENT artifact: db7f7b3fcb user: anonymous | |
2023-02-16
| ||
18:33 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: e2c74343df user: anonymous | |
18:06 | • Post: Documentation typo (flextypegood.html) artifact: 37b3431147 user: anonymous | |
16:24 | • Reply: Share your use cases for SQLite artifact: b7ccb0bc97 user: anonymous | |
13:06 | • Reply: Share your use cases for SQLite artifact: 54c3d4f455 user: anonymous | |
11:55 | • Reply: memcpy warning when compiling sqlite 3.40.1 (amalgamation) with gcc 7.5.0 artifact: c3247ee74d user: anonymous | |
05:31 | • Reply: Plans for columnstore tables in future? artifact: a9b511b466 user: anonymous | |
04:26 | • Reply: Refering to columns by N`th position artifact: cb301e8881 user: anonymous | |
02:19 | • Reply: Share your use cases for SQLite artifact: 069c6f7fc9 user: anonymous | |
02:05 | • Reply: Plans for columnstore tables in future? artifact: 9fc3bbe161 user: anonymous | |
2023-02-15
| ||
23:19 | • Reply: Plans for columnstore tables in future? artifact: e3c9a76912 user: anonymous | |
23:10 | • Reply: Plans for columnstore tables in future? artifact: c692fba8e0 user: anonymous | |
22:33 | • Post: Share your use cases for SQLite artifact: 8dc8bc4437 user: anonymous | |
21:14 | • Post: zipfile('a-large-enough-archive.zip') seems to report zero rows artifact: cc0805b68d user: anonymous | |
20:29 | • Post: memcpy warning when compiling sqlite 3.40.1 (amalgamation) with gcc 7.5.0 artifact: ebed07d341 user: anonymous | |
20:25 | • Post: Documentation typo in json_quote example artifact: e9d25f4520 user: anonymous | |
15:18 | • Reply: Plans for columnstore tables in future? artifact: bf96f95eff user: anonymous | |
15:10 | • Reply: Power Query connector for SQLite artifact: 8c8e596844 user: anonymous | |
07:19 | • Post: Unable to change the default file permission by setting compiler option SQLITE_DEFAULT_FILE_PERMISSIONS to 600 artifact: 79ea15e1ca user: anonymous | |
2023-02-14
| ||
20:03 | • Reply: Plans for columnstore tables in future? artifact: 764ecb7c49 user: anonymous | |
17:23 | • Reply: FILTER clause with window functions artifact: 0642bbbf07 user: anonymous | |
17:04 | • Post: Visual Studio debugger seems to corrupt SQLite databases artifact: bc7382a5eb user: anonymous | |
16:48 | • Reply: FILTER clause with window functions artifact: 380c43b4ef user: anonymous | |
14:55 | • Post: Plans for columnstore tables in future? artifact: 2b06c0ab64 user: anonymous | |
07:02 | • Reply: Refering to columns by N`th position artifact: f61cfa6afb user: anonymous | |
06:17 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 9261094ebb user: anonymous | |
03:07 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 9d971baf48 user: anonymous | |
2023-02-13
| ||
21:00 | • Reply: How to view Telegram sqlite3 database file? artifact: a80b478dfc user: anonymous | |
19:56 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 220f74451b user: anonymous | |
19:51 | • Reply: DuckDB (v0.7) now supports SQLite DB files artifact: b0eb419e56 user: anonymous | |
16:44 | • Post: Power Query connector for SQLite artifact: 0842bd8637 user: anonymous | |
16:14 | • Reply: Refering to columns by N`th position artifact: 0b62fbd8a8 user: anonymous | |
15:03 | • Reply: Trying to establish a DB connection to SQLite artifact: a287021a16 user: anonymous | |
14:20 | • Post: Refering to columns by N`th position artifact: 7759c11b27 user: anonymous | |
12:59 | • Post: Trying to establish a DB connection to SQLite artifact: e142030510 user: anonymous | |
06:52 | • Reply: Dense vector search in SQLite? artifact: ee1004e5f4 user: anonymous | |
04:31 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 4621b3f22d user: anonymous | |
03:40 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 820b092f7f user: anonymous | |
01:41 | • Reply: Sqlite query plan not using compound index for IN clause artifact: 443ccc6d3b user: anonymous | |
2023-02-12
| ||
20:36 | • Reply: OSX Xcode produces warnings artifact: 35bd6cd87d user: anonymous | |
17:00 | • Reply: OSX Xcode produces warnings artifact: 7426e5ac77 user: anonymous | |
06:25 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 5650bf536a user: anonymous | |
03:29 | • Post: Sqlite query plan not using compound index for IN clause artifact: 675ded3cbc user: anonymous | |
2023-02-11
| ||
21:20 | • Reply: OSX Xcode produces warnings artifact: bf7557555e user: anonymous | |
13:44 | • Reply: Advice regarding migrating thousand of text files to SQLite artifact: 30d227d580 user: anonymous | |
06:19 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: a69ca1cfd9 user: anonymous | |
03:56 | • Post: Advice regarding migrating thousand of text files to SQLite artifact: 560459cf0e user: anonymous | |
03:56 | • Post: Advice regarding migrating thousand of text files to SQLite artifact: 1bfbe285b6 user: anonymous | |
2023-02-10
| ||
21:41 | • Reply: Locking behavior for multi-database transactions artifact: 6f1d77f0b3 user: anonymous | |
21:16 | • Reply: Locking behavior for multi-database transactions artifact: 8c622c2a89 user: anonymous | |
20:32 | • Post: Locking behavior for multi-database transactions artifact: e426e0190e user: anonymous | |
13:00 | • Reply: sqlite3_json_init not found artifact: f592c739fc user: anonymous | |
12:48 | • Post: sqlite3_json_init not found artifact: 42a5f78718 user: anonymous | |
05:07 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 22591d058e user: anonymous | |
2023-02-09
| ||
20:35 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 0c2565d525 user: anonymous | |
20:20 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: e26a36ddf4 user: anonymous | |
20:11 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: bb301fc96e user: anonymous | |
04:39 | • Reply: upgrade of SQLite version artifact: 4477aefd5b user: anonymous | |
04:39 | • Reply: upgrade of SQLite version artifact: 699fae72d7 user: anonymous | |
04:37 | • Reply: upgrade of SQLite version artifact: c8488d7f12 user: anonymous | |
03:33 | • Reply: Delete using nested subqueries artifact: 077d8b315e user: anonymous | |
02:27 | • Reply: Delete using nested subqueries artifact: 1bd34ebb5e user: anonymous | |
02:03 | • Reply: Delete using nested subqueries artifact: fd77adf5b1 user: anonymous | |
01:30 | • Reply: Database query and calculation of percentages artifact: 1b6ee533c8 user: anonymous | |
00:52 | • Post: sqlite3_db_config() documentation is confusing artifact: b23a44acf8 user: anonymous | |
00:40 | • Post: Delete using nested subqueries artifact: c42b1f35e1 user: anonymous | |
00:13 | • Reply: upgrade of SQLite version artifact: e40f263313 user: anonymous | |
2023-02-08
| ||
22:48 | • Reply: Database query and calculation of percentages artifact: 602007ee9a user: anonymous | |
22:43 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: c492c4fec6 user: anonymous | |
22:37 | • Reply: Database query and calculation of percentages artifact: 7c1047dd14 user: anonymous | |
22:31 | • Reply: Database query and calculation of percentages artifact: eb7abbeb5b user: anonymous | |
22:26 | • Reply: Database query and calculation of percentages artifact: 2daa885890 user: anonymous | |
22:17 | • Reply: Database query and calculation of percentages artifact: 4d7ad67fb0 user: anonymous | |
18:56 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 2f33fc669f user: anonymous | |
16:49 | • Reply: Virtual table xShadowName lacking any context information artifact: c3c6bbb173 user: anonymous | |
11:16 | • Reply: Database query and calculation of percentages artifact: e762312403 user: anonymous | |
07:03 | • Post: upgrade of SQLite version artifact: 2055ebcb30 user: anonymous | |
05:33 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: d7b39e3266 user: anonymous | |
01:18 | • Reply: Virtual table xShadowName lacking any context information artifact: d969fa0093 user: anonymous | |
2023-02-07
| ||
23:56 | • Post: Database query and calculation of percentages artifact: 73cbb7218a user: anonymous | |
20:37 | • Reply: How to stores dates for my use case (best query performance). artifact: 23ed79597d user: anonymous | |
20:12 | • Post: Not possible to search short non-ASCII strings in a FTS5 table artifact: 25ac341c8f user: anonymous | |
16:14 | • Post: typo in vtab_in_first documentation artifact: 42f0309f94 user: anonymous | |
13:01 | • Reply: How to stores dates for my use case (best query performance). artifact: 8aabba7f7d user: anonymous | |
05:30 | • Reply: Sorting by date into groups artifact: 10161ae310 user: anonymous | |
2023-02-06
| ||
21:17 | • Reply: Locale database & remote JS application artifact: 039a0fc3ed user: anonymous | |
19:16 | • Reply: GLOB index acceleration for special characters like star and square bracket? artifact: 2dd98dab4b user: anonymous | |
18:54 | • Reply: transposing columns to rows and getting counts artifact: f494c6c81b user: anonymous | |
03:54 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: cd2ba21c9e user: anonymous | |
03:17 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 4b25017d4d user: anonymous | |
01:22 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: d8a88a700d user: anonymous | |
00:23 | • Reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 3c722bc250 user: anonymous | |
2023-02-05
| ||
20:18 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 621382ad80 user: anonymous | |
09:51 | • Reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 72d10e264d user: anonymous | |
2023-02-04
| ||
02:56 | • Post: What is the best way to backup an SQLite DB on a host without SSH? artifact: ded0170047 user: anonymous | |
2023-02-03
| ||
22:21 | • Post: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 303ee96b60 user: anonymous | |
17:13 | • Reply: Working around `INSERT SELECT` doing shortcuts in case of corrupted DBs artifact: 06d2d4efcb user: anonymous | |
13:23 | • Reply: How we can implement SQLiteEngine in latest version of SQLite? I'm migrating from SQLCE to SQLITE. artifact: 81bee54cf1 user: anonymous | |
13:17 | • Reply: How we can implement SQLiteEngine in latest version of SQLite? I'm migrating from SQLCE to SQLITE. artifact: 97fb80158e user: anonymous | |
05:08 | • Reply: INSTR from the right? artifact: 7ee67bdd71 user: anonymous | |
2023-02-02
| ||
20:10 | • Reply: Working around `INSERT SELECT` doing shortcuts in case of corrupted DBs artifact: e81340c82c user: anonymous | |
10:58 | • Post: How we can implement SQLiteEngine in latest version of SQLite? I'm migrating from SQLCE to SQLITE. artifact: 789ac64403 user: anonymous | |
03:03 | • Reply: The "sqlite_schema" name is not fully first-class artifact: 8391c59eb4 user: anonymous | |
2023-02-01
| ||
16:00 | • Reply: Speeding up creation of multiple indices on single table artifact: f6f2b99712 user: anonymous | |
15:11 | • Reply: Speeding up creation of multiple indices on single table artifact: 03f316d6ac user: anonymous | |