Wednesday, 3rd February 2021
Cleaning Up Your Postgres Database (via) Craig Kerstiens provides some invaluable tips on running an initial check of the health of a PostgreSQL database, by using queries against the pg_statio_user_indexes table to find the memory cache hit ratio and the pg_stat_user_tables table to see what percentage of queries to your tables are using an index.
Release
datasette-tiles 0.4
— Mapping tile server for Datasette, serving tiles from MBTiles packages
TIL
Serving MBTiles with datasette-media
— The [MBTiles](https://github.com/mapbox/mbtiles-spec) format uses SQLite to bundle map tiles for use with libraries such as Leaflet.