SQLite Forum

Timeline
Login

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

188 events for the month beginning 2020-12-01 by user kmedcalf

Following month ↑
2020-12-31
23:48 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 43edf8ceed user: kmedcalf
22:40 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: f695e3518d user: kmedcalf
22:28 Edit reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 4a2697dde7 user: kmedcalf
22:22 Edit reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 867563a014 user: kmedcalf
22:16 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 5a4da3c1a2 user: kmedcalf
21:43 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 45a55d06c1 user: kmedcalf
19:58 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 6ab7dafefe user: kmedcalf
19:41 Reply: Bug: MSVC uses intrinsic versions of ceil and floor for floating-point modes precise and fast (diagnosed) artifact: 04212ea49c user: kmedcalf
19:24 Reply: lock pending artifact: 5c773ff1d4 user: kmedcalf
01:59 Reply: Suggestion: Use strong hashes on the download page artifact: abb7e5081b user: kmedcalf
2020-12-30
18:47 Reply: Difference on NULL when WITHOUT ROWID artifact: dd7e41a1aa user: kmedcalf
2020-12-29
19:09 Reply: Database is read-only but file permissions seem correct - config issue? artifact: fb43e269f4 user: kmedcalf
00:24 Reply: Missing comma in ctime.c artifact: c87dbf0e74 user: kmedcalf
2020-12-28
22:18 Reply: Suggestion: Use strong hashes on the download page artifact: 6f9048626c user: kmedcalf
21:36 Edit reply: Off-by-one in testing.html artifact: 0ff5a77a45 user: kmedcalf
21:32 Reply: Off-by-one in testing.html artifact: f028ae2534 user: kmedcalf
21:11 Post: Missing comma in ctime.c artifact: aacac97680 user: kmedcalf
03:10 Reply: on conflict depends on conflict artifact: a3ea04d182 user: kmedcalf
02:53 Edit reply: on conflict depends on conflict artifact: f80a710938 user: kmedcalf
02:49 Reply: on conflict depends on conflict artifact: 5b7102a3b2 user: kmedcalf
00:26 Edit reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: 2e890e6751 user: kmedcalf
00:18 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: ada216320e user: kmedcalf
2020-12-27
23:00 Reply: .timer on artifact: 482b955cfc user: kmedcalf
22:29 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: f3d7bee10a user: kmedcalf
22:20 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: d34ca5b5ce user: kmedcalf
22:13 Edit reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: 71c54ab13e user: kmedcalf
22:07 Edit reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: eca46565bf user: kmedcalf
22:04 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: a4ab1774e2 user: kmedcalf
21:22 Edit reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: 3d4771cf05 user: kmedcalf
21:19 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: 9466132f15 user: kmedcalf
20:45 Reply: Is using prepared statements without a FROM to employ built-in methods bad practice? artifact: 2a68bbc400 user: kmedcalf
19:28 Edit reply: .timer on artifact: 7557803447 user: kmedcalf
19:28 Edit reply: .timer on artifact: cd791bd3d1 user: kmedcalf
19:26 Edit reply: .timer on artifact: 6f275f1756 user: kmedcalf
19:18 Edit reply: .timer on artifact: 1a7fc421a7 user: kmedcalf
19:16 Reply: .timer on artifact: 3f73899f94 user: kmedcalf
2020-12-26
19:06 Reply: sqlite3_expanded_sql for carray with single bound parameter artifact: 3e2ba0f1b4 user: kmedcalf
02:13 Edit reply: sqlite3_expanded_sql for carray with single bound parameter artifact: 9010d147c3 user: kmedcalf
02:11 Reply: sqlite3_expanded_sql for carray with single bound parameter artifact: 3253d0d53b user: kmedcalf
01:11 Reply: Creating an emty database artifact: 5f617e24e5 user: kmedcalf
01:02 Reply: Novice question about employing more complex SQL versus procedural code artifact: 4a90f17a99 user: kmedcalf
2020-12-25
21:16 Reply: 3 incorrect tables created during import artifact: 501070a68a user: kmedcalf
20:58 Reply: 3 incorrect tables created during import artifact: bbcf6bd5e2 user: kmedcalf
19:57 Reply: Check date when not null artifact: b07936a4b5 user: kmedcalf
19:34 Reply: Check date when not null artifact: 5b0887ebfb user: kmedcalf
19:34 Edit reply: Check date when not null artifact: 7e42b6fd52 user: kmedcalf
19:30 Reply: Check date when not null artifact: 472a6fae6a user: kmedcalf
18:50 Edit reply: Check date when not null artifact: 805f1e5687 user: kmedcalf
18:03 Reply: Check date when not null artifact: a586ad0da9 user: kmedcalf
2020-12-24
23:26 Reply: Question about Multiple database connections and loadable extensions. artifact: f69e37b1a1 user: kmedcalf
08:04 Reply: Question about Multiple database connections and loadable extensions. artifact: 3d80127205 user: kmedcalf
2020-12-23
21:30 Reply: Enabling REGEXP on Windows artifact: f85bba4537 user: kmedcalf
21:26 Reply: sqlite opens a database file in R/W mode, even if the file is read-only artifact: ea1c54db92 user: kmedcalf
18:42 Reply: Question about Multiple database connections and loadable extensions. artifact: ca888e0eee user: kmedcalf
18:31 Reply: Question about Multiple database connections and loadable extensions. artifact: b3ac59d593 user: kmedcalf
17:22 Reply: sqlite opens a database file in R/W mode, even if the file is read-only artifact: 15225b99f4 user: kmedcalf
16:41 Edit reply: Simple COUNT/GROUP BY query using a temporary table artifact: 4885b85464 user: kmedcalf
16:40 Reply: Simple COUNT/GROUP BY query using a temporary table artifact: 7872576e7f user: kmedcalf
16:15 Reply: Simple COUNT/GROUP BY query using a temporary table artifact: 52123ed186 user: kmedcalf
16:05 Reply: Simple COUNT/GROUP BY query using a temporary table artifact: 313512e5df user: kmedcalf
14:59 Edit reply: Simple COUNT/GROUP BY query using a temporary table artifact: 20cb75670a user: kmedcalf
14:57 Reply: Simple COUNT/GROUP BY query using a temporary table artifact: 2e62e426d1 user: kmedcalf
2020-12-22
22:58 Reply: Date & Time Data Type artifact: af04fd1eef user: kmedcalf
22:41 Edit reply: remark about sqlite3_result_blob and zero-lenght blob artifact: 5bae43cbd7 user: kmedcalf
22:40 Reply: remark about sqlite3_result_blob and zero-lenght blob artifact: f0f092c0bb user: kmedcalf
19:36 Reply: Date & Time Data Type artifact: f769ef3880 user: kmedcalf
2020-12-21
20:12 Reply: CREATE INDEX ignoring pragma cache_size - is there a way to fix? artifact: 17dc88cdff user: kmedcalf
18:32 Reply: CREATE INDEX ignoring pragma cache_size - is there a way to fix? artifact: f355e9e80f user: kmedcalf
18:27 Reply: CREATE INDEX ignoring pragma cache_size - is there a way to fix? artifact: 8d84b45fc3 user: kmedcalf
18:22 Reply: CREATE INDEX ignoring pragma cache_size - is there a way to fix? artifact: 403900c463 user: kmedcalf
17:59 Reply: CREATE INDEX ignoring pragma cache_size - is there a way to fix? artifact: 0c262eefb2 user: kmedcalf
07:53 Reply: WAL recovery error artifact: 89be1a8796 user: kmedcalf
07:46 Reply: WAL recovery error artifact: 3985b1aa33 user: kmedcalf
07:27 Reply: multiple queries artifact: 38b9e5b855 user: kmedcalf
2020-12-20
18:49 Reply: Insert or ignore in a trigger artifact: f61ba17c95 user: kmedcalf
18:39 Reply: Insert or ignore in a trigger artifact: 24208a7b3f user: kmedcalf
18:23 Reply: multiple queries artifact: 5be358f65e user: kmedcalf
18:03 Reply: sqlite3_prepare_v2 & pzTail artifact: 072948d049 user: kmedcalf
17:59 Reply: sqlite3_prepare_v2 & pzTail artifact: f8119cd1b3 user: kmedcalf
07:52 Reply: SQLite3 Extension artifact: 2b37270b7f user: kmedcalf
07:39 Edit reply: sqlite3_prepare_v2 & pzTail artifact: cb0bf51a53 user: kmedcalf
07:33 Reply: sqlite3_prepare_v2 & pzTail artifact: 5d9d43baa0 user: kmedcalf
07:21 Reply: 'ON DELETE CASCADE' seems to not be working artifact: c44d54929b user: kmedcalf
07:18 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 98ecb6254a user: kmedcalf
2020-12-19
19:31 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 3d67b03ac7 user: kmedcalf
06:54 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 89e3113ff4 user: kmedcalf
2020-12-18
21:45 Post: OT: APSW on Python 3.9 artifact: e0f010c6ee user: kmedcalf
20:27 Reply: ValueError: parameters are of unsupported type artifact: 3f4ec53a5c user: kmedcalf
20:04 Reply: ValueError: parameters are of unsupported type artifact: fe1d822de1 user: kmedcalf
19:35 Edit reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: c2f2330dc7 user: kmedcalf
19:32 Edit reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: f495df5ed8 user: kmedcalf
19:19 Reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: 04b2c1af13 user: kmedcalf
19:07 Edit reply: ValueError: parameters are of unsupported type artifact: cf0f6ba6d1 user: kmedcalf
18:48 Reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: f26c7ed6fd user: kmedcalf
18:38 Edit reply: ValueError: parameters are of unsupported type artifact: 809cd706a3 user: kmedcalf
18:34 Reply: ValueError: parameters are of unsupported type artifact: 1f55a36539 user: kmedcalf
16:29 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 6793753753 user: kmedcalf
16:18 Edit reply: 'ON DELETE CASCADE' seems to not be working artifact: 2689cedfe9 user: kmedcalf
16:16 Reply: 'ON DELETE CASCADE' seems to not be working artifact: c6e4ca9a0e user: kmedcalf
14:55 Reply: 'ON DELETE CASCADE' seems to not be working artifact: 318ec60dec user: kmedcalf
04:26 Edit reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: ca1fc9847b user: kmedcalf
04:24 Reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: badb012d84 user: kmedcalf
2020-12-17
18:22 Reply: Locking_Mode=EXCLUSIVE: What is the Journal file? artifact: 375feda068 user: kmedcalf
12:53 Reply: Change from SQL Server CE to SQLite. Something similar to SQLCEResultSet and SQLCEUpdatableRecord. artifact: 2d02b051ba user: kmedcalf
12:40 Edit reply: DB Access artifact: 24cca50dd1 user: kmedcalf
12:36 Edit reply: DB Access artifact: 8e3189ffae user: kmedcalf
12:34 Edit reply: DB Access artifact: fcbc0155b3 user: kmedcalf
12:32 Reply: DB Access artifact: ea9191d75c user: kmedcalf
12:23 Reply: DB Access artifact: 6e701f5f1d user: kmedcalf
11:06 Reply: DB Access artifact: 039d670130 user: kmedcalf
10:43 Reply: DB Access artifact: 23df036fc9 user: kmedcalf
10:26 Reply: DB Access artifact: 546f29017a user: kmedcalf
2020-12-16
22:11 Reply: v3.35 - wish for a datedif function artifact: 324068361d user: kmedcalf
21:50 Reply: v3.35 - wish for a datedif function artifact: 20414a9a41 user: kmedcalf
21:34 Reply: v3.35 - wish for a datedif function artifact: f3724402e8 user: kmedcalf
21:16 Edit reply: v3.35 - wish for a datedif function artifact: 4cee13245c user: kmedcalf
21:12 Reply: v3.35 - wish for a datedif function artifact: 6ea540e71e user: kmedcalf
00:59 Reply: SQLite WAL mode on vxWorks artifact: 5d3ec07690 user: kmedcalf
00:38 Reply: Importance of "exclusive" in speedtest artifact: 97aff886d5 user: kmedcalf
2020-12-15
17:22 Reply: SQLite3 Extension artifact: 19ee13e14e user: kmedcalf
16:02 Reply: SQLite3 Extension artifact: fc7d385a59 user: kmedcalf
2020-12-14
23:20 Edit reply: Windows CLI v3.34.0 - paths?s artifact: 4993c7a3f0 user: kmedcalf
23:17 Reply: Windows CLI v3.34.0 - paths?s artifact: 57bdbccfda user: kmedcalf
16:11 Reply: multiple queries artifact: ed80815132 user: kmedcalf
15:15 Reply: multiple queries artifact: e0bb182db6 user: kmedcalf
14:59 Reply: SQLite3 Extension artifact: 680ee2a642 user: kmedcalf
14:09 Reply: SQLite3 Extension artifact: fd2875ab9d user: kmedcalf
12:38 Reply: SQLite3 Extension artifact: d325157ef6 user: kmedcalf
12:16 Reply: SQLite3 Extension artifact: 322b84106a user: kmedcalf
10:07 Reply: SQLite3 Extension artifact: 6ad7d4f4be user: kmedcalf
09:38 Reply: Joining table-valued functions with a dynamic constraint artifact: 0482c149c3 user: kmedcalf
2020-12-12
18:57 Reply: multiple queries artifact: b12a7d6898 user: kmedcalf
18:33 Reply: Change in behavior: CLI --init artifact: 925fc9a275 user: kmedcalf
16:57 Reply: Incorrect conversion from unixepoch artifact: 00da8ca1ee user: kmedcalf
2020-12-11
23:00 Reply: Why not constant columns ? artifact: 4bc45518ae user: kmedcalf
22:04 Reply: Why not constant columns ? artifact: d138a76fb7 user: kmedcalf
16:37 Edit reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: b2a9d6268b user: kmedcalf
16:24 Edit reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: 7dfd8a81a5 user: kmedcalf
16:20 Edit reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: a68fbd900e user: kmedcalf
16:12 Reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: ad804386ac user: kmedcalf
16:05 Reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: 97189baf90 user: kmedcalf
15:43 Reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: ec856c03c5 user: kmedcalf
15:25 Reply: Reference to RECURSIVE table column apparently not allowed in nested SELECT artifact: 73a1d2dc50 user: kmedcalf
2020-12-10
16:43 Edit reply: Sqlite3 Trigger artifact: d5c6845c21 user: kmedcalf
16:35 Reply: Sqlite3 Trigger artifact: 96113880a9 user: kmedcalf
16:23 Edit reply: Transactions involving multiple databases artifact: 76c7d7cc43 user: kmedcalf
16:21 Reply: Transactions involving multiple databases artifact: 35345a09d3 user: kmedcalf
14:22 Reply: Sqlite3 Trigger artifact: c311e8cd74 user: kmedcalf
2020-12-09
23:13 Reply: Sqlite3 Trigger artifact: ab9c7e2893 user: kmedcalf
21:07 Reply: Sqlite3 Trigger artifact: ad7480dfbe user: kmedcalf
20:50 Reply: Sqlite3 Trigger artifact: 794d08d724 user: kmedcalf
19:26 Reply: Sqlite3 Trigger artifact: d9ea67b5f8 user: kmedcalf
19:14 Reply: Sqlite3 Trigger artifact: 2f39c04735 user: kmedcalf
2020-12-08
23:52 Reply: New SQLITE_ENABLE_MATH_FUNCTIONS artifact: 0bf128a3a5 user: kmedcalf
21:43 Post: New SQLITE_ENABLE_MATH_FUNCTIONS artifact: 7d974cabe9 user: kmedcalf
20:50 Edit reply: How to ignore "no such function" in metadata creation artifact: f70f77e6a4 user: kmedcalf
20:45 Reply: How to ignore "no such function" in metadata creation artifact: 7bc14e89cf user: kmedcalf
2020-12-06
05:37 Edit reply: Create view with best result pro week artifact: 1be725d4bb user: kmedcalf
05:35 Reply: Create view with best result pro week artifact: 45617dea9d user: kmedcalf
03:10 Reply: Substract Yesterday Cases from today's Cases artifact: 7cf4f7b37a user: kmedcalf
02:27 Reply: Create view with best result pro week artifact: 4ff824415f user: kmedcalf
2020-12-05
18:20 Reply: Create view with best result pro week artifact: cd94f57349 user: kmedcalf
17:02 Reply: sqlite3_close artifact: 678a9db3ba user: kmedcalf
16:52 Edit reply: Create view with best result pro week artifact: 0fbb14e1e1 user: kmedcalf
16:51 Reply: Create view with best result pro week artifact: 40e77912a6 user: kmedcalf
00:43 Reply: How can I calc weekly totals? artifact: 8fedfa615e user: kmedcalf
2020-12-04
13:37 Reply: SQLite and Concurrency Bug? artifact: 7e6508c0be user: kmedcalf
13:30 Reply: How can I calc weekly totals? artifact: e28f32cff6 user: kmedcalf
02:00 Edit reply: Support of unicode operators like ≠? artifact: 6341a5f76d user: kmedcalf
01:52 Reply: Support of unicode operators like ≠? artifact: cfdac6256f user: kmedcalf
2020-12-03
17:05 Reply: Support of unicode operators like ≠? artifact: 1f35793d29 user: kmedcalf
16:20 Reply: Is typeof() and hex() unique ? artifact: b3adf29caf user: kmedcalf
15:41 Reply: Is typeof() and hex() unique ? artifact: 6936169211 user: kmedcalf
15:31 Edit reply: Is typeof() and hex() unique ? artifact: 06b0081740 user: kmedcalf
15:20 Reply: Is typeof() and hex() unique ? artifact: d4290784f9 user: kmedcalf
14:23 Reply: Is typeof() and hex() unique ? artifact: 8c7bbc0559 user: kmedcalf
2020-12-02
19:29 Edit reply: pragma_table_info and view artifact: c58f26edf8 user: kmedcalf
19:27 Reply: pragma_table_info and view artifact: 819781c818 user: kmedcalf
18:12 Reply: V 3.34.0 artifact: f2dad90cc8 user: kmedcalf
17:52 Edit reply: Freeing sqlite3_module after registering artifact: 82eb3eeb3a user: kmedcalf
17:49 Reply: Freeing sqlite3_module after registering artifact: 792ada401c user: kmedcalf
15:58 Reply: SQLite - CLI History dialogue artifact: 39ebbdacad user: kmedcalf
2020-12-01
20:49 Reply: Mismatch in query results artifact: b07759e75e user: kmedcalf
10:37 Reply: SELECT Simple way to search for data that start with given pattern? artifact: e93edc0b76 user: kmedcalf
05:32 Reply: Freeing sqlite3_module after registering artifact: bca3745c28 user: kmedcalf
01:24 Reply: SELECT Simple way to search for data that start with given pattern? artifact: 09a4650828 user: kmedcalf
01:21 Reply: SELECT Simple way to search for data that start with given pattern? artifact: 94af40213e user: kmedcalf
01:18 Reply: How to impose soft_heap method to limit database to 5GB in sqlite artifact: 8a8fe66460 user: kmedcalf
Previous month ↓