A simple graph database in SQLite, inspired by SQLite as a document database

This is a simple graph database in SQLite, inspired by “SQLite as a document database“.

The schema consists of just two structures:

  • Nodes – these are any json objects, with the only constraint being that they each contain a unique id value
  • Edges – these are pairs of node id values, specifying the direction, with an optional json object as connection properties

There are also traversal functions as native SQLite Common Table Expressions which produce lists of identifiers or return all objects along the path:

Choose an implementation:

Want to contribute a version in your preferred language?

The schema and prepared sql statements can be used by programs in any programming language with SQLite bindings.

Pull requests are welcome!


Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

GIPHY App Key not set. Please check settings

FEEDBACK REQUESTED: We’re building a way to understand your internet self

How to add forms to Notion