Databases

For most of its life, SQLite was thought of as "the little database" — great for phones and desktop apps, not something you'd run a real web backend on. That…

Joins are where SQL stops being a fancy spreadsheet query and starts being a real tool for working with related data. They are also where a lot of developers quietly…

Database indexing is essential for scaling backend applications and preventing performance bottlenecks. This guide explores how indexes function, the trade-offs of write overhead, and the importance of column order in composite indexes. Learn to use EXPLAIN to diagnose slow queries and transform sluggish performance into sub-millisecond results by indexing the columns you search, join, and sort.