OQGRAPH Engine for MySQL, MariaDB and Drizzle

visual representation of a graph structure (PD via wikipedia)The Open Query GRAPH engine (OQGRAPH) is a computation engine allowing hierarchies and more complex graph structures to be handled in a relational fashion. In a nutshell, tree structures and friend-of-a-friend style searches can now be done using standard SQL syntax, and results joined onto other tables.

No server modifications or SQL syntax extensions are necessary, the engine is implemented as a clean engine plugin for MySQL, MariaDB 5.1 and above, and Drizzle – this means that a standard server binary (mysqld) can be used, and the OQGRAPH plugin loaded at runtime. For MySQL 5.0 (which has no plugin capability) it has to be compiled in, we provide OurDelta builds.

See the OQGRAPH Documentation for more information, downloads, examples, etc.

Antony and Arjen at MySQLconf 2008

The OQGRAPH engine is based on an original idea by Open Query founder Arjen Lentz, and has been developed in-house with Antony Curtis who is a veteran in MySQL server code and storage engines.

For the earlier proof of concept we had valuable support from MySQL and MariaDB core developers such as Sergei Golubchik (Sun/MySQL), Timour Katchaounov (Sun/MySQL), Igor Babaev (Monty Program).

Availability & Licensing
The base Mk.II implementation is available as a gift to you, for MySQL 5.0 and MySQL/MariaDB 5.1, under the GPLv2+ license (please contact us if you have special licensing requirements).

I want it!

Sure! You can grab an OurDelta 5.0.87-d10 build at OurDelta incorporating OQGRAPH in the -sail (bleeding edge) packages, for 5.1 we’re working to get OQGRAPH packaged as a MariaDB plugin. If you need a particular build, we’re happy to help. The source is available on Launchpad.


Naturally, Open Query provides support for its OQGRAPH engine, we have the expertise on it. We prefer an ongoing subscription arrangement (billed quarterly) as this provides you with the best value, while being respectful of your budget.

As a more extreme example, we can provide source code or a build matching the MySQL version you’re running, even if it’s older. Very simply, Antony knows his own code well, he implemented significant parts of the engine infrastructure in the MySQL server core.

Paid work is ongoing for customers needing more storage efficiency (memory usage), persistence, and aspects of speed, as well as certain specialised functional requirements. We emphasise that the base implementation is in no way crippled.

Please see the OQGRAPH Documentation for more detailed information, as well as specific pricing for extras we offer. We operate transparently and charge reasonable prices. You can also contact us if you have any questions!

Copyright © 2007-2010 Open Query