This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CSV to JDBC reader

 
Peter Rooke
Ranch Hand
Posts: 825
Java Linux Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm looking at using a tool to parse CSV files, as if they were database tables. Have found two tools:

i) CSVJDBC
ii) xlSQL

My question is, and in terms of stability and extensibility which would be the preferred tool?
 
Scott Selikoff
author
Saloon Keeper
Posts: 3897
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Two questions for you...

Can you use a database? Why not write your own csv parser?

CSV files are just text files with a fancier name. While I'm sure those two packages you listed may have many special features and abilities for general database storage, something simpler and more custom may prove more applicable in your situation. The performance really depends on what you are going to do with it, and for something as simple as a CSV file, I'd probably want to write my own.
 
Peter Rooke
Ranch Hand
Posts: 825
Java Linux Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why not write your own
- Yes could do, but if there is a proven tool out there, would like to have a look at it. If I write something, I'm not convinced that it will be tested as fully as a tool developed as open source. Also want to get into the interesting parts of this project, and not spending time grinding code for a solution that has been done before.

Years back, had to write an Informix 4GL XML parser (well sort of :roll: ) for an old Informix database - did'nt enjoy this.

Mind you by the time I find any documentation for xlSQL - I could have written my own utility.
[ May 05, 2006: Message edited by: Peter Rooke ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic