Every article tagged Databases, in one place.
Showing 4 articles
PostgreSQL has become the go-to database for startups and enterprises alike. It's open source, reliable, and handles workloads that once needed several different databases. What developers love Rich SQL : CTEs, window functions, UPSERT , RETURNING , lateral jo...
MongoDB stores data as JSON-like documents in collections . If you know SQL, most concepts map directly; the big shift is designing around how data is read rather than normalising everything. Vocabulary Table → collection . Row → document (stored as BSON, whic...
Both are mature, fast, open-source relational databases that run some of the biggest sites in the world. For most applications either will work; the differences show up at the edges. Where PostgreSQL leads Richer SQL and types : arrays, ranges, JSONB with powe...
"The database is the bottleneck. How do you scale it?" Walk through the options from cheapest to most complex. 1. Optimise and scale up Indexes, query fixes, connection pooling and caching first. Then a bigger machine (vertical scaling). Modern servers are pow...
