SQLite Forum

Timeline
Login

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

198 events for the month beginning 2023-01-01 by user kmedcalf

Following month ↑
2023-01-31
17:33 Edit reply: Importing columns with CR/CRL/CRLF and no double-quotes within? artifact: bd5c6ea9f4 user: kmedcalf
17:23 Reply: Importing columns with CR/CRL/CRLF and no double-quotes within? artifact: 5b35d71251 user: kmedcalf
2023-01-30
23:41 Reply: Getting two answers from one expression artifact: 3801a6326c user: kmedcalf
15:36 Reply: feature suggestion Prepared statements in SQL: PREPARE/EXECUTE/DEALLOCATE PREPARE statements artifact: 85cf6385fe user: kmedcalf
06:32 Reply: feature suggestion Prepared statements in SQL: PREPARE/EXECUTE/DEALLOCATE PREPARE statements artifact: ede9aa94ab user: kmedcalf
2023-01-29
10:29 Reply: newbie Find missing rows in another table? artifact: e6e909768f user: kmedcalf
10:26 Reply: Python UPDATE in SELECT loop? Multi-paragraph text in variable? artifact: 5b9dea67b4 user: kmedcalf
03:21 Reply: Python UPDATE in SELECT loop? Multi-paragraph text in variable? artifact: 99e37f60d1 user: kmedcalf
2023-01-28
23:16 Reply: Python UPDATE in SELECT loop? Multi-paragraph text in variable? artifact: 0014c86c41 user: kmedcalf
23:15 Reply: Python UPDATE in SELECT loop? Multi-paragraph text in variable? artifact: 2090e33d2d user: kmedcalf
2023-01-27
07:09 Reply: Pthreads and SQLite artifact: b1781d403b user: kmedcalf
07:06 Edit reply: Pthreads and SQLite artifact: edfa5516e2 user: kmedcalf
07:05 Reply: Pthreads and SQLite artifact: c8c30b7a11 user: kmedcalf
06:53 Edit reply: Pthreads and SQLite artifact: 2d31afda7e user: kmedcalf
06:53 Reply: Pthreads and SQLite artifact: ded10bce9a user: kmedcalf
01:42 Edit reply: return table-like result set artifact: 977bfa881f user: kmedcalf
01:41 Edit reply: return table-like result set artifact: bb933d84c8 user: kmedcalf
01:30 Reply: return table-like result set artifact: 19655660a2 user: kmedcalf
01:27 Reply: return table-like result set artifact: 22cadd6d62 user: kmedcalf
2023-01-26
22:21 Edit reply: return table-like result set artifact: c9a90e20cb user: kmedcalf
22:20 Reply: return table-like result set artifact: a3ac826582 user: kmedcalf
2023-01-25
21:06 Edit reply: Pthreads and SQLite artifact: b86cfe808f user: kmedcalf
20:55 Edit reply: Pthreads and SQLite artifact: aa38ea27fe user: kmedcalf
20:50 Reply: Pthreads and SQLite artifact: cfb249ae95 user: kmedcalf
2023-01-24
22:56 Edit reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 6c1ebea7a8 user: kmedcalf
22:53 Edit reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 59d5dbf73d user: kmedcalf
22:53 Reply: No LEFT JOIN elimination if the subquery is an aggregate? artifact: 3d2b74a131 user: kmedcalf
13:42 Reply: ATTACHed DATABASE doesnt not respect cache_size pragma artifact: 08e14cad92 user: kmedcalf
13:41 Reply: ATTACHed DATABASE doesnt not respect cache_size pragma artifact: c4ea545c98 user: kmedcalf
12:36 Edit reply: Virtual Table _ CSV artifact: 24031ed3c3 user: kmedcalf
12:34 Reply: Virtual Table _ CSV artifact: 47690a70f6 user: kmedcalf
00:11 Edit reply: SQLITE forces my primary key to autoindex. artifact: 7c08c05f1d user: kmedcalf
00:06 Reply: SQLITE forces my primary key to autoindex. artifact: a1789e5abc user: kmedcalf
00:03 Reply: SQLITE forces my primary key to autoindex. artifact: ee72d9396a user: kmedcalf
00:00 Reply: SQLITE forces my primary key to autoindex. artifact: 312f05de4e user: kmedcalf
2023-01-23
23:44 Reply: SQLITE forces my primary key to autoindex. artifact: 7331363645 user: kmedcalf
23:05 Reply: Virtual Table _ CSV artifact: 8de37f7ed8 user: kmedcalf
22:41 Reply: CLI .import <filename> table not finding file in using Cygwin filename format artifact: e69c880ccb user: kmedcalf
22:39 Reply: CLI .import <filename> table not finding file in using Cygwin filename format artifact: e1ce9eb32f user: kmedcalf
22:23 Reply: Use of CTE's is broken artifact: 3cdf8b1ba1 user: kmedcalf
22:21 Reply: Use of CTE's is broken artifact: 40d254eaa3 user: kmedcalf
22:20 Reply: CLI .import <filename> table not finding file in using Cygwin filename format artifact: e3889307fd user: kmedcalf
22:08 Reply: Use of CTE's is broken artifact: 6154ede9b2 user: kmedcalf
21:58 Reply: Best practices lowering memory consumption with hundreds of open DBs artifact: 564d0d2c08 user: kmedcalf
21:50 Reply: Virtual Table _ CSV artifact: 0198a1c042 user: kmedcalf
21:37 Edit reply: Virtual Table _ CSV artifact: 7fc99b29b1 user: kmedcalf
21:34 Reply: Virtual Table _ CSV artifact: 7e43234270 user: kmedcalf
21:10 Edit reply: CHECK constraint used to check values between tables artifact: 37abe1c54d user: kmedcalf
21:07 Reply: CHECK constraint used to check values between tables artifact: a210b0540c user: kmedcalf
17:23 Reply: Virtual Table _ CSV artifact: 07d9d6582d user: kmedcalf
2023-01-22
03:38 Edit reply: How do I query all columns? artifact: 8e2d5ab3fb user: kmedcalf
02:46 Edit reply: How do I query all columns? artifact: 99f4e9ab19 user: kmedcalf
02:45 Reply: How do I query all columns? artifact: ba8b5c523f user: kmedcalf
2023-01-20
17:44 Edit reply: Null DB when debugging with C# artifact: adcb2ed778 user: kmedcalf
17:42 Reply: Null DB when debugging with C# artifact: fc874c2cf9 user: kmedcalf
16:44 Reply: Null DB when debugging with C# artifact: 54a39e32c0 user: kmedcalf
16:35 Reply: Null DB when debugging with C# artifact: f0662bc9b3 user: kmedcalf
16:08 Edit reply: Null DB when debugging with C# artifact: bfacbf6e12 user: kmedcalf
16:07 Reply: Null DB when debugging with C# artifact: f469f73c81 user: kmedcalf
15:21 Reply: How to add base64 and 85 to the amalgamation as builtin function artifact: 88c08c711f user: kmedcalf
04:52 Reply: Methods of achieving the same results as if it were possible to perfrom an unpdate and an insert within the same CTE? artifact: e83e1f728c user: kmedcalf
03:32 Reply: What pragmas are not available as pragma functions? artifact: d60657a5c7 user: kmedcalf
03:31 Reply: Methods of achieving the same results as if it were possible to perfrom an unpdate and an insert within the same CTE? artifact: 308191be47 user: kmedcalf
01:54 Edit reply: What pragmas are not available as pragma functions? artifact: 76caca4ade user: kmedcalf
01:53 Reply: What pragmas are not available as pragma functions? artifact: a673b66b1f user: kmedcalf
00:44 Reply: Duplicate constraints per column artifact: 5d57d1a6bf user: kmedcalf
2023-01-19
21:32 Edit reply: Multiple string comparisons in a case when artifact: 6a527f7f24 user: kmedcalf
21:29 Edit reply: Multiple string comparisons in a case when artifact: 9831021266 user: kmedcalf
21:28 Reply: Multiple string comparisons in a case when artifact: cdceca0ca7 user: kmedcalf
21:01 Reply: Methods of achieving the same results as if it were possible to perfrom an unpdate and an insert within the same CTE? artifact: 9e04146177 user: kmedcalf
15:24 Reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 2bcd49d937 user: kmedcalf
14:33 Reply: Multiple string comparisons in a case when artifact: e6ba69872a user: kmedcalf
14:23 Reply: Methods of achieving the same results as if it were possible to perfrom an unpdate and an insert within the same CTE? artifact: 8d706305c0 user: kmedcalf
14:04 Reply: Updating to 3.40 broke our software artifact: ee5fcbf96b user: kmedcalf
00:36 Reply: SQLLite Querying Question artifact: 875862aa94 user: kmedcalf
2023-01-18
22:18 Reply: SQLLite Querying Question artifact: a1e2540d0f user: kmedcalf
21:45 Reply: SQLLite Querying Question artifact: f77ad56925 user: kmedcalf
21:15 Reply: SQLLite Querying Question artifact: 08c289ae53 user: kmedcalf
21:03 Edit reply: SQLLite Querying Question artifact: f4912bd086 user: kmedcalf
20:46 Edit reply: SQLLite Querying Question artifact: 4d00d279a4 user: kmedcalf
20:45 Edit reply: SQLLite Querying Question artifact: 5b7d120473 user: kmedcalf
20:43 Reply: SQLLite Querying Question artifact: 5f552b2628 user: kmedcalf
20:41 Edit reply: SQLLite Querying Question artifact: cfa80bbfa1 user: kmedcalf
20:37 Edit reply: SQLLite Querying Question artifact: 0fa2c59085 user: kmedcalf
20:36 Reply: SQLLite Querying Question artifact: 4528bc4f19 user: kmedcalf
20:28 Reply: SQLLite Querying Question artifact: aac7e75018 user: kmedcalf
20:24 Edit reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 89350078ca user: kmedcalf
19:49 Reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: 7692d50f8e user: kmedcalf
19:42 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 09bdef5eb4 user: kmedcalf
19:37 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 44246e2397 user: kmedcalf
18:47 Reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: c54bfc184e user: kmedcalf
13:17 Reply: Updating to 3.40 broke our software artifact: a8959aaabb user: kmedcalf
00:47 Edit reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization artifact: e5a41ce880 user: kmedcalf
00:45 Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization artifact: 1864632952 user: kmedcalf
2023-01-17
22:46 Reply: Terminal output into DB with SQLite artifact: 24de237e9a user: kmedcalf
06:59 Reply: List of functions artifact: 765df74bb6 user: kmedcalf
06:58 Reply: List of functions artifact: e3ac23f041 user: kmedcalf
06:45 Edit reply: List of functions artifact: 7706f21d26 user: kmedcalf
06:44 Reply: List of functions artifact: 9b9edf4b75 user: kmedcalf
04:23 Reply: How to work with FTS5 external content tables ? artifact: 32aceaec2c user: kmedcalf
02:39 Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization artifact: 50a6c4ed26 user: kmedcalf
02:05 Reply: How to work with FTS5 external content tables ? artifact: abad9592a1 user: kmedcalf
00:20 Reply: is compilation configure script parsing my variables? artifact: 4c88cfc740 user: kmedcalf
00:04 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 7a48616a01 user: kmedcalf
2023-01-16
23:55 Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization artifact: 595f52e740 user: kmedcalf
23:44 Edit reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 7bbe7cc331 user: kmedcalf
23:40 Edit reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 3352b4fa57 user: kmedcalf
23:39 Reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: 8d21be21f1 user: kmedcalf
21:52 Reply: How to avoid temp B-tree when accumulating a json array by using "sum() over (order by rowid) from json_each()"? artifact: e2e03bbec7 user: kmedcalf
19:04 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 5cf7db4fca user: kmedcalf
18:38 Reply: cross-compiling to Windows host on Linux builder: can't find ioctl.h artifact: 259035b6c4 user: kmedcalf
18:21 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: b0e9d3610a user: kmedcalf
17:26 Edit reply: More thread-safe/reentrant way to obtain insertion row ID artifact: a70fc0971f user: kmedcalf
17:11 Edit reply: Loading extensions in a trigger, unsafe use of load_extension() artifact: 60725ff95d user: kmedcalf
17:01 Reply: Loading extensions in a trigger, unsafe use of load_extension() artifact: fc1a823238 user: kmedcalf
16:48 Edit reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 7924cb6180 user: kmedcalf
16:45 Reply: More thread-safe/reentrant way to obtain insertion row ID artifact: 1622d0e7ac user: kmedcalf
16:32 Reply: Bug? "SQL Logic Error" when compiled with Visual Studio artifact: dc10dfd82c user: kmedcalf
2023-01-15
22:56 Edit reply: Sqlite3 as a shared object (.so) artifact: ec87ff9f50 user: kmedcalf
22:55 Reply: Sqlite3 as a shared object (.so) artifact: 88eb3e303c user: kmedcalf
15:35 Reply: Sqlite3 as a shared object (.so) artifact: 8a97e97343 user: kmedcalf
2023-01-14
23:13 Edit reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: 70e7421f7d user: kmedcalf
22:51 Reply: bug? running error with SQLITE_OMIT_WAL FOR RBU artifact: f9d1e0b4a4 user: kmedcalf
2023-01-13
17:42 Edit reply: Loading extensions in a trigger, unsafe use of load_extension() artifact: b292dec8af user: kmedcalf
17:38 Reply: Loading extensions in a trigger, unsafe use of load_extension() artifact: 3ca662e9e0 user: kmedcalf
15:32 Reply: smiley face symbols in sqlitestudio artifact: cf43000dc0 user: kmedcalf
2023-01-12
23:10 Reply: List of functions artifact: e934d803d2 user: kmedcalf
22:55 Reply: UnsatisfiedLinkError (undefined symbol: trunc) With JDBC Driver 3.40.0.0 artifact: 0f4196cfba user: kmedcalf
21:12 Reply: UnsatisfiedLinkError (undefined symbol: trunc) With JDBC Driver 3.40.0.0 artifact: 0d6db83a62 user: kmedcalf
18:24 Reply: UnsatisfiedLinkError (undefined symbol: trunc) With JDBC Driver 3.40.0.0 artifact: 014cf8a661 user: kmedcalf
18:19 Reply: UnsatisfiedLinkError (undefined symbol: trunc) With JDBC Driver 3.40.0.0 artifact: 3cbdfae95c user: kmedcalf
2023-01-11
23:11 Reply: Why in tables WITHOUT ROWID is the amount of payload that spills onto overflow pages from leaf page like for an index page? artifact: 59766494ad user: kmedcalf
22:57 Edit reply: Why in tables WITHOUT ROWID is the amount of payload that spills onto overflow pages from leaf page like for an index page? artifact: 8edba58dd7 user: kmedcalf
22:56 Reply: Why in tables WITHOUT ROWID is the amount of payload that spills onto overflow pages from leaf page like for an index page? artifact: 58a4f39fdd user: kmedcalf
22:50 Reply: sqlite3_context_db_handle question artifact: f68fe520d1 user: kmedcalf
21:23 Post: sqlite3_context_db_handle question artifact: 115af630ae user: kmedcalf
20:45 Post: Current Head of Trunk MSVC Compiler barf artifact: 8db1711ca2 user: kmedcalf
19:15 Reply: Feature Request - ORDER BY random(seed) artifact: f260df1870 user: kmedcalf
13:01 Reply: How to show tables? artifact: 1592930e12 user: kmedcalf
12:56 Reply: Feature Request - ORDER BY random(seed) artifact: 0c9b91844d user: kmedcalf
04:53 Reply: about the result 1='1' that sqlite behave different with mysql or oracle artifact: 9d706de7c6 user: kmedcalf
2023-01-10
17:43 Reply: Find an issue sqlite cannot open on some release version of Linux artifact: 95764aa7bf user: kmedcalf
17:40 Reply: Cancellation in custom SQLiteFunction artifact: e4cefc4db6 user: kmedcalf
17:31 Reply: about the result 1='1' that sqlite behave different with mysql or oracle artifact: 443e259335 user: kmedcalf
17:13 Edit reply: Help Compiling SQLite for UWP ARM64 artifact: db5fa9b1c3 user: kmedcalf
17:11 Reply: Help Compiling SQLite for UWP ARM64 artifact: e2dbd7e9d5 user: kmedcalf
2023-01-09
21:40 Post: Opening a memdb does not save filename artifact: da842c35c1 user: kmedcalf
18:15 Reply: SQLite won't .quit from Windows PowerShell artifact: 60ec27da09 user: kmedcalf
17:19 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: 846384ed77 user: kmedcalf
16:43 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: 1e943d8df9 user: kmedcalf
16:12 Edit reply: SQLite won't .quit from Windows PowerShell artifact: 1ffcc58800 user: kmedcalf
16:11 Reply: SQLite won't .quit from Windows PowerShell artifact: 106eea20ad user: kmedcalf
16:07 Reply: Empty column What is not NULL? Right way to convert to NULL? artifact: e22ca6aea0 user: kmedcalf
08:58 Reply: in memory syntax creates file in ntfs streams artifact: 16271baf07 user: kmedcalf
05:48 Reply: Empty column What is not NULL? Right way to convert to NULL? artifact: e1bdd72f36 user: kmedcalf
05:11 Reply: Empty column What is not NULL? Right way to convert to NULL? artifact: 42cb2b0b92 user: kmedcalf
01:09 Reply: incremental view maintenance? artifact: dcfdf25711 user: kmedcalf
00:51 Edit reply: in memory syntax creates file in ntfs streams artifact: df7e17f9c4 user: kmedcalf
00:40 Edit reply: in memory syntax creates file in ntfs streams artifact: 18188dd994 user: kmedcalf
00:39 Reply: in memory syntax creates file in ntfs streams artifact: 033406ffa0 user: kmedcalf
2023-01-08
18:39 Reply: Why is json_extract() considered unsafe? artifact: 7f02ce3775 user: kmedcalf
2023-01-07
17:48 Reply: Deleting index data without dropping artifact: bd15f0bf59 user: kmedcalf
13:48 Reply: Deleting index data without dropping artifact: d06bdc1a1d user: kmedcalf
13:20 Reply: incremental view maintenance? artifact: 993de63b5f user: kmedcalf
13:10 Reply: Help Compiling SQLite for UWP ARM64 artifact: 9a19940f73 user: kmedcalf
2023-01-06
22:15 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: bbd7b1f4f1 user: kmedcalf
22:08 Edit reply: Issue with pragma table_info / data-type on views in 3.41 artifact: d198912643 user: kmedcalf
22:07 Reply: Issue with pragma table_info / data-type on views in 3.41 artifact: 7974ec6d82 user: kmedcalf
18:22 Reply: Easy way to insert parent-child relationships? artifact: 35e3f8ae0b user: kmedcalf
18:15 Reply: ORDER BY in VIEW definition or in SELECT from the view? artifact: 2c79130773 user: kmedcalf
17:18 Edit reply: Easy way to insert parent-child relationships? artifact: b7f50cdc34 user: kmedcalf
17:08 Edit reply: Easy way to insert parent-child relationships? artifact: 8f825b1007 user: kmedcalf
17:03 Reply: Easy way to insert parent-child relationships? artifact: f500aec459 user: kmedcalf
2023-01-05
21:50 Reply: Which of these queries is faster? artifact: 5c55cb8a81 user: kmedcalf
21:48 Reply: How to avoid scientific notation? artifact: 7801a8edd9 user: kmedcalf
19:14 Reply: Release security fix for CVE-2022-46908 artifact: ec6609adc1 user: kmedcalf
2023-01-04
23:23 Edit reply: Best Development Environment for SQLite3 artifact: 107c61cb3e user: kmedcalf
23:22 Reply: Best Development Environment for SQLite3 artifact: b07ae362f5 user: kmedcalf
17:43 Reply: Accessing SQLite DB file remotely over network artifact: 55c55ea35e user: kmedcalf
01:48 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 2c4e0925eb user: kmedcalf
01:04 Reply: Ctrl-Z too pretty for published Linux 3.40.1 CLI artifact: 93577f4314 user: kmedcalf
2023-01-03
16:28 Reply: Info on sqlite Write-Ahead Logging (WAL) artifact: 4fe5f1dfd8 user: kmedcalf
03:38 Reply: Complete documentation artifact: 9b4b8f92b8 user: kmedcalf
03:15 Reply: Complete documentation artifact: 83b6d77e57 user: kmedcalf
03:12 Edit reply: Complete documentation artifact: 79328968aa user: kmedcalf
03:09 Reply: Complete documentation artifact: 89ccca46b4 user: kmedcalf
00:12 Reply: Can SQLite filter duplicates? artifact: febe49e45c user: kmedcalf
2023-01-02
20:06 Reply: Bug selecting 64bit integer artifact: c5cdcde686 user: kmedcalf
20:02 Reply: Bug selecting 64bit integer artifact: 4d1c692105 user: kmedcalf
19:38 Reply: SQLite work very slowly artifact: c3c9314b5b user: kmedcalf
19:08 Reply: SQLite work very slowly artifact: e35a7ee9d8 user: kmedcalf
19:02 Edit reply: SQLite work very slowly artifact: c2692db4b4 user: kmedcalf
16:48 Edit reply: SQLite work very slowly artifact: ae823de868 user: kmedcalf
16:47 Edit reply: SQLite work very slowly artifact: 716be81ed2 user: kmedcalf
16:46 Reply: SQLite work very slowly artifact: 723d146896 user: kmedcalf
03:05 Edit reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 1f2bbd70a4 user: kmedcalf
03:03 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: 521b9215b1 user: kmedcalf
2023-01-01
22:57 Reply: How to remove two rows with a Sqlite command in my JSON database ? artifact: d1b0e6db36 user: kmedcalf
Previous month ↓