Skip to main content

Developer Guide

Follow the instructions in the README of the RookDB/RookDB to run the Storage Engine. After the system starts, the interface will display a list of available operations to choose from.

The Storage Engine currently provides the following options:

Show Databases​

Displays all databases available in the catalog.

Create Database​

Creates a new database and updates the catalog.

Steps:

  1. Enter a database name when prompted

Example:

users

Select Database​

Sets the active database for performing operations.

Steps:

  1. Enter a database name from the displayed list

Show Tables​

Displays all tables in the selected database.

Create Table​

Creates a new table with a schema.

Steps:

  1. Enter table name
  2. Enter columns using format:
column_name:data_type
  1. Press Enter on an empty line to finish

Supported Types:

  • INT
  • TEXT

Example:

id:INT
name:TEXT

Load CSV​

Loads CSV data into an existing table.

Steps:

  1. Enter table name
  2. Enter CSV file path

Example:

examples/example.csv

Show Tuples​

Displays tuples stored in table pages along with page metadata such as pointers and tuple count.

Show Table Statistics​

Displays storage statistics like total number of pages.

Exit​

Exit from RookDB.