4 ms·
I 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 + Rabb
by agentgt 10y ago
I 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.