Skip to content

Releases: TamerOnLine/postgres_study_project

🎉 Initial Release – PostgreSQL CLI Admin Toolkit

15 Jun 23:57
Compare
Choose a tag to compare

This is the first official release of the PostgreSQL Study Project – a modular and educational CLI toolkit built in Python for managing PostgreSQL databases.

🚀 Features Included:

  • ✅ Interactive CLI launcher (main.py)
  • 🧱 SQLAlchemy models (Product, User)
  • 🧩 Modular tools for:
    • Creating and dropping databases
    • Creating or wiping tables
    • Performing backups and restores via pg_dump / psql
    • Viewing table contents
  • 🧪 Multi-database support (PostgreSQL, MySQL, SQLite)
  • 🌿 .env support via python-dotenv
  • ⚙️ GitHub Actions CI: test DB connection, backup, restore

Proudly crafted by @TamerOnLine