Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Learn to fish with a useful tool for database development

 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's a tip for all you Java developers working with Oracle or MySQL databases.

At least once a week a question pops up here on the JDBC forum, where it is clear that people have no idea how to run their SQL directly on the database, or how to inspect their tables directly, or how to explore stored procedures etc.

So in the spirit of teaching you guys to fish, can I recommend you go off to:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

and download Oracle's free SQLDeveloper tool.

This is a combination of database browser, IDE for SQL and PL/SQL, data-modeller and DDL generator for Oracle software developers. It's easy to set up, easy to use and best of all free of charge.

This will give you the ability to try out your SQL to make sure it works e.g. before posting queries here, to explore your data and your stored procedures, and generally understand what's happening on the database side of your Java/database applications. Who knows - you might even start to enjoy it!

And for those of you outside the Oracle family, it can apparently be used with other databases such as MySQL as well, although I haven't tried this myself:

http://total-bi.com/2011/07/using-sql-developer-with-mysq/

And yes, I know that Eclipse plugins will do a lot of this stuff, but it seems nobody is using them around here.
 
Sumit Bisht
Ranch Hand
Posts: 331
Python Ruby Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Chris for sharing the information!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic