News for hackers. Stuff that matters.

A comment on ListenBrainz moves to TimescaleDB. Parent comment

Re:ListenBrainz moves to TimescaleDB by iliekcomputers on Wednesday July 22, 2020 @08:44AM (#23916328)
ListenBrainz dev here. We wanted stuff like the ability to do stuff like "DELETE FROM measurement where field = blah" and that support didn't exist last time we looked. [0]

Another thing that's not mentioned in the post but was a pain point for us was that it's not easy to query for fields with "null" values [1].

I figure a lot of our pain might be because we're not as good at Influx as we are at PostgreSQL. We've been running MusicBrainz[2] for ~18 years on PostgreSQL, that knowledge will hopefully transfer over a little with Timescale.

[0]: https://github.com/influxdata/influxdb/issues/3210

[1]: https://github.com/influxdata/docs.influxdata.com/issues/717

[2]: https://musicbrainz.org

[ Parent | on HN ]
Re:ListenBrainz moves to TimescaleDB by silvester23 on Wednesday July 22, 2020 @09:00AM (#23916428)
True, deleting by value does not seem to be possible. I can see how that would be painful if it's necessary for your use case.
[ Parent | on HN ]