I ended up only using FTS5 because I managed to update the SQLite version on Android: github.com/craftzdog/react-native-...
I use neither contentless nor contentful because the actual content is stored in PouchDB. Since they are just text notes, the size wouldn't matter.
I use neither contentless nor contentful because the actual content is stored in PouchDB
I'm a bit confused. I thought that's what contentless tables were about?
Contentless FTS4 Tables: In order to create an FTS4 table that does not store a copy of the indexed documents at all, the content option should be set to an empty string.
Great article Takuya. Thank you so much. I had this post bookmarked for a few years because I knew one day I will need it :)
I have a few questions:
I ended up only using FTS5 because I managed to update the SQLite version on Android: github.com/craftzdog/react-native-...
I use neither contentless nor contentful because the actual content is stored in PouchDB. Since they are just text notes, the size wouldn't matter.
Thank you for your reply
I'm a bit confused. I thought that's what contentless tables were about?
From the SQLite docs