Up and Running with SQLite3 in a NodeJS API

[@mtcindianutube]

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

[@RafaelSales55]

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

[@averstrum6372]

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]

Tutorial too good! Amazing

[@orangesupercar789]

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]

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]

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]

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.

[@tmoumimahmoud6966]

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]

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]

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]

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]

@@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]

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

[@kettenbach]

Great content and tutorial as always. Just missed the biggest enemy of all {Sleepy Joe, he has no clue of all the damage he's done}.

[@alexeyn2281]

vladimir putin ? are you serious ?

[@SteveGriffith-Prof3ssorSt3v3]

всегда.

[@alexeyn2281]

@@SteveGriffith-Prof3ssorSt3v3 он же убийца, садист, военный преступник