Skip to content

Latest commit

 

History

History
36 lines (26 loc) · 1.33 KB

README.md

File metadata and controls

36 lines (26 loc) · 1.33 KB

🏦 Python SQL Banking App

A simple console-based banking system built with Python and SQLite, designed to showcase secure data handling, database integration, and clean code structure.
This project was originally built for a college course and later refactored to use SQL for persistent storage, along with CSV audit logging and preloaded test accounts for quick testing.

🚀 Features

  • 🔐 Secure 4-digit PIN hashing (SHA-256) — no plaintext PINs stored
  • 🧾 Checking and Savings accounts with deposits, withdrawals, and balance updates
  • 🧠 Basic statistics — view average balances and users above the average
  • 📝 CSV transaction audit logging for transparent tracking
  • 👤 Interactive account creation and deletion via the console menu
  • 🧪 Three preloaded test accounts for instant use:
    • alice / PIN: 1111
    • bob / PIN: 2222
    • carla / PIN: 3333

🧰 Tech Stack

  • Language: Python 3
  • Database: SQLite (bank.db created automatically)
  • Audit Logging: CSV (transactions.csv auto-generated)
  • No external libraries — runs out of the box using only the Python standard library

🧪 How to Run

git clone https://github.com/alenchavez-dev/python-sql-banking-app.git
cd python-sql-banking-app
python3 main.py