/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

 git-history-demos.datasette.io
pge-outages
| | simonwillison.net
Archive for Monday, 25th March 2024
2.8 parsecs away

Travel
| |
| | til.simonwillison.net
SQLite aggregate filter clauses | Simon Willison's TILs
4.9 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
KNN queries with SpatiaLite | Simon Willison's TILs
3.5 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".
| | devremote.io
Setup Local Postgres Database Using Docker
32.5 parsecs away

Travel
| PostgreSQL is a powerful, open-source object-relational database management system (ORDBMS) widely used for web, mobile, geospatial, and analytics applications. It is known for its robust features, including support for complex queries, foreign keys, and triggers, and its ability to handle large volumes of data. Docker is a containerization platform that