StelsCSV is a JDBC driver that allows performing SQL statements and other JDBC operations upon text files (comma separated, tab-separated, fixed length, etc.). Using this driver, users can easily create a simple database consisting of plain text files. The driver can be used for writing data importing programs and migration tools. It supports most keywords of ANSI SQL92, table joins, INSERT, UPDATE, and DELETE statements, data types, aggregate, converting, string, and user-defined SQL functions.
|Tags||Software Development Libraries Java Libraries Database API Database Engines/Servers Information Management Records Management jdbc driver csv SQL|
|Operating Systems||Windows Windows Unix POSIX Solaris Linux Windows Windows|
Release Notes: Support for DATE and TIME data types (java.sql.Date and java.sql.Time correspondingly) was added. Support for the CHAR type was added. The driver preserves all spaces and quotes in a CHAR value as-is. The properties "dateFormat", "decimalFormatInput", and "decimalFormatOutput" can be set for each column separately. The "nullString" property supports regular expressions.
Release Notes: A new mode of the driver has been added.
Release Notes: The H2 database is now used as an SQL engine. Indexes are now supported.
Release Notes: Various bugs have been fixed. Overall performance was improved.
Release Notes: Support for the FTP protocol was added. New properties were added to the driver. JDBC API 2.0 classes were added, including a data source class (jstels.jdbc.csv.CsvDataSource). A connection pool data source class (jstels.jdbc.csv.CsvConnectionPoolDataSource) was added.