Hi Sven,
I'm using your P3 library
https://github.com/svenvc/P3
to connect to TimescaleDB set up like this tutorial...
http://docs.timescale.com/v0.8/tutorials/tutorial-hello-nyc
but the following doesn't work unless I un-comment the second line...
(P3Client new url:
'psql://postgres:password@localhost:5432/nyc_data') in: [ :client |
[ " client database: 'nyc_data'. "
client query: 'SELECT date_trunc(''day'', pickup_datetime)
as day, avg(fare_amount)
FROM rides
WHERE passenger_count > 1 AND pickup_datetime < ''2016-01-08''
GROUP BY day ORDER BY day;'
] ensure: [ client close ]
].
Is it supposed to work without the second line,
just with the database set in the url ?
cheers -ben
P.S. TimescaleDB looks like cool tech...
https://blog.timescale.com/time-series-data-why-and-how-to-use-a-relational…
Some notes for anyone wanting to try tutorial-hello-nyc...
a. Postgresql >9.6.3 is required, for which the default install on
Ubuntu 16.04 had a problem with libpq not being recent enough. I
needed to follow these steps...
https://askubuntu.com/questions/831292/how-to-install-postgresql-9-6-on-any…
b. Downloading the sample data errored using the given "https" url,
but plain "http" worked...
http://timescaledata.blob.core.windows.net/datasets/nyc_data.tar.gz