Overview

In order to understand the features of RonDB and its storage engine NDB we will look at the SQL commands available to define tables and their support structures such as tablespaces, UNDO log files and the parts of a table like columns, indexes, primary keys and so forth.

This is important to understand since even applications using the native RonDB APIs will query tables that have been mostly defined in SQL.

We will cover basic SQL statements, row format, foreign keys, disk data columns, BLOB handling. We will deal in some detail about the various table options that are available when creating a table in RonDB.

We will cover how various MySQL concepts such as stored procedures, views and so forth are handled in RonDB and we will cover ALTER TABLE statements.

We will also cover RonSQL, a RonDB native SQL engine that can execute some queries without relying on MySQL.