sqliteman Enable SQLite RTREE module

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 !

Apr 21 '16 08:04 david-bouyssie

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.

Dec 21 '16 17:12 rparkins999

Great !

Any plan to release a windows compatible version ?

Jan 02 '17 16:01 david-bouyssie

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.

Jan 02 '17 16:01 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.

Jan 02 '17 18:01 rparkins999

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

Jan 03 '17 10:01 david-bouyssie

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.

Jan 03 '17 10:01 rparkins999