@leafac/sqlite: The best way to use SQLite in Node.js

Опубликовано: 29 Октябрь 2024
на канале: Leandro Facchinetti
5,393
83

Support:
  / leafac  
https://paypal.me/LeandroFacchinetti

———

Example code: https://gist.github.com/leafac/2f3f57...

My packages:
https://github.com/leafac/sqlite
https://github.com/leafac/sqlite-migr...

More of my packages that are related:
https://github.com/leafac/html
https://github.com/leafac/caxa

Visual Studio Code extensions that I recommend using with this package:
https://marketplace.visualstudio.com/...
https://marketplace.visualstudio.com/...

Example application using @leafac/sqlite:
https://kill-the-newsletter.com

Learn more:
https://github.com/JoshuaWise/better-...
https://sqlite.org/
https://sqlite.org/pragma.html#pragma...
https://github.com/mapbox/node-sqlite3

———

Code review:    • Code Review: @leafac/sqlite: The best...  

———

00:00 - Introduction
00:21 - Why SQLite is a great database
02:42 - Existing Node.js packages for SQLite
04:54 - Introducing @leafac/sqlite
05:43 - Demonstration
23:25 - Migrations with PRAGMA user_version
35:45 - Brief mention of @leafac/sqlite-migration
36:32 - Thoughts on migration systems
39:01 - Conclusion