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.
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.
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.
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.
I'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're more advanced, you can use the SQL editor to do any query you can think of!
I also have a GraphJSON importer in pyground (pyground.vercel.app), which lets you load a GraphJSON collection into Python in-browser and use eg. pandas/matplotlib to poke at it too.
So, if you're a developer and you want a Mixpanel-style API to send events, and then a secure way to query them for individual customer accounts, and embed dashboards in your SPA, you can do all this, with some nice data visualization / chart building tools inside GraphJSON.
Amplitude and Mixpanel were the go-to's I had heard of when starting my company. Amplitude makes you schedule a sales call, so Mixpanel it was. One of our engineers filed a bug affecting our dashboard in a significant way, and after many months, no movement. That + some other persistent bugs, I was having a bad time.
I was able to migrate everything in one call with JR. He's responded to all my emails in O(hours). I'm paying way less than I was, and have 100% parity with what I was using Mixpanel for. I'm sure there exists features on Mixpanel that don't on GraphJSON; we just haven't hit it yet. Highly recommend.
Honestly as a dev all I want is a simple/fast/cheap keen alternative that I can dump events into and do ad-hoc analytical queries with programmatically.
I’m not sure I understand the pricing: the FAQ talks about a "free tier" but the Pricing page shows only a $12/mo tier.
The pricing page could definitely use some work. To clarify - there is a free forever tier of 5k events. If you go over, then the only available tier is the $12/mo per million events tier.
curious to know if you are using the newly introduced JSON Type?
At work we run a small CH cluster ( 10 TB+ Data ) and the functions for Working with JSON consume too much CPU resources.
Regarding the JSON column type - we're waiting for it to become more battle tested before introducing it in prod. So far we've been scaling by adding more compute since CH scales pretty well horizontally. One nice thing about multi-tenancy is the queries per user are generally spiky and rare. So all GraphJSON users get to share one beefy cluster instead of every user buying their own.