6 ms·
So forgive my very basic question here, I’m coming from mobile dev world. But can I: 1.) Use Clickhouse as infrastructure to build a product similar to MixPane
by pixel_tracing 5y ago
So forgive my very basic question here, I’m coming from mobile dev world. But can I:
1.) Use Clickhouse as infrastructure to build a product similar to MixPanel / Amplitude
2.) If I wanted a basic MVP of above can anyone point to me in steps (like 1., 2., 3., etc.) on what I would need to do to have a basic MVP ready. (Note: I am already very familiar with Docker, Kubernetes and writing rest APIs)
Would greatly appreciate this since it would clear up a lot of questions I have
- timgl 5y ago1) Essentially yes! You'll have to write SQL queries yourself 2) You'd want to have some way of sending events (simple api) to a Kafka cluster which would be read by Clickhouse, then you'd be able to query the data using metabase or datagrip. (Or you can use PostHog, which has essentially done all this for you and has all the functionality that Mixpanel/Amplitude has, but you're able to self host it!)
- pixel_tracing 5y agoYou are a god send thank you. Can you explain this in a little more detail: “Which would be read by Clickhouse” are talking about something like a Kafka connector? Or some Ksql type query?