... our donation to the Open Source community: xlSQL. We think it is probably the best document JDBC driver ever written. Try it, what do -you- think? Process your documents with much, much less code. Save time. Be more productive. Read your XML, Excel and CSV as if it were one database. Download xlSQL on SourceForge. Subscribe to xlSQL on FreshMeat for release updates.
Developers who want to contribute to xlSQL are allowed to use the RefactorIT Community Edition as the code-base in the com.nilostep.xlsql domain is part of the RefactorIT Open Source license. xlSQL
can be used in JDBC scripting using judoscript.
xlSQL: Excel JDBC Driver
xlSQL is a JDBC Driver for Excel ( CSV, XML and other ) document data sources. Documents can be read and written with SQL
as if they were tables in a database. In the case of Excel, xlSQL maps a directory with Excel files to a database,
workbooks to schemas, and sheets to tables. These tables can be queried with the full SELECT syntax of either the
HSQLDB or MySQL (more to follow) SQL dialect. Native xlSQL is a rich subset of SQL for creating, altering and populating
documents ( spreadsheets ). The xlSQL Yn codebase, although alpha, has been taken into production at numerous sites worldwide. xlSQL has proven to be a very stable read-write SQL Excel JDBC Driver. Continuous development efforts are aimed to explore the limits of the XLS fileformat for storing relational data and to support other document formats as CSV and XML.
xlSQL Y7
New Features in Y7:
native DBA interface: "xldba"
export filesystem data to Excel with dir2xls
all new utilities: export excel to XML or SQL script format (HSQLDB or MySQL)
xlSQL Y7 comes with a zero-admin MySQL Server -included- which runs out of the zip
no installation needed, xlSQL just runs, Windows directory and registry remain untouched
download contains all software (excluding JRE) and is still less than 4Mb
start the background SQL engine with mysql_startup
That's it!
Or read the Tutorial ( temporarily off-line: moving website )
Status
December, 27 2004. xlSQL will be maintained for the foreseeable future. A new release is expected somewhere
in the first quarter of 2005. xlSQL Y7 proved that it is possible to serialize and deserialize SQL queries on to
any format. Expect new formats, and more.. (soon).
Thanks to our sponsors
It is our commitment to create a software product of superior quality. Commitment is not enough to achieve a goal,
knowledge and discipline are just as important. Thanks to our sponsors we are able to use the best test and
quality tools available in the industry today.
java.net RSS
