Database Design

what is the easiest to use database software?

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2006

Posts: 1

Reputation: buddie is an unknown quantity at this point

Solved Threads: 0

buddie

Offline

Newbie Poster

what is the easiest to use database software?

Sep 17th, 2006

I am creating a database from scratch for a scrap metal company in the uk, i have limited experience in MSexcel and have created some sort of database, however i reckon their are loads better software packages out there that are simple to use for a novice like me - any suggestions?:lol:

•

Join Date: Dec 2003

Posts: 6,439

Reputation: DMR will become famous soon enough

Solved Threads: 364

DMR

Offline

Wombat At Large

Re: what is the easiest to use database software?

Oct 5th, 2006

Have you looked in to FileMaker Pro? It's a good balance between ease-of-use and functionality, especially if you aren't heavily in to database development

"May the Wombat of Happiness snuffle through your underbrush."
- Ancient Aborigine blessing

Please do not contact me by email or PM for help. We're all volunteers here, and only have so much free time to dedicate to our efforts.

However, if I've been working on a thread with you already, and seem to have "forgotten" your thread, please do send me a message. I try not to let things slip through the cracks, but it does happen sometimes.

•

Join Date: May 2006

Posts: 35

Reputation: roswell1329 is an unknown quantity at this point

Solved Threads: 0

roswell1329 roswell1329 is offline

Offline

Light Poster

Re: what is the easiest to use database software?

Oct 24th, 2006

It sounds like you're new to the database world, but you may benefit from a data modeling tool to help you conceptualize how the database will operate, and to identify things that could use some normalization. I know some who use Visio for some rudimentary schema design, but Toad Data Modeler is free, powerful, and can target a large number of databases (like Oracle, MySQL, Access, etc).

After you create the diagram of your database, you should choose a database engine to use. If your accustomed to MS Office, then then natural progression would be to use Access. It's just fine for small databases. Another popular database that is also free is MySQL. It might be overkill, however, for something that won't be heavily utilized.

Hope that helps!

/* You are not expected to understand this */

•

Join Date: May 2006

Posts: 25

Reputation: forumposters is an unknown quantity at this point

Solved Threads: 1

forumposters forumposters is offline

Offline

Light Poster

Re: what is the easiest to use database software?

Oct 25th, 2006

MS Access is what I would suggest for you. It has a nice GUI and chances are you probably have it installed on your machine already if you have Office.

•

Join Date: Jan 2008

Posts: 14

Reputation: ujwaliyer is an unknown quantity at this point

Solved Threads: 0

ujwaliyer

Offline

Newbie Poster

Re: what is the easiest to use database software?

Jan 24th, 2008

you can use SQL server.

if u have any queries let me know

•

Join Date: Jan 2008

Posts: 2

Reputation: LewisC is an unknown quantity at this point

Solved Threads: 0

LewisC

Offline

Newbie Poster

Re: what is the easiest to use database software?

Jan 25th, 2008

Easiest to use: Filemaker, downside: not free

For free, you have several tools available. I'd suggest staying with the "name" brand databases.

Oracle Express
DB2 Express
MySQL
Postgres

MySQL is probably the easiest to get installed and get started with. It will limit you in the long run.

The other three, Oracle, DB2 and Postgres are all comparable in functionality. You'll find minimal third party support for db2 express. Oracle has massive support online but to scale up, should it ever be required, takes a lot money. Postgres is completely free, always. Lot's of third party support.

I'd say choose between Oracle and Postgres. Check with the company to see if they have any on house experience and go that way.

LewisC