Show HN: GraphJSON – Easily log and analyze events using ClickHouse
Hi HN,<p>My name is JR and I had a need for a simple analytics solution that allowed me to store (timestamp, json) logs and run SQL over them.<p>It was hard to find the right solution. Solutions like Mixpanel and Amplitude optimized for particular report types. Whereas solutions like Snowflake, BigQuery, etc. required a lot of setup.<p>I built GraphJSON to fit in the middle. I strived for the ease of use of tools like Mixpanel and Amplitude, but wanted to ensure affordances were built to support use cases that big data warehouses enable.<p>Under the hood, GraphJSON is powered by ClickHouse. This enables really efficient disk compression and fast queries. In many ways, you can think of GraphJSON as an easy way to explore ClickHouse without having to run and maintain your own clusters.<p>I&#x27;d love for you to give it a try. You can generally start logging your data in under a minute. From there, you can either use the UI tooling to create graphs in a no-code way. Or if you&#x27;re more advanced, you can use the SQL editor to do any query you can think of!