StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma-separated, delimiter-separated, fixed-length, etc). Using this driver, you can easily create a fast database consisting of plain text files. Also, the driver can be used for writing data importing applications and migration tools.
Features:
- It supports most keywords of ANSI SQL’92
- It supports inner and outer table joins
- It supports INSERT, UPDATE and DELETE statements
- It supports transactions
- It supports integer, floating point, string and date/time data types
- It supports aggregate, numeric, string, conversion and other SQL functions
- It supports user-defined SQL functions
- It supports processing of text files from Zip/Jar archives and FTP, HTTP URLs
- It is platform independent
