MintSQL is a lightweight SQL database written in Go that supports basic database CRUD operations.

Make sure you have the following installed:

• Go 1.17
• Docker (optional)

Run the server (on local):

make run-server

Run the server (in docker container):

make docker-run

Run the client:

make run-client

Install the server:

make install-server

Install the client:

make install-client

The default port for MintSQL is 7384.

mintsql <port>

mintcli <host> <port>

The query language is a subset of SQL. For now, MintSQL only supports simple CREATE|INSERT|SELECT queries.

To quit the client console, type \quit.

• Create a table:

> CREATE TABLE students (id INT, name TEXT);
ok

• Insert values into a table:

> INSERT INTO students VALUES (1, 'Bob');
ok

• Select data in a table:

> SELECT name, id FROM students;
| name | id |
==============
|  Bob |  1 |