Yet another object database on RDBMS backend: A new project

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

July 31st, 2007 HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database.

May 19th, 2007 HSQLD is a mature, high-performant database written in Java. It is used in several high profile popular commercial and open source products like Open Office 2.0 (Office productivity suite; competitor of MS Office), JBoss (Application Server), JFox (Application Server), Jonas (Application Server), Mathemetica, Hibernate (ORM), Jira (Defect Tracking), TrackStudio (Defect Tracking), C-JDBC (Database Clustering) etc.

January 17th, 2006 HSQLDB, the famous fast RDBMS written in Java, introduced a new feature which affects code ported over from previous versions. From version 1.7.2, in-process databases are no longer closed when the last connection to the database is explicitly closed via JDBC.

March 15th, 2009 db4o is a popular object database available both for Java and .NET. I have used it sporadically over several years and can highly recommend it.

July 21st, 2007 I previously discussed how to extend HSQLDB relational database with simple Java functions. The example there actually implements case insensitive like query functionality for HSQLDB.

August 18th, 2008 Db4o is an excellent open source object database for Java & .NET platform by Carl Rosenberger's team. I highly recommend it for rapid prototyping and RAD.

June 19th, 2005 There is more to data access than SQL.

August 26th, 2009 Open Source Server based database management systems have become a common choice for organizations over the stand alone desktop databases. The server based databases or RDBMS such as MySQL, PostgreSQL, Microsoft SQL Server are designed to be used on servers and it can be easily shared by multiple users.

January 10th, 2006 It was fun to watch Java software companies posting videos of their product demonstration on the web. Watching them however made me realize couple of important issues.

April 5th, 2008 TechCrunch got it from a source that Google plans to launch their BigTable, their proprietary internal database which is used for Google Search, as a web service to compete with Amazon SimpleDB Web Service. Bigtable is a distributed storage system for managing structured data that is designed to scale to a very large size: petabytes of data across thousands of commodity servers at Google.

August 19th, 2008 In earlier versions of Db4o we used Db4o.configure() to configure all Db4o database globally (across all ObjectContainer). However in 7.2 (and above) versions of Db4o Db4o.configure() has been deprecated and it is suggested to use Db4o.newConfiguration() instead.

July 17th, 2007 HSQLDB is an unique high performing, high quality Java based relational database which can be very easily extended with simple Java static functions. Here we will see how you can easily extend the database capability with a real-life example.

February 25th, 2006 One of the common questions I hear from Java newcomers is - where is a FIFO list in Java? Java does have a FIFO list capability built-in with LinkedList and ArrayList, but they are not well advertized. A FIFO interface should at least have: public interface FIFO { /** Add an object to the end of the FIFO queue */ boolean add(Object o); /** Remove an object from the front of the FIFO queue */ Object remove(); /** Return the number of elements in the FIFO queue */ int size(); } A FIFOList class implementing the above would simply be: public class FIFOList extends LinkedList implements FIFO { public Object remove() { return remove(0); } } I prefer this setup instead of using a LinkedList.remove(0) directly.

May 26th, 2007 Sometimes you need to have database column names with space or other non-standard characters. The standard procedure is to escape them with backtick (`) character.