Hello, first of all this is excatly what I've been looking for so thank you. The only question I have is how would I actually send quereyObject to the server in a real website like how do I fill the field and type.
Hey! There’s a few ways to do this depending on what language and library you’re using. The most basic thing to do though is use query parameters. Basically a ? At the end of url. Then each field gets a field name = variable. For multiples use &. For example: www.myurl.com?fieldone=one&fieldtwo=two&fieldthree=something
This could work for you! Depends on the hosting provider though. And your usage. For a portfolio project like application I wouldn’t worry. But for something large scale with a lot of users it could be an issue. This is really just a file, so if it’s a really big database it will be a really big file. You may have a limit on overall storage or file size depending on your hosting provider
@@bytemyke Thank you so much for responding. Would I need to host the database on a certain type of server? I’m using ReactJS for my FE to create multiple eCommerce stores. I’m under the impression that the only way to to consume the data is at endpoints through a rest api. Is there a way around that? I would like to use php or python to access the data without a rest api... Sort of like in WordPress. Also if SQLite is just a file, would it need to be hosted on a certain type of server? I’m hunting for hosting solutions before I put a lot of effort into something that won’t work long-term due to the cost to storing the data. That my dilemma. Again, thank you so much for you video and response.
what is going on at like 3:46 where everthing jumps and re-arranges and all of a sudden there's a ton of new semi-colons everywhere? Are you editing and jumping the video or is VSCode doing that for you? If VS Code is doing that for you = what are you using for that? So hard to follow because of that.
Yes this is a vs code auto formatter. It formats upon save. I believe at the time of this video I was using one called prettier. I’m sorry that this makes it difficult to follow, perhaps I should leave it off in future videos.
@@bytemyke Appreciate the response. At some level of newbie that will probably confuse people. Or maybe I am jumping too far ahead in my tutorials vs my skills and knowledge? Maybe this is something VSC users are used to seeing? I'm still figuring out all the tricks VS Code can do. I've done mostly basic Python with NP++ until now.
This error most often occurs when the file path in “new sqlite.Database(“ is incorrect. I’d double check that 1. You created your database file with a .db extension 2. You spelled the file name correctly when opening the database and included the .db in the name 3. It is in the correct directory. For example, if you are using “./“ it should be in the same directory that the js file trying to open the database resides. If you are still having trouble, feel free to upload the code to GitHub and drop a link. I’ll check it out and let you know what’s wrong
Hi Mike, could you please explain why do you have 'try...catch' block here ? Since you catch an error inside of try block, it would never go to catch block, what's the use of it then ?
Sorry for the very late reply but if you still don't know the answer, the try catch block is catching other errors to prevent something unexpected. The "If (err)" part is dealing with an expected error (which is why the status codes are different).
If you're going to include a tool like Postman in a beginner tutorial maybe you should explain a little more about it. Like "first thing you want to do is make sure you have your 'thing' set to POST" -- ummm what does that even mean? What 'thing'? Postman doesn't even show you the option until you until you click the + button which as no roll-over tool-tip and I have no idea what it is even for. You've got 'thing' pre-set in your Postman leaving us newbies struggling. I do appreciate the video but it is not exactly easy to follow. I am staying with it because it is the only one I can find that doesn't shove 15 different dependencies at you to do the same thing. You also tell us all the dependencies up front instead of springing new dependencies on us 3/4 of the way through the video. Appreciate that. Would love the same consideration for tools like Postman!
That’s fair. I’m sorry that makes it difficult for you to follow. This is not a tutorial on how to use Postman though so I do not focus much on it. I should have made a separate video on postman and included a link to it for those who are unfamiliar though.
@@bytemyke I managed to figure it out. Took me a few minutes. You're a good enough teacher I think you could walk the viewer through the steps required to follow along in like 10 seconds. I think I had to create a collection, then hit the "+" and then "unhide" headers and I was ready to continue following along. No need to explain what or why just "do this, and there's a more complete Postman tutorial link in the description" :) Your content is fantastic. It is exactly what I want to/need to learn to get started. I am in over my head with the project I am working on but your video is helping a lot.
Appreciate the focused approach to teaching. You covered everything without fluff and filler. Thank you!
I can rarely find any UA-camr making Nodejs projects API with SQLite and explaining it in such an easy way.
Great work bro. Keep it up 😎
Thank you, I will! 😁
Hands down! great tutorial, just what I needed.
Excellent - exactly what i was looking for and well explained
It doesn't look so hard :) Thanks for this tutorial. It's a good introduction
Thanks! This was really helpful and clear. :)
just came across your channel. Very helpful 👍
Glad I could help! 😁
Hello, first of all this is excatly what I've been looking for so thank you. The only question I have is how would I actually send quereyObject to the server in a real website like how do I fill the field and type.
Hey! There’s a few ways to do this depending on what language and library you’re using. The most basic thing to do though is use query parameters. Basically a ? At the end of url. Then each field gets a field name = variable. For multiples use &. For example:
www.myurl.com?fieldone=one&fieldtwo=two&fieldthree=something
I see why coding is such a prestigious career
nice, please check sound is low and screen is bit blury.
Great tutorial. Much thanks.
How to deploy this project and create own api
Kind request to make a video
At 4:06 you have Tabs but at 4:07 they've changed to ? spaces ?? ... is that jump a video edit or a VS Code plug-in?
It is a syntax formatter plugin. It formats the code upon save
I love SQLite but hosting provider only supports php or python on a MySQL database. Could this work for me?
This could work for you! Depends on the hosting provider though. And your usage. For a portfolio project like application I wouldn’t worry. But for something large scale with a lot of users it could be an issue. This is really just a file, so if it’s a really big database it will be a really big file. You may have a limit on overall storage or file size depending on your hosting provider
@@bytemyke Thank you so much for responding. Would I need to host the database on a certain type of server? I’m using ReactJS for my FE to create multiple eCommerce stores. I’m under the impression that the only way to to consume the data is at endpoints through a rest api. Is there a way around that? I would like to use php or python to access the data without a rest api... Sort of like in WordPress.
Also if SQLite is just a file, would it need to be hosted on a certain type of server? I’m hunting for hosting solutions before I put a lot of effort into something that won’t work long-term due to the cost to storing the data. That my dilemma. Again, thank you so much for you video and response.
what is going on at like 3:46 where everthing jumps and re-arranges and all of a sudden there's a ton of new semi-colons everywhere? Are you editing and jumping the video or is VSCode doing that for you? If VS Code is doing that for you = what are you using for that?
So hard to follow because of that.
Yes this is a vs code auto formatter. It formats upon save. I believe at the time of this video I was using one called prettier. I’m sorry that this makes it difficult to follow, perhaps I should leave it off in future videos.
@@bytemyke Appreciate the response. At some level of newbie that will probably confuse people. Or maybe I am jumping too far ahead in my tutorials vs my skills and knowledge? Maybe this is something VSC users are used to seeing?
I'm still figuring out all the tricks VS Code can do. I've done mostly basic Python with NP++ until now.
I am getting an error like this, SQLITE_CANTOPEN: unable to open database file... Please help
This error most often occurs when the file path in “new sqlite.Database(“ is incorrect. I’d double check that
1. You created your database file with a .db extension
2. You spelled the file name correctly when opening the database and included the .db in the name
3. It is in the correct directory. For example, if you are using “./“ it should be in the same directory that the js file trying to open the database resides.
If you are still having trouble, feel free to upload the code to GitHub and drop a link. I’ll check it out and let you know what’s wrong
Hi Mike, could you please explain why do you have 'try...catch' block here ? Since you catch an error inside of try block, it would never go to catch block, what's the use of it then ?
Sorry for the very late reply but if you still don't know the answer, the try catch block is catching other errors to prevent something unexpected. The "If (err)" part is dealing with an expected error (which is why the status codes are different).
Thanks bro. I guess this it the back end overview?
Yeah, that's exactly what it is
cannot set headers after they are sent to the client
can you attach the code?
please provide code
If you're going to include a tool like Postman in a beginner tutorial maybe you should explain a little more about it. Like "first thing you want to do is make sure you have your 'thing' set to POST" -- ummm what does that even mean? What 'thing'? Postman doesn't even show you the option until you until you click the + button which as no roll-over tool-tip and I have no idea what it is even for. You've got 'thing' pre-set in your Postman leaving us newbies struggling.
I do appreciate the video but it is not exactly easy to follow. I am staying with it because it is the only one I can find that doesn't shove 15 different dependencies at you to do the same thing. You also tell us all the dependencies up front instead of springing new dependencies on us 3/4 of the way through the video. Appreciate that. Would love the same consideration for tools like Postman!
That’s fair. I’m sorry that makes it difficult for you to follow. This is not a tutorial on how to use Postman though so I do not focus much on it. I should have made a separate video on postman and included a link to it for those who are unfamiliar though.
@@bytemyke I managed to figure it out. Took me a few minutes. You're a good enough teacher I think you could walk the viewer through the steps required to follow along in like 10 seconds. I think I had to create a collection, then hit the "+" and then "unhide" headers and I was ready to continue following along. No need to explain what or why just "do this, and there's a more complete Postman tutorial link in the description" :)
Your content is fantastic. It is exactly what I want to/need to learn to get started. I am in over my head with the project I am working on but your video is helping a lot.
Explaiiiinnnnn !!!!
FACTS!