Easy Encrypt and Decrypt databases with SQLCipher.
943
Easy Encrypt and Decrypt SQLite databases with SQLCipher. Based on pallocchi/docker.
This image contains 3 utils csv2sqlite (convert csv to sqlite), sqlenc (encrypt) and sqldec (decrypt) that do the hard work for you.
docker run -v <workdir>:/sqlcipher lgili/sqlcipher csv2sqlite <csv-file> <db-plain> <table-name>
docker run -v <workdir>:/sqlcipher lgili/sqlcipher sqlenc <db-plain> <db-encrypted> <PASSPHRASE>
docker run -v <workdir>:/sqlcipher lgili/sqlcipher sqldec <db-encrypted> <db-plain> <PASSPHRASE>
| Name | Description |
|---|---|
workdir | Local directory where db-plain is present and db-encrypted will be created. |
csv-file | Filename of the csv to convert to sqlite (must be present in workdir). |
db-plain | Filename of the database to encrypt (must be present in workdir). |
db-encrypted | Filename of the encrypted database which will be created. |
passphrase | Passphrase used by SQLCipher to encrypt the database |
Our database to encrypt is in ./databasesdirectory.
$ ls databases
$ file.csv
Convert csv file to the sqlite, generating the my-data.db3 file.
$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher csv2sqlite file.csv my-data.db3 table
Verify that the new database was created.
$ ls databases
$ file.csv my-data.db3
Encrypt the database, generating the my-encrypted.db3 file.
$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher sqlenc my-data.db3 my-encrypted.db3 password
Verify that the new encrypted database was created.
$ ls databases
$ file.csv my-data.db3 my-encrypted.db3
Let's decrypt the previously generated database.
$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher sqldec my-encrypted.db3 my-decrypted.db3 password
Verify that the new database was created.
$ ls databases
$ file.csv my-data.db3 my-encrypted.db3 my-decrypted.db
Please direct all feedback to lgili/sqlite-sqlcipher-docker.
Content type
Image
Digest
sha256:e2db4b1b3…
Size
63.5 MB
Last updated
about 4 years ago
docker pull lgili/sqlcipher