How to store key value data in pascal lazarus / 16-Databases ---------------------------------------------------------------------- Packs · 2022-11-26 21:25 We would like to store data in json file. With encrypted and it should search key fast ---------------------------------------------------------------------- Packs · 2022-11-27 14:50 how to store data in json format in pascal. ---------------------------------------------------------------------- dseligo · 2022-11-27 14:58 Look at examples here: https://wiki.freepascal.org/fcl-json ---------------------------------------------------------------------- Packs · 2022-11-28 14:43 how to encrypt sqllite database . ---------------------------------------------------------------------- KodeZwerg · 2022-11-28 14:46 May I ask for what purpose? Storing data in an encrypted way can result in a very slow database. ---------------------------------------------------------------------- Zvoni · 2022-11-28 14:48 Quote from: Prakash on November 28, 2022, 03:43:13 pmhow to encrypt sqllite database . by reading the manual: https://www.sqlite.org/see/doc/trunk/www/readme.wiki ---------------------------------------------------------------------- dseligo · 2022-11-28 14:53 Quote from: Prakash on November 28, 2022, 03:43:13 pmhow to encrypt sqllite database . I didn't try it, but I think you need different dll's. Look here: https://wiki.freepascal.org/SQLite#Support_for_SQLite_encryption ---------------------------------------------------------------------- PierceNg · 2022-11-28 15:42 Quote from: KodeZwerg on November 28, 2022, 03:46:57 pmMay I ask for what purpose? Storing data in an encrypted way can result in a very slow database. Encrypting a database is said to impose 5-20% overhead. Depending on nature of data, encryption might be mandated by law. If a database is hosted "in the cloud" unencrypted, they are at risk of leakage and unauthorized modifications / deletion by the cloud provider's employees and bad actors who break into the cloud infrastructure.