CSQL

CSQL

CSQL Logo
Developer(s) Lakshya & Community
Stable release CSQL 3.3 / May 8, 2011; 9 months ago (2011-05-08)
Operating system Linux, Solaris
Type RDBMS
License GNU General Public Licence or proprietary
Website http://www.csqlcache.com/

CSQL is an open source main memory high-performance relational database management system developed @ sourceforge.net.[1] It is designed to provide high performance for SQL queries and DML statements.

Main Memory databases performs 10-20 times faster than the disk based database systems, as it completely keeps the database in main memory. As there is no disk I/O, main memory databases provide predictive response time (~10 microsecs for point lookup and ~20 microsecs for insert/update/delete operations) which makes main memory databases ideal for real time as well as near real time applications. Refer:[2] for more information.

It can be configured to work in Embedded as well as client/server mode. Apart from acting as relational storage engine, it can also transparently cache data from existing databases.[3]

It can be configured to work as transparent, updateable, real time cache ( CSQL Cache ) for existing database management systems such as MySQL, Postgres, etc.

Contents

Storage

Data Type and Constraints

Index

SQL

Caching

Interfaces

See also

same as mysql DBMS

References

http://www.csqldb.com/download/CSQLMMDBDatasheet.pdf