RDBMS framework for miniConnect.
MiniBase is a flexible java framework for building relational database engines. It has built-in support for SQL parsing, query execution, storages, indexing, and more. It manages concurrency, currently a very basic transaction management is implemented.
One of its implementations is HoloDB, a database seemingly filled with random data.
Click here for the SQL documentation
MiniBase has built-in support for SQL queries. Features:
- Limited support for the CRUD operations
- Multiple schemas, multi-schema queries
- User variables
- Simple expressions
SELECT example, demonstrating most of the supported features:
SELECT
t3.*,
t1.label,
t1.created t_created,
CONCAT(@somevar, ': ', t4.col1) AS `concatenated value`
FROM base_table t1
INNER JOIN inner_joined_table t2 ON t2.id = t1.i_id
LEFT JOIN left_joined_table t3 ON t3.id = t1.l_id
LEFT JOIN other_left_joined_table t4 ON t4.id = t3.l2_id
WHERE
t1.category = 'basic' AND
t1.id >= 150 AND
t1.id < 960 AND
t4.year BETWEEN 1995 AND 2003 AND
t4.phone IS NOT NULL
ORDER BY
t1.level,
1 DESC,
t3.price ASC NULLS LAST
LIMIT 10