Daffodil software has announced the release of v4.0 of its open source java database One$DB. It is an open source database designed to handle complex computing environments that demand a robust, scalable and high-performance RDBMS that can operate across platforms. The new version (v4.0) enhances speed and adds key features such as support for updatable views, scalar sub-query and scalar functions.

One$DB users can now update views using update query. Updation will be performed on the base table of the view. Support for scalar sub-query in select list of select query has also been introduced. Scalar sub-query is a query that returns a single column with one single row. Sub-query column can be sorted using Order By clause. This version also comes with a number of new scalar functions.

For the full list of features and functionalities download the source code files, available at: http://sourceforge.net/projects/daffodildb/