Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
189 events for the month beginning 2023-02-01 by user kmedcalf
Following month ↑
2023-02-28
| ||
23:01 | • Edit reply: sqlean – a set of widely implemented functions to add to SQLite artifact: 009ffda11f user: kmedcalf | |
22:24 | • Reply: sqlean – a set of widely implemented functions to add to SQLite artifact: 0083a135fe user: kmedcalf | |
20:05 | • Reply: GLOB get different results for different encodings. artifact: 526f3cc9a0 user: kmedcalf | |
16:39 | • Reply: GLOB get different results for different encodings. artifact: 13b9b19aaa user: kmedcalf | |
15:33 | • Edit reply: printf: meaningfulness of the "extended precision" floating-point format artifact: 58cf81b49f user: kmedcalf | |
14:33 | • Reply: GLOB get different results for different encodings. artifact: 26b414c86d user: kmedcalf | |
04:04 | • Edit reply: printf: meaningfulness of the "extended precision" floating-point format artifact: 6c41fd07ee user: kmedcalf | |
00:17 | • Reply: printf: meaningfulness of the "extended precision" floating-point format artifact: 66bc778f37 user: kmedcalf | |
00:03 | • Reply: printf: meaningfulness of the "extended precision" floating-point format artifact: bd60a3be35 user: kmedcalf | |
2023-02-27
| ||
19:46 | • Edit reply: GLOB get different results for different encodings. artifact: a096218719 user: kmedcalf | |
19:45 | • Reply: GLOB get different results for different encodings. artifact: cc9f3cafb8 user: kmedcalf | |
19:41 | • Edit reply: GLOB get different results for different encodings. artifact: 3fe0dc1b7a user: kmedcalf | |
19:33 | • Reply: Windows command line shell converts ’ character to ' artifact: 9bb7c70da6 user: kmedcalf | |
16:56 | • Edit reply: GLOB get different results for different encodings. artifact: a7ada05c08 user: kmedcalf | |
16:55 | • Reply: GLOB get different results for different encodings. artifact: 89bfad6463 user: kmedcalf | |
14:50 | • Reply: GLOB get different results for different encodings. artifact: f51f9024b2 user: kmedcalf | |
2023-02-26
| ||
19:46 | • Edit reply: WITH ... AS BOUNDARY artifact: aefdf81b96 user: kmedcalf | |
19:35 | • Reply: WITH ... AS BOUNDARY artifact: 2ce95379dc user: kmedcalf | |
16:57 | • Edit reply: Read connection DATA LOSS under WAL mode artifact: 086213cf91 user: kmedcalf | |
16:49 | • Edit reply: Read connection DATA LOSS under WAL mode artifact: 960b650e6e user: kmedcalf | |
16:45 | • Reply: Read connection DATA LOSS under WAL mode artifact: e196798bdd user: kmedcalf | |
16:23 | • Reply: unique constraint only if flag is set artifact: d8ba09dfd7 user: kmedcalf | |
15:01 | • Reply: WITH ... AS BOUNDARY artifact: c45bb9702a user: kmedcalf | |
00:11 | • Reply: Read connection DATA LOSS under WAL mode artifact: 3a6520ae6b user: kmedcalf | |
2023-02-25
| ||
22:34 | • Reply: unique constraint only if flag is set artifact: c123be503f user: kmedcalf | |
20:49 | • Edit reply: WITH ... AS BOUNDARY artifact: 0a477870d9 user: kmedcalf | |
20:44 | • Edit reply: WITH ... AS BOUNDARY artifact: 51dbb7bfd3 user: kmedcalf | |
20:40 | • Reply: WITH ... AS BOUNDARY artifact: 64229f5818 user: kmedcalf | |
17:35 | • Edit reply: WITH ... AS BOUNDARY artifact: 57aca7b2c9 user: kmedcalf | |
17:32 | • Reply: WITH ... AS BOUNDARY artifact: 5b954d3b73 user: kmedcalf | |
2023-02-24
| ||
18:36 | • Post: WITH ... AS BOUNDARY artifact: 8dacfe8d3b user: kmedcalf | |
17:28 | • Reply: .mode quote surprise artifact: af402e9257 user: kmedcalf | |
16:49 | • Reply: Needs SQLite for MS-DOS. artifact: 953b86dcc4 user: kmedcalf | |
15:29 | • Reply: Needs SQLite for MS-DOS. artifact: 08480c54f6 user: kmedcalf | |
15:21 | • Reply: .mode quote surprise artifact: d71ed0f934 user: kmedcalf | |
14:52 | • Reply: .mode quote surprise artifact: 3297b21cc0 user: kmedcalf | |
01:33 | • Edit reply: .mode quote surprise artifact: 2d2ddc5b70 user: kmedcalf | |
01:15 | • Reply: .mode quote surprise artifact: 5bcc6d460c user: kmedcalf | |
2023-02-23
| ||
20:04 | • Reply: .mode quote surprise artifact: 82da7b3ddf user: kmedcalf | |
20:01 | • Reply: .mode quote surprise artifact: bd5973d140 user: kmedcalf | |
17:36 | • Reply: round() rounding behaviour artifact: 451d0b2567 user: kmedcalf | |
16:30 | • Reply: round() rounding behaviour artifact: e546807a9d user: kmedcalf | |
16:03 | • Reply: round() rounding behaviour artifact: 8b270d8569 user: kmedcalf | |
03:02 | • Reply: How many times is strftime calculated? artifact: b2ebb33a31 user: kmedcalf | |
00:57 | • Reply: Building custom extensions into a WASM Distribution of SQLite artifact: 541240feaa user: kmedcalf | |
2023-02-22
| ||
23:42 | • Reply: Building custom extensions into a WASM Distribution of SQLite artifact: 0b85c61931 user: kmedcalf | |
16:00 | • Reply: round() rounding behaviour artifact: cdd69c01fc user: kmedcalf | |
15:55 | • Reply: round() rounding behaviour artifact: 7198a211fe user: kmedcalf | |
14:54 | • Edit reply: SQL: substr() result for 0-index artifact: edee2b10be user: kmedcalf | |
14:52 | • Reply: SQL: substr() result for 0-index artifact: 627a92330f user: kmedcalf | |
00:25 | • Edit reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 9dc63e84e2 user: kmedcalf | |
00:22 | • Reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 2436b69963 user: kmedcalf | |
2023-02-21
| ||
07:20 | • Reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: fb09da7b95 user: kmedcalf | |
06:23 | • Edit reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 52b382605c user: kmedcalf | |
06:22 | • Edit reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 0c426f7fe9 user: kmedcalf | |
06:01 | • Reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 6f0c865a06 user: kmedcalf | |
05:50 | • Edit reply: strftime + LIKE? artifact: f30fe73a35 user: kmedcalf | |
05:46 | • Edit reply: strftime + LIKE? artifact: 4127984367 user: kmedcalf | |
05:39 | • Reply: strftime + LIKE? artifact: 3ad7e8cae3 user: kmedcalf | |
04:36 | • Reply: UPDATE ... RETURNING bug: does not present consistent snapshot of DB artifact: 4cf8952896 user: kmedcalf | |
03:57 | • Reply: strftime + LIKE? artifact: aab091ee98 user: kmedcalf | |
2023-02-20
| ||
23:06 | • Reply: strftime + LIKE? artifact: 59e82dcf78 user: kmedcalf | |
22:54 | • Reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: d6dae8d4cc user: kmedcalf | |
20:29 | • Edit reply: The latency of python PeeWee object save function for sqlite become too slow accidentally artifact: 0a249b469e user: kmedcalf | |
20:13 | • Reply: The latency of python PeeWee object save function for sqlite become too slow accidentally artifact: a522677c29 user: kmedcalf | |
19:57 | • Reply: The latency of python PeeWee object save function for sqlite become too slow accidentally artifact: 6dd418953c user: kmedcalf | |
17:16 | • Edit reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: dd336415ce user: kmedcalf | |
17:03 | • Reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: 25b61eb016 user: kmedcalf | |
16:38 | • Reply: Sqlite3 python driver returning error for table having more than 2000 Columns artifact: 8fa63d4d06 user: kmedcalf | |
2023-02-19
| ||
05:23 | • Edit reply: The latency of python PeeWee object save function for sqlite become too slow accidentally artifact: ddc45bff60 user: kmedcalf | |
05:07 | • Reply: The latency of python PeeWee object save function for sqlite become too slow accidentally artifact: f3bb031eac user: kmedcalf | |
2023-02-18
| ||
20:36 | • Edit reply: Flatten Table of Ranges? artifact: ace8a8f43a user: kmedcalf | |
20:34 | • Edit reply: Flatten Table of Ranges? artifact: d5ab7ba9a1 user: kmedcalf | |
20:33 | • Reply: Flatten Table of Ranges? artifact: fd408c9edd user: kmedcalf | |
17:00 | • Reply: ouput question for powershell sqlite THANKS artifact: 133e301d87 user: kmedcalf | |
16:28 | • Edit reply: ouput question for powershell sqlite THANKS artifact: c61373ea05 user: kmedcalf | |
16:26 | • Edit reply: ouput question for powershell sqlite THANKS artifact: bb97173d64 user: kmedcalf | |
16:25 | • Reply: ouput question for powershell sqlite THANKS artifact: 0f9c653de9 user: kmedcalf | |
01:16 | • Reply: Two problems with time artifact: 9e18de4346 user: kmedcalf | |
2023-02-17
| ||
21:11 | • Edit reply: Two problems with time artifact: da9fdac24a user: kmedcalf | |
21:11 | • Reply: Two problems with time artifact: 95092f3976 user: kmedcalf | |
14:42 | • Edit reply: Two problems with time artifact: 88136c263e user: kmedcalf | |
14:22 | • Edit reply: Two problems with time artifact: efa34b1791 user: kmedcalf | |
14:21 | • Reply: Two problems with time artifact: df24ce48ca user: kmedcalf | |
2023-02-15
| ||
02:27 | • Reply: WAL mode: No VFS writes on first sqlite3_step of statement with RETURNING artifact: 43c22a7f14 user: kmedcalf | |
2023-02-14
| ||
23:46 | • Reply: Consistent bare column values to accompany aggregate function results artifact: 1e7d219ce8 user: kmedcalf | |
23:28 | • Reply: WAL mode: No VFS writes on first sqlite3_step of statement with RETURNING artifact: 5650122f75 user: kmedcalf | |
21:01 | • Reply: WAL mode: No VFS writes on first sqlite3_step of statement with RETURNING artifact: b2955a5b2e user: kmedcalf | |
2023-02-13
| ||
21:53 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: f1ea0f8970 user: kmedcalf | |
21:39 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 54584980ff user: kmedcalf | |
18:50 | • Reply: How to view Telegram sqlite3 database file? artifact: 194570c7fb user: kmedcalf | |
17:48 | • Reply: How to view Telegram sqlite3 database file? artifact: 2d76f4650e user: kmedcalf | |
17:41 | • Delete reply: Refering to columns by N`th position artifact: 0fab569a93 user: kmedcalf | |
17:41 | • Reply: Refering to columns by N`th position artifact: 6e11c280f1 user: kmedcalf | |
17:37 | • Edit reply: Refering to columns by N`th position artifact: e52affb5c8 user: kmedcalf | |
17:37 | • Reply: Refering to columns by N`th position artifact: 74139ba25a user: kmedcalf | |
17:09 | • Edit reply: How to view Telegram sqlite3 database file? artifact: 5c1b9e3aef user: kmedcalf | |
17:09 | • Edit reply: How to view Telegram sqlite3 database file? artifact: 70bcbc40fb user: kmedcalf | |
17:05 | • Reply: How to view Telegram sqlite3 database file? artifact: 1c634cc867 user: kmedcalf | |
00:21 | • Reply: Changing python's default sqlite version in Cygwin artifact: 445398f3c6 user: kmedcalf | |
2023-02-11
| ||
23:00 | • Reply: loading a normalized db with transactions artifact: 914e99b8b1 user: kmedcalf | |
22:55 | • Reply: loading a normalized db with transactions artifact: 838dd8deab user: kmedcalf | |
22:10 | • Reply: loading a normalized db with transactions artifact: 5934a78c8e user: kmedcalf | |
22:02 | • Reply: loading a normalized db with transactions artifact: bf45c34f61 user: kmedcalf | |
03:30 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: e4b861fbc2 user: kmedcalf | |
2023-02-10
| ||
22:13 | • Reply: Locking behavior for multi-database transactions artifact: 2aa4e7f744 user: kmedcalf | |
21:21 | • Reply: Locking behavior for multi-database transactions artifact: 1a26320155 user: kmedcalf | |
21:07 | • Edit reply: Importing columns with CRLFs? artifact: 831512ccd7 user: kmedcalf | |
19:49 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 55e6471006 user: kmedcalf | |
19:32 | • Edit reply: Importing columns with CRLFs? artifact: 5069d9fe70 user: kmedcalf | |
19:30 | • Reply: Importing columns with CRLFs? artifact: 23eb596715 user: kmedcalf | |
2023-02-09
| ||
22:31 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 204e6427df user: kmedcalf | |
21:54 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 0db3c48954 user: kmedcalf | |
21:52 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: b22fa25b48 user: kmedcalf | |
21:42 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: f4545dd4c4 user: kmedcalf | |
20:36 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 93a38b9113 user: kmedcalf | |
20:35 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: dc4ddcb832 user: kmedcalf | |
20:25 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 07f4ce8237 user: kmedcalf | |
19:50 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 7e98a0a6cd user: kmedcalf | |
18:59 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 2278284984 user: kmedcalf | |
18:58 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: c646db6126 user: kmedcalf | |
18:30 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 4a5bc2cfdb user: kmedcalf | |
18:18 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: e48cf5718e user: kmedcalf | |
18:11 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: aa3dd93a72 user: kmedcalf | |
17:51 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 2a00da4d40 user: kmedcalf | |
17:47 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 6f7c4fc936 user: kmedcalf | |
17:13 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 5e757a1fe5 user: kmedcalf | |
16:59 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: be82744d85 user: kmedcalf | |
16:42 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 624b5e0b54 user: kmedcalf | |
07:45 | • Edit reply: Database query and calculation of percentages artifact: 70c56ab3e1 user: kmedcalf | |
07:44 | • Edit reply: Database query and calculation of percentages artifact: 014e81c0ab user: kmedcalf | |
03:09 | • Reply: Database query and calculation of percentages artifact: ede0dc779f user: kmedcalf | |
03:07 | • Reply: Database query and calculation of percentages artifact: 3cf17d2fbd user: kmedcalf | |
02:56 | • Reply: Delete using nested subqueries artifact: 2ff055d4c4 user: kmedcalf | |
01:22 | • Edit reply: Delete using nested subqueries artifact: db23882058 user: kmedcalf | |
01:16 | • Reply: Delete using nested subqueries artifact: 1c6830ec10 user: kmedcalf | |
01:11 | • Reply: Delete using nested subqueries artifact: 67dcae8527 user: kmedcalf | |
00:33 | • Reply: Database query and calculation of percentages artifact: 17b7f32710 user: kmedcalf | |
00:29 | • Reply: Database query and calculation of percentages artifact: a7329be6d2 user: kmedcalf | |
2023-02-08
| ||
21:43 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 53739b63d9 user: kmedcalf | |
17:15 | • Reply: Database query and calculation of percentages artifact: c15a95175a user: kmedcalf | |
08:27 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 70bf702fe0 user: kmedcalf | |
08:16 | • Edit reply: Consistent bare column values to accompany aggregate function results artifact: ef54f11f34 user: kmedcalf | |
08:05 | • Reply: Consistent bare column values to accompany aggregate function results artifact: 224a78775d user: kmedcalf | |
04:20 | • Reply: Consistent bare column values to accompany aggregate function results artifact: ca836eecc3 user: kmedcalf | |
04:10 | • Reply: API to fetch ROWID artifact: 309f906747 user: kmedcalf | |
04:01 | • Reply: API to fetch ROWID artifact: bed0d6bd1e user: kmedcalf | |
03:47 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 9e2a64cbbd user: kmedcalf | |
2023-02-07
| ||
22:29 | • Reply: How to stores dates for my use case (best query performance). artifact: 5f5d468e4e user: kmedcalf | |
20:44 | • Edit reply: How to stores dates for my use case (best query performance). artifact: d8bbf19f8b user: kmedcalf | |
20:26 | • Reply: How to stores dates for my use case (best query performance). artifact: b9a8f5c4e2 user: kmedcalf | |
17:30 | • Edit reply: GLOB index acceleration for special characters like star and square bracket? artifact: 8154cfa8a2 user: kmedcalf | |
17:27 | • Reply: GLOB index acceleration for special characters like star and square bracket? artifact: 6be6172c10 user: kmedcalf | |
16:57 | • Edit reply: How to stores dates for my use case (best query performance). artifact: 84640b4227 user: kmedcalf | |
16:25 | • Reply: SUM and DISTINCT artifact: 23719d6010 user: kmedcalf | |
16:14 | • Edit reply: How to stores dates for my use case (best query performance). artifact: 6c641a69c2 user: kmedcalf | |
16:10 | • Reply: How to stores dates for my use case (best query performance). artifact: c8071fecb0 user: kmedcalf | |
2023-02-06
| ||
22:07 | • Reply: transposing columns to rows and getting counts artifact: 637a608cec user: kmedcalf | |
21:35 | • Reply: transposing columns to rows and getting counts artifact: 8123c7765c user: kmedcalf | |
21:15 | • Reply: GLOB index acceleration for special characters like star and square bracket? artifact: 51aeeb70e7 user: kmedcalf | |
20:55 | • Reply: transposing columns to rows and getting counts artifact: 027744390c user: kmedcalf | |
19:43 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: f73d9f8759 user: kmedcalf | |
19:26 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 81064505a4 user: kmedcalf | |
19:12 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 4fe8e77272 user: kmedcalf | |
19:11 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 527b772022 user: kmedcalf | |
18:35 | • Reply: GLOB index acceleration for special characters like star and square bracket? artifact: d1c5a3de3d user: kmedcalf | |
03:48 | • Edit reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 8a735a3042 user: kmedcalf | |
02:37 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: ff50ae4430 user: kmedcalf | |
00:02 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: 69a0a4410d user: kmedcalf | |
2023-02-05
| ||
22:50 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: de7c1b9e44 user: kmedcalf | |
21:00 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: f2d50c68a0 user: kmedcalf | |
19:46 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: fde287bf3d user: kmedcalf | |
19:38 | • Reply: 'NOW' and differences between SQLite and PostgreSQL artifact: a152858668 user: kmedcalf | |
2023-02-04
| ||
17:31 | • Edit reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 2e7a135810 user: kmedcalf | |
17:30 | • Reply: Bug? Parsing Schema -- Triggers bug artifact: a4c041d854 user: kmedcalf | |
03:00 | • Reply: SELECT On-the-fly column output? artifact: 45e6c080f2 user: kmedcalf | |
02:57 | • Reply: Bug? Parsing Schema -- Triggers bug artifact: 10a9544417 user: kmedcalf | |
02:33 | • Reply: Bug? Parsing Schema -- Triggers bug artifact: 56beb85c5d user: kmedcalf | |
02:27 | • Edit reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: aaa89b86bc user: kmedcalf | |
02:21 | • Edit reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 36d3a79f6d user: kmedcalf | |
02:20 | • Edit reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: c66206ccb8 user: kmedcalf | |
02:15 | • Post: Bug? Parsing Schema -- Triggers bug artifact: 2de28898e1 user: kmedcalf | |
02:09 | • Edit reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 8e6304e09f user: kmedcalf | |
01:45 | • Reply: Suggest changes to https://www.sqlite.org/lang_naming.html artifact: 369d1b38c1 user: kmedcalf | |
2023-02-03
| ||
18:00 | • Reply: pragma_index_list does not report a primary key column if it aliases rowid artifact: 7d0945c64e user: kmedcalf | |
2023-02-02
| ||
14:18 | • Reply: Can Replace only match whole words? artifact: d92b9f7f25 user: kmedcalf | |
01:46 | • Reply: Can Replace only match whole words? artifact: 48e47b3629 user: kmedcalf | |
2023-02-01
| ||
18:21 | • Reply: Splitting up conflated names artifact: e042ee9947 user: kmedcalf | |
14:38 | • Reply: Splitting up conflated names artifact: 8877540c21 user: kmedcalf | |