#16 How To Open Pre Populated SQLite Database In React Native 0.60+ ?

[@umairsaeed5055]

Thanks alot
After 1.5 month searching on youtube i found your video
That one is awesome
Now I am going to continue my work.
Thanks

[@ItzErHarinder]

Glad to hear that brother 😇🙏🏻

[@umairsaeed5055]

Today I followed exactly the same method. I checked for android but it didn't connect. What is the problem? Please help me

[@varunkhera5461]

Thanks for the great Tutorial.I created a db file using DB Browser for SQLite on Mac...I followed all the steps you mentioned but still when I run the App in the local database folder 'library/localdatabase/'. it seems that there is always override on my original database file......

[@KalaiVani-fw7ki]

Hi bro after done with executesql alert is not coming with length of the row.

[@ItzErHarinder]

It means database is not copied over there. You are missing something.

[@KalaiVani-fw7ki]

@@ItzErHarinder ok let me check also FYI I am working with windows 10 and checking in android alone

[@ItzErHarinder]

It should work. Try to delete the app and try again.

[@shobrisyaiful658]

how to fix it? my react native v 0.67

[@vikassonwani773]

hello, bro i have followed same steps as your for android, in my code database is opening but query is not running in tx.executeSql function. when console tx it is returning some undefined in error and success object. please help me.

[@ItzErHarinder]

Clear build folder, delete the app and rebuild again.

[@vikassonwani773]

@@ItzErHarinder I have cleared build after your suggetion. but i am getting your point of "delete the app"

[@ItzErHarinder]

Delete the app from android device and reinstall.

[@vikassonwani773]

@@ItzErHarinder I have done this but still it is same postion.
db.transaction((tx) => {
console.log(tx)
tx.executeSql('select * from demo', [], (tx, results) => {
console.log("Query completed");
});
});
{"db": {"dbname": "sqlite.db", "openError": [Function anonymous], "openSuccess": [Function anonymous], "openargs": {"dblocation": "nosync", "name": "sqlite.db"}}, "error": undefined, "executes": [{"error": [Function anonymous], "params": [Array], "sql": "BEGIN", "success": null}], "fn": [Function anonymous], "readOnly": false, "success": undefined, "txlock": true}
NOT executing tx.executeSql

[@shobrisyaiful658]

how to fix it? my react native v 0.67

[@วรัญญูวัฒนโรจนาพร]

I have a little problem.
db.transaction((tx) => {
console.log('run') // this code is working
tx.executeSql('SELECT * FROM users', [], (tx, res) => {
console.log('Query completed');
// this code isn't working
});
});
Thank you.

[@ItzErHarinder]

May be db is not fetching.

[@วรัญญูวัฒนโรจนาพร]

​@@ItzErHarinder How can I fix it?
db.transaction((tx) => {
tx.executeSql('SELECT 1 + 1', [], (tx, res) => {
console.log("Query completed");
// this code is working
});
});

[@patriciajarosi6391]

hey, i have the same problem, did you fix it?

[@vikassonwani773]

What are the good option for local storage except for async storage?

[@ItzErHarinder]

Check video from 56 to 60.

[@prajnahegde503]

Hey, this tutorial is amazing.. I was trying this from 2 days... Only thing which I missed was npx react-native link. Thanks to you. Please make video tutorials for redux with react-native from scratch.

[@ItzErHarinder]

After firebase series; redux will start 😊

[@denisfs5526]

Thanks for sharing, you help me a lot.

[@ItzErHarinder]

My pleasure

[@indiohellfox]

Thanks, you really help me! As a tip for the next video, try to be more dynamic! Again, thanks!

[@ItzErHarinder]

My pleasure

[@roopa_iks]

Hi iam getting error like undefined is not n object at db.transaction

[@ardhendugatait4366]

Can we use .sqlite file instead .db file

[@littleremix7302]

Nice video sir

[@ItzErHarinder]

Thanks

[@darioalves7739]

Hello brother , one suggestion : Do the same video but with Expo !

[@ItzErHarinder]

Thanks for the idea!

[@niteews92]

@@ItzErHarinder Any progress on a video using react-native-sqlite-storage with Expo?

[@trandinhthang9812]

Hi Bro. Do you know how to "Use pre-populated database file file local storage on phone"

[@CreativeJE]

Nice tutorial but please turn off all those click sounds they are pretty annoying or better just turn off the sound.

[@ItzErHarinder]

Okay 😃

[@oguzhan2393]

thanks. but in android also need to use www folder. I am already hearing thanks to me also :D

[@ItzErHarinder]

👍🏻great

[@chirpieful]

Good video but please improve on the audio quality. There is a lot of annoying sounds

[@ItzErHarinder]

Sure. Thanks 😀🙏🏻

[@badboy-ke6hr]

Can anybody know how to use in expo

[@littleremix7302]

Please make simple social media using react-native and mysqli

[@ItzErHarinder]

Means?

[@littleremix7302]

@@ItzErHarinder means make a simple app which have features like social media using mysql database

[@littleremix7302]

Is it possible to make an app like this using mysql and react native?

[@ItzErHarinder]

Chat like app?

[@littleremix7302]

@@ItzErHarinder yes