مثال‌های FlovaQL

SELECT time, value
FROM telemetry
WHERE device.name = 'DEVICE_NAME'
  AND datastream.key = 'relay'
  AND time > now() - 7d
ORDER BY time ASC
LIMIT 1000

SELECT
  bucket(time, 1h) AS hour,
  avg(value) AS average_value,
  min(value) AS minimum_value,
  max(value) AS maximum_value
FROM telemetry
WHERE device.name = 'DEVICE_NAME'
  AND datastream.key = 'temperature'
  AND time > now() - 24h
GROUP BY hour
ORDER BY hour ASC
LIMIT 24

SELECT
  bucket(time, 1h) AS hour,
  datastream.key AS stream,
  count(value) AS samples
FROM telemetry
WHERE device.name = 'DEVICE_NAME'
  AND datastream.key IN ('temperature', 'humidity')
  AND time > now() - 7d
GROUP BY hour, stream
ORDER BY hour ASC
LIMIT 400

SELECT id, name, status, last_seen_at
FROM devices
WHERE status = 'offline'
ORDER BY last_seen_at DESC
LIMIT 100

SELECT time, datastream_key, status, acked_at, error_message
FROM commands
WHERE device_id = 'DEVICE_ID'
  AND time > now() - 24h
ORDER BY time DESC
LIMIT 100