[{"_1":2,"_165":-5,"_166":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_140":141},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_131":-5,"_132":11,"_133":17,"_134":11,"_135":-5,"_136":11,"_137":-5,"_138":139},"canonicalUrl","https://hub.docker.com/r/lgili/sqlcipher/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","lgili","reponame","sqlcipher","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2022-08-06T17:32:39.017152Z","description","Easy Encrypt and Decrypt databases with SQLCipher.","is_private","last_updated","2022-08-06T22:03:17.292547Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",943,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# About This Image\n\nEasy Encrypt and Decrypt [SQLite](https://www.sqlite.org) databases with [SQLCipher](https://www.zetetic.net/sqlcipher).\nBased on [pallocchi/docker](https://github.com/pallocchi/docker).\n\n# How to Use this Image\n\nThis image contains 3 utils `csv2sqlite` (convert csv to sqlite), `sqlenc` (encrypt) and `sqldec` (decrypt) that do the hard work for you.\n\n### Convert to sqlite\n\n```bash\ndocker run -v :/sqlcipher lgili/sqlcipher csv2sqlite

\n```\n\n### Encrypt\n\n```bash\ndocker run -v :/sqlcipher lgili/sqlcipher sqlenc

\n```\n\n### Decrypt\n\n```bash\ndocker run -v :/sqlcipher lgili/sqlcipher sqldec

\n```\n### Parameters\n\n| Name | Description |\n|----------------------------|---------------------------------------------------------------------------------------------------------------------|\n| `workdir` | Local directory where `db-plain` is present and `db-encrypted` will be created. |\n| `csv-file` | Filename of the csv to convert to sqlite (must be present in `workdir`). \n| `db-plain` | Filename of the database to encrypt (must be present in `workdir`). |\n| `db-encrypted` | Filename of the encrypted database which will be created. |\n| `passphrase` | Passphrase used by SQLCipher to encrypt the database |\n\n## Example\n\nOur database to encrypt is in `./databases`directory.\n\n```bash\n$ ls databases\n$ file.csv\n```\nConvert csv file to the sqlite, generating the `my-data.db3` file.\n\n```bash\n$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher csv2sqlite file.csv my-data.db3 table\n```\nVerify that the new database was created.\n```bash\n$ ls databases\n$ file.csv my-data.db3\n```\n\nEncrypt the database, generating the `my-encrypted.db3` file.\n\n```bash\n$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher sqlenc my-data.db3 my-encrypted.db3 password\n```\n\nVerify that the new encrypted database was created.\n\n```bash\n$ ls databases\n$ file.csv my-data.db3 my-encrypted.db3\n```\n\nLet's decrypt the previously generated database.\n\n```bash\n$ docker run -v ${PWD}/databases:/sqlcipher lgili/sqlcipher sqldec my-encrypted.db3 my-decrypted.db3 password\n```\n\nVerify that the new database was created.\n\n```bash\n$ ls databases\n$ file.csv my-data.db3 my-encrypted.db3 my-decrypted.db\n```\n\n# Feedback\n\nPlease direct all feedback to [lgili/sqlite-sqlcipher-docker](https://github.com/lgili/sqlite-sqlcipher-docker/issues).\n\n\n\n\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",66578898,"orgData","recentTags",[87,125],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":98,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",7223522,"digest","sha256:e2db4b1b3a12cdd2a854179d5ca609fd494116a1fa762e0cccbdac34cf878cde","full_size",66570525,"id",267755319,"images",[99],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},"architecture","amd64","features","","last_pulled","2026-09-23T11:07:54.441694372Z","last_pushed","2022-08-06T22:03:15Z","os","linux","os_features","os_version","size","variant","2022-08-06T22:03:17.287416Z","last_updater","last_updater_username","media_type","latest","repository",17769939,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_88":40,"_89":90,"_91":92,"_93":94,"_95":126,"_97":127,"_46":129,"_115":90,"_116":29,"_117":52,"_53":130,"_119":120,"_121":105,"_122":129,"_123":62,"_124":17},267711130,[128],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},"2022-08-06T22:03:14.990005Z","22.04","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":142,"_149":150,"_138":163,"_164":11},{"_36":143,"_38":144,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":145,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":146,"_75":11,"_76":148,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":147},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_151":152,"_153":-5,"_154":-5,"_155":156},"count",2,"next","previous","results",[157,160],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_97":158,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[159],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},{"_88":40,"_89":90,"_91":92,"_93":94,"_95":126,"_97":161,"_46":129,"_115":90,"_116":29,"_117":52,"_53":130,"_119":120,"_121":105,"_122":129,"_123":62,"_124":17},[162],{"_100":101,"_91":92,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":94,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

lgili/sqlcipher

Tags for lgili/sqlcipher