Tables

SchemaHero can manage both the columns and properties of a SQLite table.

Cassandra Table Columns

Like other databases, a SQLite table schema can be declaratively defined and the SchemaHero operator will reconcile it against the running cluster to apply the required migrations.

For example, given the following Table object:

apiVersion: schemas.schemahero.io/v1alpha4
kind: Table
metdata:
  name: users-table
database: my-sqlite-database-object
name: users
schema:
  sqlite:
    primaryKey:
      - [id]
    columns:
      - name: id
        type: int
      - name: login
        type: text
      - name: name
        type: text