Skip to content

Database for AutoCompany, built with PostgreSQL. Application in Python3+Tkinter as a graphical frontend to it. Coursework for 3 semester.

Notifications You must be signed in to change notification settings

genndy007/auto-company-db-gui

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

AutoCompany Database application

About

This application is to present the contents of tables. The database was created
and filled with PostgreSQL DBMS (used psql-shell and pgAdmin4)

Requirements

Install PostgreSQL

# Ubuntu
# Add repo
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
# Download and add key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
# Update 
sudo apt-get update
# Install
sudo apt-get -y install postgresql

Programming languages:
Nothing but python3 and tkinter

Install tkinter if needed

sudo apt install python3-tk   # Ubuntu, Debian

Oh, yes... You need that database

  1. Use psql
> \i tables.sql
> \i fill.sql

OR run commands from sql files at pgAdmin4

  1. Create a file database.ini (in project folder :) ) with such contents:
    [postgresql] host= database= user= password=

Run

python3 app.py

How to use

Run and press buttons to show the contents of tables filled by PostgreSQL
and feel happy :)

About

Database for AutoCompany, built with PostgreSQL. Application in Python3+Tkinter as a graphical frontend to it. Coursework for 3 semester.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages