A solution to minimizing the number of BU courses you have to take to fulfill HUB Requirements
python3.9 -m pip install --upgrade pip
python3.9 -m venv venv
source venv/bin/activate
pip install Flask
pip install python-dotenv
pip install psycopg2
pip install flask_sqlalchemy
pip install flask-cors
npm install -g @angular/cli
You must use two separate terminals so you can run the frontend in one and the backend in the other.
python3.9 app.py
cd frontend
ng serve
- Connecting to a certain DB as a specific user
psql -U username -d database_name
- Listing data tables
\dt
- Showing data table schema
\d table_name
- Showing roles of DB
\du
- Showing data within a data table
SELECT * FROM table_name;
- Access to 127.0.0.1 was denied ( visit
chrome://net-internals/#sockets
andFlush socket pools
)