Links tagged “database”
49 links, newest first.
malisper.me
Postgres was designed when the disk was the bottleneck.
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.
djangostars.com
How to run complex analytical queries with SQLAlchemy Core alongside Django's ORM in the same project, covering engine setup, debugging and multi-database testing.
jvns.ca
Why a SELECT query is evaluated as FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT rather than in written order, and what that explains about SQL's rules.
edgedb.com
Home page of EdgeDB, a graph-relational database built on PostgreSQL with its own query language EdgeQL; the project is now called Gel.
cybertec-postgresql.com
Why aggregating first and joining the lookup table afterwards beats joining five million rows then grouping, with the execution plans that explain the gap.
beyondthelines.net
A point-by-point comparison of two databases descended from the Dynamo paper, covering keys, schema, indexes, consistency and replication strategy.
oldblog.antirez.com
What Redis durability really guarantees — the path from client to disk, RDB snapshotting versus the append-only file, and what each fsync policy survives.
geoalchemy-2.readthedocs.io
Documentation for GeoAlchemy 2, SQLAlchemy extensions for working with spatial databases, with primary support for PostGIS.
metabase.com
Open-source business intelligence tool that lets people query databases, build dashboards and explore data through a visual query builder rather than SQL.
knexjs.org
Knex.js, a SQL query builder for Node.js and the browser, supporting PostgreSQL, MySQL, SQLite and Oracle with callback, promise and stream interfaces.
