SQLite Forum

Timeline
Login

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