/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
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".
| | 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.
| | git-history-demos.datasette.io
pge-outages
2.8 parsecs away

Travel
| |
| | chava61photography.photo.blog
Pull Up a Seat Photo Challenge 2019: #47 - This and That: The Continuation
21.5 parsecs away

Travel
| Visit the post for more.