On 29 Jan 2018, at 15:45, Ben Coman <btc@openinworld.com> wrote:
On 29 January 2018 at 22:40, Ben Coman <btc@openinworld.com> wrote:
On 29 January 2018 at 22:32, Sven Van Caekenberghe <sven@stfx.eu> wrote:
Ben,
On 29 Jan 2018, at 15:27, Ben Coman <btc@openinworld.com> wrote:
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
Cool.
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 ?
Yes, it is supposed to work like that. Did you try with the latest #reset patch (split settings/properties) ?
Yes. This occurs after I tested the #reset patch. I "think" it was occurring prior but my memory is not sure.
Just checked, its the same behaviour prior to updating to the #reset patch.
For me, (P3Client new url: 'psql://postgres:password@localhost:5432/nyc_data') database. => 'nyc_data' You'll have to trace how it fails, see #startupMessage where #database is used setting up the connection.
cheers -ben
Sven
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