/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 simonwillison.net
Archive for Monday, 25th March 2024
| | til.simonwillison.net
SQLite aggregate filter clauses | Simon Willison's TILs
2.2 parsecs away

Travel
| | SQLite supports aggregate filter clauses (as of 3.30.0, released 2019-10-04 ), as described in this SQL Pivot in all databases tutorial.
| | til.simonwillison.net
Calculating the size of a SQLite database file using SQL | Simon Willison's TILs
2.1 parsecs away

Travel
| | I learned this trick today while browsing the code of Blacklite , a neat Java library for writing diagnostic logs to a SQLite database.
| | til.simonwillison.net
KNN queries with SpatiaLite | Simon Willison's TILs
2.1 parsecs away

Travel
| | The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this point".
| | nick.zoic.org
MySQL: Foreign Keys between InnoDB and MyISAM ยท ... and another thing ...
32.9 parsecs away

Travel
| [AI summary] The post explains the error caused by defining foreign keys between InnoDB and MyISAM tables in MySQL and MariaDB, offering a solution to migrate legacy tables to InnoDB.