Up and Running with SQLite3 in a NodeJS API

Рет қаралды 3,838

Күн бұрын

Пікірлер: 23

@LoayAl-Said-j8p 6 күн бұрын

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.

@tomyk9233 Ай бұрын

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

@paulolawale5104 Ай бұрын

very concise. Thank you Steve

@mtcindianutube 5 ай бұрын

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

@joelomoglio6450 14 күн бұрын

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!!!

@RafaelSales55 5 ай бұрын

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

@averstrum6372 5 ай бұрын

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

@andredearaujorodrigues7725 5 ай бұрын

Tutorial too good! Amazing

@tmoumimahmoud6966 4 ай бұрын

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 3 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

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 5 ай бұрын

@@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 5 ай бұрын

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

@LoayAl-Said-j8p 6 күн бұрын

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..

@orangesupercar789 4 ай бұрын

Great Tutorial, Im not sure if im asking the right question. But i would like to pull from an API lets say the pokemonAPI and store into a sqlite3 database. Lets say every time a button is clicked on a website or something. Do you have any videos or anything like that to do this. I really enjoy your methods of teaching.

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

I have no specific tutorial for that. I have a tutorial that explains everything you would need to know about fetch - kzbin.info/www/bejne/aKS0aqufeqaLhNE This is the only SQLite tutorial that I have. I have playlists about NodeJs and express on the server. I also have a playlist about JS events for the browser. How you combine all this with the client-side website really depends on what you are trying to build. What data are you saving? Is there other data being combined with it? Does the data need to be saved for one person or all users? One user - in the browser? All users - on the server. Does the data need to be cached or permanently saved - to decide what kind of storage to use and where to put it.

@sjshdhehbesjks 4 ай бұрын

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 4 ай бұрын

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.