4 ms·
Do you mean you use pipelinedb and citus or do you mean you use citus to cluster pipelinedb? I never thought to try mixing the two since pipelinedb has their o
by faizshah 10y ago
Do you mean you use pipelinedb and citus or do you mean you use citus to cluster pipelinedb?
I never thought to try mixing the two since pipelinedb has their own commercial product for clustering. You should write a blog post on that if you were able to cluster pipelinedb with citus.
- agentgt 10y agoI mix the two. Citus for offline warehousing and pipelinedb for realtime. I'm very pleased with the results. I mix the two by using a message bus (Kafka + RabbitMQ) I spent a lot of time with Cassandra. It is probably great tech I just don't have petabyte data yet. And I know all the stats I want a prior.
- no1youknowz 10y agoThis is why I love HN. People give their real-world scenarios. Thank you for recommending pipelinedb, I haven't come across them before. I have kafka and postgres and in need of real-time analytics, this may be the solution I'm looking for. I've used citus in the past, whilst it's excellent for data-warehousing. Unless you scale up the servers, then it's not suitable for real-time counts. I found that lacking for my use-case. If you see this, can you reach out at my name @ gmail dot com, I'd like to chat about issues you have come across.
- manigandham 10y agoIf you need both citus + pipelinedb then memsql.com will solve your problem with a much more polished solution. MySQL dialect instead of PostgreSQL but that's rarely a problem for a data warehouse.
- no1youknowz 10y agoThanks. I actually have scheduled a demo. In the meantime will download the community version and have a play.