Looks great as a self-host alternative if/when you make self-hosting feasible.
Show HN: Openpanel – An open-source alternative to Mixpanel
11–20 of 102 posts
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#12This doesn't seem to be buffering inserts to ClickHouse: https://github.com/Openpanel-dev/openpanel/blob/c90848765a6a... So any major website will have problems with it. I would suggest moving this into a stream (NATS, Kafka) or just having some sort of service that buffers events, then offloads to Clickhouse in batch.
Correct! Currently no batching but no need to make things complicated for now.
Can extend the current redis queue to batch request or clickhouse batch engine.
Looking forward to have these problems hehe.
Please DM if you want to chat about best approach!
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#13Looks great as a self-host alternative if/when you make self-hosting feasible.
When*
Before beta is over it’ll be easily self-hosted.
But since it free now there is no need for self-hosting.
Will make it easy to export/import your events between instances
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#14Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#15Earlier quoted context omitted.
Thanks! Similar to how Plausible is doing. Each user gets a unique identifier which is based on `hash(domain+useragent+ip+salt)` (the salt is generated each day).
That does create clusters for users that work at the same company, with the same company-issued devices. Or iPhones in a New York City block.
A bit more factors tbh. User agents have browser, version etc.
iPhone in New York block still have different IP, versions etc
But I hear you, it’s better than cookies and that’s the entire point.
You can also provide a user id, more info here https://news.ycombinator.com/item?id=40434115
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#16Earlier quoted context omitted.
Thanks! Similar to how Plausible is doing. Each user gets a unique identifier which is based on `hash(domain+useragent+ip+salt)` (the salt is generated each day).
That does create clusters for users that work at the same company, with the same company-issued devices. Or iPhones in a New York City block.
This is the same problem that I had with parsing logs. There's no way to know that mom+dad+kid all using the same model device were 3 different users.
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#17If we use your hosted version, what will the pricing be when it's out of beta. I always think these services should basically be like 2x cost of underlying S3 or whatever storage you're using, but they end up being like 100x+
2x cost of S3 does not include whatever compute cost that is also incurred nor the cost of dev's time, marketing costs, or any other business expenses. When running a business, you see why the markups are applied for much less sinister reasons than maximizing profits. if you want to sustain your business on sales alone without being propped up by investment, you have to price your product/service appropriately to cover all business expenses.
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#18If we use your hosted version, what will the pricing be when it's out of beta. I always think these services should basically be like 2x cost of underlying S3 or whatever storage you're using, but they end up being like 100x+
2x cost of S3 does not include whatever compute cost that is also incurred nor the cost of dev's time, marketing costs, or any other business expenses. When running a business, you see why the markups are applied for much less sinister reasons than maximizing profits. if you want to sustain your business on sales alone without being propped up by investment, you have to price your product/service appropriately to cov…
Great points
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#19I run a saas where we host a number of websites, can I use this for us to track visits, events etc across multiple sites? We want aggregated results not per site metrics
Re: Show HN: Openpanel – An open-source alternative to Mixpanel
#20This doesn't seem to be buffering inserts to ClickHouse: https://github.com/Openpanel-dev/openpanel/blob/c90848765a6a... So any major website will have problems with it. I would suggest moving this into a stream (NATS, Kafka) or just having some sort of service that buffers events, then offloads to Clickhouse in batch.
Correct! Currently no batching but no need to make things complicated for now. Can extend the current redis queue to batch request or clickhouse batch engine. Looking forward to have these problems hehe. Please DM if you want to chat about best approach!
Won't this be a problem as soon as a website reaches, say, 600 RPS? Which is not much.