+- Ethical Tech Developer Forum (https://ethicaltechdevforum.com)
+-- Forum: Support (https://ethicaltechdevforum.com/forumdisplay.php?fid=4)
+--- Forum: Ethics Code (https://ethicaltechdevforum.com/forumdisplay.php?fid=5)
+--- Thread: Data Storage Security (/showthread.php?tid=4)
Data Storage Security - keith.watson - 09-19-2025
SQLite is a highly vulnerable db engine which produces files which can be easily read using Android's application interoperability features. Therefore, all database files must be encrypted, including the block chained data change event record. How does one execute SQL on an encrypted database file? The only way to access, navigate, filter, and apply analytics is to first read the entire file into RAM and decrypt it into custom maps and other feature convenient collections. The security problem then is only how to securely store encryption and decryption keys.