SQLite Forum

Timeline
Login

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

139 events for the month beginning 2022-01-01 by user anonymous

Following month ↑
2022-01-31
16:30 Post: 4-byte float possible in SQLite? artifact: fe89b039d2 user: anonymous
14:22 Reply: sqlite3_backup_init returns null, but no error is set artifact: 4eea8651aa user: anonymous
09:58 Post: sqlite3_backup_init returns null, but no error is set artifact: 8b39fbf3e7 user: anonymous
2022-01-30
08:23 Post: sqlite3_stmt: binding from multiple threads possible ? artifact: ddb682d613 user: anonymous
2022-01-29
17:40 Reply: UPDATE FROM syntax error artifact: a991607139 user: anonymous
16:45 Post: UPDATE FROM syntax error artifact: 5da57f8562 user: anonymous
2022-01-28
23:32 Post: How to keep collation after substr()? artifact: 0f7d79f53e user: anonymous
15:43 Reply: Primary Key or Unique Index artifact: 8a6ec21259 user: anonymous
02:24 Reply: Include extensions at compile time artifact: 4eb852e31c user: anonymous
2022-01-27
23:46 Post: SQLITE_FCNTL_LAST_ERRNO artifact: c1bd305cbc user: anonymous
16:05 Post: Include extensions at compile time artifact: afcde048be user: anonymous
15:54 Post: Error in UPDATE FROM examples? "GROUP BY 2)"? artifact: a05a2dff69 user: anonymous
14:42 Reply: Proposed JSON enhancements. artifact: 05687574ab user: anonymous
2022-01-26
09:37 Reply: How to start a program that use SQLITE with SYSTEMD ? artifact: a08fee6697 user: anonymous
03:47 Post: How to start a program that use SQLITE with SYSTEMD ? artifact: deaec04a2b user: anonymous
2022-01-25
19:47 Reply: Finding the SQLite version for a feature artifact: 7666cfe7e0 user: anonymous
14:51 Reply: Case when artifact: 27d62a5779 user: anonymous
14:10 Reply: Case when artifact: ef423f63ea user: anonymous
11:03 Reply: One connection per function or one shared connection? artifact: 4b098d3891 user: anonymous
10:57 Reply: One connection per function or one shared connection? artifact: ff2fe46b1f user: anonymous
08:11 Reply: Finding the SQLite version for a feature artifact: 6b0d1f7d7b user: anonymous
04:00 Reply: column constraint ascending primary key with text type artifact: cfe7604e71 user: anonymous
01:55 Post: One connection per function or one shared connection? artifact: 11ff514e05 user: anonymous
01:29 Reply: Case when artifact: 6cf57f582a user: anonymous
2022-01-24
22:04 Reply: Session Extension: Changeset for Query/View artifact: 9cfa8cef03 user: anonymous
21:37 Reply: Session Extension: Changeset for Query/View artifact: 8cc4cb1e8e user: anonymous
20:55 Reply: Session Extension: Changeset for Query/View artifact: ba60f9879f user: anonymous
20:28 Reply: Session Extension: Changeset for Query/View artifact: deb67c5033 user: anonymous
19:57 Reply: Case when artifact: 2f9b0dd7e2 user: anonymous
19:37 Post: Session Extension: Changeset for Query/View artifact: 8da27fbe1d user: anonymous
19:19 Reply: Trying to "Open Database" Safari History.db file and get Error: "could not open safari database file reason: unable to open.. artifact: cbc5917fbd user: anonymous
17:06 Reply: Is it possible to use WAL mode without using mmap() function ? artifact: 2be556bf95 user: anonymous
16:58 Reply: Is it possible to use WAL mode without using mmap() function ? artifact: 6844815bbf user: anonymous
14:46 Reply: Case when artifact: 573d9a4a0e user: anonymous
09:24 Reply: Initialisation artifact: 18f1fcc4a5 user: anonymous
06:59 Reply: Proposed JSON enhancements. artifact: 32186abcac user: anonymous
06:53 Post: column constraint ascending primary key with text type artifact: 1b4209200b user: anonymous
2022-01-23
23:24 Reply: binding by reference instead of value artifact: 6592f932e8 user: anonymous
20:36 Reply: What happens if I exit an app without closing the db? artifact: 8fe28670d2 user: anonymous
15:03 Reply: INSERT INTO SELECT upgrade to IMMEDIATE/EXCLUSIVE artifact: 38f50cfef0 user: anonymous
09:35 Reply: INSERT INTO SELECT upgrade to IMMEDIATE/EXCLUSIVE artifact: 9b35abdfdc user: anonymous
2022-01-22
22:17 Reply: Confusing sqlite3_vtab_distinct artifact: 4380f29b58 user: anonymous
13:15 Post: INSERT INTO SELECT upgrade to IMMEDIATE/EXCLUSIVE artifact: ba3eb2deab user: anonymous
04:45 Post: Confusing sqlite3_vtab_distinct artifact: 2eaeea344d user: anonymous
2022-01-21
22:13 Reply: Looks like some exports are missing from the Windows x64 official SQLite DLL artifact: bf30698850 user: anonymous
17:28 Post: Looks like some exports are missing from the Windows x64 official SQLite DLL artifact: 4ff22bc13e user: anonymous
08:19 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: cdd755ce51 user: anonymous
2022-01-20
19:59 Reply: Case when artifact: 54d257a88c user: anonymous
19:30 Reply: Case when artifact: aae50a2ad0 user: anonymous
18:29 Reply: Case when artifact: 9ea8174bc6 user: anonymous
18:12 Post: Case when artifact: fed03dfa39 user: anonymous
16:55 Reply: Is it possible to fix a more than 1G corrupted SQLite file with only the first 16K content corrupted? artifact: 8d7fa608bd user: anonymous
11:14 Reply: How to check if sqlite3_stmt is done? artifact: a48df178ed user: anonymous
02:41 Post: Is it possible to fix a more than 1G corrupted SQLite file with only the first 16K content corrupted? artifact: 7498847597 user: anonymous
2022-01-19
23:06 Reply: SQLITE3.EXE V3.37.2 artifact: 6afb109b33 user: anonymous
20:51 Post: SQLITE3.EXE V3.37.2 artifact: f52e6c09f9 user: anonymous
20:45 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: 8de43163fb user: anonymous
20:27 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: 622e06690c user: anonymous
18:19 Reply: Where is sqlite3_stmt defined artifact: 76f81d3be5 user: anonymous
01:31 Reply: .param set accepts "illegal" names artifact: b4f6880323 user: anonymous
2022-01-18
21:47 Post: pragma table_info confusion by multiple attache databases artifact: d462db9ed4 user: anonymous
15:32 Reply: Query about backup API artifact: 9b0717a355 user: anonymous
2022-01-17
18:54 Reply: Query about backup API artifact: 59528fa583 user: anonymous
11:34 Post: USE statement, or a way to set default schema artifact: 0ba2be5e05 user: anonymous
00:08 Post: Query about backup API artifact: ec9215945c user: anonymous
2022-01-16
14:31 Reply: Windows 3.37.3 sqlite3.exe .schema output includes creation of sqlite_ tables in error (presumably) artifact: 392d16f367 user: anonymous
13:14 Post: Windows 3.37.3 sqlite3.exe .schema output includes creation of sqlite_ tables in error (presumably) artifact: 64adc36938 user: anonymous
08:19 Reply: Change windows current folder as part of .system parameter artifact: 57cc9ad439 user: anonymous
06:02 Post: Change windows current folder as part of .system parameter artifact: ad85056ade user: anonymous
2022-01-15
07:29 Post: Release db file artifact: 3cbfbbcb58 user: anonymous
2022-01-14
17:35 Reply: Any use case for the Bloom filter for "large analytic queries" artifact: 68e574584b user: anonymous
14:45 Reply: Any use case for the Bloom filter for "large analytic queries" artifact: 0eb30ba42a user: anonymous
2022-01-13
20:13 Post: Any use case for the Bloom filter for "large analytic queries" artifact: 7d0457b3a8 user: anonymous
2022-01-12
19:48 Reply: Proposed JSON enhancements. artifact: 1529127930 user: anonymous
14:15 Reply: Proposed JSON enhancements. artifact: cf829c8847 user: anonymous
14:06 Reply: Unicode Input/output in sqlite3.exe on Windows 10 artifact: 0059517289 user: anonymous
13:42 Post: sqlite native library in Android returns disk I/O error artifact: 0a051ab9c2 user: anonymous
06:21 Reply: Unicode Input/output in sqlite3.exe on Windows 10 artifact: 3355248685 user: anonymous
06:10 Reply: Dispatch Sqlite Instance with event loop artifact: b93e27dfab user: anonymous
02:09 Reply: Proposed JSON enhancements. artifact: 60c2c6ec7f user: anonymous
2022-01-11
22:42 Post: System.Data.SQLite.Core SUM operation always returns as Int64 artifact: 13e47f0557 user: anonymous
21:41 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 artifact: 3be2f8aedc user: anonymous
20:47 Reply: Proposed JSON enhancements. artifact: 993c4bb7fc user: anonymous
19:23 Reply: Unicode Input/output in sqlite3.exe on Windows 10 artifact: aa8d35140b user: anonymous
18:07 Reply: Dispatch Sqlite Instance with event loop artifact: f61051cfad user: anonymous
15:31 Reply: install sqlite on windows10 artifact: 635ecaf226 user: anonymous
14:19 Reply: Dispatch Sqlite Instance with event loop artifact: de24245a0c user: anonymous
13:36 Reply: Dispatch Sqlite Instance with event loop artifact: bd07b45c47 user: anonymous
11:36 Reply: install sqlite on windows10 artifact: 001d478caa user: anonymous
11:22 Post: Dispatch Sqlite Instance with event loop artifact: 3cdde924d3 user: anonymous
02:04 Reply: Proposed JSON enhancements. artifact: a3b5f03ec1 user: anonymous
01:52 Reply: Unicode Input/output in sqlite3.exe on Windows 10 artifact: 673782675f user: anonymous
2022-01-10
21:20 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 artifact: 95259d7cec user: anonymous
21:18 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 artifact: 27a0b095d3 user: anonymous
20:35 Post: Unicode Input/output in sqlite3.exe on Windows 10 artifact: 100d47ad3d user: anonymous
20:22 Reply: Proposed JSON enhancements. artifact: 88007ca540 user: anonymous
19:41 Reply: RETURNING clause on prepared statement not behaving like un-prepared artifact: 5d05e48db7 user: anonymous
17:23 Reply: Proposed JSON enhancements. artifact: 10b073e5a8 user: anonymous
13:36 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 artifact: e74274f52a user: anonymous
10:01 Reply: Proposed JSON enhancements. artifact: bbcd725f93 user: anonymous
04:16 Reply: Proposed JSON enhancements. artifact: 70ca618a55 user: anonymous
01:15 Post: Using SQLITE_OMIT_xxx in SQLite 3.36 artifact: 9dbcfb2e40 user: anonymous
2022-01-09
22:34 Reply: Is it possible to make -shm/-wal files permanent? artifact: dec1b07865 user: anonymous
22:16 Reply: Is it possible to make -shm/-wal files permanent? artifact: 4269077ef3 user: anonymous
22:14 Reply: An index is not used to optimize GROUP BY query artifact: bc96228693 user: anonymous
21:33 Reply: Is it possible to make -shm/-wal files permanent? artifact: bbe5f02864 user: anonymous
21:16 Reply: 3 incorrect tables created during import artifact: 5ac04fcb4c user: anonymous
21:03 Reply: Is it possible to make -shm/-wal files permanent? artifact: 9203707e98 user: anonymous
20:51 Reply: Is it possible to make -shm/-wal files permanent? artifact: 5691813a85 user: anonymous
20:46 Reply: Proposed JSON enhancements. artifact: 57f56ee586 user: anonymous
20:00 Reply: Is it possible to make -shm/-wal files permanent? artifact: 6430a4076f user: anonymous
19:37 Post: An index is not used to optimize GROUP BY query artifact: c922d6f398 user: anonymous
18:03 Reply: LIKE doesn't handle text with embedded zero bytes artifact: 3695611254 user: anonymous
17:30 Post: Is it possible to make -shm/-wal files permanent? artifact: 30d8de773a user: anonymous
16:15 Post: LIKE doesn't handle text with embedded zero bytes artifact: 2692e7475a user: anonymous
03:41 Reply: Proposed JSON enhancements. artifact: a494784788 user: anonymous
2022-01-08
21:19 Reply: Proposed JSON enhancements. artifact: 628df513ab user: anonymous
14:55 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS artifact: aa5eda1696 user: anonymous
09:26 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS artifact: fcba3fcbfc user: anonymous
01:29 Reply: Proposed JSON enhancements. artifact: c8cf8de857 user: anonymous
2022-01-07
14:27 Reply: Windows nanosecond file times to accurate presentable format and back artifact: e8b0464ede user: anonymous
14:06 Reply: Windows nanosecond file times to accurate presentable format and back artifact: 1e4871d245 user: anonymous
14:04 Reply: Calculating time between two dates artifact: 344e5a9c6f user: anonymous
14:00 Reply: Calculating time between two dates artifact: d3213a0d59 user: anonymous
11:09 Post: Windows nanosecond file times to accurate presentable format and back artifact: 698fc6290b user: anonymous
07:26 Post: Disk i/o error in WAL mode artifact: 1a035dd803 user: anonymous
04:52 Reply: Potential database corruption in SQLite versions 3.35.0 through 3.37.1 artifact: 95c0246c27 user: anonymous
2022-01-06
20:27 Reply: Data loss after iOS device force restarts artifact: aa47b6b579 user: anonymous
16:16 Reply: Buggy JSON1? artifact: 659a5d51e6 user: anonymous
14:59 Post: Buggy JSON1? artifact: 156de6384b user: anonymous
10:04 Reply: Shell documentation request artifact: ccceca9e49 user: anonymous
2022-01-05
16:27 Reply: Arrays in SQLite artifact: fbdc4cc040 user: anonymous
15:39 Reply: Is safe to perform sqlite3_reset and sqlite3_clear_bindings in a separate thread? artifact: ad1beab8b3 user: anonymous
13:12 Reply: Arrays in SQLite artifact: 4b040f50c8 user: anonymous
12:43 Reply: Data loss after iOS device force restarts artifact: dbe512e5bc user: anonymous
04:14 Post: The wrong separation of eval extension artifact: 255a66fa35 user: anonymous
2022-01-04
15:54 Reply: strings separated by ";" convert to columns artifact: 4cb709801f user: anonymous
2022-01-02
17:59 Post: UTF-16 + blob + .mode quote → nonsense artifact: b4bfe62fe6 user: anonymous
2022-01-01
17:05 Post: sqlite3.c:228457:18: warning: 'memcpy' specified bound exceeds maximum object size artifact: befb9b54fd user: anonymous
Previous month ↓