Stop running analytics on your transactional DB.
Our latest post with the @ClickHouseDB team shows how to kill loading spinners in your @reactjs app by moving slow analytical queries from Postgres/MySQL/Mongo → ClickHouse:
- Mirror data from Postgres/MySQL → ClickHouse w/ ClickPipes
- Import ClickHouse schemas into TS Code with Moose OLAP
- Build type-safe APIs + auto-generated React SDKs to query typed schemas
- Develop on a local replica of prod with realistic data
- 1-click deploy w/ Boreal
Blog: https://t.co/YItHCj81Ka
Repo: https://t.co/n8PaNM9N2L
#ClickHouse #DataEngineering #TypeScript #OLAP
Add fast analytics to your @reactjs front-end without messing w your existing transactional backends
OLTP → CDC → @ClickHouseDB + MooseStack → React front end
Guide: https://t.co/qxpPHyGvid
Repo: https://t.co/dQPsEF7tL9
#ClickHouse#TypeScript
Built analytics on Postgres? You know what happens next: works great initially, then queries slow down as you scale.
https://t.co/fhRRSuCiVq
Here's how to add ClickHouse speed without a full rewrite:
- Keep Postgres as source of truth
- CDC sync to ClickHouse
- TypeScript APIs with MooseStack
- Auto-generated React clients
Data infra needs its Rails moment.
Our take with @ClickHouseDB: 8 principles of great DX for data & analytics infra →
https://t.co/BGaBVv8jir
Shout out to pioneers of the modern web dev experience for inspiration — @rails, @nextjs, @tan_stack, and @supabase
Give the repo a star if you think its interesting: https://t.co/bVPwPUJTJA
Git-native ✓
Local-first ✓
Schemas as code ✓
Open source ✓
AI copilot ready ✓
Transparent migrations ✓
Modern DX for data infrastructure → https://t.co/EovhFupJ6O
An ORM for ClickHouse? Let's look at the open-source, MIT-licensed project Moose OLAP from @514hq. Inspired by the likes of SQLAlchemy, Drizzle and Prisma, it adapts the ORM experience to work on analytical databases like ClickHouse.
https://t.co/l6KjfOs3wR