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|
|Operating Systems||Linux Unix Windows|
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.