SQLite Forum

Timeline
Login

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

122 events for the month beginning 2023-01-01 by user anonymous

Following month ↑
2023-01-31
20:43 Reply: .import csv and NULL values artifact: 21b4c09fb3 user: anonymous
19:08 Post: julianday('now') returns incorrect date/time artifact: 704f331603 user: anonymous
18:56 Reply: Working around `INSERT SELECT` doing shortcuts in case of corrupted DBs artifact: 0ce8b2fcd5 user: anonymous
18:45 Reply: Decrease RBU Runtime artifact: d7b3076bbf user: anonymous
13:10 Reply: Safari error for latest SQLite WASM artifact: beb3335e9a user: anonymous
10:38 Reply: base64 and 85 line length artifact: 4c0044389f user: anonymous
07:24 Post: base64 and 85 line length artifact: d7e094798a user: anonymous
2023-01-30
11:47 Reply: Completion of error handling artifact: 01cdf771d8 user: anonymous
2023-01-29
20:01 Reply: WASM COOP/COEP HTTP Headers artifact: 8ed64b6175 user: anonymous
16:29 Reply: Completion of error handling artifact: d6ab7dbb2e user: anonymous
06:00 Reply: A question to walCkptInfo() artifact: ddfa00ca00 user: anonymous
02:38 Post: A question to walCkptInfo() artifact: ae5fd31d97 user: anonymous
2023-01-28
23:35 Post: PatchCLIWin32 Use current console codepages instead of default OEM codepage artifact: 1b7764df16 user: anonymous
22:24 Post: SQLite dll artifact: 615416c5bb user: anonymous
16:37 Post: Bugcheck PRAGMA quick_check errors on 3.40.0+ artifact: 2531706cb5 user: anonymous
13:03 Reply: WASM COOP/COEP HTTP Headers artifact: d2cca90d0f user: anonymous
2023-01-27
06:33 Reply: WASM COOP/COEP HTTP Headers artifact: 6d7bda728a user: anonymous
02:37 Reply: return table-like result set artifact: 21e3ac5dcb user: anonymous
2023-01-26
22:59 Reply: return table-like result set artifact: d8b166f63a user: anonymous
22:45 Post: Decrease RBU Runtime artifact: 719b1c7cb3 user: anonymous
19:32 Reply: return table-like result set artifact: ec11511239 user: anonymous
19:31 Reply: return table-like result set artifact: 9622137bed user: anonymous
16:42 Reply: return table-like result set artifact: eb92a6c12c user: anonymous
04:18 Post: SQLite 3.31.1 .command stopped working? artifact: abcfaf732a user: anonymous
01:39 Post: WASM COOP/COEP HTTP Headers artifact: 0497b3e608 user: anonymous
2023-01-25
19:53 Post: return table-like result set artifact: b083a23211 user: anonymous
09:16 Reply: an update suggestion for faq page artifact: 38973914db user: anonymous
06:28 Post: an update suggestion for fileformat2.html artifact: f381c42ab1 user: anonymous
05:33 Reply: Naming convention for dynamically loaded extension libs artifact: cefe8660ef user: anonymous
05:29 Post: an update suggestion for faq page artifact: f3b8bbae2a user: anonymous
2023-01-24
22:27 Reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 7439d5df0a user: anonymous
13:34 Reply: ATTACHed DATABASE doesnt not respect cache_size pragma artifact: 0b04a990eb user: anonymous
12:57 Post: ATTACHed DATABASE doesnt not respect cache_size pragma artifact: 14676e878c user: anonymous
06:37 Reply: Best practices lowering memory consumption with hundreds of open DBs artifact: ac3e8e1baa user: anonymous
2023-01-23
21:31 Post: Best practices lowering memory consumption with hundreds of open DBs artifact: d4bee5c609 user: anonymous
19:44 Reply: i've got that terrible warning at the end of building my c++ project artifact: d828157b1d user: anonymous
17:21 Reply: Help Compiling SQLite for UWP ARM64 artifact: fead17552c user: anonymous
2023-01-22
23:18 Post: How to download and install version 3.39.2 artifact: a77ad5e00c user: anonymous
19:47 Reply: Shouldn't a missing comma cause an error? artifact: 53b10364b9 user: anonymous
03:19 Reply: Shouldn't a missing comma cause an error? artifact: 7a74bcd103 user: anonymous
2023-01-21
13:50 Reply: How to add base64 and 85 to the amalgamation as builtin function artifact: 265f5d26f8 user: anonymous
09:36 Reply: How to add base64 and 85 to the amalgamation as builtin function artifact: 97de25aaed user: anonymous
08:24 Reply: Bitmap/mask index ? artifact: 34eef677ec user: anonymous
05:19 Reply: how to use SQLITE_DEFAULT_LOCKING_MODE artifact: 4c6f2ad310 user: anonymous
2023-01-20
14:51 Post: How to add base64 and 85 to the amalgamation as builtin function artifact: 28bda0bb15 user: anonymous
13:43 Reply: HEX - What is the reverse function? artifact: 87276e1c55 user: anonymous
08:40 Reply: Duplicate constraints per column artifact: 250aa633c0 user: anonymous
06:02 Reply: Bitmap/mask index ? artifact: 13e2d343a1 user: anonymous
00:54 Reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 2b63f9fe75 user: anonymous
2023-01-19
21:33 Post: Duplicate constraints per column artifact: ecec4a0cfc user: anonymous
19:47 Reply: Protect against spurious wakeups artifact: 0a8fffa25e user: anonymous
14:26 Reply: Hctree is an experimental high-concurrency database backend for SQLite. artifact: 62c5bd5bfe user: anonymous
13:02 Reply: Hctree is an experimental high-concurrency database backend for SQLite. artifact: 80c8f54654 user: anonymous
10:31 Reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: e79052b9d7 user: anonymous
09:31 Reply: Methods of achieving the same results as if it were possible to perfrom an unpdate and an insert within the same CTE? artifact: 222184a6d9 user: anonymous
05:46 Post: i've got that terrible warning at the end of building my c++ project artifact: e3f72e9291 user: anonymous
02:53 Reply: Hctree is an experimental high-concurrency database backend for SQLite. artifact: a104d7df56 user: anonymous
2023-01-18
20:46 Reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 82edb3e909 user: anonymous
20:22 Reply: Hctree is an experimental high-concurrency database backend for SQLite. artifact: e0a3a088dd user: anonymous
19:55 Post: SQLLite Querying Question artifact: fb3f1c8114 user: anonymous
2023-01-17
21:40 Post: Terminal output into DB with SQLite artifact: 5f1065ad98 user: anonymous
13:33 Reply: How to work with FTS5 external content tables ? artifact: acdc2aa30a user: anonymous
13:02 Reply: In the sqlite shell, show the number of rows in the result set artifact: a524b3cc5f user: anonymous
02:32 Reply: How to work with FTS5 external content tables ? artifact: 560eca57e2 user: anonymous
01:39 Post: How to work with FTS5 external content tables ? artifact: 38d5238e16 user: anonymous
2023-01-16
19:53 Post: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 604359f32d user: anonymous
10:55 Post: near "%": syntax error artifact: aa1b0b4121 user: anonymous
01:38 Post: .clone/.recover: manpages and webpage artifact: 85f1fef4fb user: anonymous
01:32 Post: .clone command should suppress one error artifact: 71ff9e6c4c user: anonymous
01:10 Post: Working around `INSERT SELECT` doing shortcuts in case of corrupted DBs artifact: 06c227ccc4 user: anonymous
2023-01-15
16:11 Reply: How to save/export results of .recover command? artifact: ef543c1997 user: anonymous
14:45 Reply: How to save/export results of .recover command? artifact: d4ee0b8170 user: anonymous
11:41 Reply: How to save/export results of .recover command? artifact: 5e68961186 user: anonymous
07:09 Reply: Protect against spurious wakeups artifact: 02f66a0cc7 user: anonymous
01:12 Post: How to save/export results of .recover command? artifact: 7c71b87003 user: anonymous
2023-01-13
07:27 Reply: ALTER TABLE RENAME TO fails if compiled with SQLITE_OMIT_TEMPDB artifact: 37c824578f user: anonymous
2023-01-12
14:49 Post: ALTER TABLE RENAME TO fails if compiled with SQLITE_OMIT_TEMPDB artifact: c9043ae08c user: anonymous
05:03 Reply: Windows Build default compile options? artifact: 0d76b54308 user: anonymous
04:03 Reply: Help Compiling SQLite for UWP ARM64 artifact: 55807d9558 user: anonymous
2023-01-11
23:51 Reply: Why in tables WITHOUT ROWID is the amount of payload that spills onto overflow pages from leaf page like for an index page? artifact: bd58ceb9b5 user: anonymous
10:16 Post: sqlar documentation error artifact: 0ee8c281ff user: anonymous
08:38 Post: How to show tables? artifact: ac69606634 user: anonymous
06:43 Reply: about the result 1='1' that sqlite behave different with mysql or oracle artifact: 177a7f8f4a user: anonymous
2023-01-10
20:24 Reply: Find an issue sqlite cannot open on some release version of Linux artifact: 3a0a9f9bde user: anonymous
19:51 Reply: Cancellation in custom SQLiteFunction artifact: 532910b62d user: anonymous
13:47 Reply: SQLite won't .quit from Windows PowerShell artifact: ec1bf8a23d user: anonymous
09:21 Reply: Help Compiling SQLite for UWP ARM64 artifact: d2391595aa user: anonymous
04:29 Reply: sqlite3_reset not picking up error from window function final artifact: a79b587ee4 user: anonymous
2023-01-09
17:35 Reply: Execute Tab artifact: 71d34321c2 user: anonymous
12:33 Reply: in memory syntax creates file in ntfs streams artifact: 15f1c8e416 user: anonymous
12:33 Post: Execute Tab artifact: 787da7f42f user: anonymous
12:28 Post: SQLite won't .quit from Windows PowerShell artifact: 72e64743aa user: anonymous
12:28 Reply: in memory syntax creates file in ntfs streams artifact: 1a51699462 user: anonymous
03:37 Reply: Easy way to insert parent-child relationships? artifact: cb00b30354 user: anonymous
2023-01-08
22:02 Post: in memory syntax creates file in ntfs streams artifact: 22c440c825 user: anonymous
2023-01-07
10:16 Post: sqlite3_preupdate_hook documentation hole artifact: 94a32f6e37 user: anonymous
04:25 Reply: Help Compiling SQLite for UWP ARM64 artifact: d10d8af345 user: anonymous
2023-01-06
20:08 Post: online verrsion of sqlite3 artifact: 4951ae950f user: anonymous
17:39 Reply: Easy way to insert parent-child relationships? artifact: d41679abdb user: anonymous
14:54 Post: Easy way to insert parent-child relationships? artifact: fd5785384a user: anonymous
11:42 Post: How to reset and account password artifact: fd86a4989d user: anonymous
08:43 Reply: Master-Slave replication for sqlite3? artifact: c808d8cf46 user: anonymous
00:18 Reply: INSERT from SELECT artifact: dfa6877bba user: anonymous
2023-01-05
05:10 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 395742a4b0 user: anonymous
2023-01-04
21:32 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 918f864ea4 user: anonymous
21:09 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: ac1352fb8e user: anonymous
17:28 Post: Accessing SQLite DB file remotely over network artifact: 33a6112dd4 user: anonymous
05:39 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 8bf91fedac user: anonymous
05:14 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 82397fe43f user: anonymous
04:58 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 3dc2de01da user: anonymous
2023-01-03
12:52 Reply: Info on sqlite Write-Ahead Logging (WAL) artifact: a9e681a729 user: anonymous
01:23 Reply: Complete documentation artifact: 4ab9eb2421 user: anonymous
2023-01-02
20:50 Reply: Bug selecting 64bit integer artifact: 7d4c10b1f8 user: anonymous
18:58 Post: Bug selecting 64bit integer artifact: baef963831 user: anonymous
18:56 Reply: SQLite work very slowly artifact: 8cb67ece75 user: anonymous
07:53 Reply: How to import the sql exported from mysqldump. artifact: 989374a282 user: anonymous
06:09 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: c4e9459161 user: anonymous
02:25 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 57c2b02a8b user: anonymous
2023-01-01
22:57 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 1535163567 user: anonymous
22:38 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 9031c591c6 user: anonymous
22:33 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 998fe75d02 user: anonymous
07:03 Post: Bitmap/mask index ? artifact: 40f861de76 user: anonymous
Previous month ↓