Blog
Posts in category: oltp
OLAP, OLTP, ORM
Just OLAP it: derive an OLAP data model from your OLTP ORM
Most developers love their ORMs — but what happens when you move from transactional (OLTP) to analytical (OLAP) workloads? This post explains how to reuse your existing TypeScript ORM types (from Drizzle, Prisma, or TypeORM) to build OLAP-ready schemas in ClickHouse using MooseOLAP. You’ll learn how to make implicit OLTP assumptions explicit, add OLAP-specific semantics like strict types and partitioning, and keep type safety while achieving true analytics performance.
OLAP, OLTP, ClickHouse, Redpanda
Code first CDC from Postgres to ClickHouse with Debezium, Redpanda, and MooseStack
Learn how to keep OLTP fast while streaming changes to ClickHouse for lightning-quick analytics. This code-first guide uses Debezium, Redpanda, and MooseStack to model CDC, transforms, and OLAP tables you can spin up locally in seconds.