CSQL Main Memory Database / Cache / News: Recent posts

Additions in this release

1.Statement Caching
2.Bug Fixes
3.Performance Improvements

Also this release is integrated with Asterisk for Real Time Queue through ODBC interface. More information on this can be found at http://wp.me/pgiki-17

CSQL is open source main memory database management system and cache for MySQL and Postgres database. It improves the database performance of applications by 20 times.

Additions in this release:

1.Logical Undo logging for Tree Index

2.Auto increment key

3.Command history for CSQL tool

4.cachetable tool option to display cached table information

5.Bug Fixes

Additions in this release

1.JDBC Datasource support

2.Client/Server for ODBC / JDBC/ ISQL

3.Support for simple expressions in UPDATE statement

4.ResultSetMetaData and ParameterMetaData for JDBC

5.Bug Fixes

6.Performance Fixes

7.Wisconsin Benchmark

8.User Manual updates

Additions in this release
1.Multiple cache nodes
2.Partial table caching
3.Tree Index
4.Inner Join Support

Additions in this release
1.Composite Keys
2.Binary Datatype
3.cacheverify tool
4.Aggregates and Group By support
5.LIKE operator support
6.Cache support for Postgres (Bi-directional)

Latest version of CSQL does not support composite keys. In the next release CSQL2.1 , composite primary keys will be supported.

Additions in this release
1.Primitive ODBC Driver
2.ODBC Adapter for MySQL
3.Gateway with Synchronous mode
4.csqldump tool to take backup of tables and its records
5.Memory leak fixes using Valgrind
6.Improved test coverage in DBAPI, SQLAPI, JDBC, ODBC interfaces
7.Updated user manual
8.Recovery in case of graceful shutdown
9.cacheverify tool to verify the cache coherency with the target database
10.Bi-directional update propagation support for cached tables.

CSQL2.0 Beta, Transactional Data cache which uses ultra fast compact main memory database. It gives ultra high throughput, 100K selects/sec and 50K updates/sec.
This release includes primitive ODBC driver, MySQL ODBC Adapter, Caching and Gateway.

CSQL 1.2 Beta, compact main memory database SQL engine released. It gives ultra high throughput, 100K selects/sec and 50K updates/sec.
This release includes primitive SQL Engine, Interactive SQL tool, JDBC driver.

CSQL 1.1 Beta, a main memory database storage engine is released. It gives ultra high performance, takes 5 microsecs for point lookup as compared to hundreds of microsecs taken by disk based databases.