Web UI

It provides a built-in web UI for easy handling of Machbase Neo.

Open http://127.0.0.1:5654/ with web browser. Enter ID/Password as ‘sys’ and ‘manager’ which is the default.

If the machbase-neo process is running in a remote machine, please refer Start and Stop, it shows how to make machbase-neo remote-accessible.

SQL

Select “SQL” to open a new sql editor.

Create table

The page shows the SQL editor on left panel and result and logs are on the right panel.

Copy the below DDL statement and paste it to the editor.

CREATE TAG TABLE IF NOT EXISTS example (
  name varchar(100) primary key,
  time datetime basetime,
  value double summarized
);

Execute the statement by hit “Ctrl+Enter” or click ▶︎ icon on the top-left of the panel. Don’t forget the semi-colon of the end of the statement.

Insert Table

Execute the statement below to write a single record of data.

INSERT INTO example VALUES('my-car', now, 1.2345);

Select Table

Execute the select statement below, it will show the result on the right tabular panel.

SELECT time, value FROM example WHERE name = 'my-car';

Chart Draw

Insert more records by executing insert statement repeatedly.

INSERT INTO example VALUES('my-car', now, 1.2345*1.1);
INSERT INTO example VALUES('my-car', now, 1.2345*1.2);
INSERT INTO example VALUES('my-car', now, 1.2345*1.3);

Then review the stored ‘my-car’ records.

SELECT time, value FROM example WHERE name = 'my-car';

Click CHART tab from the right side pane. It will show a line chart with the query result.

Download CSV file

The full result of the query can be exported in a CSV file.

Delete Table

Delete records with a DELETE statement.

DELETE FROM example WHERE name = 'my-car'

Or, remove the table if you want to create a fresh one.

DROP TABLE example;

Non-SQL

show tables

Simplified command that queries M$SYS_TABLES table.

show tables;

desc table_name

Describe table’s columns and related index.

desc example;

show tags table_name

show tags example;

Query stored tags of the table, it works to TAG table only.

Shell

Click the Shell tab to run the interactive shell on the web.