Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
165 events for the month beginning 2021-04-01 by user anonymous
Following month ↑
2021-04-30
| ||
17:20 | • Post: classic save possibility artifact: fdd082cfc8 user: anonymous | |
03:30 | • Reply: sqlite3_blob_read returns SQL Logic Error artifact: dec4f3a94c user: anonymous | |
01:54 | • Post: sqlite3_blob_read returns SQL Logic Error artifact: d644a9a787 user: anonymous | |
2021-04-29
| ||
16:38 | • Post: SQLITE_OMIT_AUTHORIZATION and unused result warning artifact: 1f868b0e68 user: anonymous | |
12:23 | • Post: GCC 11.1 warnings in 3.35.3 artifact: 256140e470 user: anonymous | |
08:46 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 31b1cbacb0 user: anonymous | |
04:36 | • Reply: Help, reading sqlite3_blob_open() artifact: 5771188e6f user: anonymous | |
00:28 | • Reply: Help, reading sqlite3_blob_open() artifact: a33c27b4d8 user: anonymous | |
2021-04-28
| ||
23:13 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 17ce93cea4 user: anonymous | |
20:28 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: d48b41d8dc user: anonymous | |
18:30 | • Reply: Version 3.35.6 ?? artifact: 781fbb1124 user: anonymous | |
16:42 | • Post: Version 3.35.6 ?? artifact: be4de87657 user: anonymous | |
09:53 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 3f1a7acf12 user: anonymous | |
09:45 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 61a14a96a2 user: anonymous | |
04:45 | • Reply: Help, reading sqlite3_blob_open() artifact: 8e282c132c user: anonymous | |
03:27 | • Post: Help, reading sqlite3_blob_open() artifact: dfc381680e user: anonymous | |
01:08 | • Reply: Blobs & SQLITE_TRANSIENT clarification artifact: a98d455103 user: anonymous | |
2021-04-27
| ||
23:42 | • Post: Blobs & SQLITE_TRANSIENT clarification artifact: b395962937 user: anonymous | |
2021-04-26
| ||
13:19 | • Reply: Virtual Table based on template templatevtab loads OK but "no such module" artifact: f80c29a20e user: anonymous | |
12:17 | • Reply: Virtual Table based on template templatevtab loads OK but "no such module" artifact: dca41189b0 user: anonymous | |
11:34 | • Post: Virtual Table based on template templatevtab loads OK but "no such module" artifact: 19404fc630 user: anonymous | |
2021-04-25
| ||
22:03 | • Reply: Backup via file system backup software artifact: 019444a0ec user: anonymous | |
17:57 | • Reply: How to convert to CTE artifact: 2108d35208 user: anonymous | |
10:23 | • Reply: How to convert to CTE artifact: 7a81a2f204 user: anonymous | |
00:16 | • Post: Backup via file system backup software artifact: f173a78e2e user: anonymous | |
2021-04-24
| ||
18:03 | • Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 1f5e9ad2bd user: anonymous | |
16:28 | • Reply: How to convert to CTE artifact: 0ee037e6da user: anonymous | |
16:06 | • Reply: How to convert to CTE artifact: 31fcbbe0e4 user: anonymous | |
16:04 | • Reply: Getting error when pipe sql into sqlite3 utility artifact: eeaa25a776 user: anonymous | |
15:50 | • Reply: How to convert to CTE artifact: c3a85c617b user: anonymous | |
13:42 | • Reply: Getting error when pipe sql into sqlite3 utility artifact: 939d45fd1d user: anonymous | |
12:02 | • Reply: PROBLEM WITH TRANSACTION artifact: c9f81f2eb9 user: anonymous | |
10:01 | • Reply: How to convert to CTE artifact: 03bd260b24 user: anonymous | |
09:59 | • Post: Getting error when pipe sql into sqlite3 utility artifact: ed8f696a20 user: anonymous | |
05:15 | • Reply: How to convert to CTE artifact: 0d9d3a0ab8 user: anonymous | |
04:53 | • Reply: How to convert to CTE artifact: 2266974831 user: anonymous | |
2021-04-23
| ||
18:30 | • Reply: How to convert to CTE artifact: 46061e2f58 user: anonymous | |
06:28 | • Reply: How to convert to CTE artifact: 64853f11a9 user: anonymous | |
03:00 | • Reply: How to convert to CTE artifact: 9a1e80c07a user: anonymous | |
2021-04-22
| ||
21:40 | • Reply: How to convert to CTE artifact: 3ccd04a696 user: anonymous | |
21:34 | • Reply: How to convert to CTE artifact: 61c2babbcd user: anonymous | |
21:23 | • Reply: How to convert to CTE artifact: a4e0a30a01 user: anonymous | |
21:09 | • Reply: How to convert to CTE artifact: 65545bcb33 user: anonymous | |
20:50 | • Reply: How to convert to CTE artifact: 6bb785e723 user: anonymous | |
16:38 | • Post: SQL Lite DB drawbacks then going for full text index library artifact: 3c2abd5f08 user: anonymous | |
2021-04-21
| ||
19:08 | • Reply: V 3.35.5 artifact: aa005429ab user: anonymous | |
17:01 | • Post: query plan for "is null" on column defined as "not null" artifact: 85be5cc08f user: anonymous | |
16:49 | • Post: query plan for "is null" on column defined as "not null" artifact: dc6fcfe6b2 user: anonymous | |
07:52 | • Reply: The NUMERIC data type? artifact: 7b065ccf40 user: anonymous | |
04:11 | • Reply: Will there be a 64-bit Windows Download for v3.35.5? artifact: 23bbb607e8 user: anonymous | |
03:27 | • Reply: Will there be a 64-bit Windows Download for v3.35.5? artifact: d45bbb5fe0 user: anonymous | |
03:20 | • Post: How to compile the libsqlitejdbc.so? artifact: 5d7b069676 user: anonymous | |
02:04 | • Post: Will there be a 64-bit Windows Download for v3.35.5? artifact: 3080f97941 user: anonymous | |
01:09 | • Post: The NUMERIC data type? artifact: 6540c75cf6 user: anonymous | |
2021-04-20
| ||
19:31 | • Reply: Bug report: Complex CTE generates segmentation fault depending on the order of joined tables in its body artifact: 975726c023 user: anonymous | |
13:31 | • Reply: Why no release announcement in this Forum anymore? artifact: 8b99c2e0fc user: anonymous | |
12:06 | • Reply: V 3.35.5 artifact: fdf144384c user: anonymous | |
11:25 | • Reply: Why no release announcement in this Forum anymore? artifact: d925bdae08 user: anonymous | |
08:44 | • Post: Why no release announcement in this Forum anymore? artifact: 5a99f150c6 user: anonymous | |
06:14 | • Reply: Clarification re parameters needed. artifact: 006b445e59 user: anonymous | |
04:55 | • Post: V 3.35.5 artifact: e42820dc90 user: anonymous | |
2021-04-19
| ||
23:54 | • Reply: simple insert issue with 3.35.5 - .sqliterc issue? artifact: da3c47397b user: anonymous | |
23:08 | • Post: Clarification re parameters needed. artifact: 1acdeae96c user: anonymous | |
20:42 | • Reply: Administrator SQLite artifact: 12ccb88bac user: anonymous | |
20:21 | • Post: simple insert issue with 3.35.5 - .sqliterc issue? artifact: d3f408df38 user: anonymous | |
19:59 | • Reply: Access strategy for a one-thread per connection http server artifact: 1bc7813cdb user: anonymous | |
17:59 | • Reply: Administrator SQLite artifact: e9ab63c697 user: anonymous | |
15:10 | • Post: Administrator SQLite artifact: 8f3fd098b9 user: anonymous | |
13:34 | • Post: How to Record all Transactions artifact: d444043cad user: anonymous | |
13:11 | • Reply: Access strategy for a one-thread per connection http server artifact: 47e9770883 user: anonymous | |
08:45 | • Reply: AVG with GROUP BY returns 0 artifact: 95c3b35c4b user: anonymous | |
08:43 | • Reply: AVG with GROUP BY returns 0 artifact: d87ea04e54 user: anonymous | |
07:45 | • Post: AVG with GROUP BY returns 0 artifact: 422cbf1f60 user: anonymous | |
06:56 | • Reply: Access strategy for a one-thread per connection http server artifact: b7c5b251aa user: anonymous | |
02:05 | • Post: Access strategy for a one-thread per connection http server artifact: 4306d5fb45 user: anonymous | |
2021-04-18
| ||
08:23 | • Reply: Reporting vulnerabilities artifact: 8ac39a2db2 user: anonymous | |
08:08 | • Reply: Week numbers in queries artifact: 3c41319790 user: anonymous | |
2021-04-16
| ||
17:50 | • Post: Reporting vulnerabilities artifact: 306a7d3381 user: anonymous | |
2021-04-15
| ||
21:01 | • Post: Question About Command Line Backup of Locked DB artifact: 77b3c9106a user: anonymous | |
18:02 | • Reply: Feature request: support sqlite3_mem_methods.xSize = NULL artifact: cf61f92970 user: anonymous | |
16:06 | • Reply: Proposal: Implement the MOD(x, y) function artifact: ee7b54a87e user: anonymous | |
14:48 | • Reply: SQLite the only database you will ever need in most cases artifact: 8544ffd786 user: anonymous | |
13:43 | • Reply: How to run SQLite shell program on Android artifact: 705f348437 user: anonymous | |
12:21 | • Reply: programming sqlite bytecode directly ? artifact: f5a05923b2 user: anonymous | |
11:58 | • Post: programming sqlite bytecode directly ? artifact: 83578adea8 user: anonymous | |
11:32 | • Post: Feature request: support sqlite3_mem_methods.xSize = NULL artifact: 554ab25226 user: anonymous | |
10:57 | • Reply: How to run SQLite shell program on Android artifact: 184328ca66 user: anonymous | |
10:27 | • Post: How to run SQLite shell program on Android artifact: 85479d92b5 user: anonymous | |
2021-04-14
| ||
13:50 | • Reply: usage of SHA-1 artifact: 91a19b36c6 user: anonymous | |
12:12 | • Reply: object name reserved for internal use: sqlite_parameters artifact: 7a1db0c1f4 user: anonymous | |
10:28 | • Post: object name reserved for internal use: sqlite_parameters artifact: 2457828f46 user: anonymous | |
09:35 | • Reply: Only Column Names read from table artifact: 8e7fa4ac7f user: anonymous | |
2021-04-13
| ||
23:20 | • Reply: Regression: Mixing AND with OR results in no rows returned artifact: 3ff04c191c user: anonymous | |
19:48 | • Reply: Pragma compile_options does not show some options artifact: 8b5d81a30a user: anonymous | |
19:27 | • Reply: how DISTINCT remove the duplicate rows? artifact: 698d575bbe user: anonymous | |
19:24 | • Reply: index misuse? artifact: 5251fcede3 user: anonymous | |
19:02 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 065476f522 user: anonymous | |
18:51 | • Reply: how DISTINCT remove the duplicate rows? artifact: 4f99c1d7a6 user: anonymous | |
18:34 | • Reply: Pragma compile_options does not show some options artifact: 13a7754152 user: anonymous | |
18:29 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: ec3bfe7246 user: anonymous | |
18:18 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 481013e484 user: anonymous | |
18:12 | • Reply: how DISTINCT remove the duplicate rows? artifact: 977e054183 user: anonymous | |
18:11 | • Reply: Pragma compile_options does not show some options artifact: 4e1d13385f user: anonymous | |
17:54 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 4ece302a22 user: anonymous | |
17:38 | • Post: how DISTINCT remove the duplicate rows? artifact: befd52d034 user: anonymous | |
17:36 | • Post: Select of text that matches scientific notation format automatically converted to number artifact: e0d0b22e62 user: anonymous | |
17:13 | • Reply: Noob Question artifact: e2371a5f0f user: anonymous | |
12:48 | • Reply: Creating in-memory DB from a bunch of bytes artifact: 61b9c210e1 user: anonymous | |
12:44 | • Reply: Only Column Names read from table artifact: 8ae906bae9 user: anonymous | |
12:10 | • Reply: count strings with same length artifact: 573eebdcaf user: anonymous | |
09:10 | • Reply: count strings with same length artifact: 70d5f48ae0 user: anonymous | |
2021-04-12
| ||
23:01 | • Reply: XML extension artifact: d7291ee380 user: anonymous | |
23:00 | • Reply: Noob Question artifact: b74338aebd user: anonymous | |
22:47 | • Post: Pragma compile_options does not show some options artifact: b2b813a409 user: anonymous | |
22:05 | • Reply: Noob Question artifact: 74d75e4e65 user: anonymous | |
19:17 | • Reply: Noob Question artifact: c3442a7fe9 user: anonymous | |
19:00 | • Reply: Noob Question artifact: 4d8a207153 user: anonymous | |
18:44 | • Post: Noob Question artifact: ad8b9c405d user: anonymous | |
14:21 | • Reply: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: 9d6a148f56 user: anonymous | |
12:36 | • Reply: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: eb50b6294c user: anonymous | |
10:09 | • Post: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: 1007f28b78 user: anonymous | |
09:49 | • Reply: How to get the last row_id in a table without inserting anything artifact: 631b9a6834 user: anonymous | |
07:31 | • Reply: sqlite3_bind_() problem I do not understand artifact: 7b1e26a822 user: anonymous | |
04:02 | • Post: sqlite3_bind_() problem I do not understand artifact: 7d689d92a5 user: anonymous | |
02:05 | • Post: Tiny comment fix artifact: 2415559747 user: anonymous | |
00:42 | • Reply: You don't know what people are using your database for artifact: 9b218b3aa0 user: anonymous | |
2021-04-11
| ||
22:51 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: abcad64131 user: anonymous | |
20:46 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 15f5276317 user: anonymous | |
18:51 | • Reply: How to get the last row_id in a table without inserting anything artifact: ebd065b0c5 user: anonymous | |
16:43 | • Post: How to get the last row_id in a table without inserting anything artifact: 375569937c user: anonymous | |
12:28 | • Reply: You don't know what people are using your database for artifact: 3d98e18edb user: anonymous | |
2021-04-10
| ||
14:07 | • Reply: useless constant term lead to incorrect output artifact: 6ea94d0c6f user: anonymous | |
03:12 | • Reply: StrCaseEq in sqlite3? artifact: 0306c2295e user: anonymous | |
02:37 | • Post: StrCaseEq in sqlite3? artifact: 937a16f4fe user: anonymous | |
2021-04-09
| ||
15:21 | • Reply: Question .open chinook.db artifact: 943baf3481 user: anonymous | |
15:15 | • Reply: Question .open chinook.db artifact: 50221da653 user: anonymous | |
14:59 | • Reply: Question .open chinook.db artifact: 5ee770b279 user: anonymous | |
14:17 | • Post: Question .open chinook.db artifact: e9b5abf69c user: anonymous | |
01:01 | • Reply: how to pre allocate my SQLite database to a certain size artifact: 53d1e08709 user: anonymous | |
2021-04-08
| ||
23:50 | • Reply: Impact analysis for "larger-databases" change artifact: 3d651caefd user: anonymous | |
2021-04-07
| ||
15:54 | • Reply: Command line option '.read' - Windows version artifact: ba95c40625 user: anonymous | |
15:06 | • Post: Possible WINDOW optimization opportunity artifact: 2451f0c193 user: anonymous | |
14:27 | • Post: Command line option '.read' - Windows version artifact: 89deaae8c3 user: anonymous | |
13:30 | • Reply: segfault in sqlite3 (3.35.4) artifact: 34fa9ecd2e user: anonymous | |
13:26 | • Reply: segfault in sqlite3 (3.35.4) artifact: cb76672fda user: anonymous | |
09:06 | • Reply: books / papers on "one sqlite per user" design ? artifact: f002442fba user: anonymous | |
01:34 | • Post: Typo in docs artifact: c661cf4fcb user: anonymous | |
00:41 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: a64953e91c user: anonymous | |
00:40 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: cbb488244c user: anonymous | |
00:01 | • Post: deploying 1_000_000 sqlitedb on AWS? artifact: 00c0465605 user: anonymous | |
2021-04-06
| ||
13:57 | • Reply: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: b3f4b6a4b8 user: anonymous | |
12:28 | • Post: INTEGER PRIMARY KEY AUTOINCREMENT with UPSERT skips numbers artifact: 7dfc384b33 user: anonymous | |
07:32 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 260c93dc77 user: anonymous | |
07:26 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 49bf3378fc user: anonymous | |
00:24 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: e3833276d2 user: anonymous | |
2021-04-05
| ||
19:09 | • Post: books / papers on "one sqlite per user" design ? artifact: 7567899112 user: anonymous | |
19:03 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: cee3de06cb user: anonymous | |
18:45 | • Post: open db in read only; explicitly store diff as WAL ? artifact: e5aae48802 user: anonymous | |
2021-04-03
| ||
19:06 | • Reply: How to dump a table to a TSV file but escape characters properly artifact: 572925f16e user: anonymous | |
14:36 | • Reply: Problem with single quotes Swift/MacOS artifact: 58ca3c3b67 user: anonymous | |
2021-04-02
| ||
07:11 | • Reply: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: 5052c79f69 user: anonymous | |
00:12 | • Reply: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: 65ff4f6834 user: anonymous | |
2021-04-01
| ||
23:47 | • Reply: Order of results of multiple SELECT statements separated by ";" artifact: 7ddd158bd8 user: anonymous | |
15:54 | • Reply: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: 4cd17a02bd user: anonymous | |
08:21 | • Post: Enabling SQLITE_ENABLE_UPDATE_DELETE_LIMIT by default artifact: f260688831 user: anonymous | |