Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

quickest route to JDBC  RSS feed

 
paul wheaton
Trailboss
Posts: 22574
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
Posts: 22574
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!