Skip to main content

HelloDB

Introduction#

The HelloDB files are Sqlite 3 *.sqlite files. This approach makes each template file portable. The main difference is the specific hellodb table that brings configuration and translations for the database. The types of entities, fields and create/edit forms in the Studio will be directly calculted from the tables structure.

Configuration table#

The structure of the hellodb table is a classic key/value one:

CREATE TABLE "hellodb" ("key" varchar, "value" text);

3 rows are required in the configuration table:

KeyUsage
configA YAML definition for the HelloDB tables and fields (see the entities and fields configuration)
bundleA YAML that defines the translations for the bundle name
iconA SVG code to display an icon for the bundle