Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

mySQL, MS access, Oracle ...spec question  RSS feed

 
Peter Primrose
Ranch Hand
Posts: 755
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
guys,

Say I have to create a database with the following spec:

500 users,
30 simultaneous connections,
All information in the db will be text and will not exceed 200Mb

What db should I use?

I�ve been using MS for a while and it worked great, however, I learned that mySQL is much more robust and FREE. As per Oracle � I�m not sure.

Anyone can help on this one?

"I�m the wonder�"
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 65971
140
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While Access may be a great little personal database -- I used it quite a bit when I was still using Windows to keep track of personal data -- it is by no means production-capable. And, unless things have changed a bit, you will be saddled with the ODBC-JDBC bridge in order to use it from Java.

Free databases like MySQL and PostgreSQL (I use the latter for my commercial sites) certainly have the chops for the job.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!