Denis Database

A lightweight Java cache and data engine

This site turns the project’s scattered README information into a clearer product-style documentation experience.

GitHub RepoReleases

SQL Queries

Supported SQL-style query subset

After login and project token authentication, Denis accepts a documented subset of SQL-like commands over its TCP protocol. This is one of the clearest product capabilities exposed in the upstream README.

Documented supported operations

  • CREATE TABLE <table> (<column> <type>, ...)
  • INSERT INTO <table> (<columns>) VALUES (<values>)
  • SELECT <columns|*> FROM <table> [WHERE <column> = <value>]
  • UPDATE <table> SET <column> = <value> [, ...] [WHERE <column> = <value>]
  • DELETE FROM <table> [WHERE <column> = <value>]
  • DROP TABLE <table>

End-to-end example

CREATE TABLE users (id INT, name TEXT);
INSERT INTO users (id, name) VALUES (1, 'Ada');
SELECT * FROM users WHERE id = 1;
UPDATE users SET name = 'Grace' WHERE id = 1;
DELETE FROM users WHERE id = 1;
DROP TABLE users;

Interpretation

The README describes this as a supported subset rather than a fully documented relational engine. Treat it as a pragmatic command interface on top of Denis rather than as a drop-in SQL database replacement.

  • Prefer simple table and condition shapes first.
  • Assume the documented subset is authoritative unless source code proves broader support.
  • Use token-authenticated connections when exercising SQL commands over TCP.