SQLite Forum

Timeline
Login

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

124 events for the month beginning 2020-06-01 by user kmedcalf

Following month ↑
2020-06-30
20:01 Reply: Sum precision ? artifact: 786f1d4449 user: kmedcalf
09:11 Reply: Can VACUUM rollback the db? artifact: defe489a63 user: kmedcalf
06:33 Edit reply: Do not auto reset after schema change artifact: e73eb1de19 user: kmedcalf
06:31 Edit reply: Do not auto reset after schema change artifact: 3d787d5ab9 user: kmedcalf
06:24 Reply: Do not auto reset after schema change artifact: a9e809065d user: kmedcalf
06:07 Reply: Do not auto reset after schema change artifact: e54182143b user: kmedcalf
2020-06-29
22:56 Reply: Beginner: keep getting ...> artifact: 5d3fca4a20 user: kmedcalf
22:06 Reply: Beginner: keep getting ...> artifact: 423012837e user: kmedcalf
21:54 Reply: Which C standard does Sqlite's source code compatible? artifact: a0e556c422 user: kmedcalf
21:44 Reply: Which C standard does Sqlite's source code compatible? artifact: e6199feeeb user: kmedcalf
21:41 Delete reply: Which C standard does Sqlite's source code compatible? artifact: 934446a41a user: kmedcalf
21:28 Reply: Which C standard does Sqlite's source code compatible? artifact: 43240dc70d user: kmedcalf
2020-06-28
18:44 Reply: Beginner: keep getting ...> artifact: 43e4fadc40 user: kmedcalf
15:42 Reply: Beginner: keep getting ...> artifact: ece81e2830 user: kmedcalf
2020-06-27
14:51 Reply: Query planner fails to use obvious index artifact: ff3a80de99 user: kmedcalf
12:06 Reply: Problem with Sqlite DELETE documentation artifact: c2ca25c1ad user: kmedcalf
2020-06-23
19:02 Reply: Formatting of SQLite files artifact: 4dd3a03e6d user: kmedcalf
17:56 Reply: Decimal128 artifact: 13a4d76a85 user: kmedcalf
17:51 Reply: Decimal128 artifact: 83c74d5751 user: kmedcalf
2020-06-22
21:49 Reply: Decimal128 artifact: 1ee3147fd7 user: kmedcalf
21:25 Reply: Decimal128 artifact: 72337a85dc user: kmedcalf
21:04 Reply: Decimal128 artifact: 2ae1467186 user: kmedcalf
17:29 Reply: Decimal128 artifact: a657f1663a user: kmedcalf
14:53 Edit reply: Decimal128 artifact: fa32cf7807 user: kmedcalf
14:49 Reply: Decimal128 artifact: 4cc6e84e96 user: kmedcalf
13:24 Reply: Decimal128 artifact: ac6cbd8431 user: kmedcalf
00:18 Reply: Decimal128 artifact: 5af712f5f4 user: kmedcalf
2020-06-21
19:30 Reply: Decimal128 artifact: c0fa5a4a34 user: kmedcalf
19:15 Reply: Decimal128 artifact: 198b151166 user: kmedcalf
19:02 Edit reply: Decimal128 artifact: 569ff2dca0 user: kmedcalf
18:58 Reply: Decimal128 artifact: c690c360d2 user: kmedcalf
16:02 Reply: Decimal128 artifact: 8bda7a0373 user: kmedcalf
15:52 Reply: Decimal128 artifact: 562f129178 user: kmedcalf
15:45 Reply: Decimal128 artifact: 9c3890fd04 user: kmedcalf
15:34 Reply: What reading wal can result in `BusyError: database is locked`? artifact: 48e2342508 user: kmedcalf
2020-06-20
22:55 Reply: Decimal128 artifact: 591f15f9b3 user: kmedcalf
18:18 Reply: Decimal128 artifact: ce6886f64d user: kmedcalf
16:56 Reply: Decimal128 artifact: 9c8399275e user: kmedcalf
02:47 Reply: Decimal128 artifact: c82232d79f user: kmedcalf
2020-06-19
22:23 Reply: Using coalesce in where clause artifact: 48d6844c2f user: kmedcalf
02:16 Reply: Join tables by nearest older date artifact: 0eb3c803af user: kmedcalf
2020-06-18
21:33 Reply: Join tables by nearest older date artifact: 308cc1420e user: kmedcalf
20:25 Edit reply: Join tables by nearest older date artifact: 5cf4e89142 user: kmedcalf
20:23 Edit reply: Join tables by nearest older date artifact: b8d4c42dec user: kmedcalf
20:21 Reply: Join tables by nearest older date artifact: 7b79c81e19 user: kmedcalf
18:22 Reply: Are result values always the same? artifact: 1ec2de425f user: kmedcalf
17:22 Reply: Slow update table with large BLOB issue(solution) artifact: 5c37c11e3f user: kmedcalf
15:31 Reply: Slow update table with large BLOB issue(solution) artifact: 8019aa22f6 user: kmedcalf
05:53 Reply: Are result values always the same? artifact: 5dfa2e2609 user: kmedcalf
2020-06-17
18:51 Reply: Are result values always the same? artifact: ff444e8960 user: kmedcalf
2020-06-16
22:37 Reply: Help with foreign key artifact: 1e9c69e122 user: kmedcalf
22:09 Reply: Help with foreign key artifact: 40c85624a0 user: kmedcalf
22:05 Reply: Help with foreign key artifact: dd55a7835b user: kmedcalf
15:21 Reply: How to Extension SQLite to support Stored Procedure? artifact: e6566322c0 user: kmedcalf
15:13 Reply: Query planner stability guarantee with SQLITE_ENABLE_STAT4 artifact: 32e4754518 user: kmedcalf
15:09 Reply: Database Schema Changed Error artifact: 1df053250d user: kmedcalf
14:40 Edit reply: ALTER TABLE new_X RENAME TO X issue. artifact: 4357902333 user: kmedcalf
14:25 Reply: ALTER TABLE new_X RENAME TO X issue. artifact: e1efa73ddf user: kmedcalf
2020-06-15
22:02 Reply: New Caveat (bug?) Interrupt does not Interrupt during Columnar output artifact: ccc09a12a8 user: kmedcalf
18:26 Post: New Caveat (bug?) Interrupt does not Interrupt during Columnar output artifact: f283c9615f user: kmedcalf
16:32 Reply: DROP VIEW IF EXISTS failure artifact: 681b89ebda user: kmedcalf
2020-06-14
19:23 Reply: Possible vulnerabilities from December 2019 artifact: 81089b4e87 user: kmedcalf
17:24 Edit reply: Possible vulnerabilities from December 2019 artifact: ec4e2b201d user: kmedcalf
17:22 Reply: Possible vulnerabilities from December 2019 artifact: cd13133502 user: kmedcalf
17:18 Reply: Possible vulnerabilities from December 2019 artifact: 8fd64a7328 user: kmedcalf
17:15 Reply: Possible vulnerabilities from December 2019 artifact: 9060072f58 user: kmedcalf
16:49 Reply: How db access is handled by sqlite3? artifact: 87d3923d46 user: kmedcalf
16:43 Reply: storing number with 2 decimal place artifact: caff487612 user: kmedcalf
16:22 Reply: DROP VIEW IF EXISTS failure artifact: 46c064c87e user: kmedcalf
16:04 Reply: storing number with 2 decimal place in Sqlite3 with python3 artifact: d5cdfdbc4b user: kmedcalf
15:54 Reply: Query planner stability guarantee with SQLITE_ENABLE_STAT4 artifact: 194730cc00 user: kmedcalf
2020-06-13
22:23 Edit reply: How db access is handled by sqlite3? artifact: bfef1d44ee user: kmedcalf
22:18 Reply: How db access is handled by sqlite3? artifact: b1f3dd0fa9 user: kmedcalf
21:35 Edit reply: current_date, etc are functions? artifact: 1328ae35b1 user: kmedcalf
21:34 Reply: current_date, etc are functions? artifact: a5e8d469fd user: kmedcalf
14:17 Reply: ALTER TABLE ADD COLUMN problem artifact: 2338858af2 user: kmedcalf
13:23 Reply: ALTER TABLE ADD COLUMN problem artifact: 948baa805f user: kmedcalf
2020-06-12
20:59 Reply: current_date, etc are functions? artifact: f60a8e9219 user: kmedcalf
19:23 Reply: Show duplicate rows sorted artifact: e63cef6e90 user: kmedcalf
18:14 Reply: Show duplicate rows sorted artifact: e827513718 user: kmedcalf
18:09 Reply: DROP VIEW IF EXISTS failure artifact: 93cef1d325 user: kmedcalf
17:49 Reply: DROP VIEW IF EXISTS failure artifact: c2020838fd user: kmedcalf
16:34 Edit reply: sqlite user authentication in c++ project artifact: dda968eb6f user: kmedcalf
16:31 Reply: sqlite user authentication in c++ project artifact: ad09394653 user: kmedcalf
16:27 Reply: DROP VIEW IF EXISTS failure artifact: db5637f2a4 user: kmedcalf
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
Previous month ↓