Which DB format to use?

[C0m3b4ck]

Hello, I am making a library app in Lazarus 1.6.2 with FPC 3.0.0. When I made this app in Visual Basic 6, I used .CSV files due to ease of parsing, creation and portability. However, this time I want to add options for encrypted databases.

What is the best database format in FreePascal if I also want to add encryption down the line? What libraries do I use for hashing variables and encrypting databases? Which FPC do they support?

Thank you for your time! 

[JohnJ]

Take a look at Sqlite. For encryption look at the online package manager. Sqlite itself may have builtin encryption but I don't recall for sure.

[C0m3b4ck]

Thank you for pointing me to SQlite! Upon reading for encryption libraries supporting both FPC 2.4.4 and FPC 3.0.0, I encountered DCPcrypt, LockBox3, and Delphi Encryption Compendium.

I will be using DCPcrypt for hashing (creates username and password hash upon registering, then compares upon login) and for strongly encrypting other data.

As for what you said, SQLite has extentions such as SQLiteCipher and wxSQLite3, though I am willing to encrypt date before writing in exchange for stronger encryption. Will see how it goes. 

[LemonParty]

https://wiki.freepascal.org/SQLite#Support_for_SQLite_encryption

[cdbc]

Hi
I'd go with DCPCrypt (New version on github surfaced last week) and SQLite3.
I use this combo for desktop apps and it works really well =^
Regards Benny

[C0m3b4ck]

Hi
I'd go with DCPCrypt (New version on github surfaced last week) and SQLite3.
I use this combo for desktop apps and it works really well =^
Regards Benny

Thank you Benny! I did decide to use DCPCrypt due to its various encryption modules and support for both FPC 2.4.4 and 3.0.0