Connecting to Sqlite Database in Electron JS - (Electron & Databases)
HTML-код
- Опубликовано: 2 дек 2021
- Nearly every application needs a database of some sort. Sqlite is a great choice for an Electron db. It's lightweight, it's portable and can process normal SQL commands. In this video I show you how to connect and work with a Sqlite database using Electron.
![Rob49 - On Dat Money (with Cardi B) [Official Video]](http://i.ytimg.com/vi/fTFS58mHJh8/mqdefault.jpg)
I’m a 43 ur old full stack dev , need to build a Win, Mac and Linux gui app. Was planning to use c++ but have now decided to use electron for speed of development , keep the vids coming my friend :)
Electron is a pretty good choice for rapid development. I've commercially released one app so far in it, and my second one is nearly ready to hit production.
Your channel is very cool!
Please make more!
Thanks.
Thank you, I will
For Connecting to Databases like Ibm db2 and mysql what package should be installed.For me when i tried to run the application then in the console i am getting an error Unreferenced error for the var=require('mysql') in my javascript file.So my doubt render process does not have node apis ??
hey i am using electron forge with react, sqlite3 and typeorm when i am trying making the package , the sqlite3 file is not exporting with bundle is there any solution and not even creating ? and thanks a lots for amazing tutorial
Very cool. But I have a problem, when I try to add an item by clicking on a button it returns " Fatal error: throw as JavaScript exception napi_throw". Do you have any idea how to help me? It's a CRUD.
Very helpful. keep as you do.
Thanks
You are amazing Sir. Thank you
You are welcome and happy learning!
Great video sir, Thank you
Glad you liked it
Very nice tutorial.. Really explains a lot.
Thanks mate
Thanks so much - great video
Took a few years off from dev work. Come from front end design world and doing my first personal project that will push me into the backend dev world. Any tips on how to properly build a database for a beginner?
Güzel bir anlatım olmuş.. Teşekkürler..
Thanks for this video👍
Can i use database located in another directory?
Such a good video , i would love to see on how the packaging works for linux and others thank you !! I'm having really hard time on packaging. I can use this system with react too right?
Yes, you can use node.js with react, there is a separate setup for it though and you can find videos online on that.
I am making training on packaging, we'll have it up soon.
I just put up a packaging video today.
If I add react to this, nothing will different except the api calling inside the react file isn't it ?
Thanks man you are a life saver
You are welcome
when ever i try to install better-sqlite3-prebuilds it shows an error
can anyone help me please 🙏
Hey it's already 3 days without sleeping and i cant figure out npm better-sqlite3-with-prebuilds and i receive error ERR! gyp ERR! can you help me..?
I'm starting to study now, and I don't know much about databases, but what I understand is that when I compile my program and pass it on to someone else, the database will be created if it doesn't exist, am I right? Thank you
You can ship the basic (empty) db file alongside your setup. If you want the db to be created, you'll need to write a function that'll create the db on first run.
Thanks @coderJeet! Great vids. Having an issue with preload.js in your examples in this vid. If preload.js file is empty no error, but when I add code as in the vid I get error unable to load preload script and gives the the correct path. Any suggestions?
seems to use contextbrige, you also have to have contextIsolation: true in webPreferences... and double check your paths :)
Thanks for pointing out
I am trying to make offline desktop app so plz tell me Is ipc needed to make crud application in electron or i have to use express in electron? But if i use express in electron it will work as online desktop aap in production.I dont find solution any where, if you can reply in this reguard.
You can use Express if you want to. It can be used in both online and offline apps. IPC is available to an express app too. However, I recommend KOA instead of Express if you start out now.
why can't I use require in my js file
Hi first congratulate you for the video. I wanna ask you something. I didn't understand what you did with electron-rebuild, when you mention you had to set the whole path. I followed "npm i -D electron-rebuild" and then "npm i" but still receiving the same error. what Am I missing? Thanks!
same issue have you got the solution?
@@shanjainavithar1169 did anyone got the solution?
@@anserwaseem3362 I used ./node_modules/.bin/electron-rebuild in the terminal (can't see the underscore very well in the vid) and it fixed the issue. It's using the full relative path to call electron-rebuild.
Awesome Tutorial ++++++++++++++++++++++ Thank You.
Thank you ! :)
does ur code works?
In case of 'table **** not found' even if name has match, try this:
const sqlite = require('better-sqlite3-with-prebuilds');
const path = require('path');
const db = sqlite(path.resolve(__dirname, '../local.db'), {fileMustExist: true});
exports.db = db;
Thank you for the tip!
@@coderjeet btw, is there any chace to not refresh app after one of the methods to store/get data in sql is called?
@@Zaxior Don't understand your question
@@coderjeet Basically as long as I don't use:
db.exec(); all works fine, but as soon I call it, it refresh my whole app. I'm using react redux where I can keep my temp data in state, after app refresh it gone.
I still got the errors when you rebuild electron
how i run the ./node_modules/.bin/electron-rebuild ?
You can use git bash (windows) or .
ode_modules\.bin\electron-rebuild.cmd
Hi, I'm having an error in .
ode_modules\.bin\electron-rebuild.cmd it keeps giving me an error which is :
An unhandled error occurred inside electron-rebuild
node-gyp failed to rebuild 'C:\Users\Admin\Desktop\Test
ode_modules\better-sqlite3-with-prebuilds'.
For more information, rerun with the DEBUG environment variable set to "electron-rebuild".
Error: Could not find any Python installation to use
why i'm having an error like this? can you suggest some solution for this 😅?
same any fixed for this?
@@anikokey7716 did you find any solution?
Can i get the source code of this project? I have try following your video but still got an error like this when I try to do electron-rebuild :
"Error: Could not find any Visual Studio installation to use"
Sorry, I didn't put this one in a repo.
To fix that error you need to install Visual C++ Build Environment from here: visualstudio.microsoft.com/es/thank-you-downloading-visual-studio/?sku=BuildTools
@@JuanCarlos611 and then do what?
At 12:35 what command did you use? As you did?
.
ode_modules\.bin\electron-rebuild.cmd
how to check that insert query is successfully executed in db, any flag ? @coderJeet
Yes, when you run an insert query, you will get a non zero return value if the query is successful
thanks so much , can u make a video on how to build with the database
Thanks for the suggestion
i mean packaging ^^ thNkss
you wrapped js in Electron, but I want to wrapper React.js in Electron and connect to sqlite. Is it really?
Yep, you can absolutely do that.
@@coderjeet after installing the electron-builder, my application does not react at all to my actions. Why?
module not found:error!!!
what the difference between sqlite and sqlite3?
Sqlite3 is the latest version of the library.
where is your repo on github? ....
Top. +1
Appreciate it!
I faced a preload error and your solution didn't work.
So sad to know
does anybody's code work?
Mine is not working.....
As usual... When working with namespaces (the most idiotic way of importing) I got stuck with scope for more than an hour and at the end it just cracked ... Unable to rebuild it on windows 10
Hmm..
@@coderjeet Hmm.. is top answer -.-
have you found an alternative sqlite?
Please give the git hub.
Dont have one for this.
Unfortunately, I've just wasted 15 hours...
??
This is awful. It might work, but the instructions are too jumpy.