I need to execute basic queries on a text file which consists of several columns. I tried to use StelsCSV which is a JDBC Driver for CSV files. It is good but commercial. Do you know other tools for the same task?
+1
A:
One option would be to parse the text files and store them in an embedded database like HypersonicDB. Once there, they can be queried using SQL.
How practical this is would depend how often the files change, and how expensive it is to parse and load them. Only you can answer that, but it may be worth considering. For example, if you run frequent queries against the data, it may be worth the up-front cost of loading into the DB, since each query should be more efficient.
Of course, you also get the advantage of using a "proper" supported database.
skaffman
2009-07-21 20:47:06
A:
HSQL has functionality for manipulatng csv data, and it's open source.
Adamski
2009-07-21 22:29:23
More information is available here: http://hsqldb.org/doc/guide/ch06.html
utku.utkan
2009-07-22 08:42:14
A:
Do you need to do this as a database driver, or just an easy way to parse a CSV file?
My personal opinion is that JDBC/etc... for this sort of thing is way overkill. If you are good with using a simple reader interface, and having things be lightweight, and 'just work', check out OpenCSV
Kevin Day
2009-07-22 03:12:39
JDBC is not a must but since I need to execute some simple queries, I thought such a thing would be a better choice although it is a bit heavy weight.
utku.utkan
2009-07-22 06:20:25
I'd parse the CSV directly and just work with the iterator. It will be much, much faster.
Kevin Day
2009-07-23 15:36:03
A:
Hi,
If you want, you can use MySQL to do the job.
Take a look at:
http://dev.mysql.com/tech-resources/articles/csv-storage-engine.html
SourceRebels
2009-07-22 08:00:13