How to encrypt a database using Python and sqlite?

2.6k views Asked by At

I've got a web app which using Flask, python3, sqlite and sqlalchemy but before I deploy I want to encrypt the contents of the database. I've googled and read on here that pysqlcipher is the route to go (happy to choose another option if this is incorrect) but am falling down at the first hurdle:

pip3 install pysqlcipher3
Collecting pysqlcipher3
  Using cached pysqlcipher3-1.0.2.tar.gz
Building wheels for collected packages: pysqlcipher3
  Running setup.py bdist_wheel for pysqlcipher3 ... done
  Running setup.py clean for pysqlcipher3
Failed to build pysqlcipher3
Installing collected packages: pysqlcipher3
  Running setup.py install for pysqlcipher3 ... done
Successfully installed pysqlcipher3

Then trying in python3:

Python 3.6.1 (v3.6.1:69c0db5050, Mar 21 2017, 01:21:04) 
[GCC 4.2.1 (Apple Inc. build 5666) (dot 3)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import pysqlcipher3
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ModuleNotFoundError: No module named 'pysqlcipher3'

I can't find instructions or a simple example to get my started. Any ideas?

0

There are 0 answers