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.

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;

Shell

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