Implementing Encrypted SQLite Database Similar to Commercial Dictionary Apps

Hi everyone,

I'm working on a FlutterFlow app that requires storing a large amount of read-only reference data locally, similar to how a dictionary app like Merriam-Webster works. I've noticed that if you inspect the data files of their app, the SQLite database is encrypted and appears as gibberish in a standard SQLite browser. However, the data is perfectly accessible within the app itself.

I want to implement a similar level of protection for my own app's SQLite database within FlutterFlow to prevent users from easily extracting and copying the data.

My main questions are:

1. What is the recommended way to implement an encrypted SQLite database in a FlutterFlow project? I assume this involves using custom Dart code.

2. How should I handle the encryption key securely within the app to balance security and functionality?

Any insights, code snippets, or pointers to relevant tutorials would be incredibly helpful.

Please share your insights in a detailed and comprehensive way as making understand a naieve learner. Apart from the experts, any member of the community who has ever attempted to achieve this may share their experience.

Thanks in advance for your expertise.