Database on Mac

I am new to this Mac environment. I am planning to develop a Java Application that runs on Mac OS.
My application requires a database. my database is not so huge.

What is the best database that i can use in my application. If database is free it would be nice(as my client dont have $$ to spend)?

Is there anythings to be considered b4 i start writing the application?

Thanks.
sankar_nekkanti1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

speyfisherCommented:
MySQL is a database server found on OSX server.  You can install it by getting the binary and the guide from http://www.entropy.ch/software/MacOSx/mysql/

The famous phpMyAdmin is a free GUI to administer MySQL from your browser
http://www.phpmyadmin.net/home_page/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
InsolenceCommented:
As spey mentioned, MySQL is one of the best (if not the best) database, and it is completely free.  And there isn't much for you to consider, seeing as how you didn't describe what exactly you're doing.  The only thing I would consider are things like...

Is this application going to install on a lot of people's computers?  If so, are you going to require them all to install MySQL?  That is a bit extreme.  With a week or less of work you could make something that resembles a database in Java or any other decent language that just stores information in a file.

Is this application server-side only?  If so, why in Java?  C++ especially if this is high-demand is a better choice for something higher end.  If it has low requirements, and isn't going to be doing much though, Java is just fine.

The next few things I would consider is permissions.  If you're going to use MySQL, you should prolly make at least 1 user, maybe multiple users, with very restricted access.  Allow them only to do the things they need to do, nothing more.  This is the user that you will make your program use.  Also... lock the root account for MySQL down with a good alphanumeric password.

Other than that... code away.  =)  If you want to reveal more detail about what type of project you're attacking here, maybe myself or someone else can give you a little more advice, or things to think about before you jump right in.  =)  Take care mate.

 - Insolence
jjamcguCommented:
Another option that is free for low utilization (With a fee to unlock speed limits) is openbase.  You can find it at www.openbase.com  I use it for Web Objects Development in Java.  They are very responsive if you have any questions or problems.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Apple Hardware

From novice to tech pro — start learning today.