I am developing a vocabulary + quizzes app. For every word, I need to store an image and multiple audio files. I need some professional advice on:
- Use SQLite directly or PouchDB with SQLite adapter. The app is completely offline. No DB sync.
- Save image and audio files directly as binaries into the DB or save names only into the DB and the actual files to the local file system. I know it’s never been a good idea saving binaries into DB. PouchDB has sort of “attachments”. If the answer to my question 1 is PouchDB, should I use it to save binaries or not?