Daffodil DB is a SQL-99 specification compliant, 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 a complete JDBC 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. It can be included as a jar file in any Java application. Daffodil DB includes Daffodil DB Browser, a GUI-based database management tool that can be used to carry out all database operations such as creating a database, creating database objects, executing SQL statements, and manipulating data, browser database objects, etc.
|Tags||Utilities Information Management Records Management Database Database Engines/Servers API|
|Operating Systems||Unix POSIX Solaris Linux Windows|
Release Notes: Performance enhancements were made for the following functionalities: prepared statement caching for select queries at the JDBC driver level, select query with the order by clause, retrieving objects from java.sql.ResultSet, select query with user defined functions, and time reduction in index navigation.
Release Notes: User defined functions, support for updatable views, scalar functions, and table aliases in Update and Delete queries, support for using scalar functions in Group By clauses, addition and subtraction using (+) and (-) operators with Date and Timestamp data types, and support for scalar sub-queries in the select-list of a select query. This release also supports sorting using the Order By clause in a sub-query column, support for accessing cursor columns in FOR LOOP statements using a single variable, support for recursive routines, and performance enhancements related to DDL.
Release Notes: New features include full text search, support for external Java methods, support for read-only data, and multi line comments.
Release Notes: New features include significantly reduced boot-up time, a visual interface for creating triggers, tables, and stored procedures, Select For Update, support for Default in Insert query, natural join, and support for expressions in the 'IN' predicate. Current Timestamp function, Backup and Restore. The 'AUTOCOMMIT TRUE' transaction performance was improved. Changes were incorporated in the locking and index handling mechanism. Bugs related to privileges of procedure execution have been fixed, and much more.
No changes have been submitted for this release.