How I Learned to Stop Worrying and Love NULL in SQL
You should not try to prevent NULL values - instead, write your query in a way to overcome its limitations.
4 hours ago
SQL
Featured
SQL
Anatomy of a PostgreSQL Query Plan
The first thing to look at to start optimizing a query is the Query Planner. In this post we will explain how a query gets executed and how to understand the EXPLAIN command.
By
Kevin Zhang
Reimagining the SQL Curriculum: Change How SQL is Taught
SQL has transformed itself from a specialized skill to a core requirement for all data related jobs. What can be done to educate even more professionals in this basic proficiency? We’ll need to rethink how querying is perceived by and taught to the public.
22 days ago
Featured
SQL
Decoding Django Sessions in PostgreSQL
When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.
a month ago
6 Common Mistakes for SQL Queries that "Should be Working"
We've all seen the dreaded error... SQL: Invalid syntax near ")". In this article, I cover some of common culprits I've seen for this error and others.
2 months ago
A Complete Guide to UUIDs in PostgreSQL
Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.
3 months ago
What Can We Learn From SQL’s 50 Year Reign? A Story of 2 Turing Awards
The relational data model was introduced in 1970 and has dominated for 50 years. What led to its success? Building on first principles and Bushnell's law.
3 months ago
Trigger Warning! Setting up Database Tracking with Triggers in Postgres
SQL triggers are less common but can be a great solution for certain situations. I'll provide examples for how to use triggers to enforce data integrity and track changes to a database.
3 months ago
Featured
Arctype
5 Hacks to Improve Your SQL Productivity with Arctype
Learn how Arctype Slash Commands, Query History, and more can improve your SQL productivity.
By
Derek Xiao