Lock it, Block it, but Don't Deadlock it
Learn how deadlocks may be impacting your database performance, and how you can resolve them
a year ago
Articles
Time to Add Databases to your Spring Cleaning - VACUUMs in Postgres
Deleted records from your database could still be taking up space on your disk. Learn how to use VACUUM to reduce size and improve performance of your databases.
a year ago
Create a Web App and Deploy it to the Cloud in 20 minutes with Python
Learn how to create a web app using Flask, connect to a Postgres database, and deploy the app and database to Heroku.
a year ago
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL
Create a database schema for any situation with the power of JSON.
By
Derek Xiao
Slow Queries? 10X Query Performance with a Database Index
Database indexes are a common solution for faster queries, but they also add overhead that can degrade performance. Keep reading to learn how to create the optimal database index.
a year ago
How Divided Are We? Top 20 Words in Biden's vs Trump's Inauguration Speeches
50% of the top 10 words in Biden's inaugural speech were the same as Trump's top 10 words. Analyze both inaugural speeches with Python to find all the similarities and differences.
By
Derek Xiao
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.
a year 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.
a year 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.
a year ago
