Enable SQLite RTREE module

[david-bouyssie]

I have a project where I use intensively the SQLite RTREE module (https://www.sqlite.org/rtree.html).

SQLiteman is still for me the best GUI for SQLite but I would really appreciate a support of the RTREE features.

It seems to be very simple, enabling the flag SQLITE_ENABLE_RTREE should fix this.

Thanks !

[rparkins999]

This appears to be enabled in rparkins999/sqliteman. I don't know how to use RTREE properly, but creating a virtual table as specified in the RTREE documentation appears to work. I think RTREE is enabled by default in the most recent sqlite releases: I'm using 3.9.2.

[david-bouyssie]

Great !

Any plan to release a windows compatible version ?

[rparkins999]

I don't have a Windows machine to build or test on. The source code should be Windows compatible apart from the build timestamp which is made with a Linux command, but it should be easy to replace that with a corresponding Windows one. Anyone volunteering to build it for Windows would be very welcome.

[rparkins999]

I've just added a piece of build script which makes a timestamp on a Windows emulation console, so it should work on real Windows too. So rparkins999/sqliteman should now build on Windows.

[david-bouyssie]

Fantastic !
So I should be able to build the project using Windows CMake ?

[rparkins999]

You should, but as I say I haven't tested it. If it doesn't build, send me the output and I will see if I can do anything, although it's hard to fix problems flying blind. Incidentally I suggest we continue this thread in rparkins999/sqliteman as it doesn't really concern pvanek/sqliteman any more.