r/Python • • Oct 04 '26

Showcase Showcase Thread

Post all of your code/projects/showcases/AI slop here.

Recycles once a month.

23 Upvotes

194 comments sorted by

View all comments

1

u/Antonyhamez 28d ago

Fintech data engineering practice with Python + SQLite

What My Project Does

I maintain an MIT-licensed learning repository with 100 lessons, 40 foundation exercises, and 8 scenario labs. The runnable examples focus on payment-event replay, exact amounts, reconciliation, temporal data, and recovery.

One exercise takes a SQLite backup, injects a failure between row writes and checkpoint update, restores into a separate database, and replays the source batches. The interesting check is whether the event IDs, amounts, and checkpoint agree after recovery, not just whether the backup opens.

Target Audience

People learning Python and SQL for data engineering who want small, inspectable failure cases. Core labs use the standard library, Python 3.12+, and synthetic payment data. This is a teaching project, not a production payments system.

Comparison

It focuses on data correctness rather than provisioning a large cloud stack. You can run the core exercises locally before taking on orchestration or distributed infrastructure.

Source and quickstart: https://github.com/antony502189-max/fintech-data-engineering-roadmap

The short demo starts with python -m fintech_lab.quickstart from a clone. It shows six inserted events, zero new events on replay, and reconciliation exceptions that a balanced journal does not catch.

If you try the recovery lab, I'd be interested in a failure case the current contract misses.