SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

111 events for the month beginning 2020-11-01 by user kmedcalf

Following month ↑
2020-11-30
09:02 Edit reply: max page count doesn't return sqlite_full error when reaches the limit of page count artifact: 0cacf17da6 user: kmedcalf
08:46 Edit reply: How to impose soft_heap method to limit database to 5GB in sqlite artifact: 5902288bcf user: kmedcalf
08:42 Reply: How to impose soft_heap method to limit database to 5GB in sqlite artifact: b15eb92305 user: kmedcalf
08:21 Reply: max page count doesn't return sqlite_full error when reaches the limit of page count artifact: 2c1c3b349d user: kmedcalf
2020-11-29
11:42 Edit reply: SQLite3 artifact: 673b59adc5 user: kmedcalf
11:39 Reply: SQLite3 artifact: f1276105a0 user: kmedcalf
2020-11-28
00:58 Reply: NULL values for collation sequence artifact: 079bbd0753 user: kmedcalf
2020-11-27
02:07 Reply: How I can get all the information of *msf file? artifact: 8785e31e0f user: kmedcalf
2020-11-25
19:44 Reply: Modify rowid via C-API callback artifact: 3c8e3ef1b4 user: kmedcalf
19:38 Reply: Mutex with Sqlite artifact: 6e166f4c1c user: kmedcalf
16:44 Edit reply: SQLite ODBC artifact: 799c843424 user: kmedcalf
16:39 Reply: SQLite ODBC artifact: f93b33eab9 user: kmedcalf
11:40 Reply: Modify rowid via C-API callback artifact: e80016adb0 user: kmedcalf
10:18 Reply: Modify rowid via C-API callback artifact: a1871880e4 user: kmedcalf
10:13 Edit reply: Modify rowid via C-API callback artifact: ad118627c5 user: kmedcalf
10:13 Edit reply: Modify rowid via C-API callback artifact: 4d3bec1135 user: kmedcalf
10:09 Reply: Modify rowid via C-API callback artifact: 1858488bfc user: kmedcalf
10:01 Delete reply: SQLite ODBC artifact: 5db64bcc3b user: kmedcalf
09:59 Reply: SQLite ODBC artifact: 58352bc785 user: kmedcalf
09:56 Reply: SQLite ODBC artifact: 51a318d934 user: kmedcalf
2020-11-23
12:55 Edit reply: sqlite3 rounding off the values of timestamp causing issues artifact: b3e548ed84 user: kmedcalf
12:48 Edit reply: sqlite3 rounding off the values of timestamp causing issues artifact: c99dc2c79a user: kmedcalf
12:43 Reply: sqlite3 rounding off the values of timestamp causing issues artifact: 8892cef072 user: kmedcalf
12:12 Edit reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: 72f72ce92e user: kmedcalf
12:10 Edit reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: aa4ca17aa8 user: kmedcalf
12:08 Reply: FEATURE REQUEST: use of DEFAULT in INSERTs artifact: 1538d39055 user: kmedcalf
09:12 Reply: sqlite3 rounding off the values of timestamp causing issues artifact: 1470b10cf5 user: kmedcalf
00:22 Reply: sha3 (sha3sum) artifact: 48215d61af user: kmedcalf
2020-11-22
23:24 Edit reply: sqlite3 '-batch' option appears undocumented artifact: 3200601ffd user: kmedcalf
23:18 Edit reply: sqlite3 '-batch' option appears undocumented artifact: c1ff1fedbd user: kmedcalf
23:12 Reply: sqlite3 '-batch' option appears undocumented artifact: aacdbda368 user: kmedcalf
2020-11-21
14:10 Reply: Help please importing data artifact: 008efe6274 user: kmedcalf
13:46 Reply: Help please importing data artifact: 1e2a7670c5 user: kmedcalf
13:20 Edit reply: Help please importing data artifact: 5c341d1c1b user: kmedcalf
13:15 Reply: Help please importing data artifact: 13ab5a4090 user: kmedcalf
04:10 Edit reply: SQLite - CMD prompt - How to exit Statement/Expression after messing up? artifact: 6b3e6e2303 user: kmedcalf
04:08 Edit reply: SQLite - CMD prompt - How to exit Statement/Expression after messing up? artifact: c1549f8995 user: kmedcalf
04:08 Reply: SQLite - CMD prompt - How to exit Statement/Expression after messing up? artifact: 1e393acac0 user: kmedcalf
00:42 Reply: Help please importing data artifact: 8e99223201 user: kmedcalf
2020-11-18
17:27 Reply: Start rowid from 0 artifact: 319a0b8197 user: kmedcalf
17:04 Reply: sha3 (sha3sum) artifact: 34c57ee9b4 user: kmedcalf
16:39 Reply: trying to select one column from one table artifact: 7dbb548a3c user: kmedcalf
05:57 Reply: What would be the recommended way to hold an array of ~600 double values? artifact: 6eaa8c46f0 user: kmedcalf
00:09 Reply: Start rowid from 0 artifact: e40e19684d user: kmedcalf
2020-11-17
15:05 Reply: Serious Sqlite command line Problems after Windows 10 update artifact: 4af78df6b7 user: kmedcalf
2020-11-16
22:39 Reply: RTree on ESP32 SQLite Version artifact: 5f489b9568 user: kmedcalf
22:22 Reply: RTree on ESP32 SQLite Version artifact: 1fa2a32903 user: kmedcalf
21:29 Edit reply: Serious Sqlite command line Problems after Windows 10 update artifact: b81c80445d user: kmedcalf
21:21 Reply: Serious Sqlite command line Problems after Windows 10 update artifact: f03a0ce01a user: kmedcalf
00:59 Reply: Serious Sqlite command line Problems after Windows 10 update artifact: 9530e72f64 user: kmedcalf
00:46 Edit reply: RTree on ESP32 SQLite Version artifact: 45392f01cd user: kmedcalf
00:44 Reply: RTree on ESP32 SQLite Version artifact: 31eaf53846 user: kmedcalf
00:12 Reply: RTree on ESP32 SQLite Version artifact: 1e653cb3bf user: kmedcalf
2020-11-15
21:06 Reply: Serious Sqlite command line Problems after Windows 10 update artifact: 4dabd31056 user: kmedcalf
2020-11-12
22:31 Reply: OLE error 800A03EC when sending to Excel artifact: 59dc6ec839 user: kmedcalf
22:22 Reply: General question concerning database stucture and number of databases to use. artifact: 33b66d560b user: kmedcalf
18:38 Reply: Why Sqlite parse error: line 1:94: expecting RPAREN, found 'OR' in CHECK constraint? artifact: cc5c59cf79 user: kmedcalf
18:24 Reply: Help to solve database locked artifact: 5333a6ff12 user: kmedcalf
18:18 Reply: Help to solve database locked artifact: f80b7f9300 user: kmedcalf
06:36 Reply: Undetected table artifact: c16c641194 user: kmedcalf
2020-11-11
20:56 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 550d61b893 user: kmedcalf
08:38 Reply: CASE value within trigger? artifact: 5694270c63 user: kmedcalf
2020-11-10
19:07 Reply: Empty journal files left on disk after connection was gracefully closed artifact: f00dd6a891 user: kmedcalf
19:00 Reply: Empty journal files left on disk after connection was gracefully closed artifact: 8a31f1fe4a user: kmedcalf
11:46 Edit reply: Empty journal files left on disk after connection was gracefully closed artifact: 62eb6e2549 user: kmedcalf
11:31 Reply: Empty journal files left on disk after connection was gracefully closed artifact: f53bf8ae99 user: kmedcalf
10:29 Edit reply: WAL journal and threading mode artifact: f4bfb82c2c user: kmedcalf
10:28 Edit reply: WAL journal and threading mode artifact: 90ef18d88d user: kmedcalf
10:20 Reply: WAL journal and threading mode artifact: d0c0f3de41 user: kmedcalf
10:09 Reply: WAL journal and threading mode artifact: ed5c6c6cff user: kmedcalf
09:51 Reply: Empty journal files left on disk after connection was gracefully closed artifact: 89f86840f5 user: kmedcalf
06:53 Reply: WAL journal and threading mode artifact: 45ce2f433a user: kmedcalf
06:47 Reply: WAL journal and threading mode artifact: f60faa87dd user: kmedcalf
2020-11-09
04:37 Reply: General question concerning database stucture and number of databases to use. artifact: 141f0ef3f8 user: kmedcalf
04:13 Reply: Updating SQLite3 version from 3.26 to 3.27 on Oracle Linux 8 artifact: 71067964e9 user: kmedcalf
2020-11-08
21:10 Reply: General question concerning database stucture and number of databases to use. artifact: e388610f1b user: kmedcalf
2020-11-07
16:07 Reply: General question concerning database stucture and number of databases to use. artifact: 1d5f1df25c user: kmedcalf
02:16 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 7f45e8e015 user: kmedcalf
2020-11-06
23:32 Edit reply: Convert datetime string to second since Epoch with millisecond precision artifact: ce7a5a9459 user: kmedcalf
23:29 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: dac56b0f27 user: kmedcalf
21:25 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 1c6a862f3d user: kmedcalf
01:02 Reply: Recursive Update on Date field artifact: 038d4db860 user: kmedcalf
00:47 Reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: 312f991948 user: kmedcalf
2020-11-05
22:08 Reply: Re-use and execute SQL code stored in tables (eval?) artifact: 1a72923cbb user: kmedcalf
21:46 Reply: Recursive Update on Date field artifact: d6f5f04929 user: kmedcalf
21:05 Reply: Recursive Update on Date field artifact: 444a558da0 user: kmedcalf
20:07 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: b8002975d2 user: kmedcalf
20:03 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: 9c8368f717 user: kmedcalf
19:45 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: 1b24508a54 user: kmedcalf
19:44 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: b2970c1ed6 user: kmedcalf
19:42 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: 62545b2c36 user: kmedcalf
19:24 Edit reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: e6c6081df0 user: kmedcalf
19:02 Reply: Use Recursive Date to test Holiday and Weekend and Update Record artifact: c7e5440481 user: kmedcalf
17:35 Reply: Displaying progress state during DELETE execution artifact: 81fe2df9b7 user: kmedcalf
06:13 Reply: Efficiency of updates versus replace when using the JSON1 extension functions. artifact: 3df5a1d882 user: kmedcalf
03:44 Reply: Centos pre-thread db connection using WAL journal_mode artifact: 85a0a408e1 user: kmedcalf
2020-11-04
23:36 Reply: Case-insensitive using 'ORDER BY' artifact: 871b885b61 user: kmedcalf
23:17 Edit reply: Centos pre-thread db connection using WAL journal_mode artifact: dcbb4e4430 user: kmedcalf
23:10 Reply: Centos pre-thread db connection using WAL journal_mode artifact: 763c9a4f69 user: kmedcalf
19:07 Reply: Bug: Database schema corruption artifact: adf20255b9 user: kmedcalf
18:46 Reply: How to select entries from second table that either do not have an entry or do not have a specific entry? artifact: 7dbae9a01a user: kmedcalf
08:24 Reply: Enabling JSON1 extension in the sqlite3.c amalgamation at compile time artifact: 08ed061c3c user: kmedcalf
05:14 Reply: Centos pre-thread db connection using WAL journal_mode artifact: 08e8ff78e8 user: kmedcalf
05:13 Reply: Enabling JSON1 extension in the sqlite3.c amalgamation at compile time artifact: 84760809f1 user: kmedcalf
2020-11-03
21:33 Edit reply: Spanish characters in SQLITE artifact: 5b6065831d user: kmedcalf
21:32 Reply: Spanish characters in SQLITE artifact: a10757a686 user: kmedcalf
10:31 Edit reply: .param converts text to number - How to avoid this artifact: a2d10dac6a user: kmedcalf
10:27 Edit reply: .param converts text to number - How to avoid this artifact: ac31c0838b user: kmedcalf
10:16 Reply: .param converts text to number - How to avoid this artifact: 665a775bf8 user: kmedcalf
2020-11-02
06:09 Reply: CTEs in triggers artifact: ee0ce47761 user: kmedcalf
02:03 Reply: CTEs in triggers artifact: f66e7cacf6 user: kmedcalf
Previous month ↓