Node JS SQLite Crash Course 

Glad I could help! Good luck with the app

Glad it helped!

Thanks! Will do!

Thank you!

Thank you! 😁

Glad I could help! I have a BS in CS and RU-vid got me though it haha

Welcome 😊

Thank you!

Of course! Thanks for watching!

You would want to use a WHERE clause in a select query. I have a full in depth video covering WHERE clauses in SQLITE here : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7AtIjM6_EM8.html The clause would look something like this: "SELECT insertColumnName/s FROM insertTableName WHERE user = insertUserData" Please let me know if further help is needed after watching that video :)

If you are using Express, which I highly recommend using. You want to grab it using the request variable in the post method. Here is an example where I use express and postman ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mnH_1YGR2PM.html . Here is an online example nodejs.dev/learn/get-http-request-body-data-using-nodejs

Hey Matteo! This video is a great place to start. To make it simple I'll break it up into a few sections that you'll want to learn to build the full app Backend: 1. Working with sqlite - learn how to set up a database, insert, delete, retrieve, and retrieve with a filter 2. Creating the API / ROUTES. This video will be helpful for SQLite and Node JS routes ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mnH_1YGR2PM.html - You'll need a GET route that does a select all and ideally have a way to filter, see how I do it via query parameters in that video - If you want to store data in the database as well via a form or something on the front end, you will also need a POST route Frontend: 1. Create the basic form or whatever that handles filtering, and do some kind of GET request to the API 2. Grab the response from the get request and turn it into a graph. I recommend checking out chart.js if you're using vanilla js www.chartjs.org/ Hopefully this helped! Let me know if you have any other questions

Glad you enjoyed it! This would essentially be impossible without node, or another JavaScript runtime environment such as bun or deno. These environments are what allow us to run JavaScript outside of the browser. This could easily be done without NPM if you download the package manually and link to it in your main file. If you mean without using the library at all though, that would be extremely difficult and time consuming as you'd have to create your own which would suck haha

You'll want to use an HTML form that POSTS the data or post it via JavaScript (frontend). Then set up a route in Node js express. Here is an example where I set up a route ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mnH_1YGR2PM.html . You would just use a form or JavaScript instead of postman

You would need to set up a frontend connected to it using either html/javascript/css, or a popular front end framework like react or vue. This video only covers the backend

SQLite is an sql database that takes the form of a file. To be exact it is an embedded file-based relational database management system.

He must have installed auto formatter vs code extension

I don’t, but I’ll make one and reply with the link when it’s done

@Ariel Yabo Here is the video using async await ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0-Xu3tnMEiI.html. I do have a github, I don't upload all my code here, but I do upload some of the code for my bigger videos github.com/miketona

Glad I could help! Good luck on your coding endeavors!

If you're getting that error, then you likely either did not create the table by successfully running the "CREATE TABLE xxx" sql, or you have a typo in the table name. This typo could be in the create table sql or where you are currently trying to use it. I recommend looking at my source code and comparing it to yours.

me to?????

That’s a great question! It is not possible to have a password/username in the traditional sense like what you’d see with a mysql database.

I'm sorry, I do not know of such a tool. I have been thinking of making a browser based GUI tool for sqlite, would that be of interest to you?

@@bytemyke Okay will be waiting for that... let see how that can really help.... How long have you been using sqlite?

can we get closer on social media?? perhaps whatsapp or instagram?

@@goodluckoriuwa1669 Sure! I have my linkedin in my youtube profile if you would like to connect with me there.

I’m sorry, there is not

I’m not sure what you’re asking. Could you explain a bit more?

How to make the db.all function return rows. Not console.log(row), but return rows

@@ananasios Gotcha that makes sense. Thanks for the clarification. Rows is an array of objects so you can return it the same way you would any other variable. I would personally wrap the db.all inside of a function and then you'd use a return statement saying "return rows". If it helps there is an example here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mnH_1YGR2PM.html at around 9:50 where I return rows as a JSON object using express for an API. Another, and perhaps easier, option is to use async await, I'm planning to make a video showing how to do that with sqlite3 in the near future.

@@bytemyke Since asynchronous database queries, the word "return" in the function will work faster than the query to the database and instead of rows will return undifinded.

@@ananasios Yes you would have to use return similar to the way I do in that video with express. Or you would have to use async await so that it is not undefined

This is not. I have an async / await tutorial version here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0-Xu3tnMEiI.html