• Post Reply Bookmark Topic Watch Topic
  • New Topic

Suggestions for a tool  RSS feed

 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am incorporating a Derby database into a personal Java project.  It will be an embedded database.  What I am wondering is can y'all offer suggestions for a free GUI application that will help me design, alter, visualize and ultimately help build the SQL statements I am going to need.  I have one had one course on basic database design.  So I have basic knowledge of the process but would like to use a GUI application to help make sure I am doing things correctly.
 
Tim Moores
Saloon Keeper
Posts: 4032
94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SquirrelSQL (on SourceForge) is a good GUI JDBC client, which I have been using for years.
 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You
 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It took me a little playing around but I was finally able to connect to the embedded database and then to understand the extra data showing.
 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way I can build a completely new test database in squirrelSQL, Using the derby embedded driver.  Then I can build the database in the same way I want my application to handle it through code, copy the correct SQL statements into the java code and bing boom?  I was messing around with it a bit but can't see where I start a new database. 

Thanks 
 
chandn Kumar
Greenhorn
Posts: 2
Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are main tools used in java to creating database. I suggestion for a tools,if you downloaded java DB on its own,then following.
1-Run the self extracting file.
2-A file name "javadb"created the same location.
3-Restart the system.
4-Creating new directory to be used as a home directory for the database server.



 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
chandn Kumar wrote:There are main tools used in java to creating database. I suggestion for a tools,if you downloaded java DB on its own,then following.
1-Run the self extracting file.
2-A file name "javadb"created the same location.
3-Restart the system.
4-Creating new directory to be used as a home directory for the database server.





I have figured out how to include the database in the application.  At the time of this post I was looking for a DB management tool that would allow me to build a database to the specs I want my program to build.  Then the tool would output all the SQL needed to build the database.  I used to use a tool a long time ago when I worked with VB 6.0.  It allowed me to build a database.  using buttons ect, no SQL.  Then at the end you could click a menu option that gave you all the SQL that would build the same database.  It was a database visualization tool.  I can't remember the name of it now or if its even still available.

I haven't found an answer to this question yet, I just went on to work on a different side of the program.  I realized the database should be one of the last design features.
 
Knute Snortum
Sheriff
Posts: 4276
127
Chrome Eclipse IDE Java Postgres Database VI Editor
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I realized the database should be one of the last design features.

I would have to disagree with you on that.  How you design your database can radically change the way your programs are structured.
 
Dwayne Barsotta
Ranch Hand
Posts: 86
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I would have to disagree with you on that.  How you design your database can radically change the way your programs are structured.


Agreed but if the database is primarily used for persistent data then would it not be one of the last things?  I would say if you are designing an app that is constantly dealing with data that has access fro more than one location, or you are asked to design the app to conform to an already running database then....  As it is right now, I'm designing the app and as I go I have a notebook with a section for the database design where I'm adding notes.  I didn;t design the database then the app around it.  Maybe that is something other can ring in on!  You have more experience then I do. As does most people here!   
 
Paul Clapham
Sheriff
Posts: 22828
43
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You haven't used the word "architecture" yet, but I think that's what you're talking about. The way I see designing an application which you know in advance is going to involve a database is like this: you envision what your application is going to do, at a high level, and then you envision the data structures required to support that. For example:

You might say "I want to keep track of all of the people who attend my pottery-making course." That's a high-level vision, and from that you know that you're going to have a table which stores information about people. Of course at this point you can't write TABLE CREATE statements, nor can you write any Java code. So, what do you want to do with that information about people? Perhaps you want to keep track of what supplies they bought from you and haven't paid for yet? Perhaps you want to keep track of who took course A so you can call them when you start running an advanced course they might be interested in? Now you have more ideas about what your application should do, and those ideas lead to what should be stored in the database. So what I'm trying to say here is, neither application design nor database design comes first.

That's if you're doing green-field design, anyway. Which it sounds like you're doing that. But if you've already got a database and a team of Smaug-like database managers, it's an entirely different ball game.
 
Dave Tolls
Ranch Foreman
Posts: 3058
37
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:But if you've already got a database and a team of Smaug-like database managers, it's an entirely different ball game.


They're lovely people!
You just need to distract them with shiny things sometimes.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!