Xbase DBMS is a C++ library which supports access to Xbase type datafiles and indexes (ie., .dbf and related files). It provides access at the record level to these files.
XBSQL is a wrapper library which provides an SQL-subset interface to Xbase DBMS, built on xbase-1.8.1. This is the first release, so various things are still missing, however I think there is now sufficient functionality to make the library useful. In particular, the documentation is a bit thin. There is a simple command-line client xql which can be used as an example
Documentation, such as it is, is here.
XBSQL currently supports:
XBSQL supports expression names and table aliases, so you can SQL queries like:
XBSQL also supports single-column .ndx indexes, hence the following indexes the i and t columns. The library can make use of these indexes for simple join cases.
The following list contains SQL features that are currently missing. This should not be read as meaning that anything not listed is implemented!
XBSQL can be downloaded as source from here. All comments, feedback and bug reports welcome, please send to email@example.com.
This library has been developed with the support of theKompany.com.