PyCon AU 2024 encrypted data vault tutorial

Code that accompanies the Monday November 25 tutorial How to secure, break, and re-secure an encrypted data vault using Python and PostgreSQL at PyCon AU 2024

Quickstart

Make sure you have these dependencies installed:

• Python
• git
• Docker

Then run the app:

# Clone the repo
git clone https://github.com/cipherstash/pyconau2024-tutorial
cd pyconau2024-tutorial

# Install dependencies
python3 -m venv .venv
. .venv/bin/activate
pip install -r requirements.txt

# Start the database
docker compose up -d

# Setup the database schema and fake data
python init_db.py

# Run the app
flask run --debug

Now query the API:

# List all users
curl http://127.0.0.1:5000/users

If you need to reset the database at any point, run:

python init_db.py

Development

To update dependencies:

# Make sure the virtualenv is activated
. .venv/bin/activate

# Install the new dependency
pip install -U Flask-SQLAlchemy

# Update requirements
pip freeze > requirements.txt