Welcome onboard everyone. Wishing u all a great learning experience.
How to get started? Here are some pointers. N.B. Whenever u have any suggestions/modifications or better alternatives to these pointers, please share them with us. These pointers won't work for everyone. I need your feedback and suggestions so that we can together create a starting guide that is as conclusive and useful as possible.
First thing: We need to set up our local machines.
For Linux/Mac users, getting started is much easier.
For windows users, I highly recommend windows subsystem for linux (WSL)
This hopefully would make ur life much easier throughout the course and even after it.
The transition to WSL is fairly easy through this link. WSL for windows 10 You will keep on using windows on ur laptops while having an additional way to run linux commands through the terminal.
The transition has saved me hours and hours.
If you wish to use windows, which again I don't recommend, upgrade to windows 10 and check the links below.
How to install PostgreSQL - 13 on windows 10 | 2020 - YouTube
Getting Started with PostgreSQL for Windows | 2021 - YouTube In this video you will learn how to:
- Install PostgreSQL on Windows
- Use PSQL - through psql shell not from cmd or powershell
- Use PGAdmin
- CRUD operations
Open postgreSQL command line through command prompt in windows PC - YouTube
How to start and stop PostgreSQL server? | TablePlus
Reset PostgreSQL password on Windows if u have forgotten it - ChillyFacts
Creating user, database and adding access on PostgreSQL - YouTube
PostgreSQL - How to Create a PostgreSQL Superuser or alter a user to become a superuser- YouTube This can work for both windows and linux, as the commands are from psql itself.
try it step by step. if a step fails, go to the next one till one of them succeeds.
1- pip3 install psycopg2-binary
2- Installing psycopg2 on Windows (2018 update) - YouTube
use pip3 install psycopg2-binary instead of pip install psycopg2
3- Installing psycopg2 on Windows (older versions) - YouTube
use pip3 install psycopg2-binary instead of pip install psycopg2
(3) How to Install and Use Flask on Windows for Beginners (2019) - YouTube
Setting up PyCharm on Windows - YouTube
PostgreSQL In Windows Subsystem for Linux (WSL) | by Harshit Yadav | Medium
How to create postgresql user and database (both from terminal and from psql) - YouTube
How to start and stop PostgreSQL server? | TablePlus
PostgreSQL - How to Create a PostgreSQL Superuser or alter a user to become a superuser- YouTube This can work for both windows and linux, as the commands are from psql itself.
Windows Powershell vs Command Prompt: What's The Difference Anyway? - YouTube
The NEW Windows Terminal is Finally Released! - Here's Why It's Awesome - YouTube