Database SQL Query

The SQL Query tool provides access to the SQL tables created by Dari .

../../_images/db-sql.png

Use standard SQL syntax. For example:

SELECT HEX(id), HEX(typeId), value FROM RecordString4 WHERE value = "spurious news planted by trolls";

To specify a UUID value, remove the dashes from the record Id and add “0x” in front of it. For example:

SELECT HEX(id), HEX(typeId), data FROM Record WHERE id = 0x0000015ecd9fdad1a7ffedff7b980003;