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 install
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
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.
What's New in This Release: [ read full changelog ]
· Logical Undo logging for Tree Index
· Auto increment key
· Command history for CSQL tool
· cachetable tool option to display cached table information
· Bug Fixes