Lazarus

Programming => Databases => Topic started by: Prakash on November 26, 2022, 10:25:13 pm

Title: How to store key value data in pascal
Post by: Prakash on November 26, 2022, 10:25:13 pm: We would like to store data in json file.
With encrypted and it should search key fast
Title: Re: How to store key value data in pascal
Post by: Prakash on November 27, 2022, 03:50:05 pm: how to store data in json format in pascal.
Title: Re: How to store key value data in pascal
Post by: dseligo on November 27, 2022, 03:58:46 pm: Look at examples here: https://wiki.freepascal.org/fcl-json (https://wiki.freepascal.org/fcl-json)
Title: Re: How to store key value data in pascal
Post by: Prakash on November 28, 2022, 03:43:13 pm: how to encrypt sqllite database .
Title: Re: How to store key value data in pascal
Post by: KodeZwerg on November 28, 2022, 03:46:57 pm: May I ask for what purpose? Storing data in an encrypted way can result in a very slow database.
Title: Re: How to store key value data in pascal
Post by: Zvoni on November 28, 2022, 03:48:22 pm: Quote from: Prakash on November 28, 2022, 03:43:13 pm
how to encrypt sqllite database .
by reading the manual: https://www.sqlite.org/see/doc/trunk/www/readme.wiki
Title: Re: How to store key value data in pascal
Post by: dseligo on November 28, 2022, 03:53:25 pm: Quote from: Prakash on November 28, 2022, 03:43:13 pm
how 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 (https://wiki.freepascal.org/SQLite#Support_for_SQLite_encryption)
Title: Re: How to store key value data in pascal
Post by: PierceNg on November 28, 2022, 04:42:26 pm: Quote from: KodeZwerg on November 28, 2022, 03:46:57 pm
May 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.