If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > Little experience with databases, looking for a suitable tool

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Oct 2012
Posts: 1
Little experience with databases, looking for a suitable tool

Hello gentlemen

I've tried to google programs but I'm not sure which one to go for. Money isn't a a big issue but I would of course like to get something isn't extremely expensive.

Basically I am looking for a program that is really easy to use, that doesn't require one to be an expert already, if you know what I mean. Basically a program I both can use to learn and then work with later.

I was hoping some of you more experienced could help me out and find a program. I'd really appreciate it! Here are some of the features I was looking for (hope I don't come across as too naive, I realize it might not all exist or even exist in one single program haha) so basically:

- Work offline so I don't have to set up a server
- A feature to upload the database to a server when I'm ready
- Work visually to add, remove, edit etc. instead of having to google 6 hours to find the right way to type it
- Get visual feedback as I work, so I don't have to refresh or something like it
- Have support for a variety of dialects

All in all I think I'm looking for a super user-friendly program lol

Any ideas?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
Quote:
Basically I am looking for a program that is really easy to use, that doesn't require one to be an expert already, if you know what I mean
No, i don't know what you mean. What kind of "program"? What do you want to learn?

Yup, it would surely be a "super user-friendly program" that would do what you want with unspecified input and output.

If you explain (by example(s)) what you mean by each of your bullets, someone may have suggestions. What do you "have" and what do you want to do with it?
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Oct 2012
Posts: 1
Hi

DBEXform could be one, to make easy forms for Sql Databases.

:JW
Reply With Quote
  #4 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,294
you want to create a DB using a graphical front end
there's several contenders out there, some of them are targeted at specific DB servers, but the output (SQL DDL) can probably used to create the schema in other DB's

MySQL workbench is probably worth a look, assuming you are contemplating using MySQL.
There's also one called SQL Power Architect

But like al these tools they do assume that you have got some basic knowledge on DB design, and know what the various terms mean.
__________________
Is taking part in the 'Distinguished Gentlemans' ride. Being neither distinguished nor a gentleman, but I am keen to raise funds for Prostrate Cancer research. At present I'm threatening to ride a Norton 961 wearing a kilt. If you would like to contribute to Prostrate Cancer research then please consider donating via this page:-
http://www.gentlemansride.com/rider/healdem
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Oct 2010
Location: Orlando, FL
Posts: 261
Your post is detailed but not in the way it helps us answer you. What are wanting to learn? SQL, database design concepts, RDBMS attributes?

I think you're asking for a program that lets you learn how to manage / administer databases and data and in that case it depends on what database software you prefer. We need to know if you're particular to any specific RDBMS vendor like Oracle, IBM, PostgreSQL, Microsoft, etc etc etc and then also what platform will the database you want to learn function on? Solaris, UNIX, Microsoft, etc etc etc.

If you don't have an answer to any of those, I highly recommend:

- Linux (Debian / RHEL) = Operating System
- PostgreSQL 9.2 = Database software (RDBMS)
- pgAdmin3 = graphical tool

Cost = $0.00

Good luck!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On