Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
115 events for the month beginning 2020-09-01 by user kmedcalf
Following month ↑
2020-09-30
| ||
00:35 | • Reply: slow import of CSV files artifact: cc06a09f05 user: kmedcalf | |
2020-09-28
| ||
23:15 | • Reply: compiling extensions for Windows x64 with mingw-w64 artifact: 01b9b69211 user: kmedcalf | |
22:54 | • Reply: compiling extensions for Windows x64 with mingw-w64 artifact: 22462f6f8e user: kmedcalf | |
17:52 | • Edit reply: compiling extensions for Windows x64 with mingw-w64 artifact: 1b6bb550d1 user: kmedcalf | |
17:47 | • Reply: compiling extensions for Windows x64 with mingw-w64 artifact: 0f7354cf0b user: kmedcalf | |
17:29 | • Reply: compiling extensions for Windows x64 with mingw-w64 artifact: 5e27f2cda6 user: kmedcalf | |
17:06 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 4378273230 user: kmedcalf | |
16:56 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 239c1d91d4 user: kmedcalf | |
06:36 | • Reply: Nesting of statements artifact: 0fcf66d52e user: kmedcalf | |
2020-09-27
| ||
21:34 | • Edit reply: identification of user function artifact: 28ff792747 user: kmedcalf | |
21:23 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 27cd2bda8d user: kmedcalf | |
17:51 | • Reply: identification of user function artifact: 50467643af user: kmedcalf | |
07:45 | • Reply: slow import of CSV files artifact: 58b5fbbf73 user: kmedcalf | |
07:34 | • Reply: slow import of CSV files artifact: 91bfd5f4f0 user: kmedcalf | |
06:22 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: e1ac7bfb64 user: kmedcalf | |
00:37 | • Reply: slow import of CSV files artifact: 5a37ccc266 user: kmedcalf | |
00:32 | • Reply: slow import of CSV files artifact: b6a9915b1d user: kmedcalf | |
00:12 | • Reply: slow import of CSV files artifact: 1d63845aba user: kmedcalf | |
2020-09-26
| ||
19:59 | • Reply: Does SQLite automatically create an index for a INTEGER PRIMARY KEY column? artifact: 3ac44bed84 user: kmedcalf | |
19:54 | • Reply: Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings) artifact: 1d13ef71b2 user: kmedcalf | |
2020-09-25
| ||
19:21 | • Reply: Nesting of statements artifact: 59a2720afa user: kmedcalf | |
18:11 | • Reply: Nesting of statements artifact: ceb0b4b2e2 user: kmedcalf | |
14:11 | • Reply: Could not load assembly System.Data.SQLite.dll artifact: 074675dd23 user: kmedcalf | |
2020-09-23
| ||
04:11 | • Reply: Disable -wal option artifact: 5a5c13b15a user: kmedcalf | |
01:20 | • Edit reply: Counting with datetime artifact: 9113a3b360 user: kmedcalf | |
01:20 | • Reply: Counting with datetime artifact: c9afbd50a9 user: kmedcalf | |
01:12 | • Edit reply: Counting with datetime artifact: c56ffe70b6 user: kmedcalf | |
01:06 | • Reply: Counting with datetime artifact: bbb3685c65 user: kmedcalf | |
00:33 | • Reply: Disable -wal option artifact: e9e799d561 user: kmedcalf | |
2020-09-22
| ||
16:47 | • Edit reply: Strange behaviour with tables have the same name and different schemas artifact: 16282a67c5 user: kmedcalf | |
16:46 | • Reply: Strange behaviour with tables have the same name and different schemas artifact: acb24695bc user: kmedcalf | |
16:42 | • Edit reply: Strange behaviour with tables have the same name and different schemas artifact: 4b404aa47a user: kmedcalf | |
16:41 | • Reply: Strange behaviour with tables have the same name and different schemas artifact: cde9a3d2c7 user: kmedcalf | |
16:28 | • Edit reply: Counting with datetime artifact: 319bfeb144 user: kmedcalf | |
16:27 | • Edit reply: Counting with datetime artifact: 1994ed71ab user: kmedcalf | |
16:24 | • Reply: Counting with datetime artifact: 65e7e59884 user: kmedcalf | |
16:17 | • Reply: Counting with datetime artifact: 322a486ae0 user: kmedcalf | |
16:16 | • Reply: Counting with datetime artifact: de82d2ce63 user: kmedcalf | |
2020-09-21
| ||
23:43 | • Reply: How does sparse files used by sqlite3? artifact: 6c558dc1e9 user: kmedcalf | |
23:35 | • Reply: Strange behaviour with tables have the same name and different schemas artifact: 8448259cfd user: kmedcalf | |
2020-09-19
| ||
22:43 | • Reply: Multithreading support artifact: 235d646d0d user: kmedcalf | |
22:13 | • Reply: Why was there no error message at CREATE TABLE? artifact: bd5bb1c3f9 user: kmedcalf | |
06:55 | • Edit reply: How to write this trigger? artifact: 0db810b8a8 user: kmedcalf | |
06:50 | • Reply: How to write this trigger? artifact: ef95859046 user: kmedcalf | |
06:30 | • Reply: How to write this trigger? artifact: 3c7ca9dfeb user: kmedcalf | |
06:19 | • Reply: How to write this trigger? artifact: 9f021b5a29 user: kmedcalf | |
2020-09-16
| ||
22:48 | • Reply: Bug or feature? DISTINCT ignored in the initial select of a WITH clause artifact: 462ecf05d7 user: kmedcalf | |
20:45 | • Edit reply: Error: no such column: x artifact: ef2a872e43 user: kmedcalf | |
20:44 | • Reply: Error: no such column: x artifact: 4ce2df4fbd user: kmedcalf | |
20:35 | • Reply: Error: no such column: x artifact: 10eced83c9 user: kmedcalf | |
18:59 | • Reply: Error: no such column: x artifact: b968943f42 user: kmedcalf | |
18:48 | • Post: Documentation Error? preupdate_hook artifact: d11200e806 user: kmedcalf | |
17:12 | • Edit reply: sqlite-gui application artifact: 57870f57a4 user: kmedcalf | |
17:11 | • Reply: sqlite-gui application artifact: 7d4f0a5da0 user: kmedcalf | |
03:00 | • Reply: Error: no such column: x artifact: 387c43788c user: kmedcalf | |
02:30 | • Edit reply: Error: no such column: x artifact: a73067e5e4 user: kmedcalf | |
02:13 | • Reply: Error: no such column: x artifact: 051db2bf68 user: kmedcalf | |
01:02 | • Reply: sqlite-gui application artifact: 2c72e7b033 user: kmedcalf | |
00:18 | • Reply: Network filesystems for sqlite DBs artifact: 0a0a5efd5b user: kmedcalf | |
2020-09-15
| ||
20:50 | • Reply: 64-bit Win compile of Tcl interface artifact: 851c96e3e8 user: kmedcalf | |
10:20 | • Reply: another performance question related to `geopoly` artifact: 5a73cc04a2 user: kmedcalf | |
09:52 | • Reply: select * from t; -- but don't want virtual columns artifact: a5586f80ff user: kmedcalf | |
2020-09-14
| ||
22:59 | • Reply: 64-bit Win compile of Tcl interface artifact: 8460a3f8a5 user: kmedcalf | |
22:35 | • Reply: Compile sqlite3.dll with FOREIGN_KEYS=ON as default artifact: 3a07613ed4 user: kmedcalf | |
22:23 | • Reply: Compile sqlite3.dll with FOREIGN_KEYS=ON as default artifact: 4bdba5ec37 user: kmedcalf | |
22:19 | • Reply: Compile sqlite3.dll with FOREIGN_KEYS=ON as default artifact: 0cd4959f62 user: kmedcalf | |
21:45 | • Reply: RAISE(ROLLBACK,...) giving 'no transaction error' artifact: 33b06bd206 user: kmedcalf | |
21:29 | • Reply: RAISE(ROLLBACK,...) giving 'no transaction error' artifact: f97c489a59 user: kmedcalf | |
21:02 | • Edit reply: select * from t; -- but don't want virtual columns artifact: 248581b21a user: kmedcalf | |
21:00 | • Reply: select * from t; -- but don't want virtual columns artifact: 1669f4f63a user: kmedcalf | |
10:25 | • Reply: executable file artifact: 07ddbf1097 user: kmedcalf | |
10:18 | • Reply: select * from t; -- but don't want virtual columns artifact: ab002f8120 user: kmedcalf | |
09:42 | • Reply: select * from t; -- but don't want virtual columns artifact: ef4308d8dd user: kmedcalf | |
09:32 | • Reply: select * from t; -- but don't want virtual columns artifact: d3546b2b10 user: kmedcalf | |
07:27 | • Reply: select * from t; -- but don't want virtual columns artifact: 9c43f238d0 user: kmedcalf | |
2020-09-13
| ||
22:09 | • Reply: select * from t; -- but don't want virtual columns artifact: 8595f39416 user: kmedcalf | |
21:06 | • Reply: select * from t; -- but don't want virtual columns artifact: 18bd92b03b user: kmedcalf | |
08:01 | • Reply: SHA-3 hash artifact: a04275f147 user: kmedcalf | |
01:34 | • Reply: Is data in the OS buffers faster to read? artifact: 3d69d7252e user: kmedcalf | |
2020-09-11
| ||
21:58 | • Reply: INNER JOIN error artifact: bc596d0c5d user: kmedcalf | |
00:17 | • Reply: sqlite3BtreeHoldsMutex: Assertion error artifact: 393b8bdf93 user: kmedcalf | |
2020-09-10
| ||
23:26 | • Edit reply: Help speeding up this query artifact: 2dea041d3e user: kmedcalf | |
23:25 | • Reply: Help speeding up this query artifact: 055cab9fcc user: kmedcalf | |
18:52 | • Reply: Help speeding up this query artifact: 2484b8aa6e user: kmedcalf | |
07:06 | • Edit reply: SQLITE_ENABLE_UPDATE_DELETE_LIMIT artifact: cfbb22ef8f user: kmedcalf | |
07:04 | • Reply: SQLITE_ENABLE_UPDATE_DELETE_LIMIT artifact: 0323c3ffbf user: kmedcalf | |
06:34 | • Reply: SQLITE_ENABLE_UPDATE_DELETE_LIMIT artifact: 9d175dca4a user: kmedcalf | |
2020-09-09
| ||
22:52 | • Edit reply: after crash loosing all records in a multi-GB table artifact: baeed0edb0 user: kmedcalf | |
22:49 | • Reply: after crash loosing all records in a multi-GB table artifact: 0e90328410 user: kmedcalf | |
22:11 | • Reply: Switching data between two columns artifact: 135864d342 user: kmedcalf | |
21:10 | • Reply: Unique every N seconds. How? artifact: 43cf790650 user: kmedcalf | |
2020-09-08
| ||
19:30 | • Edit reply: Switching data between two columns artifact: 8c7c1ab96c user: kmedcalf | |
19:27 | • Edit reply: Switching data between two columns artifact: 13b0d87896 user: kmedcalf | |
19:26 | • Edit reply: Switching data between two columns artifact: 13b145d5de user: kmedcalf | |
19:21 | • Reply: Switching data between two columns artifact: d146240ba1 user: kmedcalf | |
18:40 | • Reply: Switching data between two columns artifact: 7a2a6cde9f user: kmedcalf | |
09:03 | • Reply: extension-functions.c - pre-compiled Windows Binary artifact: 5306122ab1 user: kmedcalf | |
00:32 | • Reply: Is date/time atomic per statement/transaction? artifact: f2989f4d69 user: kmedcalf | |
2020-09-07
| ||
23:09 | • Reply: Is date/time atomic per statement/transaction? artifact: a864e48a13 user: kmedcalf | |
00:27 | • Reply: RAISE (ROLLBACK | ABORT | FAIL) differences? artifact: 2a3186333c user: kmedcalf | |
2020-09-05
| ||
22:22 | • Reply: Problems adding 'eval' and 'csv' extensions to the shell artifact: 970367598f user: kmedcalf | |
19:17 | • Reply: Can Richard do some YouTube videos explaining transaction implementation? artifact: 95400e5609 user: kmedcalf | |
03:49 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: 6591f5de77 user: kmedcalf | |
2020-09-04
| ||
22:53 | • Reply: Can Richard do some YouTube videos explaining transaction implementation? artifact: e215f95ff0 user: kmedcalf | |
22:29 | • Reply: Can Richard do some YouTube videos explaining transaction implementation? artifact: 959ce148d4 user: kmedcalf | |
22:25 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: b42eab30ec user: kmedcalf | |
22:09 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: 2fd9942906 user: kmedcalf | |
21:57 | • Reply: SQLITE_MAX_ATTACHED; artifact: 64f4090bcb user: kmedcalf | |
21:50 | • Reply: SQLITE_MAX_ATTACHED; artifact: e0082f0290 user: kmedcalf | |
2020-09-03
| ||
22:34 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: e97b8fa0d6 user: kmedcalf | |
21:07 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: b542f65f81 user: kmedcalf | |
15:41 | • Reply: Pre-release Versions of System.Data.SQLite packages? artifact: d056cb68b0 user: kmedcalf | |
2020-09-01
| ||
18:08 | • Reply: 'vfs' artifact: 635bd3f95a user: kmedcalf | |
15:21 | • Edit reply: UPDATE x AS y: alias invalid in "SET" expr artifact: 0244ed68f2 user: kmedcalf | |
15:14 | • Reply: UPDATE x AS y: alias invalid in "SET" expr artifact: 8ff9a9687b user: kmedcalf | |