The Moment I Realised a Database Is Not a Data WarehouseThis article is part of a series documenting the development of a real-time crypto analytics platform.6 min read·andreaparisdata.hashnode.devJun 11
Building a Real-Time Crypto Analytics PlatformHow I built a real-time cryptocurrency analytics platform using Kafka, Spark, PostgreSQL, Airflow, and modern analytics engineering practices.6 min read·andreaparisdata.hashnode.devJun 10
Week 1: Building the Dataset (Harder Than Expected)We’re still figuring out what this project is going to become. I’m working with Zoe (data scientist), and my role is to build the dataset — daily stock data for a selection of energy companies so we c6 min read·andreaparisdata.hashnode.devApr 19
I Thought I Understood Databases — Then I Built One ProperlyI thought I understood databases. I had written SQL queries, built tables, and used them in projects. But everything I knew was limited to querying data - not managing it. So I decided to build a comp5 min read·andreaparisdata.hashnode.devApr 15
Building an ETL Pipeline in Bash (and What I Learned)Learn how to build a simple ETL pipeline in Bash to collect, transform, and analyse real-world weather data.5 min read·andreaparisdata.hashnode.devApr 8
