Mirror a remote Postgresql table (dblink + materialized view)
It is very useful to have a copy of a production table in a local server.
Bounding Box Filtered Grafana Panels (with Postgis)
Today at work I had to create some dynamic panels in Grafana for a project involving some geometry data in Postgresql (Postgis). Most of the data are polygons, with some meta data related to them.