SQLite Forum

Timeline
Login

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
Previous month ↓