TODO
List of main things to do, by order of priority:
- TEXT and IMAGE datatypes.
- DEFAULT clause for CREATE TABLE.
- DESC for ORDER BY
- jdbc driver
Other features, like functions, UNION without ALL, subqueries, encryption of connections and storage, etc, will be implemented later.
The optimizer uses indexes. But for the moment, tables are not reordered and are joined in the order they appear from left to right.
- If you know how indexes work, you know how to write fast queries.
- But if you don’t, the server will not reorder the tables for you.
- That’s why it is very important to create large test tables that you can fill with random data (functions
RANDOM_VARCHAR
,RANDOM_NUMERIC
,RANDOM_INT
,RANDOM_DATE
, etc can help you), so that you can test your SQL queries with different table orders.