Skip to content
 
 

Repository files navigation

Repo Size Issues Visits Stars Python SQLite3 SQLite3

A Python + SQLite3 mini banking system demonstrating real-world backend logic and CRUD operations.


dbankite3 is a beginner-friendly database-driven banking application built using Python and SQLite3. It simulates core banking operations through a command-line interface (CLI) and demonstrates how real-world systems manage persistent data securely.

🎯 Ideal for learning Python database integration, CRUD operations, and backend logic fundamentals.


✨ What This Project Does

This project allows users to interact with a simple banking system where account and transaction data is stored permanently in a database.

With dbankite3, you can:

  • 🏦 Create and manage bank accounts
  • 💾 Store account data persistently using SQLite3
  • ➕ Deposit money into an account
  • ➖ Withdraw money safely with balance checks
  • 📊 View stored account information
  • 🔄 Update records directly in the database
  • 🧠 Understand how backend systems work internally

All operations are handled using Python’s sqlite3 module, making this project lightweight and easy to run.


🧠 Learning Outcomes

By exploring this project, you will learn:

  • How to connect Python with SQLite databases
  • How CRUD operations work in real applications
  • How data persistence differs from in-memory programs
  • How banking-style logic is implemented safely
  • How backend systems manage structured data

This project forms a strong base for upgrading to:

  • MySQL / PostgreSQL
  • Flask / Django web applications
  • REST APIs
  • Full-stack projects

🛠️ Tech Stack

Technology Purpose
Python Core programming language
SQLite3 Lightweight embedded database
CLI (Terminal) User interaction

🚀 Getting Started

⚡ Quick Start (No Installation Required)

You can download and run the release executable file (dbankite3.exe) without any installation:

  1. Download the latest .exe file from the Releases page
  2. Double-click dbankite3.exe to run the application directly
  3. No Python installation or dependencies required!

🎯 Recommended for users who just want to use the application without setting up a development environment.


🔧 Prerequisites (For Development)

  • Python 3.13 or higher
  • Basic knowledge of Python (recommended)

Check Python version:

python --version

📥 Installation (For Development)

1️⃣ Clone the repository

git clone https://github.com/ViratiAkiraNandhanReddy/dbankite3.git
cd dbankite3

2️⃣ (Optional but recommended) Create a virtual environment

python -m venv venv
source venv/bin/activate      # Linux / macOS
venv\Scripts\activate         # Windows

3️⃣ Install dependencies

pip install -r requirements.txt

▶️ Usage

Run the application using:

python main.py

The program will guide you through available banking operations via the terminal.

📌 Since this is a CLI project, all interactions happen through user input in the terminal.


🔄 How It Works (Internals)

  1. The application establishes a connection to an SQLite database
  2. User actions trigger SQL queries
  3. Data is inserted, updated, retrieved, or validated
  4. Changes are saved permanently in the database
  5. Results are displayed instantly in the CLI

This mimics how real banking systems handle backend operations (on a smaller scale).


🎯 Use Cases

  • 📘 Academic / learning project
  • 🧑‍💻 Python + Database practice
  • 🗃️ Understanding CRUD operations
  • 💼 Portfolio backend project
  • 🚀 Base project for scaling into web apps

🤝 Contributing

Pull requests are welcome!

To contribute:

  1. Fork the repository
  2. Create a new branch
  3. Add your changes
  4. Open a PR

⭐ Support

If you like this project, consider giving it a star ⭐ on GitHub — it helps a lot.


🌐 Social & Links

LinkedIn X Instagram Facebook Gist YouTube Website Mail


📝 License

© 2025 ViratiAkiraNandhanReddy. This project is licensed under the MIT License.


👤 Author

💤 - PASSIVE MAINTENANCE : Mean the project is no longer actively developed ( NO New Features And Regular Updates ), but the maintainer will respond only when an issue or PR is raised. Feel free to fork and continue development!


🌟 Questions, suggestions, or want to contribute? Open an issue or pull request on GitHub! 🌟

About

A lightweight Python banking simulator that lets users perform core banking operations like deposits, withdrawals, and balance tracking. It’s ideal for learning basic finance logic and simulating account interactions in a simple CLI app with clear structure and MIT licensing.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages