Daffodil DB

Daffodil DB is a SQL-99 specification compliant, capable, reliable, scalable, high-performance, embeddable, lightweight java-based relational database engine (RDBMS). It supports almost all constructs of SQL 99 (including triggers, views, constraints, UDT, stored procedures etc), supports distributed transactions (XA), provides complete JDBC(Java Database Connectivity) 3.0 driver (including support for optional features like save points, rowsets, UDT, XA, connection pooling etc) and can run in embedded or server mode. Daffodil DB can be included as a jar file in any java application. Daffodil DB includes Daffodil DB Browser, a GUI based database management tool. Daffodil DB Browser can be used to carry out all database operations such as creating a database, creating database objects, execute SQL statements, manipulate data, browser database objects etc.

Daffodil DB provides the following unique features some of which are not provided by any other database vendor to date.

ResultSet Listener Support

Unique concept of ResultSet listeners support allows automatic updating of ResultSet or RecordSets that are updated according to the isolation level, if underlying database tables are changed, without requiring the Listener to execute the query again.

Serialized Session

Daffodil DB has a unique concept of serialized session. This concept of Serializable Session applies serialization to a user session comprising of one or more transactions, just like transaction isolation level of “Serializable” applies serializability to one particular transaction, and that too, while maintaining efficiency.

Materialized View

Materialized view maintains user defined views from other database objects in storable manner, hence when queries on views are fired, views are not recalculated as they are already maintained by the database separately, and this simplifies and speeds up things.

Runs on any platform with a certified Java Virtual Machine. Tested on all Windows and Linux Operating Systems.

How To Use: