CSQL 2.5 Beta

CSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features.

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in CSQL 2.5 Beta:

  • Logical Undo logging for Tree Index
  • Auto increment key
  • Command history for CSQL tool
  • cachetable tool option to display cached table information
Read full changelog
send us
an update
GPL (GNU General Public License) 
3.8/5 12
Prabakaran Thirumalai
ROOT \ Database \ Database APIs
CSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features. It gives throughput of 50K inserts/sec and 100K selects /sec.

Compiling the source

Go to the root directory and enter the following commands.

$ export JDK_HOME=< path of jdk home >
$ ./configure --prefix=`pwd`/install CXXFLAGS="-I$JDK_HOME/include -I$JDK_HOME/include/linux"
$ make
$ make install
$ ./csqlinstall.ksh


setupenv.ksh script is available at the root directory which shall be used to
set the necessary environment variables.

This will create "install" directory under the current directory and places all the executables created in bin directory and libraries in lib directory.

Starting the Server

Note: kernel.shmmax should be set to more than 500 MB before starting the server

In linux for setting 1GB enter

$sysctl -w kernel.shmmax=1000000000

You should find csqlserver executable under the bin directory of the installation.

Change csql.conf file under the installation root directory if necessary.
Set the CSQL_CONFIG_FILE environment variable to absolute path of csql.conf file.

For example, if csql.conf is available at /tmp directory, then

$export CSQL_CONFIG_FILE=/tmp/csql.conf

Start the server using csqlserver executable


This starts the server and creates the database file.


Refer UserManual.pdf available in docs folder to know how to work with csql

Shutting down the Server

Pressing Ctrl-C on the terminal where csqlserver is running, is safe and will stop the server gracefully by removing the database file.

Last updated on May 9th, 2009

#Compact SQL #database API #memory database system #SQL #database #API #DDL

Add your review! 1 USER REVIEW SO FAR