Skip to content

BazaroZero/DBeditor

Repository files navigation

DBeditor

.github/workflows/test.yaml codecov Code style: black

Easy to use SQL databases editor with minimalistic design

Install

git clone https://github.com/BazaroZero/DBeditor.git
pip install -r requirements.txt

Usage

python dbeditor.py

Features

  • Menu file:
    • Open database (SQLite), create database (SQLite) and connect to remote database (MySQL or PostgreSQL)
    • Import data from csv and excel
    • Save added tables and inserted rows
  • Menu structure:
    • Add new table
    • Add new columns (currently not allowed to add columns to existing tables)
    • Drop table
  • Menu Settings:
    • You can choose how to find row in your table: by rowid or by primary keys (this affects editing and deleting values)
  • Menu tables:
    • After opening the database, the menu will list your tables
  • Right-click context menu:
    • Insert row
    • Open custom query window (It's unable to query unsaved table)
    • Delete row

About

🛠️ Yandex Lyceum PyQT5 project

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Contributors 2

  •  
  •  

Languages