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, you can easily create a simple database consisting of plain text files.
StelsCSV JDBC can also be used for writing data importing programs and migration tools.
Here are some key features of "StelsCSV JDBC Driver":
· 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.
Requirements:
· Any OS supporting Java platform.
· JDK 1.4 or later.
· RAM 128 MB.
Limitations:
· The demo version allows executing not more than 50 queries at once.
· SELECT queries return the first 1000 records in the result set.