OpenTube

SQLite3 in Node with better-sqlite3

Caleb Curry

21,272 views

💰 FREE Software Dev Intro Course - https://calcur.tech/free-dev-course
💯 FREE Courses (100+ hours) - https://calcur.tech/free-courses
Timestamps:
00:00:00 - Introduction
00:02:20 - Creating a Table
00:04:42 - Inserting Data
00:08:28. -Retrieving all the Data
00:09:04 - Retrieving a Single User
00:10:26 - Creating a Basic API

🏆 C++ Mastery Course - https://cppmastery.com
⚛️ FREE React Course (20 hours) - https://calcur.tech/free-react-course
✅ Data Structures & Algorithms - https://calcur.tech/dsa-youtube

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

✉️ Newsletter - https://calcur.tech/newsletter
📸 Instagram - Instagram: CalebCurry
🐦 Twitter - Twitter: calebCurry
🔗 LinkedIn - LinkedIn: calebcurry
▶️ Subscribe - http://calcur.tech/subscribe
👨🏻‍🎓 Courses - https://www.codebreakthrough.com

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

↪ My Amazon Store - https://www.amazon.com/shop/calebcurry
🅿 Patreon - http://calcur.tech/patreon-calebcurry
🅖 GitHub Sponsors - https://github.com/sponsors/CalebCurry
Ⓟ Paypal - http://paypal.me/calcur

15 Comments

@codebreakthrough Creator 2 years ago Pinned

@joshdoomwrestling 2 years ago

your database design videos from 9 years ago single-handedly got me to pass my class

cheers from the past

@wassimyazbekk 2 years ago (edited)

you are a life saver bro i am working on a project with better-sqlite3 and it is driving me crazy. Imagine i am returning a promise from a synchronous function and using async await to call it just because it's what i am used to :| waiting for the advanced tutorial.

@hikemalliday6007 2 years ago

Man im doing a backend in node because im making an electron project (i normally make python backends) and its been nothing but a nightmare trying to build with sqlite3. This sync bettersqlite 3 really solved my problems, nice vid. In order for me to build with async sqlite3, it would basically require me to deepdive into the tech, which I dont have the time to do right now. Thanks!

@wemusthavechannelstocommen619 10 months ago

simple and just works.

@John-wx3zn 2 years ago

Thank you. You are a very good teacher.

@sridharguzzu 2 years ago

you are a very good Orator..

@m4heshd 1 year ago

Hi, I'm the author of better-sqlite3-multiple-ciphers . Make sure to check that out too if anyone's looking for encryption support. 😊

@petrsonTD 2 years ago

thanks

@JoshuaWise1994 2 years ago

I'm on the YouTubes!

@MiSt3300 1 year ago

Nice tutorial, but it would also be nice if you included info on how to structure the files and create routes for express for instance users, and db models for sqlite

@LoayAl-Said-j8p 1 year ago

You can do CTRL + ~ to go to the terminal.. also CTRL + J to toggle the pane.

also.. to create a new termial... CTRL + SHIFT + ~ and to create a new one in the same pane.. like, split it .. CTRL + SHIFT + 5 (at least on my machine.. it's WLS with windowls)