Up and Running with SQLite3 in a NodeJS API

Рет қаралды 5,323

Күн бұрын

Пікірлер: 27

@davidchallik2551 Ай бұрын

Steve Griffith is always conveying the whole picture by breaking everything down in little steps. Excellent educator and a pleasant communicator. Thank you, Steve. I just learned the essence of what I needed to know. 😊

@tomyk9233 3 ай бұрын

this is the singly most helpful video on this topic. no other tutorial was ever this beginner friendly

@LoayAl-Said-j8p 2 ай бұрын

Thank you professor. I admire your style of teaching actually.. Your stepByStep, kinda way.. where you start from an overview then you go kinda layer by layer deep.. I like that systemic way.. Thanks for your efforts. Loay here from Egypt. Appreciate your efforts.

@paulathevalley 15 күн бұрын

Thank you for this! When I saw ESM imports, I knew this tutorial is what I wanted. I would love a deeper dive into error handling, either specific to this project or more generally. When do you use try/catch? Where (what file) do you handle errors? What standards or best practices exist for displaying error messages, statuses, etc? How/Where do you collect error logs for viewing later? etc. (apologies if you have this video elsewhere already)

@mtcindianutube 7 ай бұрын

Thanks Steve, iam first time watching a video on Sqlite. Awesome ❤❤

@RafaelSales55 7 ай бұрын

thank you a lot, just in time when I was needing to learn about databases

@joelomoglio6450 2 ай бұрын

Love the video, hands down the best one I have found, You do an excelent job of expaling things. Only wish you had covered PUT, im having a hard time creating based on how you did the others. But great job!!!

@averstrum6372 7 ай бұрын

Edit: in 2019-april-2 in [email protected] the body-parser middleware is included in express, so you don't need to install body-parser separately anymore

@eumm11 11 күн бұрын

thank you so much, so well explained, exactly what i was looking for!

@Dev-n8c4c 6 күн бұрын

This was a great code walk-through. I discovered better-sqlite3 seems to be NPM package to use, it claim to be more efficent.

@paulolawale5104 3 ай бұрын

very concise. Thank you Steve

@tmoumimahmoud6966 6 ай бұрын

Thank you, but I have one question when to use sqlLite instead of mysql or postgress and when I should'nt ,I know that all are relational database for sqllite it store in file and the other should i install DBMS ?

@SteveGriffith-Prof3ssorSt3v3 6 ай бұрын

There is no simple answer to that, just as there is no simple answer to should I write my server-side code with Nodejs, Python, or C#. You could look at it as a matter of scale. SQLite is a LITE db. meant for small projects. Don't use it when you want to have a second server to handle your dB. Don't use it when you have millions of records. Don't use it when you have someone on your dev team with ten years experience with MySQL. Where are you hosting? What is the cost of that db hosting? What ORM are you using? What ORM does your team have experience with? ... and a hundred other small factors.

@atlantic_love 7 ай бұрын

I really need help. What I am wanting to do is make a small web app that does very little. My husband has high blood pressure, and I would like to make something that allows him to input his BP readings and save them, and to be able to look at graphs showing things like his BP average for the week. I know a little JavaScript, HTML and CSS. Is there possibly a way to do something like this from within a single folder? I'd like to copy the app over to his computer.

@SteveGriffith-Prof3ssorSt3v3 7 ай бұрын

Building something like that is not too hard. An experienced developer could put it together in a day or two. Data can be saved locally (on your computer) using LocalStorage, IndexedDB, Cache API, or even cookies. The hard part is meeting the security restrictions for the browser. The pages have to be opened through a web server and localhost or some real url. You said you wanted it local so it has to be through localhost. It can't be done just opening a file in the browser like C:/Users/Files/mypage.html, the url has to start with With the storage options I listed before, you are still at the mercy of the browser deciding when it wants to delete the data. If loading the web page via localhost then you can actually save a file locally on the computer via JavaScript and then open it again via JavaScript. If you install Node.js on your computer and your husband's computer then you can easily build the website along with a Node.js module that creates the web server to load your HTML over http. It's a lot of moving parts but none are really that difficult on their own. Here is a tutorial about handling files from web pages. - kzbin.info/www/bejne/sKKVqXdjrdp8fZY

@atlantic_love 7 ай бұрын

@@SteveGriffith-Prof3ssorSt3v3 Thanks for the great post! Lots to think about! The Node.js thing was why I was wanting to do something "local".

@SteveGriffith-Prof3ssorSt3v3 7 ай бұрын

@atlantic_love node running on your computer or your husband's is still local. Just an extra step to set up.

@LoayAl-Said-j8p 2 ай бұрын

I would love to help with that.. and if you have done it already.. I can help you hosting it so you can easily access it everywhare.. and with free services BTW.. or of course if you need any inhancements. I would be happy to contribute. Loay from Egypt here..

@andredearaujorodrigues7725 7 ай бұрын

Tutorial too good! Amazing

@gurbanoglu5143 Ай бұрын

Thanks Professor. Could you please make a video covering PUT and PATCH requests with SQLite3 in a NodeJS API?

@SteveGriffith-Prof3ssorSt3v3 Ай бұрын

In NodeJS you can handle any HTTP Request Methods the same way - kzbin.info/www/bejne/i36uhGmpqp17h8U or you can use Express JS to handle the requests - kzbin.info/www/bejne/rWGVioWcpb6hiZI (part of a playlist for Express) The methods GET, POST, PUT, PATCH, etc are largely just a label in the header indicating to your server side code, what the browser would like you to do with any uploaded parameters. PUT and PATCH are just different versions of an UPDATE command. The first means replace everything with the new provided data. The second means only update the values for the provided parameters. So, you build your SQL UPDATE command with that in mind.

@sjshdhehbesjks 6 ай бұрын

thanks a lot , i was thinking of sqlite a week ago also can you make tutorial of sqlite using orm like drizzle or prisma

@SteveGriffith-Prof3ssorSt3v3 6 ай бұрын

I have Drizzle on my todo list. I will probably be using MySQL instead of SQLite in the tutorial with Drizzle though because of lack of full Schema support for SQLite in Drizzle currently.