[odb-users] Creating virtual tables

[Irvin Josue Hernandez Rivera]

Thank you for your response.
The underlying DB I am using is Sqlite DB and I am using this db to store
user positions as a Lat Lon. I wanted to add support to the DB for ranged
queries an rtree https://www.sqlite.org/rtree.html
In order for sqlite to create the rtree module the table instantiation need
to be as follows:

CREATE VIRTUAL TABLE *<name>* USING rtree(*<column-names>*);
I don't think the options pragma allows for this type of table creation



On Mon, Feb 27, 2023, 5:33 AM Boris Kolpackov <boris at codesynthesis.com>
wrote:

> Irvin Josue Hernandez Rivera <iherna31 at asu.edu> writes:
>
> > I am currently trying to use spatial indexes for some Geospatial lookups
> > that I need to implement for a DB in c++. Does odb allow the creation of
> > virtual tables with a praga definition?
>
> It's hard to say anything specific since you didn't mention the underlying
> database you are using. However, we've recently added support for the
> table `options` pragma that allows customizing the table definitions
> generated by ODB. Perhaps it will allow you to achieve what you want:
>
>
> https://urldefense.com/v3/__https://git.codesynthesis.com/cgit/odb/odb/commit/?id=5652354aa256426c5ab32c4a1c5687e5509af868__;!!IKRxdwAv5BmarQ!e6FfD6qB-KsqOvHZ-ijvz3m7Gd1MVvuwYXv-pB02G_ErL1KbqVoaq3B0eGY0OKK6kL-0DdMJB3BDvm74wd4$
>