Feature List

OpenMemDB plans to implement the following features:

• CRUD-style queries (CREATE TABLE, INSERT, SELECT, UPDATE, DELETE, DROP TABLE)
• Table constraints (PRIMARY KEY, NOT NULL, DEFAULT, FOREIGN KEY, UNIQUE, AUTO_INCREMENT)
• Limited Datatypes (INTEGER, BOOLEAN, CHAR/VARCHAR, FLOAT, DATE, TIME, TIMESTAMP)
• Joins(?)
• Subqueries(tentatively), with EXISTS/NOT EXISTS contingent on this
• WHERE, ORDER BY, GROUP BY, IN, BETWEEN,
• ODBC implementation
• UNION(?)
• Aliases(?)
• Boolean expressions
• Regex (LIKE, wildcards, etc)(?)
• Math aggregate functions (MAX, MIN, AVG, COUNT, SUM)