SQLite Forum

Timeline
Login

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
Previous month ↓