Projects / StelsCSV

StelsCSV

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

Recent releases

  •  14 Oct 2013 11:05

    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.

    •  07 Sep 2011 05:49

      Release Notes: A new mode of the driver has been added.

      •  20 May 2010 05:56

        Release Notes: The H2 database is now used as an SQL engine. Indexes are now supported.

        •  15 Dec 2009 11:40

          Release Notes: Various bugs have been fixed. Overall performance was improved.

          •  26 Mar 2008 13:12

            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.

            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.