csvDB is an SQL engine for CSV (comma separated values) files, allowing files to be searched as if they were database tables. It includes both a library and a client, allowing it to be used programatically and from the command line.
| Tags | csv SQL shell cli Library |
|---|---|
| Licenses | GPLv3 |
| Operating Systems | Linux Unix Windows |
| Implementation | C SQL |
| Translations | English |
Recent releases


Release Notes: "make install" now installs libraries and headers. This release adds a strcasestr implementation for systems which don't have it in their C library, support for the BDELIMETER environment variable for setting the default field separator, support for different separators, enclosures, and escapes when loading files from csvdb the shell, a switch to using readline as the default in the shell, and gettext support.


Release Notes: This release adds support for ALTER TABLE and JOIN, adds some session configuration settings with SET <setting> <state>, optimizes CREATE and INSERT queries, and greatly improves the format of results. New column/table reference resolvers have been added to work with the new result data structures, and WHERE now supports comparisons between columns.


Release Notes: This release implements the autotools build chain, increases file loading speed, implements a readline-based shell, adds table/file/column/keyword autocompletion to the shell, makes changes to table and result data structures, major query optimizations, adds AND/OR support to WHERE, implements HAVING, and expands WHERE to support =, LIKE, >, <, NOT, <=, and >= comparisons.


Release Notes: A bugfix in arrow key handling in the shell. Support for loading apache log files with the APACHE keyword. The addition of INSERT, UPDATE, CREATE TABLE, and OUTFILE support. A bugfix in WHERE parsing. Some query optimization.
Recent comments
27 Nov 2011 02:53
The configure file is included in the download at sandbox.ltmnet.com/csvdb but if you're downloading from github you'll need to run `autoreconf -i' to generate one.
26 Nov 2011 06:27
The configure file is missing. I've been trying to produce one using m4, libtool and autoconfig but I've been unsuccessful. Please advise.