SQLite Forum

Timeline
Login

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