SQLite Forum

Timeline
Login

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

111 events by user kmedcalf occurring on or before 2020-06-11 23:58:48.

2020-06-11
23:58 Reply: DROP VIEW IF EXISTS failure artifact: d829560381 user: kmedcalf
22:30 Edit reply: DROP VIEW IF EXISTS failure artifact: 3c07434c03 user: kmedcalf
22:26 Reply: DROP VIEW IF EXISTS failure artifact: 0c23f063e6 user: kmedcalf
2020-06-09
18:29 Reply: union vs left join for select artifact: d5df059a59 user: kmedcalf
13:18 Reply: union vs left join for select artifact: 454d663a5c user: kmedcalf
12:53 Reply: union vs left join for select artifact: 2a5859ef92 user: kmedcalf
12:33 Reply: Constraint Name artifact: 643a903ddb user: kmedcalf
11:45 Reply: union vs left join for select artifact: 81f966aebd user: kmedcalf
09:12 Reply: PRAGMA wal_checkpoint and sync artifact: 3ddafd7807 user: kmedcalf
08:48 Reply: Is it safe to VACUUM on a new database connection? artifact: 6fbacb228b user: kmedcalf
2020-06-05
19:23 Reply: Database WAL snapshot artifact: a1e093524f user: kmedcalf
18:32 Reply: Index question 2 artifact: e8e229c974 user: kmedcalf
16:13 Reply: Database WAL snapshot artifact: f16413bb76 user: kmedcalf
15:49 Reply: Index question 2 artifact: 8ed9f82f37 user: kmedcalf
15:41 Reply: How to not to overwrite a row if the key exists? artifact: c41e48bdef user: kmedcalf
15:10 Reply: Database WAL snapshot artifact: 3b6d6c3bb5 user: kmedcalf
08:30 Delete reply: Non primary key alias to rowid artifact: 5b800bf445 user: kmedcalf
08:23 Reply: Non primary key alias to rowid artifact: c203fecff1 user: kmedcalf
08:17 Reply: Non primary key alias to rowid artifact: 9c1c7252a0 user: kmedcalf
08:13 Reply: Non primary key alias to rowid artifact: a8e034845d user: kmedcalf
07:22 Reply: index question artifact: c960b43378 user: kmedcalf
06:58 Edit reply: How to not to overwrite a row if the key exists? artifact: 3d316d12af user: kmedcalf
06:53 Reply: How to not to overwrite a row if the key exists? artifact: bea0ac6bbf user: kmedcalf
06:26 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 869e4689ba user: kmedcalf
03:38 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 59c616d545 user: kmedcalf
03:36 Reply: How to not to overwrite a row if the key exists? artifact: 200b5af38f user: kmedcalf
2020-06-04
23:38 Reply: Non primary key alias to rowid artifact: f6c90dc3f4 user: kmedcalf
23:32 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 3beed2e7a2 user: kmedcalf
23:26 Reply: select in order artifact: a426b97b30 user: kmedcalf
15:32 Edit reply: Non primary key alias to rowid artifact: 2e3666f630 user: kmedcalf
15:23 Reply: Non primary key alias to rowid artifact: 79428a8551 user: kmedcalf
14:34 Edit reply: Non primary key alias to rowid artifact: 9ba9ab9c7d user: kmedcalf
14:28 Reply: Non primary key alias to rowid artifact: 05de6b422d user: kmedcalf
14:13 Reply: Problems related to writing following queries can someone write all these queries? artifact: f497bd1a01 user: kmedcalf
14:09 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: a5746fb174 user: kmedcalf
2020-06-02
23:54 Reply: Feature Request: pragma to curb bad column expectations artifact: 00075f7eb9 user: kmedcalf
03:24 Reply: Question about aliases on SELECT artifact: 26a82df9bc user: kmedcalf
2020-06-01
18:45 Reply: Are Views just stored SQL Strings or something more? artifact: f4e1c09069 user: kmedcalf
17:58 Reply: Are Views just stored SQL Strings or something more? artifact: d101ea0db1 user: kmedcalf
2020-05-31
05:31 Edit reply: Database Schema Changed Error artifact: e2b56e0eee user: kmedcalf
05:26 Reply: Database Schema Changed Error artifact: 6af0d63be1 user: kmedcalf
05:15 Reply: warning: function may return address of local variable -Wreturn-local-addr artifact: e44657f546 user: kmedcalf
2020-05-30
10:36 Edit reply: Confused about blobs artifact: 698b00b35c user: kmedcalf
10:34 Edit reply: Confused about blobs artifact: cfbfcf47f5 user: kmedcalf
10:33 Reply: Confused about blobs artifact: 6970443096 user: kmedcalf
10:16 Reply: Confused about blobs artifact: 41e3a253be user: kmedcalf
2020-05-29
17:59 Reply: SQLite turns 20 artifact: f0553ac256 user: kmedcalf
2020-05-27
10:27 Reply: deterministic functions behave differently in version 3.32.1 with python3 artifact: 52d80bf6da user: kmedcalf
2020-05-26
22:41 Reply: Best way to observe database operations artifact: 2d085b1de5 user: kmedcalf
11:06 Reply: How to set the column separator for the CSV extension in the CLI? artifact: 403a79bc57 user: kmedcalf
2020-05-25
22:39 Reply: Date/time formatting artifact: 038712da79 user: kmedcalf
22:02 Edit reply: Date/time formatting artifact: c282dd7e50 user: kmedcalf
21:59 Edit reply: Date/time formatting artifact: 0630198f4e user: kmedcalf
21:58 Reply: Date/time formatting artifact: 59f7b0210a user: kmedcalf
12:05 Edit reply: Bug when converting string to boolean? artifact: fe6c972903 user: kmedcalf
12:00 Edit reply: Bug when converting string to boolean? artifact: c03d6db525 user: kmedcalf
11:55 Reply: Bug when converting string to boolean? artifact: 8db8abf456 user: kmedcalf
2020-05-24
22:12 Reply: Bug when converting string to boolean? artifact: 48acc813b1 user: kmedcalf
10:14 Reply: How to set the column separator for the CSV extension in the CLI? artifact: 08a728ff22 user: kmedcalf
00:52 Edit reply: ORDER BY not working for a specific DB/table artifact: 9d7faf3590 user: kmedcalf
00:51 Reply: ORDER BY not working for a specific DB/table artifact: fd3f62f3ac user: kmedcalf
2020-05-23
12:44 Reply: ORDER BY not working for a specific DB/table artifact: 5e3775020a user: kmedcalf
2020-05-22
23:38 Reply: ORDER BY not working for a specific DB/table artifact: cc1cfd0e53 user: kmedcalf
21:33 Reply: ORDER BY not working for a specific DB/table artifact: a374c60f4a user: kmedcalf
20:30 Reply: ORDER BY not working for a specific DB/table artifact: 1197d2a524 user: kmedcalf
09:40 Reply: ORDER BY not working for a specific DB/table artifact: 219c470be5 user: kmedcalf
05:14 Reply: Temporary data when running out of memory artifact: e32a6dfba4 user: kmedcalf
04:51 Reply: ORDER BY not working for a specific DB/table artifact: b9f335807c user: kmedcalf
04:32 Reply: ORDER BY not working for a specific DB/table artifact: e023e710be user: kmedcalf
2020-05-21
21:02 Reply: ORDER BY not working for a specific DB/table artifact: d16c5fa6cb user: kmedcalf
05:13 Reply: ORDER BY not working for a specific DB/table artifact: 59c19f0b4b user: kmedcalf
2020-05-17
18:26 Reply: Jumbled image tiles? artifact: 88722e14d7 user: kmedcalf
2020-05-16
09:32 Reply: change in round() function artifact: 6de13bd987 user: kmedcalf
00:07 Edit reply: change in round() function artifact: 80fb6f9785 user: kmedcalf
00:06 Reply: change in round() function artifact: 1efbeb20ca user: kmedcalf
2020-05-15
18:04 Reply: Why is utf8 IN char* but utf8 OUT is unsigned char* artifact: 65bc906727 user: kmedcalf
17:52 Reply: change in round() function artifact: 736195c9fc user: kmedcalf
2020-05-14
18:23 Reply: Can this simple query be optimized? artifact: 3cbb049eb3 user: kmedcalf
18:09 Reply: output in column mode is truncated artifact: f9bb0d5d24 user: kmedcalf
2020-05-13
23:34 Reply: Compiling Zipfile.c artifact: b6135f7f96 user: kmedcalf
23:06 Reply: Can this simple query be optimized? artifact: 6e6d9fcfc7 user: kmedcalf
18:36 Reply: Mono.Data.Sqlite In-Memory Shared Database artifact: 22523f09e5 user: kmedcalf
01:32 Reply: Can this simple query be optimized? artifact: d1748ffe25 user: kmedcalf
01:27 Reply: Can this simple query be optimized? artifact: 642d489968 user: kmedcalf
2020-05-12
22:19 Reply: Can this simple query be optimized? artifact: 5879df2de9 user: kmedcalf
18:35 Reply: Thoughts on why this is not working? artifact: 22f9fed604 user: kmedcalf
18:12 Reply: Using sqlite3_load_extension on windows artifact: fdc8f657b3 user: kmedcalf
17:37 Edit reply: Using sqlite3_load_extension on windows artifact: cc9eba82f1 user: kmedcalf
17:35 Edit reply: Using sqlite3_load_extension on windows artifact: 81fb0fb951 user: kmedcalf
17:35 Reply: Using sqlite3_load_extension on windows artifact: 06cf40156b user: kmedcalf
2020-05-08
19:36 Reply: Help: Setting a column after finding first desired entry artifact: 4ef76046a3 user: kmedcalf
12:31 Reply: Using sqlite3_load_extension on windows artifact: 6eb7482a25 user: kmedcalf
2020-05-07
19:58 Reply: Using sqlite3_load_extension on windows artifact: f43f43fde6 user: kmedcalf
19:19 Reply: Create a trigger without a name, BUG? artifact: b89681a4d4 user: kmedcalf
18:23 Reply: Using sqlite3_load_extension on windows artifact: 5e6843dd51 user: kmedcalf
2020-05-06
22:11 Reply: Best way to handle unique column needs artifact: 57c04743e1 user: kmedcalf
22:07 Reply: Best way to handle unique column needs artifact: f1a32097f1 user: kmedcalf
17:12 Reply: Best way to handle unique column needs artifact: f03d82edcc user: kmedcalf
17:07 Reply: Best way to handle unique column needs artifact: 593af7061a user: kmedcalf
14:49 Reply: Best way to handle unique column needs artifact: 35f6675b3e user: kmedcalf
14:43 Reply: select between two dates artifact: 2cdde5bd06 user: kmedcalf
2020-05-05
20:12 Edit reply: Is write permission required for read-only connections on a WAL database? artifact: d906af6d7a user: kmedcalf
19:57 Reply: Is write permission required for read-only connections on a WAL database? artifact: 28cf852219 user: kmedcalf
18:26 Reply: Is write permission required for read-only connections on a WAL database? artifact: 3ea7b7a417 user: kmedcalf
18:00 Reply: Is write permission required for read-only connections on a WAL database? artifact: 030179b7ca user: kmedcalf
17:56 Reply: Is write permission required for read-only connections on a WAL database? artifact: e05ffc39db user: kmedcalf
2020-05-04
21:39 Edit reply: DB read fails while doing parallel bulk DB updates artifact: ac418b38b2 user: kmedcalf
21:39 Reply: DB read fails while doing parallel bulk DB updates artifact: b93fcd7170 user: kmedcalf
17:09 Reply: Week numbers in queries artifact: 66a9d50397 user: kmedcalf
16:45 Reply: Feature request: Dynamically execute SQL from shell artifact: 211575fc46 user: kmedcalf
16:30 Reply: Feature request: Dynamically execute SQL from shell artifact: 4647e9dba7 user: kmedcalf