First Session#

Start the Server#

ulimit -n 65535
mudud

When running under systemd, configure LimitNOFILE=65535 at the service level.

Open the Interactive SQL Shell#

mcli --addr 127.0.0.1:9527 shell --app demo

Run a complete CRUD flow:

CREATE TABLE users_demo (
  id INT PRIMARY KEY,
  name TEXT
);

INSERT INTO users_demo (id, name) VALUES (1, 'Alice');
SELECT id, name FROM users_demo WHERE id = 1;

UPDATE users_demo SET name = 'Alice-Updated' WHERE id = 1;
DELETE FROM users_demo WHERE id = 1;

Exit the shell:

\q

Next Step#

Continue with Wallet Example to build, install, and invoke a procedure application.