Introduction
- 7 Database Paradigms • Fireship 📺
- Database Fundamentals • Tony Solomonik
General
- TablePlus • A macOS GUI for interacting with databases 🛠️
- Queries: can test, view full history, and save favourites
- TablePlus Docs • TablePlus 📚
- I love my database GUI • A great tour of TablePlus and DBngin • PlanetScale 📺
- DBngin | All-in-One Database Version Management Tool • A macOS GUI for running databases locally (if Docker / terminal usage ain’t your thing) 🛠️
FaunaDB
- 📺 FaunaDB Basics - The Database of your Dreams • 17 minute video by Fireship
- 📺 NEXTJS + FAUNA CRASH COURSE - Learn the basics in under 1 hour • 49 minute video by James Perkins showing how to create a FaunaDB database and interact with it using Next.js api routes
Firebase
- 📺 I built a chat app in 7 minutes with React & Firebase • 9 minute video by Fireship
- 📺 Firebase Security in 100 Seconds • 2 minute video by Fireship
- 📺 How to use Firebase’s Realtime Database in React • 48 minute video by Leigh Halliday showing how to use the Firebase Realtime Database as the backend for a Next.js tic-tac-toe app
ORMs
- Drizzle ORM in 100 Seconds • Fireship 📺
- Prisma - The Easiest Way to Work with a Database in Next.js • How to set up an sqlite database in a Next.js project. See the docs for how to use a newer version of Prisma Migrate than the one shown in the video • Prisma 📺
Supabase
- 📖 Supabase • The Open Source Alternative to Firebase
- 🎙️ JAMstack Radio: Ep., Open Source Firebase Alternative • Podcast episode in which Paul Copplestone of Supabase explains why he created Supabase
Performance
- Update your database statistics often or your SQL queries will suffer • Hussein Nasser 📺
Vector Databases
- Vector databases are so hot right now. WTF are they? • Brief intro to vectors, embeddins, distances and some of the popular databases that support this data type • Fireship 📺
Indexes
- Database Indexes & Phone Books • Thorsten Ball 📖
Inbox
- Neon
- tursodatabase/libsql: libSQL is a fork of SQLite that is both Open Source, and Open Contributions. - libSQL is an open source fork of SQLite that supports remote access - Turso
- libSQL - Turso - LibSQL docs
- dbdiagram.io - Database Relationship Diagrams Design Tool - Tool for drawing entity-relationship diagrams (ERDs); what tables are needed and how do they connect?
- GitHub - danvergara/dblab at terminaltrove • TUI for inspecting databases • Dan Vergara 🛠️
- TimescaleDB in 100 Seconds • Fireship 📺
- DuckDB: Crunching Data Anywhere, From Laptops to Servers • Gabor Szarnyas • GOTO 2024
- A Fun & Absurd Introduction to Vector Databases • Alexander Chatzizacharias • GOTO 2024