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

RSS Recent releases

  •  01 Apr 2012 00:25

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.

  •  25 Nov 2011 20:17

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.

  •  06 Nov 2011 21:30

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 22:42

    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.

    RSS Recent comments

    27 Nov 2011 02:53 Avatar darkrose Thumbs up

    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 apstein Thumbs down

    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

    Tor-ramdisk

    A micro Linux distribution for securely hosting a Tor server.

    Screenshot

    Project Spotlight

    TurnKey Tracks Appliance

    A Tracks appliance that is easy to use and lightweight.