search

jepiqueau / react-sqlite-app-starter

Ionic/React SQLite Application Starter
MIT License
22 stars 14 forks source link

shall I close() the database connection everytime? #13

Closed blatoo closed 2 years ago

blatoo commented 2 years ago

Hi all,

thanks very much for this great plugin, I am just new to sql world.

I just find a strange problem, every time after insert data with "run("...", [...])", I have to close() the connection, otherwise the data won't be saved into the table. Is it true?

Shall I close() database every time after I changed some data in a table?

Conny

jepiqueau commented 2 years ago

@blatoo are you using the Web part of the plugin?. If yes the database is in-memory so you do not need to close the connections after each sql statement. there is a saveToStore method which allows the database to be saved on store (indexedDB) at your convenience. For native iOS, Android or desktop Électron you do not need to worry about this

blatoo commented 2 years ago

Hi Jepiqueau,

thanks! Ah, the "saveToStore" is at the top of the doc, I just ignored it... :D

Merry chrismas and have a nice holiday season! Conny