SQLite Forum

Timeline
Login

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