Build a Real Bank on Your Laptop | PostgreSQL + 5 Million Payments | Episode 1

#DataEngineering #PostgreSQL #Docker A real bank, on your laptop. PostgreSQL 16 in Docker, 20 tables, and 5 million payments that keep arriving while you watch. This is Episode 1 of the series. We do not open Snowflake yet. First the source has to be alive. Code and setup guides: https://github.com/fkhambaty/snowflak... Mac: https://github.com/fkhambaty/snowflak... Windows: https://github.com/fkhambaty/snowflak... You will install the tools, start PostgreSQL, build the bank, connect with DBeaver, and see bronze, silver and gold on one payment. Run these from the repository folder: docker compose -f 01_source_postgres/docker-compose.postgres.yml up -d python3 setup/start_postgres.py python3 setup/verify_setup.py Windows: py -3.12 setup\start_postgres.py py -3.12 setup\verify_setup.py DBeaver: localhost, port 5432, database meridian_core, user meridian, password meridian. Then, inside DBeaver: SELECT * FROM core.sim_tick(500); Next episode: draw the warehouse on paper before opening Snowflake. Watch the intro first if you are new to the series.