SimpleDB Manual

A basic database with core features

Data types


Number

Decimal

String

Boolean

Binary

Commands


Exporting databases

To export a database, use the following command:

dbms export -d database_name -f export_file.sql

Loading databases

To load a database from an export file, use the following command:

dbms load -d database_name -f export_file.sql

Databases

Create database

dbms create_database -d new_database

Update database

dbms update_database -d existing_database -n new_database_name

Read database

dbms read_database -d database_name

Delete database

dbms delete_database -d database_name

Tables

Create table

dbms create_table -d database_name -t new_table

Update table

dbms update_table -d database_name -t existing_table -n new_table_name

Read table

dbms read_table -d database_name -t table_name

Delete table

dbms delete_table -d database_name -t table_name

Queries


Backup & Restore