Technically

Technically

What's a data warehouse?

Where warehouse workers means something else

Justin's avatar
Justin
Aug 04, 2020
∙ Paid

The TL;DR

A data warehouse is a special type of database designed for analytics instead of transactions. 

  • There are two types of database use cases: transactional and analytical

  • Transactional databases like PostgreSQL are built for adding, updating, and removing data, but analytical DBs are for complex queries and joins

  • Data gets moved from transactional to…

User's avatar

Continue reading this post for free, courtesy of Justin.

Or purchase a paid subscription.
© 2025 Justin · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture