Database

I was wrong about databases

The best part about writing is that you get to learn new and exciting ways you were wrong. Databases are smarter than I thought!

*Why* the relational data model is so good

You've heard that array or list columns in a database are bad. But why? Yesterday it clicked for me

Why SQL is Forever followup

Yes SQL is super flexible. That is its strenght and its weakness

Why SQL is Forever

Never underestimate the power of good marketing for bad products. NoSQL was fun but SQL is here to stay.

How I Added a Related Articles Feature on Swizec.com Using GPT-4 Embeddings

Making 15 years of blog archives easier to navigate with AI and cosine similarity to build a related articles featur

Similarity search with pgvector and Supabase

Explore the power of pgvector and Supabase for efficient similarity search in this comprehensive guide. Keep vector data next to your business data for efficient queries and less overhead.

How better data modeling fixes your code

When your code feels hard, 9 times out of 10, the problem is with your data model. The signs are subtle.

Notes on A Relational Model of Data for Large Shared Data Banks

In 1970 a paper came out that changed the world of business computing. It laid the ground work for modern databases.

Lesson learned, test your migrations on the big dataset

The trials and tribulations of a large-ish dataset

Amdahl's law in action - 27s to 0.03s by changing a function

Heroku, mongo, node.js - a problem

Benchmarking node, tornado and django for concurrency

Django protip #2: Forms are awesome