I am a CS engineering student and I'm just starting my final career project. One of the core topics that will cover will be security and, because the large amount of data that the application will handle, a RDBMS will be used to handle it. I was wondering which other RDBMSs support encryption to make the data be stored safely. In my personal experience, I used MySQL (learned through my studies) and SQLite (self-learned) + SQLCipher (self-learned, for adding encryption to SQLite). What I know of each system is:
SQLite + SQLCipher
- (+) Embedded and small footprint
- (+) Seamless integration with major programming languages (programatically)
- (+) By using SQLCipher, adds AES encryption which encripts all the database at once (including the
sqlite_mastertable, which is the core table) - (-) Without proper handling, database deadlocks itself (if not compiled properly it won't support multithreading).
- (-) Not suitable for servers.
MySQL
- (+) Great choice for servers (parallel transactions support)
- (+) Seamless integration with major programming languages (through sockets & ODBC)
- (-) Encrypts data at element level (cannot encrypt table columns' names, full tables, databases -including the core database
mysql-, or the entire system)
I'd like to know whether are other choices that matches the best of both worlds: encryption at highest level possible, easy integration with the application (portable installations are very welcome), and be eligible for using in a server (support of parallel transactions). Other restrictions are: Open Source or free personal use, Win/Linux, Python integration.
Thanks in advance!
Aucun commentaire:
Enregistrer un commentaire