[jaapz]

Anyone here using QuestDB in production? What is your use case? What is your experience?

We want to migrate away from InfluxDB eventually (because of their 180 on OSS, and their tendency to reinvent the product every major release), and QuestDB seems like an interesting option.

[hansvm]

I used it for awhile for "prod" for a toy project. I was scraping nearly every sale across every Target location for awhile. It was fast and easy to use. At the time many (read) queries had bugs of various kinds, requiring strange workarounds to get certain joins and whatnot to work (and not just throwing errors either -- often reporting zero data when there was data there, things like that) and not really being composable. Their CEO (CTO?) responded to my saying as much at one point and mentioned that they had just spent a lot of time fixing all their query logic and writing enough tests that it's actually usable now. I haven't had a reason to check yet, but the next time I'm doing any time-series thing and don't want to write the data layer myself I probably will.

[gandreani]

Man I have the strangest Deja Vu with this comment. I swear it's like the third time I read this??

[hansvm]

At most the second from me, and last time I didn't talk about the project (haven't talked about the project online at all IIRC).

[gandreani]

I believe you! I wasn't implying anything about your project. I just can't quite shake the feeling.

[hansvm]

I'm probably not the only culprit then :) I'd be curious to know who else has done things like that.

[simplesocieties]

Been using it for half a year now in prod to collect sensor data from IoT devices.

My only complaints are:

1) Memory usage is a bit high. We went with the AWS instance they recommended in the docs and even that went over our provisioned memory. It's not much but I think it could be improved

2) You need to buy their enterprise plan if what you're storing is remotely sensitive like health data, PII, etc. Any row level security or credential features are locked behind that license. Our use case isn't that sensitive so we can get away with putting it in a VPN and password protecting it, but if you need DB-level security the FOSS license is severely behind Postgres in terms of features.

Other than that, it's never gone down, it's very, very fast and comes with it's own webui for querying your data. We migrated from AWS Timestream and couldn't be happier with the switch.