Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

ListenBrainz moves to TimescaleDB

blog.metabrainz.org

Post reply on HN
Print view View original

21–30 of 100 posts

Re: ListenBrainz moves to TimescaleDB

#21

Post by mayhemchaos »

RedShift1 wrote: post #18

I'm in the process of moving from InfluxDB to TimescaleDB myself and can't wait to get rid of the hoops I have to jump through to get InfluxDB to answer some basic questions, mostly stemming from the fact that InfluxQL doesn't support boolean expressions. Something like 'SELECT MAX(temperature) > 10 FROM...' doesn't work.

Agreed -- every time I tried to query data from the command line I could not get anything to work. I would usually find a piece of working python code and adapt that to run the query instead.

100% opposite of what a CLI interface should be.

Re: ListenBrainz moves to TimescaleDB

#22

Post by akulkarni »

RedShift1 wrote: post #18

I'm in the process of moving from InfluxDB to TimescaleDB myself and can't wait to get rid of the hoops I have to jump through to get InfluxDB to answer some basic questions, mostly stemming from the fact that InfluxQL doesn't support boolean expressions. Something like 'SELECT MAX(temperature) > 10 FROM...' doesn't work.

Welcome to the TimescaleDB community! In case it is helpful, we wrote a tool to easily migrate from InfluxDB to TimescaleDB:

https://docs.timescale.com/latest/tutorials/outflux

Re: ListenBrainz moves to TimescaleDB

#24

Post by brokentone »

akulkarni wrote: post #22
RedShift1 wrote: post #18

I'm in the process of moving from InfluxDB to TimescaleDB myself and can't wait to get rid of the hoops I have to jump through to get InfluxDB to answer some basic questions, mostly stemming from the fact that InfluxQL doesn't support boolean expressions. Something like 'SELECT MAX(temperature) > 10 FROM...' doesn't work.

Welcome to the TimescaleDB community! In case it is helpful, we wrote a tool to easily migrate from InfluxDB to TimescaleDB: https://docs.timescale.com/latest/tutorials/outflux

I'm personally working on migrating a DB I've had for tracking some economic time-series data from Influx to TimescaleDB, and I have to say Outflux is the most savage tool name ever.

Re: ListenBrainz moves to TimescaleDB

#25

Post by awinter-py »

timescale is a postgres extension. 'postgres as a platform' is an interesting world to live in.

postgres built-in RBAC is clunky or people would be relying on it, but an ecosystem of postgres plugins could include cleaner or smaller versions of this feature.

Even things like complex migrations (github's gh-ost, for example) could exist as DB plugins.

Re: ListenBrainz moves to TimescaleDB

#26

Post by akulkarni »

brokentone wrote: post #24
akulkarni wrote: post #22

Earlier quoted context omitted.

Welcome to the TimescaleDB community! In case it is helpful, we wrote a tool to easily migrate from InfluxDB to TimescaleDB: https://docs.timescale.com/latest/tutorials/outflux

I'm personally working on migrating a DB I've had for tracking some economic time-series data from Influx to TimescaleDB, and I have to say Outflux is the most savage tool name ever.

One of our designers teamed up with one of our web developers, went away for a week, and came back with this website for it:

https://www.outfluxdata.com/

Re: ListenBrainz moves to TimescaleDB

#27

Post by akulkarni »

thejosh wrote: post #23

I really want to love timescaledb, it's great.. except for the minor issue of not being able to back up. https://github.com/timescale/timescaledb/issues/1835

TimescaleDB definitely supports backups :-)

Here is a page from our docs on how to perform Backup & Restore: https://docs.timescale.com/latest/using-timescaledb/backup

Not sure what's going on in that one Github issue, but we are looking into it.

Re: ListenBrainz moves to TimescaleDB

#28

Post by zitterbewegung »

mfreed wrote: post #19

Fun fact: TimescaleDB exists because we were using InfluxDB + Postgres for a previous IoT project and also found it unworkable (developer experience, query language, reliability, scalability and performance, operations, etc). We first built TimescaleDB as "Postgres for time-series" for our own needs and then decided to open-source it for others. :-)

Have you thought of making a TimescaleDB app like the Postgres.app for macOS? Or could I use Postgres.app to make a TimescaleDB app?

Re: ListenBrainz moves to TimescaleDB

#29

Post by [deleted] »

zitterbewegung wrote: post #28
mfreed wrote: post #19

Fun fact: TimescaleDB exists because we were using InfluxDB + Postgres for a previous IoT project and also found it unworkable (developer experience, query language, reliability, scalability and performance, operations, etc). We first built TimescaleDB as "Postgres for time-series" for our own needs and then decided to open-source it for others. :-)

Have you thought of making a TimescaleDB app like the Postgres.app for macOS? Or could I use Postgres.app to make a TimescaleDB app?

[deleted]

Re: ListenBrainz moves to TimescaleDB

#30

Post by avthar »

zitterbewegung wrote: post #28
mfreed wrote: post #19

Fun fact: TimescaleDB exists because we were using InfluxDB + Postgres for a previous IoT project and also found it unworkable (developer experience, query language, reliability, scalability and performance, operations, etc). We first built TimescaleDB as "Postgres for time-series" for our own needs and then decided to open-source it for others. :-)

Have you thought of making a TimescaleDB app like the Postgres.app for macOS? Or could I use Postgres.app to make a TimescaleDB app?

It seems you can use the Postgres.app and install TimescaleDB on it

Here's some instructions on how to do so: https://github.com/slashdotdash/til/blob/master/postgres/ins...

Post reply on HN