DeveelDB is a complete embeddable SQL-99 RDBMS for .NET/Mono frameworks. The system is designed around the standards ISO/ANSI and supports the following features:
- ACID Transactions:
BEGIN
,COMMIT
,ROLLBACK
(Isolation Level Serializable) - Data Definition Language (DDL):
CREATE/DROP SCHEMA
,CREATE/DROP/ALTER TABLE
- Data Manipulation Language (DML):
SELECT FROM
,INSERT INTO
,DELETE FROM
,UPDATE
- User Management:
GRANT/REVOKE
statements - Support for structured variables (eg.
DECLARE var INT(200) NOT NULL
) - Procedures and functions: with the (current) limitation of the body defined into .NET classes
- Cursors
- ADO.NET native client
- Direct Access: programmatically execute SQL statements (without ADO.NET client and text commands)
Although the core project is thought to be embedded in applications, the modular architecture allows extensions to other uses, such as providing databases through networks: an application is already included in the solution.
You can verify the current status of the application code by checking the project at AppVeyor Continuous Integration (access as "guest" user: you will find the direct link below the login form).
Please, report any issue or feature request to our Issue Tracker