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

Support:

———

My packages:

More of my packages that are related:

Visual Studio Code extensions that I recommend using with this package:

Example application using @leafac/sqlite:

Learn more:

———

———

00:00 - Introduction
00:21 - Why SQLite is a great database
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

[chenyoma]

Thank you, I enjoyed using this package

[Froggie]

SUBBED! i have been looking for this all week!
the exact things you mentioned ive been scratching my head on, trying this out now.
-
i see you included the migration functionality into the base; gl

[laikesagores]

Thanks Leandro, yes, SQLite is a loving database and has a long story, since 2000 as I remember. It's serverless and your video makes me think to transform into client-server database.

[PerezJuan]

Great video Sir may ask you something? Could I use this with ElectronJS projects?? Thank you for sharing Leandro!

[robinpotter]

How can I get the last inserted row id?

[Ztifflarn]

Dunno if you can help me but i get problem with my typescript. Error [ERR_REQUIRE_ESM]: require() of ES Module. Can you help me out?

[Thehighschoolscientistforever]

Hey I need some guidance on my next project.
I am planning to make a desktop app using electron to manage inventory & track orders so I need this desktop app to have a local database but I don't want other people to install any kind of external database software it should be like packaged within the app itself, and also this desktop app should be connected with some kind of online database (more on this later). And I also have made an android app to manage the end customer and provide them with regular updates and also collect data from them. Till now I have been using Google sheets and a web app to manage everything but this has recently become really problematic (many many issues) So I need to deploy my own database (local server or online server basically anywhere possible) and this has to be connected with my the electron app and the android app
.
.
So basically 3 things
=> a desktop app with a embedded database & also linked to a online database
=> A android app which is connected to the online database
=> and the database itself Which manages all the data from the android app user and the desktop app user
.
.
I have created the android app & also making the electron app seems doable BUT the embedded database & server database part seems really confusing and I have no clue what to do or where to start (the reason I picked electron for the desktop app is because I am really familiar with Javascript, HTML & CSS)
.
So I need some guidance (maybe alot) to make this happen

[Joe-wvgl]

This is amazing! unfortunately It's raising import on my platform :/

[eljay]

This is a low-quality wrapper around better-sqlite3 that removes nearly all of the functionality.