Links tagged “postgres”

malisper.me

Postgres was designed when the disk was the bottleneck.

brandur.org

clone a template database per test for fast, isolated Postgres tests.

nikolays.github.io

PGSimCity: How PostgreSQL Works - the database rendered as a city you can walk through. Best Postgres explainer in years, and it only works on the site.

dbos.dev

Postgres as a backend for async tasks.

dataqueue.dev

dataqueue: a lightweight, PostgreSQL-backed job queue

pgdash.io

Tour of ten under-used PostgreSQL features, from LISTEN/NOTIFY and foreign data wrappers to range types, BRIN indexes and full-text search.

pgcli.com

Command-line client for Postgres with autocompletion and syntax highlighting.

geoalchemy-2.readthedocs.io

Documentation for GeoAlchemy 2, SQLAlchemy extensions for working with spatial databases, with primary support for PostGIS.

blog.patricktriest.com

Tutorial building a geospatial API for an interactive Game of Thrones map, with Node.js, PostgreSQL/PostGIS and Redis caching.

github.com

A PostgreSQL client library for Python/asyncio, built for fast asynchronous database access.

txpostgres.readthedocs.io

Documentation for txpostgres, an asynchronous PostgreSQL driver for Python built on Twisted.