 | CSQLCSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features. |
| Download | |
CSQL Ranking & Summary
Advertisement
CSQL Tags
CSQL Description
CSQL (Compact SQL) is a light weight, high performance main memory database system with minimal set of features. 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 sourceGo 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.kshNote:setupenv.ksh script is available at the root directory which shall be used toset 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 ServerNote: kernel.shmmax should be set to more than 500 MB before starting the serverIn linux for setting 1GB enter$sysctl -w kernel.shmmax=1000000000You 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.confStart the server using csqlserver executable$./csqlserverThis starts the server and creates the database file.Note:Refer UserManual.pdf available in docs folder to know how to work with csqlShutting down the ServerPressing 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: · Logical Undo logging for Tree Index · Auto increment key · Command history for CSQL tool · cachetable tool option to display cached table information · Bug Fixes
CSQL Related Software