Monday, November 30, 2015

Exploring the Utter Wonder of SQLite's RTrees

It seems like such a little thing. SQLite supports RTree relationships of parent-child.

They are maintained automatically through a virtual table.

This and many other features in SQLite are so powerful they boggle the mind. I am becoming convinced that the author of SQLite is a time traveler from the future who has decided to come back to share his vastly superior source code with the people of the early 20th century.

Some people know this can be useful in geographic information. What they don't know is that it is excellent for implementing all kinds of information relationships that may involve parent and child nodes. I am using it for Mission Impossible/Minority Report style breakdowns of vast vector maps that may need to be drilled down into ... for example, looking at an entire food storage warehouse or drilling down to a generator room inside that warehouse ... and just extracting the necessary vector diagrams to draw that particular region inside a browser.

Like so many things with SQLite, I thought about it for months and then sat down and coded it in only a few hours and it worked. I cannot praise the SQLite library highly enough. I could not imagine so little code doing so much.

1 comment:

Ave said...

Here comes the electric counter that monitors your consumption in real-time.

There is a program to MANDATORY change over 80% of the existing counter with it until 2020.

There is golden phrase here :
À noter qu'«il est impossible de refuser l'installation de Linky», insiste par ailleurs la CLCV, car «il s'agit de la mise en œuvre d'une directive européenne».

"It is impossible to refuse the installation of Linky because it's an European (=EU) directive"

Real-life monitoring of power consumption. Imagine the possibilities... for them.