MDMirna De Jesus Camberoincodelikeawoman.com·9h ago · 4 min readWhat Is a Backfill? Understanding a Common Data Evolution PatternThe first time I was asked to build a backfill for a production system, I remember thinking: This sounds important... and a little scary. It sounded like one of those engineering terms that everyone00
MAMd Ashikun Nabiinblogs.ashikunnabi.com·10h ago · 5 min readDatabase Indexes Aren't Just About Which Columns You Index. They're Also About the OrderBut here's something many developers overlook: INDEX(name, age) is NOT the same as INDEX(age, name) They contain the same columns. Yet one might make your query run in milliseconds, while the other 00
Aasmgitinasmgit.hashnode.dev·19h ago · 20 min readJOIN Like an ORM: Foreign-Key Relations in PostgreSQLA PostgreSQL query that navigates relations: SELECT item.name item_name, client.name client_name, manager.name manager_name, document_item.quantity FROM document_item , document(document_item) , item(00
RRihabinrab-engineering-notes.hashnode.dev·16h ago · 6 min readA Curious Case of Database VersioningI recently came across a deployment issue that changed how I think about database versioning. At first, it looked like a fairly ordinary deployment failure. A few database objects refused to compile a00
SDSynfinity Dynamics Pvt Ltdinsynfinitydynamics.hashnode.dev·1d ago · 9 min readMongoDB vs SQL: Which Database Should You Choose? Choosing a database is one of the most consequential decisions you'll make on a project. It shapes how you model data, write queries, scale your system, and maintain consistency and getting it wrong d10
DIDatabase Insightsindatabaseinsights.hashnode.dev·2d ago · 7 min readAutomating the Mundane: 5 Database Tasks Every Growing IT Team Should Stop Doing ManuallyAsk most DBAs what they should be spending their time on, and you'll hear architecture, query tuning, capacity planning, and performance optimization. Now check their backlog: it’s full of schema comp00
KTKushagra Trivediinkushagrablogs.hashnode.dev·2d ago · 14 min readModern Database Access: Prisma, Drizzle, and ORMs ExplainedWhere does application data live after a user closes the app? This is the first question worth asking before writing a single line of database code. When you open Instagram, your posts are still there00
SHSanskriti Harmukhinvultr.hashnode.dev·2d ago · 4 min readDeploying Metabase on KubernetesMetabase is an open-source BI tool for building charts and dashboards over MySQL, PostgreSQL, MongoDB, Redshift, and more. This guide deploys Metabase on Kubernetes, loads the Sakila sample dataset in00
SHSanskriti Harmukhinvultr.hashnode.dev·2d ago · 7 min readDeploying a PostgreSQL Cluster with Patroni and HAProxy on Ubuntu 24.04A Patroni cluster needs an odd number of nodes to maintain quorum, with 3 nodes, losing 1 still leaves a majority, so the cluster keeps running. This guide builds a 3-node PostgreSQL cluster on Ubuntu00
SSSubham Sahainsubham59036.hashnode.dev·2d ago · 16 min readComplete Production Grade Database Setup for Spring Services — A Comprehensive GuideIntroduction The database is the most critical stateful component in any Spring-based application. Misconfiguration, poor connection handling, missing indexes, or inadequate migration strategies cause00
