This project sets up a containerized data stack using Docker Compose, PostgreSQL, SQLAlchemy, and Metabase. It demonstrates how to design a relational database, perform SQL-based analysis, and create ...
Designed and implemented a modular ETL pipeline in Python to extract data from a REST API, transform and normalize JSON structures, and load processed data into PostgreSQL using SQLAlchemy. Focused on ...
Multi-tenancy is an architecture where we use one instance of a software and serve multiple tenants (clients) I had to implement multi-tenancy architecture in PostgreSql, Python/Flask. However I haven ...
This is the recommended way to run the application, as it sets up all services (API, PostgreSQL, Redis, Celery) automatically. WARNING: This script will DROP ALL EXISTING TABLES AND DATA in your ...