/The-Blue-Database

SQLite3 wrapper desktop application written in Python 3. Allows for creation and updation of tables and databases stored as local files

Primary LanguagePython

The Blue Database

The Single Desktop App for:

  • Creating on-the-go Excel Files
  • Creating, editing and saving secure and stable SQL tables in custom databases
  • Creating and Accessing SQLite Databases
  • Playground for learning how SQLite3 works

App created using the following technologies:

  • Python3
  • Tkinter
  • SQLite3
  • python-csv

image

Home page for The Blue Database

This project is a SQLite visualizer of sorts that wraps most functionalities that SQLite3 offers into an easy to use GUI.

Current features include:

  1. Initializing tables and databases and opening existing tables within databases
  2. Creating columns with specific datatypes
  3. Initializing PRIMARY KEY column to delete or alter later
  4. Viewing all rows within columns within a table
  5. Adding new rows to existing tables
  6. Changing name of table
  7. Deleting from (PRIMARY KEY) tables
  8. Geting single records from table
  9. Converting table into a csv file

image

Pop up to open or create a new database/table

image

Pop up to perform queries on an existing table within a database