SQLite Forum

Timeline
Login

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