Connecting to Sqlite Database in Electron JS - (Electron & Databases)

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.

[@G5STU]

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 :)

[@coderjeet]

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.

[@MatheusSilva-qm3ph]

Your channel is very cool! Please make more! Thanks.

[@coderjeet]

Thank you, I will

[@Zaxior]

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;

[@coderjeet]

Thank you for the tip!

[@Zaxior]

@@coderjeet btw, is there any chace to not refresh app after one of the methods to store/get data in sql is called?

[@coderjeet]

@@Zaxior Don't understand your question

[@Zaxior]

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

[@Sirot1d]

Very helpful. keep as you do.

[@coderjeet]

Thanks

[@vishnukathika2546]

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

[@khal-elbangcola8167]

You are amazing Sir. Thank you

[@coderjeet]

You are welcome and happy learning!

[@tharukerajapaksha3652]

Great video sir, Thank you

[@coderjeet]

Glad you liked it

[@galaxysoul3421]

why can't I use require in my js file

[@MatheusSilva-qm3ph]

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

[@coderjeet]

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.

[@erdincparlak7092]

Güzel bir anlatım olmuş.. Teşekkürler..

[@s1mple511]

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

[@shivamkapoor1827]

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.

[@coderjeet]

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.

[@kevinrauer]

Very nice tutorial.. Really explains a lot.

[@coderjeet]

Thanks mate

[@paulhuang2030]

Thanks so much - great video

[@kanishkakumarasiri9257]

If I add react to this, nothing will different except the api calling inside the react file isn't it ?

[@gioproyects9507]

how i run the ./node_modules/.bin/electron-rebuild ?

[@geniusidea6026]

You can use git bash (windows) or . ode_modules\.bin\electron-rebuild.cmd

[@escanortheone668]

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

[@dogustemizsoy9081]

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?

[@coderjeet]

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.

[@coderjeet]

I just put up a packaging video today.

[@tripmad]

Thanks for this video👍

[@blobropch0p]

Thanks man you are a life saver

[@coderjeet]

You are welcome

[@hrutvikkhunt4043]

Can i use database located in another directory?

[@MatheusSilva-qm3ph]

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.

[@tayebsida3mer923]

when ever i try to install better-sqlite3-prebuilds it shows an error can anyone help me please 🙏

[@mohamedyoussef8835]

Awesome Tutorial ++++++++++++++++++++++ Thank You.

[@coderjeet]

Thank you ! :)

[@diyatripathi503]

does ur code works?

[@MagicTheKrakening]

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?

[@hubert3728]

where is your repo on github? ....

[@abdelouahebbenouar6157]

I still got the errors when you rebuild electron

[@prince-vp1bu]

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 😅?

[@anikokey7716]

same any fixed for this?

[@anserwaseem3362]

@@anikokey7716 did you find any solution?

[@ДмитрийБелкин-и8ю]

you wrapped js in Electron, but I want to wrapper React.js in Electron and connect to sqlite. Is it really?

[@coderjeet]

Yep, you can absolutely do that.

[@ДмитрийБелкин-и8ю]

@@coderjeet after installing the electron-builder, my application does not react at all to my actions. Why?

[@matheusasilva1170]

At 12:35 what command did you use? As you did?

[@coderjeet]

. ode_modules\.bin\electron-rebuild.cmd

[@teamdailycode5594]

how to check that insert query is successfully executed in db, any flag ? @coderJeet

[@coderjeet]

Yes, when you run an insert query, you will get a non zero return value if the query is successful

[@adamfakrullah8265]

what the difference between sqlite and sqlite3?

[@coderjeet]

Sqlite3 is the latest version of the library.

[@salemouail627]

thanks so much , can u make a video on how to build with the database

[@coderjeet]

Thanks for the suggestion

[@salemouail627]

i mean packaging ^^ thNkss

[@hrutvikkhunt4043]

module not found:error!!!

[@RSurya99]

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"

[@coderjeet]

Sorry, I didn't put this one in a repo.

[@JuanCarlos611]

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

[@anserwaseem3362]

@@JuanCarlos611 and then do what?

[@MOGE_]

I faced a preload error and your solution didn't work.

[@coderjeet]

So sad to know

[@ShawneeConsulting]

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?

[@ShawneeConsulting]

seems to use contextbrige, you also have to have contextIsolation: true in webPreferences... and double check your paths :)

[@coderjeet]

Thanks for pointing out

[@MrFenoma]

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!

[@shanjainavithar1169]

same issue have you got the solution?

[@anserwaseem3362]

@@shanjainavithar1169 did anyone got the solution?

[@ShawneeConsulting]

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

[@diyatripathi503]

does anybody's code work?

[@godfreychiumia3925]

Mine is not working.....

[@saulotarsobc]

Top. +1

[@coderjeet]

Appreciate it!

[@tamirron1301]

Unfortunately, I've just wasted 15 hours...

[@coderjeet]

??

[@zeljkobanovic4398]

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

[@coderjeet]

Hmm..

[@Zordanus]

@@coderjeet Hmm.. is top answer -.-

[@Zordanus]

have you found an alternative sqlite?

[@matheusadmin4364]

Please give the git hub.

[@coderjeet]

Dont have one for this.

[@dwightledet5857]

This is awful. It might work, but the instructions are too jumpy.