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.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.
"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.
此版本添加了支持 ALTER TABLE 和联接,将添加一些会话配置设置与集 <setting><state>、 优化,创建和插入查询,并大大提高了结果的格式。已添加新列的表的引用解析器来处理新的结果的数据结构和在哪里现在支持列之间的比较。
标签:
SQL, cli
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.
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.
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.