Central DB - sakura-team/sakura GitHub Wiki

The Central DB is a sqlite database attached to the Hub. It allows to:

  • Save user objects:
    • projects
    • workflows and involved objects (operator instances, links, etc)
    • database metadata (whereas data itself is stored inside a datastore)
    • etc.
  • Save Sakura Users and Grants
  • Provide a stable interface to objects managed by daemons (if ever the daemon or a datastore is temporarily disconnected)
  • Manage IDs of objects which must be unique on the whole platform

As of sept 27, 2017, the schema is the following (click on it for fullscreen display): CentralDB Schema

This schema was generated by running

$ test/db-schema.py ${HOME}/.sakura/central.db

And pasting the output on https://app.quickdatabasediagrams.com.