Beyond Relational Databases

April 18th, 2004 I have started working on creating an Object database supported by RDBMS on backend. No it is not an ORM layer.

April 20th, 2008 AWK is an extremely versatile and powerful language for processing files and text data. Often you can use awk to perform complex tasks on Unix / Linux / Mac OS command line which would otherwise take a full-fledged programming effort.

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.

August 9th, 2005 As an architect I have often been asked this question by my clients, friends and at work. I would like to answer it briefly once and for all.

April 20th, 2008 Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases mysqlcheck is available in MySQL 3.23.38 and later. mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.

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.

November 8th, 2006 Yesterday I received an often asked question from a close friend of mine and someone who I very much respect. In his words: My new company has an existing system that I am rewriting.

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.

April 18th, 2005 We often talk about understanding an application from code and unit tests with catch phrases like - "code is the documentation". In my experience I haven't found a better and more concise documentation then reading the SQL schema for any application, assuming it has one.

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.

July 6th, 2007 All I really want is to store a very large Hashtable with more reads than writes. It should be able to deal with more than 8GB of data.

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.

September 24th, 2007 I have significantly improved our site performance in the last month. I did all the site optimization steps by the book, found a lot of new things and fine-tuned existing ideas.

March 28th, 2006 Previously I had provided the gist of how to access MS Access database from JDBC using JDBC-ODBC bridge. Today I will elaborate on that and provide you with two sample classes.

February 15th, 2004 I came across the post from Jesus Rodriguez where he tries to find good reasons to convince management to use Hibernate. [[I tried posting but it required me to create an account, also I felt that the topic might be of general interest.