PDPriyansh Dimriinpriyanshdimri.hashnode.dev·3h ago · 5 min readWhy GistDB Stores Data SidewaysA dashboard query and a login lookup are not the same problem. One reads a single row by primary key, as fast as possible. The other scans a million rows, but only touches two columns out of twenty. M00
AUAkhilesh Upadhyayinakhileshu.hashnode.dev·1d ago · 16 min readFrom SQL Table to Disk Bytes and Back — A Two-Row WalkthroughThis walkthrough shows how a SQL table moves through several representations: human-readable table → SQL statement → Go values → encoded bytes → disk page → decoded Go values → terminal output The go00
ASAlina Sinalinatech.hashnode.dev·3d ago · 5 min readUnderstanding Database Normalization: Why Good Database Design MattersOver the past few months, I've been spending a lot of time learning backend development. While building APIs, writing SQL queries, and designing databases, I realized that a good application starts wi00
SGSergio González Téllezinevankhandev.hashnode.dev·2d ago · 2 min readWhy do many people learn databases as collections of tables, yet struggle to understand the systems those databases represent?SEED-010 PROBLEM Why do many people learn databases as collections of tables, yet struggle to understand the systems those databases represent? INSIGHT A database is not a place where tables are sto00
JAJuan Andrés Lópezinmetadriven.hashnode.dev·4d ago · 12 min readSQL Assertions in Oracle Database 26ai: A Different Way to Enforce Data IntegrityIntroduction After many years working with Oracle Database, I still run into features that make me wonder how I missed them. That happened recently with SQL Assertions. While reviewing some of the new00
AKAnimesh Kumarinanimeshk.hashnode.dev·4d ago · 5 min readMy Software Engineer Interview Experience at Visa (2026)Recently, I had the opportunity to interview for a Software Engineer role at Visa, which ultimately led to an offer and I'm excited to share my experience with the hope that it helps others preparing 10
VCVivian Chiamaka Okoseinvivianokose.hashnode.dev·3d ago · 5 min readI Deleted My Database on Purpose. It Was Back in 47 Seconds.There's a sentence I can't stop thinking about: A backup you have never restored is a wish, not a backup. Most engineers set up backups and never test them. The backup job runs every night, everyone f00
URUTKARSH RANJANindevwithutkarsh.hashnode.dev·5d ago · 9 min readOracle APEX Performance Tuning - 10 Things That Actually Help✍️ Utkarsh Ranjan · Oracle APEX Certified Pro (1Z0-771) · ⏱ 10 min read · Intermediate → Advanced Every APEX developer eventually hits the same wall - the app works perfectly in development, but slow00
SGSergio González Téllezinevankhandev.hashnode.dev·4d ago · 2 min readWhy can someone use SQL for years and still never truly understand databases?SEED-009 PROBLEM Why can someone use SQL for years and still never truly understand databases? INSIGHT SQL queries can be learned relatively quickly; the real value for Operations, Infrastructure, a00
PMPRAVIN Minpravinm.hashnode.dev·6d ago · 6 min readSQL ORDER BY Explained: Make Your Query Results MeaningfulImagine you search for a product on an e-commerce website. Would you want the products to appear in a random order? Probably not. You'd expect to sort them by: Price: Low to High Price: High to Low 00
