Skip to content

Home

Jump to bottom
daveboden edited this page Sep 19, 2014 · 18 revisions

Comma CQ turns simple, flat database data into CSV format. It distributes data in CSV format and the Java client can create javabeans using Apache BeanUtils.

The core ideas are:

  • Allow new entity types to be specified by dropping a .sql file in a configuration directory. The output of the query must contain an "id" column as the first column. Results are formatted using the capabilities available in the database (e.g. convert()). Nothing else required to plumb a new entity all the way through to the client.
  • Choose CSV as the only supported format. Maintain data within the server in CSV strings to allow them to be served up to clients with the minimum of fuss. This forces all entities to be simple and "flat" grids of data. If you need to serve up object graphs use something else!

Here's how to get a Sandbox up quickly to play with.
Information about the Architecture of the server and client.
Details of how data sources are grouped into layers.
Information about the simpler [Broadcast mode](wiki/Broadcast mode).
CSV data can be replicated to a secondary server using Proxying.
Other [Data Source Types](wiki/Data Source Types) are available for gathering data, in addition to the normal SQL database sources.
Here are ideas about [Upcoming Features](wiki/Upcoming Features).

CommaCQ Architecture

Clone this wiki locally