SQL on the tree SQL/S00 → "LINE/*".io + log/plant.db

--
Ask the tree XDB SQL, run by the engine with this page's role (a Guest: it may read the lines, write nothing, and take in the database only through a named query)
a table is an element name, a row an element, a column an attribute; "LINE/*".io = the points of both lines, _doc = which line
The other way round SQLite's own query, every 5 s: the table x is the tree's, built by the engine from xdb('..')
linenameunit readingsmeantop
The table his holds a time, a point's id and a value. The names, the lines and the units come from the tree at the moment of the query: rename a point and the next result says so.

    
From any PostgreSQL client the same queries, as a database
psql "host=127.0.0.1 port=15432 user=eng dbname=SQL/S00"      -- role Engineer
psql "host=127.0.0.1 port=15433 user=mon dbname=SQL/S00"      -- role Monitor, read only
python pg_try.py "SELECT id, desc, val FROM \"LINE/*\".io"     -- no psql? this folder's own client
On 15432 a query may also take in the database raw, sql('CN_HIS', 'SELECT ..'), and write the tree, UPDATE "LINE/L1".io SET hi = 70 WHERE id = 'L1_LT1'. The page may do neither: try the last two buttons above.