Skip to content
Coordinator DB
View as Markdown
View as Markdown

Create a table ​

This quickstart creates a table of events with a primary key, a required text field and an exact decimal amount.

Start the server, then connect with ./coordinator client --database data. Use a database where the sample table name is available.

Create the table ​

sql
CREATE TABLE events
(
    id INTEGER PRIMARY KEY,
    kind String NOT NULL,
    amount Decimal(18, 2)
);

INTEGER PRIMARY KEY gives each row an integer identifier. NOT NULL requires a kind. Decimal(18, 2) retains two exact fractional digits.

Insert rows ​

sql
INSERT INTO events VALUES
    (1, 'view', '1.20'),
    (2, 'click', '2.40');

The amount strings are converted to the declared Decimal type and checked before storage.

Read the result ​

sql
SELECT id, kind, amount
FROM events
ORDER BY id
FORMAT csv;
text
1,"view",1.20
2,"click",2.40

ORDER BY defines the row order. FORMAT csv selects a server output format; omitting it uses the default table display.

Continue with writing queries, or consult CREATE TABLE for constraints, defaults and generated columns.