re: Need Help, building off-line & file based airtable VIEW POST

re: Here's a good overview of when to use sqlite : sqlite.org/whentouse.html Querying 500K - 1M rows of well structured and indexed data won't be the...

Hi thanks for the reply,my plan is to switch to hosted mysql for collaboration, so use sqlite for single user ,over electron basically like excel, do i face concurrency using single user,mostly multiple promise chain query?

Using it as a mysql caching layer for single-user should work smoothly. At worst, if you face performance issues you can trim old data.

Make sure to check out better-sqlite3. It offers a sync, fast API for sqlite.

thanks for the all the help. off to read the docs on sqlite but be best contender

code of conduct - report abuse