Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
114 events for the month beginning 2022-08-01 by user kmedcalf
Following month ↑
2022-08-31
| ||
19:57 | • Reply: Including the lsm1 extension in the amalgam file artifact: 7f10e4d18e user: kmedcalf | |
16:19 | • Reply: pragma_* table-valued function irregularities artifact: cadfbd6358 user: kmedcalf | |
01:59 | • Reply: max() function broken artifact: 0f271341f4 user: kmedcalf | |
2022-08-30
| ||
21:05 | • Reply: pragma_* table-valued function irregularities artifact: bd403a08b7 user: kmedcalf | |
20:58 | • Reply: Including the lsm1 extension in the amalgam file artifact: 51bdfe543b user: kmedcalf | |
20:49 | • Reply: Including the lsm1 extension in the amalgam file artifact: a28f07d850 user: kmedcalf | |
19:27 | • Reply: Including the lsm1 extension in the amalgam file artifact: 2803a357a0 user: kmedcalf | |
19:19 | • Reply: max() function broken artifact: 7bfcf4868b user: kmedcalf | |
19:02 | • Reply: max() function broken artifact: 9edba49bd6 user: kmedcalf | |
17:54 | • Reply: max() function broken artifact: e73901ba8a user: kmedcalf | |
17:49 | • Reply: max() function broken artifact: 61a6cc4ab8 user: kmedcalf | |
17:47 | • Reply: Including the lsm1 extension in the amalgam file artifact: 00601bdabd user: kmedcalf | |
17:29 | • Reply: How to select from pragma_table_info for specific schema? artifact: e5f3907dcd user: kmedcalf | |
17:16 | • Reply: max() function broken artifact: c808540cef user: kmedcalf | |
2022-08-29
| ||
19:47 | • Reply: How to expose SQL API query endpoint safely? artifact: 8e6662db55 user: kmedcalf | |
16:37 | • Reply: max() function broken artifact: c6d1eef3de user: kmedcalf | |
15:41 | • Reply: How to expose SQL API query endpoint safely? artifact: 3730624f0b user: kmedcalf | |
15:18 | • Reply: Better explanation about Readonly and ATTACH database artifact: fe5e2d12ae user: kmedcalf | |
2022-08-28
| ||
17:48 | • Reply: Different Rowid artifact: 643655048a user: kmedcalf | |
17:40 | • Edit reply: Different Rowid artifact: f0092799a3 user: kmedcalf | |
17:38 | • Reply: Different Rowid artifact: 4c477b464f user: kmedcalf | |
00:48 | • Reply: SQLite planner is definitely not working as expected artifact: e2a571e5fe user: kmedcalf | |
00:32 | • Reply: SQLite planner is definitely not working as expected artifact: 75afc9fb32 user: kmedcalf | |
2022-08-27
| ||
19:56 | • Reply: SQLite planner is definitely not working as expected artifact: 1cf2b3bde0 user: kmedcalf | |
2022-08-26
| ||
19:06 | • Edit reply: SQLite planner is definitely not working as expected artifact: 0cf09cf9db user: kmedcalf | |
18:51 | • Reply: SQLite planner is definitely not working as expected artifact: 48f0493195 user: kmedcalf | |
2022-08-25
| ||
15:39 | • Reply: How to Corrrupt an SQLite DB Section 2.2.1 artifact: 4f9501dcb1 user: kmedcalf | |
04:12 | • Reply: Minimize the useless INSERTs artifact: 1f8a65b68a user: kmedcalf | |
04:04 | • Reply: Minimize the useless INSERTs artifact: 8acde10f3c user: kmedcalf | |
2022-08-23
| ||
21:11 | • Reply: Cross process change notification artifact: 8d9c568728 user: kmedcalf | |
17:40 | • Reply: Index vs different table (speed and recommendations) artifact: aa6debcc02 user: kmedcalf | |
17:28 | • Reply: SQLite planner is definitely not working as expected artifact: d78d0a8565 user: kmedcalf | |
15:56 | • Reply: Cross process change notification artifact: 896a5a6750 user: kmedcalf | |
2022-08-22
| ||
19:23 | • Reply: continued problem with query planner (expert mode fails) artifact: 1268536fb8 user: kmedcalf | |
15:48 | • Reply: Inconsistent .def files in Windows binaries 3.39.2 artifact: 4b074dae20 user: kmedcalf | |
2022-08-20
| ||
19:14 | • Reply: what are the recommended storage limits per sqlite? is it possible to have 200TB in SQLite and still have good performance in artifact: 70be08929b user: kmedcalf | |
2022-08-19
| ||
18:27 | • Reply: Will sqlite serialise queries from multiple threads? artifact: 338659eaea user: kmedcalf | |
2022-08-18
| ||
18:16 | • Reply: Different Result for Similar Queries artifact: c0b199971e user: kmedcalf | |
18:09 | • Edit reply: Different Result for Similar Queries artifact: a4a90784dc user: kmedcalf | |
18:08 | • Reply: Different Result for Similar Queries artifact: cf1e3aeef3 user: kmedcalf | |
2022-08-17
| ||
23:13 | • Reply: Delete every record except the first of the month artifact: 7e41df2ba5 user: kmedcalf | |
22:58 | • Reply: query planner not using the right index artifact: 2a0ddd95da user: kmedcalf | |
22:37 | • Edit reply: query planner not using the right index artifact: 8142471fe1 user: kmedcalf | |
22:32 | • Reply: query planner not using the right index artifact: 4750eb18e4 user: kmedcalf | |
21:16 | • Edit reply: Delete every record except the first of the month artifact: 0df0e13127 user: kmedcalf | |
21:15 | • Reply: Delete every record except the first of the month artifact: 55a79b1964 user: kmedcalf | |
21:00 | • Edit reply: Delete every record except the first of the month artifact: bea6c9c13f user: kmedcalf | |
20:47 | • Reply: Delete every record except the first of the month artifact: 81bda5ae01 user: kmedcalf | |
20:00 | • Reply: What is the most efficient way to make this query? artifact: d9420469c9 user: kmedcalf | |
16:59 | • Reply: what are the recommended storage limits per sqlite? is it possible to have 200TB in SQLite and still have good performance in artifact: 43ba094395 user: kmedcalf | |
15:33 | • Reply: Add Comment is Must artifact: 6d534931be user: kmedcalf | |
15:06 | • Reply: what are the recommended storage limits per sqlite? is it possible to have 200TB in SQLite and still have good performance in artifact: a9ceddfc71 user: kmedcalf | |
14:38 | • Edit reply: What is the most efficient way to make this query? artifact: 602bbc00c2 user: kmedcalf | |
14:37 | • Reply: What is the most efficient way to make this query? artifact: abc590fad5 user: kmedcalf | |
14:16 | • Reply: Special feature in sqlite: definite time triggers artifact: f03172f5c3 user: kmedcalf | |
2022-08-16
| ||
19:28 | • Reply: (Deleted) artifact: ca9fadacfc user: kmedcalf | |
19:16 | • Reply: calculate percentage artifact: e9eb44fb11 user: kmedcalf | |
17:30 | • Reply: calculate percentage artifact: 9d2a255bad user: kmedcalf | |
17:24 | • Reply: calculate percentage artifact: 6f4e3feec0 user: kmedcalf | |
17:13 | • Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: 24d133d9e0 user: kmedcalf | |
17:02 | • Reply: calculate percentage artifact: f3f73eb3f8 user: kmedcalf | |
16:48 | • Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: e0b4c49222 user: kmedcalf | |
2022-08-15
| ||
19:44 | • Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: a28ee51bcb user: kmedcalf | |
17:46 | • Edit reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: 4299755bbc user: kmedcalf | |
17:41 | • Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: e571ba9639 user: kmedcalf | |
2022-08-14
| ||
17:35 | • Reply: making Count() … GROUP BY faster artifact: d8fdea2f4f user: kmedcalf | |
17:26 | • Reply: First insert always takes longer artifact: f7a43db672 user: kmedcalf | |
2022-08-13
| ||
19:44 | • Reply: First insert always takes longer artifact: 80f8be976b user: kmedcalf | |
19:37 | • Edit reply: First insert always takes longer artifact: 9ba95d97db user: kmedcalf | |
19:34 | • Reply: First insert always takes longer artifact: 96fe27b2e4 user: kmedcalf | |
14:48 | • Edit reply: ODBC official in sqlite, is possible? artifact: 09a6cfe07a user: kmedcalf | |
14:46 | • Edit reply: ODBC official in sqlite, is possible? artifact: efe12d778e user: kmedcalf | |
14:45 | • Reply: ODBC official in sqlite, is possible? artifact: 0b295409ea user: kmedcalf | |
14:36 | • Reply: making Count() … GROUP BY faster artifact: 6d6590ca4b user: kmedcalf | |
2022-08-12
| ||
19:43 | • Reply: making Count() … GROUP BY faster artifact: 2c731587f5 user: kmedcalf | |
2022-08-11
| ||
18:19 | • Edit reply: How to init a database schema with many concurent accessors artifact: 040b69f8f9 user: kmedcalf | |
17:51 | • Edit reply: How to init a database schema with many concurent accessors artifact: cb463b7854 user: kmedcalf | |
17:16 | • Reply: How to init a database schema with many concurent accessors artifact: 35419af99b user: kmedcalf | |
17:15 | • Reply: How to init a database schema with many concurent accessors artifact: 801b0cdfac user: kmedcalf | |
16:55 | • Reply: How to init a database schema with many concurent accessors artifact: cd8becdc0c user: kmedcalf | |
16:30 | • Reply: How to init a database schema with many concurent accessors artifact: 5e2ebca07b user: kmedcalf | |
2022-08-10
| ||
21:00 | • Edit reply: Finding what PRAGMA options has been set artifact: 39d6cf59a2 user: kmedcalf | |
20:52 | • Reply: Finding what PRAGMA options has been set artifact: 83c0da5a4d user: kmedcalf | |
19:40 | • Edit reply: Creating hierarchical tags artifact: 81d7879e35 user: kmedcalf | |
19:39 | • Reply: Creating hierarchical tags artifact: 85d5878763 user: kmedcalf | |
19:29 | • Edit reply: Creating hierarchical tags artifact: 824c743a8a user: kmedcalf | |
18:26 | • Reply: Creating hierarchical tags artifact: f97d2f59c8 user: kmedcalf | |
2022-08-09
| ||
17:10 | • Reply: newbie Catch error when inserting duplicate in BEGIN+END block artifact: b50d05b78f user: kmedcalf | |
2022-08-08
| ||
20:23 | • Reply: Tutorial - structuring SQL with CTEs and decoupling SQL via JSON - seeking feedback artifact: ff73f52d1f user: kmedcalf | |
19:24 | • Reply: Tutorial - structuring SQL with CTEs and decoupling SQL via JSON - seeking feedback artifact: 27dff2ed04 user: kmedcalf | |
09:23 | • Reply: Week numbers in queries artifact: a1606ef3ed user: kmedcalf | |
09:13 | • Reply: Week numbers in queries artifact: a4e2d5f0be user: kmedcalf | |
01:19 | • Edit reply: GROUP BY failing to GROUP artifact: e5103f012c user: kmedcalf | |
2022-08-07
| ||
23:55 | • Reply: GROUP BY failing to GROUP artifact: a0ca375a33 user: kmedcalf | |
19:46 | • Edit reply: Week numbers in queries artifact: 9293372ee6 user: kmedcalf | |
19:41 | • Reply: Week numbers in queries artifact: d83a853c43 user: kmedcalf | |
2022-08-04
| ||
19:46 | • Reply: Question about REAL datatype artifact: 3abe1a8c76 user: kmedcalf | |
19:25 | • Edit reply: Question about REAL datatype artifact: cf8a55ba74 user: kmedcalf | |
19:24 | • Edit reply: Question about REAL datatype artifact: 3258b7f76d user: kmedcalf | |
19:20 | • Reply: Question about REAL datatype artifact: fdceaa10b4 user: kmedcalf | |
18:44 | • Reply: Question about REAL datatype artifact: feade06fc0 user: kmedcalf | |
18:17 | • Edit reply: Question about REAL datatype artifact: 87b4057fb1 user: kmedcalf | |
18:14 | • Reply: Question about REAL datatype artifact: 297a688f2a user: kmedcalf | |
16:32 | • Reply: Publish/subscribe queue artifact: f73b4cab2b user: kmedcalf | |
2022-08-03
| ||
22:51 | • Edit: strftime('%i') ISO Calendar Format artifact: cc309a097e user: kmedcalf | |
22:45 | • Edit: strftime('%i') ISO Calendar Format artifact: 9692c94d07 user: kmedcalf | |
22:37 | • Post: strftime('%i') ISO Calendar Format artifact: 8ff10d0b74 user: kmedcalf | |
2022-08-02
| ||
01:42 | • Reply: Connect with using Multi-threaded Mode in dotnet artifact: 4350224359 user: kmedcalf | |
2022-08-01
| ||
20:14 | • Reply: Connect with using Multi-threaded Mode in dotnet artifact: ce49e4e41d user: kmedcalf | |
20:02 | • Edit reply: SELECT * FROM my_table not showing the headers artifact: 6d46a7c9f9 user: kmedcalf | |
20:01 | • Edit reply: SELECT * FROM my_table not showing the headers artifact: 03473a2770 user: kmedcalf | |
19:56 | • Reply: SELECT * FROM my_table not showing the headers artifact: b151fe74f1 user: kmedcalf | |
18:04 | • Reply: UPSERT ON CONFLICT enhancement artifact: 60e2007b2d user: kmedcalf | |
16:08 | • Reply: SELECT * FROM my_table not showing the headers artifact: 76cb8558ed user: kmedcalf | |