Making Relational Cool Again (or: JavaScript on ACID)

on YouTube ↗27m

" summary

Argues that Node can and should run traditional SQL by showing two libraries actually built: Knex (query builder handling connection pooling, dialect quirks, migrations and raw SQL, even Oracle) and Bookshelf (ORM on top of Knex with one‑to‑many/many‑to‑many and eager loading). Demonstrates promise‑based transaction handling that commits or rollbacks the whole chain, transparent nested transactions that create save points, and a working webSQL Todo example—Bookshelf still requires explicit transaction passing in some cases.

AI-written summary · about

" chapters (7)

1. 0:00Start
2. 0:28sequel
3. 12:56Atomicity Consistency Isolation Durability
4. 17:11SAVEPOINT ROLLBACK TO
5. 25:00Reinvent the wheel
6. 25:39other languages
7. 26:14Node: a target for traditional CRUD web applications

" related talks

• 02h 42mSQL (The Return): Demystifying Preconceptions and Using the DB EffectivelyFranck Pachot · Devoxx France 2023
• 35mNoSQL, No Server, No problem: Using ORM's in Javascript ApplicationsJason Maggard · RVA JavaScript Conf 2019
• 45mNoSQL: Death to Relational DatabasesBen Scofield · RubyConf 2009
• 18mFrom SQL to NOSQL - a gentle intro for DevsJoe Karlsson · Conf42 JavaScript 2020
• 23mI Would Never Use an ORMMatteo Collina · JSNation 2023
• 25mI Would Never Use an ORMMatteo Collina · JetBrains JavaScript Day 2022
• 41mModern SQL: Evolution of a dinosaurMarkus Winand · WebCamp Zagreb 2018
• 41mDo you really need that relational DB?Donatas Aleksandravičius · Dutch PHP Conference 2019