Projects / csvDB

csvDB

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
Licenses
Operating Systems
Implementation
Translations

Recent releases

  •  31 Mar 2012 12:51

    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.

    •  24 Nov 2011 13:03

      Release Notes: This release adds support for ALTER TABLE and JOIN, adds some session configuration settings with SET , 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.

      •  06 Nov 2011 13:06

        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.

        •  02 Nov 2011 05:43

          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 darkrose

          The configure file is included in the download at http://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 apstein

          The configure file is missing. I've been trying to produce one using m4, libtool and autoconfig but I've been unsuccessful. Please advise.

          Screenshot

          Project Spotlight

          OpenStack4j

          A Fluent OpenStack client API for Java.

          Screenshot

          Project Spotlight

          TurnKey TWiki Appliance

          A TWiki appliance that is easy to use and lightweight.