Skip to main content

Getting started

Get started by sign up and create a new basebase back-end

Install the CLI​

npm install @centia-io/cli --global

Use the CLI​

Start by logging in to the back-end:

centia login

Create a new schema for your tables:

centia schema add "rollhall"

Create a new table in the schema:

centia table add "rollhall" "inductees"

Add columns in your table:

centia column add "rollhall" "inductees" "id" int
centia column add "rollhall" "inductees" "name" varchar

And maybe you want to add a primary key to your id column:

centia constraint add "rollhall" "inductees" "id" primary

So now your table is ready for insert of data:

echo "INSERT into rollhall.inductees values(1, 'Guns n’ Roses')" | centia sql

And run queries on your table:

echo "select * from rollhall.inductees" | centia sql