Links tagged “database”
47 links, newest first.
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.
jvns.ca
Learning a few things about running SQLite - Julia Evans on SQLite in operation: litestream, locks, backups, the parts the tutorials skip.
dbos.dev
Postgres as a backend for async tasks.
markusholtermann.eu
Less Obvious Things To Do With Django’s ORM Django’s ORM is powerful.
djangostars.com
Django development of products is usually easy and straightforward: great documentation, many tools out of the box, plenty of open source libraries and big community.
medium.com
Giving your users the ability to delete objects from your database is a risky proposition — some types of objects are low risk, but others, no matter how much you warn them of the risks of deleting things, will lead to customer requests.
edgedb.com
EdgeQL is the query language of EdgeDB.
cybertec-postgresql.com
A couple of weeks ago I have seen a horribly designed, 370 billion (with a “b”) row Oracle database monster running some sort of aggregations.
beyondthelines.net
Cassandra and DynamoDB both origin from the same paper: Dynamo: Amazon’s Highly Available Key-value store.
redis.io
This page provides a technical description of Redis persistence, it is a suggested read for all the Redis users.
geoalchemy-2.readthedocs.io
GeoAlchemy 2 Documentation Using SQLAlchemy with Spatial Databases.
knexjs.org
Installation Knex can be used as an SQL query builder in both Node.JS and the browser, limited to WebSQL's constraints (like the inability to drop tables or read schemas).
druid.io
Interactive Queries Issue sub-second ad-hoc queries to group, filter, and aggregate data.
