Skip to content

Neliz3/managing_db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Managing db | web-site for the wholesale database

Web-site in Python using Flask, PostgreSQL and gspread library

Table of contents

Setup

  • All packages are located in requirements.txt
  • Environmental variables are located in .env

Technologies Used

  • Python 3.8
  • Flask
  • Flask-SQLAlchemy
  • PostgreSQL
  • JavaScript
  • Bootstrap

Installation

python3 -m venv env
. env/bin/activate
pip install -r requirements.txt
sudo service postgresql start
python run.py

Requirements

pip install load-dotenv
pip install Flask
pip install Flask-SQLAlchemy
pip install psycopg2-binary
pip install gspread

Database managing

sudo -i -u postgres
psql managing_db

Room for improvement

Future features

  • Adding new languages
  • Adding feature for an admin to do more actions

Future changing

  • Rebuild a database structure for more opportunities (adding some tables)