Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
154 events for the month beginning 2020-09-01 by user anonymous
Following month ↑
2020-09-30
| ||
07:17 | • Reply: Summary of Virtual Table Changes artifact: b267160741 user: anonymous | |
04:25 | • Post: Summary of Virtual Table Changes artifact: 3bef4d4c66 user: anonymous | |
2020-09-28
| ||
15:39 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 298b3827aa user: anonymous | |
03:47 | • Post: Dump and online backupjexclude tables artifact: dd95b3daa7 user: anonymous | |
2020-09-27
| ||
19:49 | • Reply: identification of user function artifact: b302c2cc03 user: anonymous | |
19:48 | • Reply: identification of user function artifact: bfb1290eb9 user: anonymous | |
19:25 | • Reply: FTS5 rows not searchable with match artifact: 245ea99ee4 user: anonymous | |
18:48 | • Reply: Nesting of statements artifact: 58775bc73a user: anonymous | |
18:41 | • Reply: Results from callcatcher run on SQLite artifact: 34ac37c89c user: anonymous | |
15:48 | • Post: identification of user function artifact: ad10d66e82 user: anonymous | |
08:00 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 9b8fdfb722 user: anonymous | |
07:52 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: a479d9c4e2 user: anonymous | |
01:36 | • Reply: sqlite-gui application artifact: cf828fbc81 user: anonymous | |
2020-09-26
| ||
21:51 | • Reply: sqlite-gui application artifact: 3f7dc97c39 user: anonymous | |
15:28 | • Reply: sqlite-gui application artifact: c74215ecba user: anonymous | |
12:51 | • Reply: FTS5 rows not searchable with match artifact: 76ccadec50 user: anonymous | |
11:37 | • Reply: FTS5 rows not searchable with match artifact: 410b90051c user: anonymous | |
01:09 | • Reply: FTS5 rows not searchable with match artifact: 2ac549c496 user: anonymous | |
2020-09-25
| ||
18:07 | • Post: Compiling sqlite3-3.33.0 on SCO OpenServer 5.0.7 artifact: 6a755ae973 user: anonymous | |
14:23 | • Reply: Could not load assembly System.Data.SQLite.dll artifact: 2a501c6b82 user: anonymous | |
02:22 | • Post: Documentation does not show when a feature was added artifact: 0eeb6c036f user: anonymous | |
2020-09-24
| ||
19:37 | • Reply: Which file(s) to download? artifact: 81e9895e02 user: anonymous | |
14:09 | • Reply: HEX function returns empty string on null input, normal? artifact: 8c4cd47fe0 user: anonymous | |
10:01 | • Reply: HEX function returns empty string on null input, normal? artifact: c90bb3a5b7 user: anonymous | |
09:34 | • Reply: HEX function returns empty string on null input, normal? artifact: b6bffedbee user: anonymous | |
09:18 | • Reply: When was iff() added? artifact: 031a1fb5ae user: anonymous | |
08:50 | • Post: When was iff() added? artifact: 8233f6d27c user: anonymous | |
06:35 | • Reply: request on 5 tables artifact: 453c270f81 user: anonymous | |
2020-09-23
| ||
16:12 | • Reply: Disable -wal option artifact: 616d9a6a0d user: anonymous | |
14:37 | • Post: HEX function returns empty string on null input, normal? artifact: 47bcdfefff user: anonymous | |
07:48 | • Reply: Disable -wal option artifact: b973c6da84 user: anonymous | |
07:45 | • Reply: Disable -wal option artifact: 1bebf458e4 user: anonymous | |
06:53 | • Reply: request on 5 tables artifact: 6b359126e9 user: anonymous | |
03:38 | • Reply: Disable -wal option artifact: 651faf3e8c user: anonymous | |
2020-09-22
| ||
20:39 | • Reply: FTS5 rows not searchable with match artifact: 0ea42245b7 user: anonymous | |
20:19 | • Post: Disable -wal option artifact: fbcd1a2120 user: anonymous | |
19:32 | • Reply: It doesn't call xCommit if xBegin is not defined artifact: 8eb1d1cef3 user: anonymous | |
14:27 | • Reply: request on 5 tables artifact: c1e2ea7384 user: anonymous | |
13:17 | • Post: Performance degrade during connection Open due to Environment Variable access artifact: 9ab9ce0caa user: anonymous | |
11:48 | • Reply: request on 5 tables artifact: 9c18cd8647 user: anonymous | |
08:39 | • Reply: request on 5 tables artifact: 7b6e7ee0e8 user: anonymous | |
02:20 | • Post: It doesn't call xCommit if xBegin is not defined artifact: 1679836469 user: anonymous | |
2020-09-21
| ||
17:30 | • Reply: request on 5 tables artifact: 58765734be user: anonymous | |
15:24 | • Reply: FTS5 MATCH doesn't support AND NOT artifact: d554eef06d user: anonymous | |
15:08 | • Reply: request on 5 tables artifact: 45fb8dde28 user: anonymous | |
13:47 | • Reply: www.sqlite.org/appfunc.html has invalid sample code artifact: aa6ebb3643 user: anonymous | |
13:19 | • Reply: request on 5 tables artifact: 745a1d87a5 user: anonymous | |
12:26 | • Post: FTS5 MATCH doesn't support AND NOT artifact: d42f1e1a9f user: anonymous | |
12:07 | • Post: request on 5 tables artifact: a77d88bc09 user: anonymous | |
06:07 | • Post: Using Password on sqlite3 command line artifact: 659076357b user: anonymous | |
02:28 | • Reply: FTS5 rows not searchable with match artifact: 91e57a367c user: anonymous | |
2020-09-20
| ||
19:41 | • Post: FTS5 rows not searchable with match artifact: 847e3ea098 user: anonymous | |
12:07 | • Post: Sqlite3 Package Import issue in electron javascript artifact: 009bcd5723 user: anonymous | |
09:21 | • Post: Typo in documentation artifact: 116812d9eb user: anonymous | |
2020-09-19
| ||
08:29 | • Reply: How to write this trigger? artifact: ba6b4d81ea user: anonymous | |
08:19 | • Reply: How to write this trigger? artifact: 2be0e12323 user: anonymous | |
2020-09-18
| ||
22:58 | • Reply: How to write this trigger? artifact: 3cd5bfd665 user: anonymous | |
22:26 | • Reply: How to write this trigger? artifact: 8507322d56 user: anonymous | |
22:25 | • Post: Concurrent Multiple Write Transactions artifact: 654a9ad813 user: anonymous | |
14:09 | • Post: How to write this trigger? artifact: b6bf56b2ca user: anonymous | |
08:41 | • Reply: Generated Columns artifact: 9d5376ac96 user: anonymous | |
07:46 | • Post: Which file(s) to download? artifact: 00647eeb86 user: anonymous | |
2020-09-17
| ||
15:51 | • Post: No index proposed when using .expert artifact: 5197b263e4 user: anonymous | |
15:31 | • Post: SQLite encryption with SEE artifact: 7f95402174 user: anonymous | |
08:20 | • Reply: backkup and restore sqlite database between different android phones artifact: d44bd6a364 user: anonymous | |
2020-09-16
| ||
19:13 | • Reply: sqlite-gui application artifact: 6b0a272498 user: anonymous | |
18:15 | • Reply: sqlite-gui application artifact: 42e989ea77 user: anonymous | |
17:32 | • Post: backkup and restore sqlite database between different android phones artifact: d3efd69db5 user: anonymous | |
14:23 | • Reply: Execution durations artifact: 317fecd842 user: anonymous | |
10:21 | • Post: Execution durations artifact: c28d7482c8 user: anonymous | |
00:23 | • Post: sqlite-gui application artifact: 7c1b5f7d56 user: anonymous | |
00:16 | • Reply: Network filesystems for sqlite DBs artifact: f5e015c1ee user: anonymous | |
2020-09-15
| ||
18:47 | • Reply: Documentation issue (wrong table name) in FAQ, point 7 artifact: d90adfbb0a user: anonymous | |
17:50 | • Post: Documentation issue (wrong table name) in FAQ, point 7 artifact: 97581e1643 user: anonymous | |
13:03 | • Reply: another performance question related to `geopoly` artifact: 4acb1ca4e5 user: anonymous | |
13:01 | • Reply: Open In-Memory DB on existing memory artifact: bbe98bdba1 user: anonymous | |
13:00 | • Reply: Open In-Memory DB on existing memory artifact: 0eded29f82 user: anonymous | |
12:40 | • Reply: Using Password on sqlite3 command line artifact: a7b5af9336 user: anonymous | |
12:18 | • Reply: Open In-Memory DB on existing memory artifact: e27178e0b0 user: anonymous | |
11:23 | • Reply: Querying all compile options used artifact: 75a4f84869 user: anonymous | |
11:06 | • Post: Querying all compile options used artifact: 955186167f user: anonymous | |
07:13 | • Reply: RAISE(ROLLBACK,...) giving 'no transaction error' artifact: 27a7935d95 user: anonymous | |
07:04 | • Post: PATCH sqlite3 abuses usleep for >=1sec sleeps artifact: 7e50ced6a6 user: anonymous | |
2020-09-14
| ||
22:03 | • Post: Compile sqlite3.dll with FOREIGN_KEYS=ON as default artifact: 9bfd09f477 user: anonymous | |
20:55 | • Post: RAISE(ROLLBACK,...) giving 'no transaction error' artifact: 2b2082ce4f user: anonymous | |
11:31 | • Reply: Placeholder for table name when inserting data? artifact: 1898fd7e1a user: anonymous | |
10:10 | • Reply: Placeholder for table name when inserting data? artifact: 9e39461c5c user: anonymous | |
09:59 | • Reply: Placeholder for table name when inserting data? artifact: 518029ccd0 user: anonymous | |
07:11 | • Post: Using Password on sqlite3 command line artifact: 0ffaefa04a user: anonymous | |
2020-09-13
| ||
21:24 | • Reply: Placeholder for table name when inserting data? artifact: 9de66b988f user: anonymous | |
17:03 | • Reply: Placeholder for table name when inserting data? artifact: f015c6a2dc user: anonymous | |
16:52 | • Reply: Placeholder for table name when inserting data? artifact: c80251687f user: anonymous | |
16:30 | • Reply: Placeholder for table name when inserting data? artifact: 9ed9a38498 user: anonymous | |
16:02 | • Post: Placeholder for table name when inserting data? artifact: 81a414645a user: anonymous | |
2020-09-12
| ||
15:16 | • Post: SHA-3 hash artifact: fbbbd3bae7 user: anonymous | |
12:05 | • Post: bug report: -init, .read run batch INSER INTO error in UTF-16le, UTF-16be table artifact: 6ae4947d26 user: anonymous | |
11:19 | • Post: bug report: table data display error when importing text file encoding utf-16le, utf-16be using .import command artifact: 8a8a4578e2 user: anonymous | |
2020-09-11
| ||
17:51 | • Reply: INNER JOIN error artifact: e14d931406 user: anonymous | |
16:57 | • Reply: INNER JOIN error artifact: 10f75ad353 user: anonymous | |
15:08 | • Reply: Is date/time atomic per statement/transaction? artifact: 83f445bc8b user: anonymous | |
2020-09-10
| ||
18:59 | • Reply: Help speeding up this query artifact: dc3ba098d4 user: anonymous | |
17:49 | • Reply: Unique every N seconds. How? artifact: 4c67fb28cf user: anonymous | |
15:59 | • Reply: Using windows function artifact: 765236c005 user: anonymous | |
15:31 | • Post: Using windows function artifact: 5a6c29b0b0 user: anonymous | |
15:11 | • Reply: Unique every N seconds. How? artifact: a2a6acf383 user: anonymous | |
15:01 | • Reply: SQLITE_ENABLE_UPDATE_DELETE_LIMIT artifact: 8c5e1deac0 user: anonymous | |
14:22 | • Post: Check-in description possible correction artifact: aa2ee170d3 user: anonymous | |
13:12 | • Reply: Generated Columns artifact: cb313de43c user: anonymous | |
13:08 | • Reply: Generated Columns artifact: ffd597286c user: anonymous | |
10:01 | • Post: Fix typo in lang_alter_table.in artifact: aeea58c8b9 user: anonymous | |
2020-09-09
| ||
21:09 | • Reply: Switching data between two columns artifact: 641f3ec8d1 user: anonymous | |
20:33 | • Post: Unique every N seconds. How? artifact: 14bffc712e user: anonymous | |
16:34 | • Post: Generated Columns artifact: 2ae3724b8f user: anonymous | |
13:37 | • Reply: Problem using strftime with .parameter set in CLI artifact: a5934d64ad user: anonymous | |
13:00 | • Reply: Unexpected behaviour of the json_valid function and .json mode in CLI artifact: ed1ef1d4ea user: anonymous | |
12:47 | • Reply: Unexpected behaviour of the json_valid function and .json mode in CLI artifact: 841b24a725 user: anonymous | |
12:40 | • Post: Problem using strftime with .parameter set in CLI artifact: 1302114924 user: anonymous | |
11:07 | • Post: content of field must not be identical to another column name of same table for UPDATE SET to work artifact: 51f516ade4 user: anonymous | |
2020-09-08
| ||
17:27 | • Reply: Switching data between two columns artifact: 4203fd0580 user: anonymous | |
13:52 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 79c850cce1 user: anonymous | |
12:02 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 249eae1a9d user: anonymous | |
12:00 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: d806d13f50 user: anonymous | |
11:36 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: e136344c36 user: anonymous | |
07:00 | • Post: Which Drawing tool is used for "sql-commands flow" on sqlite.org ? artifact: a24edd5636 user: anonymous | |
03:32 | • Reply: sqlite-utils: a command-line tool and Python utility library artifact: 4a428439d8 user: anonymous | |
2020-09-07
| ||
20:23 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 12eca84e44 user: anonymous | |
16:19 | • Post: Is date/time atomic per statement/transaction? artifact: 7d547328a4 user: anonymous | |
14:32 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 474a5f2d6c user: anonymous | |
11:14 | • Post: Attaching to DB *AFTER* Transaction started artifact: 1cd86107b8 user: anonymous | |
2020-09-06
| ||
23:25 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 34e6d8fbd8 user: anonymous | |
22:59 | • Post: RAISE (ROLLBACK | ABORT | FAIL) differences? artifact: 5d2d1630f2 user: anonymous | |
19:28 | • Reply: sqlite3 column truncation problem artifact: 8694b12211 user: anonymous | |
18:11 | • Reply: Time of artifact: 73133b5a0e user: anonymous | |
17:17 | • Reply: Time of artifact: e7d142a179 user: anonymous | |
16:59 | • Reply: Time of artifact: 10b1c0b04a user: anonymous | |
16:51 | • Post: sqlite3 column truncation problem artifact: 1f82df2dbf user: anonymous | |
14:50 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 30c17ec57d user: anonymous | |
14:36 | • Post: Time of artifact: 7106633d39 user: anonymous | |
08:04 | • Post: extension-functions.c - pre-compiled Windows Binary artifact: 89843964b7 user: anonymous | |
2020-09-05
| ||
20:12 | • Reply: Unexpected behaviour of the json_valid function and .json mode in CLI artifact: 6d27c13eb6 user: anonymous | |
19:41 | • Post: Problems adding 'eval' and 'csv' extensions to the shell artifact: 0ef3e8bc7f user: anonymous | |
19:15 | • Post: Unexpected behaviour of the json_valid function and .json mode in CLI artifact: d4d178b083 user: anonymous | |
15:10 | • Reply: Can Richard do some YouTube videos explaining transaction implementation? artifact: b9d8d277d0 user: anonymous | |
11:52 | • Reply: libsqlite3 update artifact: 4a8de958aa user: anonymous | |
2020-09-04
| ||
22:25 | • Post: libsqlite3 update artifact: c463b41ac9 user: anonymous | |
12:34 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: 9d58effcd4 user: anonymous | |
2020-09-03
| ||
15:57 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: 90ac7b876b user: anonymous | |
13:37 | • Post: Pre-release Versions of System.Data.SQLite packages? artifact: 59f0e5beb1 user: anonymous | |
2020-09-01
| ||
21:07 | • Reply: System.Data.SQLite artifact: e3cd39b79d user: anonymous | |
17:58 | • Post: 'vfs' artifact: 8dd5906b60 user: anonymous | |
16:19 | • Reply: UPDATE x AS y: alias invalid in "SET" expr artifact: 5e8fc5f5f8 user: anonymous | |
15:55 | • Reply: Which one - System.Data.SQLite or Microsoft.Data.SQLite artifact: 38ea4d6833 user: anonymous | |
11:50 | • Post: Unexpected behaviour of the sum function artifact: ac7e2fee9b user: anonymous | |
08:28 | • Reply: Getting no such column error for values to be inserted artifact: 67a4a02860 user: anonymous | |