CSQL is a high-performing, lightweight database system that operates in main memory. It has a minimal feature set, making it a suitable tool for those requiring only basic functionality.
CSQL, otherwise known as Compact SQL, is a software database system that boasts an impressively light weight and high-performance capacity, despite only offering a minimal set of features. With the ability to provide a throughput of 50K inserts/sec and 100K selects/sec, it's clear that CSQL is a powerful option for those looking for a simpler approach to database management.
To get started with the software, users will need to compile the source code by accessing the root directory and entering specific commands. This process involves configuring the software to exact specifications, which can be done by following the step-by-step instructions provided.
Once the installation is complete, users can then start the server with ease. However, it's important to note that kernel.shmmax will need to be set to more than 500 MB before the server can be initiated. In Linux, for example, users can set the limit to 1GB by inputting the correct commands.
After configuring the server and ensuring that system settings are correct, users will be able to access the csqlserver executable file and make any necessary changes to the software configuration. This can be achieved by adjusting the csql.conf file located in the root directory and setting the CSQL_CONFIG_FILE environment variable accordingly.
Finally, it's worth noting that CSQL comes complete with a range of helpful features, which can be found in the UserManual.pdf available in the docs folder. Additionally, shutting down the server is simple and can be achieved by pressing Ctrl-C on the terminal where csqlserver is running. This action will safely stop the server and remove the associated database file.
To get started with the software, users will need to compile the source code by accessing the root directory and entering specific commands. This process involves configuring the software to exact specifications, which can be done by following the step-by-step instructions provided.
Once the installation is complete, users can then start the server with ease. However, it's important to note that kernel.shmmax will need to be set to more than 500 MB before the server can be initiated. In Linux, for example, users can set the limit to 1GB by inputting the correct commands.
After configuring the server and ensuring that system settings are correct, users will be able to access the csqlserver executable file and make any necessary changes to the software configuration. This can be achieved by adjusting the csql.conf file located in the root directory and setting the CSQL_CONFIG_FILE environment variable accordingly.
Finally, it's worth noting that CSQL comes complete with a range of helpful features, which can be found in the UserManual.pdf available in the docs folder. Additionally, shutting down the server is simple and can be achieved by pressing Ctrl-C on the terminal where csqlserver is running. This action will safely stop the server and remove the associated database file.
What's New
Version 2.5 Beta: N/A