Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

quickest route to JDBC

 
paul wheaton
Trailboss
Pie
Posts: 21893
Firefox Browser IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you wanted to teach someone JDBC, what would be best free database to use?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well I found InstantDB extremely easy to use. It's essentially just a jar file which you put in your classpath (or your jre/lib/ext directory for Java 2) and then you can use it straight away.
It's not the fastest in the world (for production code I have moved to MySQL) but it's free, pure-java, portable, small and has a good SQL implementation.
Why not have a look at http://208.234.21.207/
 
paul wheaton
Trailboss
Pie
Posts: 21893
Firefox Browser IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is the speed okay, or is it a disaster? How does it compare to mySQL?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's OK. I ran using it for quite a while, then tried MySQL and found that typical accesses might be 3-5 times faster (with some cases worse, of course). Given that MySQL is generally considered to be very fast, I think that's pretty reasonable.
As a tool for understanding JDBC it's great, especially in conjuction with servlets, as you don't need to cajole a web host into installing and configuring a database for you.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic