search

pvanek / sqliteman

http://sqliteman.com/
160 stars 58 forks source link

Enable SQLite RTREE module #20

Open david-bouyssie opened 8 years ago

david-bouyssie commented 8 years ago

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 commented 7 years ago

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 commented 7 years ago

Great !

Any plan to release a windows compatible version ?

rparkins999 commented 7 years ago

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 commented 7 years ago

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 commented 7 years ago

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

rparkins999 commented 7 years ago

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.