[expo-sqlite] Ship newer SQLite3 version on Android
z0al
I read somewhere that
expo-sqlite
is inspired by react-native-sqlite-2 But, one that
react-native-sqlite2
does differently is using sqlite-android on Android to use the latest SQLite version with extensions like FTS and JSON enabled.Having consistent support for features like FTS5 is crucial for many apps. It'd be really nice if
expo-sqlite
used sqlite-android
as well.jwallet
if you can ditch or don't use expo go, this can be used in the meantime, a npm package of
expo-sqlite
with an updated version of the android database using requery/sqlite-android
, it works in managed environment and in bare workflowhttps://github.com/jwallet/expo-sqlite-storage
Daniel Meyer
The current expo SQLite version is 3.32.2 which is about 2 years old (2020-06-04). Would be great to have the newest version with the JSON features so that expo can be used with RxDB on android.
z0al
Brent Vatne / Evan Bacon is this something Expo team will be interested in doing?
Brent Vatne
z0al: hi there! you can just use react-native-sqlite2 if you need it. https://blog.expo.dev/introducing-custom-development-clients-5a2c79a9ddf8
z0al
Brent Vatne: Yeah, I'm aware of custom dev clients :)
But in this case, I'd prefer to use
expo-sqlite
since it seems more stable compared to RNSQlite2 (at least by looking at the open issues/history) + it provides TS typings and some form of documentation.Is your team against using
sqlite-android
library on Android? If yes why?Brent Vatne
z0al: we are not opposed to it, we don't necessarily have an opinion at the moment. to be honest it is not a priority right now because we are more focused on work to enable developers to use any library that they want. once eas build, submit, custom dev clients, and some other features are further along we'll have more bandwidth to spend on improvements like this.
z0al
Brent Vatne: fair enough. Thank you for all amazing work you folks are doing.