4 ms·

Fun fact: TimescaleDB exists because we were using InfluxDB + Postgres for a previous IoT project and also found it unworkable (developer experience, query lang

by mfreed 6y ago

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. :-)

zitterbewegung 6y ago
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 6y ago
  [deleted]
- avthar 6y ago
  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/install-timescaledb.md https://github.com/slashdotdash/til/blob/master/postgres/ins...
- deleted 6y ago
  [deleted]
- rubyn00bie 6y ago
  You can mount like any PostgreSQL version, including extensions, in Postgres.app. I’ve used both Timescale and Agens with it, with zero problems.
- akulkarni 6y ago
  Not sure if a coincidence, but someone just published this blog post today: Installing Timescaledb on Mac OS X with Postgres.app https://prathamesh.tech/2020/07/23/installing-timescaledb-on-mac-os-x-with-postgres-app/ https://prathamesh.tech/2020/07/23/installing-timescaledb-on...
jarym 6y ago
Have you been following ZHeap and do you think Timescale will benefit from a storage engine like that (less write amplification)?
- Lockerman 6y ago
  Timescale engineer here. I'm betting we'll see a nice win; we tend to see write-mostly workloads the UNDO shouldn't be too expensive, and the smaller tuple sizes should be nice. We've built Timescale to be compatible with custom storage engines, so it should work as a drop-in, though of course until we've tested it we won't be sure.
- enordstr 6y ago
  Another Timescale engineer here. As previously pointed out, zheap should work as a drop-in in TimescaleDB. In fact, I just tried it and it works. However, it currently requires an unmerged PR to work properly: https://github.com/timescale/timescaledb/pull/2082 https://github.com/timescale/timescaledb/pull/2082, as well as further testing.
  - jarym 6y ago
    Nice! Thanks. Postgres is just amazing in so many respects. The work you guys do contribute to that.

by mfreed 6y ago

zitterbewegung 6y ago

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 6y ago
[deleted]
avthar 6y ago
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/install-timescaledb.md https://github.com/slashdotdash/til/blob/master/postgres/ins...
deleted 6y ago
[deleted]
rubyn00bie 6y ago
You can mount like any PostgreSQL version, including extensions, in Postgres.app. I’ve used both Timescale and Agens with it, with zero problems.
akulkarni 6y ago
Not sure if a coincidence, but someone just published this blog post today: Installing Timescaledb on Mac OS X with Postgres.app https://prathamesh.tech/2020/07/23/installing-timescaledb-on-mac-os-x-with-postgres-app/ https://prathamesh.tech/2020/07/23/installing-timescaledb-on...

jarym 6y ago

Have you been following ZHeap and do you think Timescale will benefit from a storage engine like that (less write amplification)?

Lockerman 6y ago
Timescale engineer here. I'm betting we'll see a nice win; we tend to see write-mostly workloads the UNDO shouldn't be too expensive, and the smaller tuple sizes should be nice. We've built Timescale to be compatible with custom storage engines, so it should work as a drop-in, though of course until we've tested it we won't be sure.
enordstr 6y ago
Another Timescale engineer here. As previously pointed out, zheap should work as a drop-in in TimescaleDB. In fact, I just tried it and it works. However, it currently requires an unmerged PR to work properly: https://github.com/timescale/timescaledb/pull/2082 https://github.com/timescale/timescaledb/pull/2082, as well as further testing.
- jarym 6y ago
  Nice! Thanks. Postgres is just amazing in so many respects. The work you guys do contribute to that.