react-native-quick-sqlite VS react-native-sqlite-storage

5. Quick SQLite

react-native-quick-sqlite if you know what you're doing and Know SQL it gives you more control over the database like executing custom SQL queries, or some advance things, you can use it with an orm like Typeorm.

View on GitHub

Neither of the two: https://github.com/ospfranco/react-native-quick-sqlite

https://github.com/ospfranco/react-native-quick-sqlite with JSI bindings

If you decide to go to sqlite then https://github.com/ospfranco/react-native-quick-sqlite is the fastest one out there. You’ll have to write the sync logic your self (compared to watermelondb where it’s easier).

Oscar Franco created a great SQLite driver react-native-quick-sqlite, which provides a low-level API to execute SQL queries, fast bindings via JSI. JSI has a smaller overhead than the traditional RN bridge's. So, this is much faster than react-native-sqlite-2, which I made to get PouchDB to work on RN before.

Hey, I know MySQLite, what about ReactNative support? Well, last commit on official repo was almost two years ago and I really don't like using outdated libraries.

One issue that irked me during Spicebreaker's development was how painful it was to update the SQLite database with my questions. I tried various solutions, including deleting the database before loading it - it seems to work for some people, but definitely did not work under my setup with my simulator or phone. After wasting hours, I decided it's not worth shortening my lifespan further, and settled on renaming the database file each time I update it. Absolutely disgusting.

I have two apps in prod one using https://github.com/andpor/react-native-sqlite-storage and one using https://github.com/realm/realm-js, both offline only, so I guess I can report my experience with those.

In a react-native app we use react-native-sqlite-storage for dealing with sqlite3 both on iOS and Android.

We ended up using https://github.com/andpor/react-native-sqlite-storage + typeorm and are happy with that.

I'm trying to add SQLite tables dynamically in React Native using react-native-sqlite-storage. The names of the tables are specified by the user. Alternative 1 that works for me is to directly create the query like so: