SQLite Forum

RTree on ESP32 SQLite Version
Login
Creation of the table :

CREATE VIRTUAL TABLE AIRSPACERTREE USING RTREE ( ID, MINX , MAXX, MINY , MAXY);

Insertion in the table :

INSERT INTO AIRSPACERTREE VALUES ('test', 1, 1, 3, 3);

Result of SELECT length(data) FROM AIRSPACERTREE_node WHERE nodeno = 1;

**0**