4 ms·
Has anyone tried this out on mobile? I have a list of app ideas that all center around shipping a big database to a device and allowing complex querying while o
by m_fayer 2y ago
Has anyone tried this out on mobile? I have a list of app ideas that all center around shipping a big database to a device and allowing complex querying while offline.
- wahnfrieden 2y agoYes
- m_fayer 2y agoHow’d it go?
- wahnfrieden 2y agoGRDB on iOS and macOS It’s easy and works well It is slower than Realm in some benchmarking (I forget if it’s reads or writes) and might be less memory friendly (Realm does lazy evaluation). You need to use some third party open source to make sqlite faster by precompiling model definitions, which I didn’t bother with. I currently only use it for fts5 and Realm for other needs, but would like to try using it for more. I also recommend looking at https://skip.tools https://skip.tools which has cross platform SQLite for iOS and Android (you write your app in swift and SwiftUI and it generates the Android project and kotlin code) Btw I use GRDB in my iOS/macOS app here: https://reader.manabi.io https://reader.manabi.io Manabi Reader, a Japanese learning app. I use SQLite for dictionary searches which works ok for Japanese only because I’m only searching dictionary expressions and not sentences
- m_fayer 2y agoThanks for the input! Did you need to ship your own binaries of sqlite that include fts5 or does skip do that for you?
- wahnfrieden 2y agoI haven't used Skip yet, but the two founders are very responsive on twitter / elsewhere if you want to ask about that. I used GRDB for FTS5