Simple ETL Project for beginners
Setting up PostgreSQL using docker
PostgreSQL docker
Setting up PostgreSQL using docker
PostgreSQL stands out as one of the top choices among open-source relational databases in today’s market. As a data engineer, SQL is a language I constantly engage with. Whether it’s crafting quick prototypes using Streamlit or whipping up dashboards with tools like Metabase or Apache Superset, having a local database to load datasets is essential.
Setting a sample database on PostgreSQL
Setting up PostgreSQL for analytics
In our previous article, we set up PostgreSQL on our local machine. Now, we’re diving into the exciting task of inserting sample cricket data, which will be instrumental in crafting a dynamic dashboard. The setup process is designed to be straightforward, ensuring everyone can follow along easily. The dataset spans from the inaugural edition of the IPL to the most recent one.
