Daffodil Software has released version 4.0 of Daffodil DB, its cross platform Java relational database management software. Daffodil 4.0 has been made compatible with Compiere, an advanced CRM solution. This release is geared towards making Daffodil DB a solution for mission-critical and enterprise-class applications, in league with Oracle DB.

Daffodil 4.0 was made Compiere-compatible because of demands from the Compiere community for an alternate database to Oracle. No other database, Java or native, apart from Oracle is compatible with Compiere.

Features in the latest Daffodil release include support for recursive functions, advanced cursor support for Procedures and Triggers, support for scalar query in select list, support for scalar functions, support for scalar function in group by clause, support for table alias in update/delete statement, updation in view through update query and migration utility among others.

A migration utility has been added to enable the porting of existing Compiere applications in Oracle DB to Daffodil. This add-on can import all existing data from Oracle, ensuring 100% migration to Compiere in Daffodil DB. According to Compiere, users will be able to begin working in Daffodil from exactly where they left off in Oracle.

In addition to performance improvements, users of Daffodil 4.0 can define their own functions for business logic implementation. User defined functions can be used as value expressions in Select, Insert, Update, Delete and in Procedures. Using scalar subquery, queries can be returned in a single column with one single row. In the new version, support for scalar subquery in select list of select query has been introduced.

In comparison to Oracle, Daffodil is much smaller and cost-efficient. Daffodil DB can be embedded within any application and uses minimum system resources while delivering performance that is comparable to Oracle. Unlike Oracle, Daffodil DB is transparent to the end user and does not require a DBA.

Daffodil 4.0 is available in both Embedded and Network Editions, and is suitable for multithreaded applications requiring an embedded database. The Embedded Edition is a multiple connection RDBMS designed specifically for embedding inside Java based applications.

The Network Edition is built on Internet standards and provides robust relational data management for networked applications. Networked applications can use Daffodil DB Server Edition to provide ubiquitous data access from anywhere using standard Structured Query Language (SQL) and Java Database Connectivity (JDBC) interfaces.

Daffodil is compatible with the leading brands of Application Servers, Web Servers, JDO and Object Mapping Tools, including WebSphere, JBoss, Tomcat, Apache, and Oracle 9ias. Daffodil provides free support for Daffodil DB through its Daffodil Developer Forum and offers affordable commercial support under its One$/day support program.

An open source version of Daffodil DB is available, known as One$DB. This database is free for commercial use, but cannot be used with Compiere. Free evaluation versions of Daffodil's commercially offered product are being offered.