1 CSQL - Version 1.0 - Beta
2 -------------------------
3 1.Support for Atomicity, rollback for trasactions using undo logs
4 2.Support for three isolation levels: READ_UNCOMMITED, READ_COMMITED, READ_REPEATABLE.
5 3.Support for hash index with single key
6 4.Support for multiple users
7 5.Support for DML operations through table interface
8 6.Support for Predicates which involves only single table field names and constants
9 7.Debug Module, that prints additional messages on debug build
10 8.Configuration Module to load system paramaters from config file
11 9.Logger to log events of the system to log file
12 10.DBAPI for accessing the storage engine directly
14 CSQL - Version 1.1 - Beta
15 -------------------------
16 1.Primitive SQL Engine
17 2.SQL API for accessing SQL Engine
18 3.SQL Support for INSERT, UPDATE, SELECT, DELETE on single tables
20 CSQL - Version 1.2 - Beta
21 -------------------------
22 1.Primitive JDBC Type II Driver
24 Process registration and deregistration,
25 Support for multi threads and cleanup thread
27 4.Support for DDL in SQL Engine
28 5.NOT NULL, UNIQUE, PRIMARY KEY support
29 6.CSQL- Interactive SQL Tool
31 CSQL - Version 2.0 - GA
32 -----------------------
33 1.Primitive ODBC Driver
34 2.ODBC Adapter for MySQL
35 3.Gateway with Synchronous mode
36 4.csqldump tool to take backup of tables and its records
37 5.Memory leak fixes using Valgrind
38 6.Improved test coverage in DBAPI, SQLAPI, JDBC, ODBC interfaces
41 CSQL - Version 2.1 - Beta
42 -----------------------
46 4.Aggregates and Group By support
47 5.LIKE operator support
48 6.Cache support for Postgres (Bi-directional)
50 CSQL - Version 2.2 - Beta
51 -----------------------
52 1.Join (Inner) support
54 3.Arithmetic Expression in update statement
55 4.Multiple cache nodes
56 5.Partial Caching(field and row level)
58 CSQL- Version 2.3 - Beta
59 ------------------------
60 1.JDBC Datasource support
61 2.Client/Server for ODBC / JDBC/ ISQL
62 3.Support for simple expressions in UPDATE statement
63 4.ResultSetMetaData and ParameterMetaData for JDBC
69 CSQL- Version 2.5 - Beta
70 -----------------------
73 3.Separate MMDB and Cache package
75 5.Documentation Updates
77 CSQL- Version 2.7 - Beta
78 ------------------------
79 1.Logical Undo logging for Tree Index
80 2.JDBC/ODBC 3.0 Support
81 3.Command history for CSQL tool
82 4.cachetable tool option to display cached table information
84 6.Support for ORDER BY clause
85 7.Support for DISTINCT clause
86 8.Support for LEFT OUTER JOIN
87 9.Multiple Data source caching
89 11.Support for default value NOW for system date and time
90 12.LIMIT and OFFSET Support
91 13.INSERT INTO and CREATE TABLE AS SELECT support
96 18.Documentation updates