4 ms·
I see this as a very interesting project. I use ClickHouse as OLAP and I'm very happy with it. I can tell you features that make me stick to it. If some day Que
by pachico 6y ago
I see this as a very interesting project. I use ClickHouse as OLAP and I'm very happy with it.
I can tell you features that make me stick to it. If some day QuestDB offers them, I might explore the possibility to switch but never before.
- very fast (I guess we're aligned here)
- real time materialized views for aggregation functions (this is absolutely a killer feature that makes it quite pointless to be fast if you don't have it)
- data warehouse features: I can join different data sources in one query. This allows me to join, for instance, my MySQL/MariaDB domain dB with it and produce very complete reports.
- Grafana plugin
- very easy to share/scale at table level
- huge set of functions, from geo to URL, from ML to string manipulation
- dictionaries: I can load maxdb geo dB and do real time localisation in queries
I might add some more once they come to my mind.
Having said this, good job!!!
- bluestreak 6y agoThank you for the kind words and constructive feedback. We are here to build on feedback like this. Grafana plugin is coming soon.
- pachico 6y agoGlad to be useful. On the other side, I can tell you that ClickHouse also misses a feature everyone in the community of users wish for, which is automatic regarding when you add a new node (sort of what elasticsearch does). And before I forget, ClickHouse Kafka Engine is simply brilliant. The possibility of just publishing to Kafka and have your data not only inserted in your DB but also pre-processed is very powerful. Let me know if I can help you with use cases we have. Cheers
- bluestreak 6y agoThis is incredibly useful, thank you! It would be awesome if we could chat more about your use cases at some point. Drop us a line on hello at questdb.io or join our slack. Whichever is easier for you.
- santafen 6y agoThanks for the helpful feedback! Feel free to reach out to chat more. I'm super interested in more feedback from you. davidgs(at)questdb(dot)io
- pachico 6y agoI certainly will. Cheers
- pupdogg 6y agoIf you don’t mind sharing, what are the specs of your ClickHouse cluster including Zookeepers? Also, how large of a dataset are you working with?