3 ms·
PostgREST can look closer to SQL. For example this query: select time, device_id, humidity from conditions where humidity > 90
by steve-chavez 6y ago
PostgREST can look closer to SQL. For example this query:
select
time,
device_id,
humidity
from conditions
where
humidity > 90 and
time < '2016-11-16'
order by time desc
limit 10;
Can be expressed as this request:
curl -G "/conditions" \
-d select=time,device_id,humidity \
-d humidity=gt.90 \
-d time=lt.2016-11-16 \
-d order=time.desc \
-d limit=10
In long form without curl:
/conditions?select=time,device_id,humidity&humidity=gt.90&time=lt.2016-11-16&order=time.desc&limit=10
Taken from: http://postgrest.org/en/v5.2/integrations/timescaledb.html#postgrest-on-hypertables http://postgrest.org/en/v5.2/integrations/timescaledb.html#p....