Better living through database normalization
Note: This is a republication of a post that I wrote almost 10 years ago, over on my other blog. I...
SQL
The query language shared by every relational engine listed under Databases. Its entries are the parts that decide whether a schema holds up: how it is shaped, how fast it answers, and whether the data in it can be trusted.
More than 20 years writing SQL for relational databases and building reliable data-backed applications. I have written it at every job I have had: UW-Milwaukee, Kohler, Starkmedia, Quality Matters, and Bader Rutter.
Explore SQL
From the blog
Related writing
Articles from JWS News and DEV that relate to SQL.
What is good SQL?
Lately, I have been working with a lot of legacy SQL and this has caused me to think about what makes SQL (and database designs) good and bad. There is a concept called ACID, defined within ISO/IEC 10026-1:1992. ACID is an acronym, that stands for Atomicity, Consistency, Isolati…
From GoToSocial
Related thoughts
Short posts about SQL, matched by topic hashtags.