Lets Install PostgreSQL on Windows for Data Science and Trading

Todays topic is installing and getting PostgreSQL ready for work on Windows (10 or 11) for local network use and ODBC remote access over the internet.

In a video to come we will set up a database and start to create queries that will allow us to create a traders statistical dashboard.

Background:

I have a fairly extensive workflow that has been mostly manual and uses Microsoft SQL Express, which is Microsoft's very capable and free version of SQL Server that people can use on home PC's and laptops. I do not have time to figure out work arounds and bash scripts to automate data ingestion and a range of other small annoying administration tasks that SQL Express forces me to do.

This series will be demonstrating a migration of vanilla SQL, and moving over to a combination of Python and PostgreSQL to more automate administration and data ingestion tasks, and perhaps improve performance by using Python in place of some SQL functions.

SQL is a brilliant language and is easy to learn especially ChatGPT, which we will utilize extensively in this series, along with identifying areas that would be more efficiently processed with Python Scripts.

Remember, when we work with complex data, we want to make everything as easy and simple as possible, because if it breaks we do not want to have to work through complex set ups and figure out what went wrong, we simply want to update the core components forget about it until next time. So we will always focus on robust IT and Network set ups, to minimize maintenance and change management tasks. If you cant remember something it will break, so stop being a nerd jerk and get on with it.