react-native-quick-sqlite VS flash-list

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.

Also, yes, scrolling handling with lots of images can be a problem, but don't panic, React Native has some good partners 😉. Shopify created a library specifically to deal with this problem called FlashList ⚡ which is now the solution to this problem.

Use flashlist

FlashList is what you want https://shopify.github.io/flash-list/

I think there's a lot of apps out there that have this type of navigation. I'm working myself on one like that :) It's doable, BUT you have to make sure to work on all sorts of perf improvements. You should also check out FlashList https://shopify.github.io/flash-list/

In my experience Flashlist from Shopify mostly solves the issue with large lists. I'd prefer if it was built-in to the platform, still...

It can't render same height items. I reported bug, still wait for response

2. FlashList