Intro

Get up and running with Centia.io in less than 5 minutes.

Getting Started

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

Install the CLI

npm

npm install @centia-io/cli --global

Yarn

yarn global add @centia-io/cli

pnpm

pnpm add @centia-io/cli --global

Use the CLI

Start by logging in to the back-end:

cen login

Create a new schema for your tables:

cen schema add "my_new_schema"

Create a new table in the schema:

cen table add "my_new_schema" "my_new_table"

Add columns in your table:

cen column add "my_new_schema" "my_new_table" "id" int
cen column add "my_new_schema" "my_new_table" "name" varchar

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

cen constraint add "my_new_schema" "my_new_table" "id" primary

So now your table is ready for insert of data:

echo "INSERT into my_new_schema.my_new_table values(1, 'Martin')" | cen sql

And run queries on your table:

echo "select * from my_new_schema.my_new_table" | cen sql