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 > Database Concepts & Design > Which Database to Use??

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-18-07, 12:35
LFDavidson LFDavidson is offline
Registered User
 
Join Date: May 2007
Location: Washington State
Posts: 3
Which Database to Use??

I am looking at developing a database but I am not sure what direction to go with the language or database design (Access, SQL, Oracle, Sybase, etc.) Looking for feedback/recommendations/pros&cons. The data would be for surveys of a mulitude of companies and involves a lot of text in comment form, some ratings, pre-determined choices/categories, ability to do statistics on ratings and metrics, searchable text (within db and within field), the usual names/address/mailing list type info, follow up alerts on dates and priority based, PC based to start but with growth to client server, maybe browser based, useable in the field on a laptop but able to bring it back to a server. Seems the leading factor might be the need for text in the database. I am familiar with VB, Access, and SQL so leaning that way.

Any comments are really appreciated...
Reply With Quote
  #2 (permalink)  
Old 05-18-07, 13:09
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
If you believe you'll be outgrowing a single user/desktop, then go with a server-based solution. Any of the above except access. Add PostgreSQL and MySQL to the mix also. Both Oracle and SQL Server have 'Lite' versions of their databases that you can install on a desktop PC and use there initially, and buy the full blown version when you outgrow the limitations of the lite version. You could, of course, install PostgreSQL or mySql up front, and not worry about needing to upgrade to a "full" version later.

PostgreSQL offers a more complete feature-set than MySQL, and has closed the performance gap (and is faster than MySQL when you use constraints/referential integrity in the database, and with more than 8-10 concurrent users), whereas mySql has historically tended to emphasize speed over enforcement of data integrity (in the database) but has recently introduced some features that other products have had for years.
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Reply With Quote
  #3 (permalink)  
Old 05-18-07, 13:24
healdem healdem is offline
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,246
it depends what you want to do
it depends how you see your database being used
if its an online web survey then a web paradigm may be appropriate (if so budget reasons may make PHP & MySQL)

if its a conventional application, and you are familiar with Access then Id use Access but use a server back end to actually store the data.. it can be any server product.. if budget is an issue then MySQL is fine, if you have ample budget then any of the other products are viable.

there are several issues
what you are familiar with
what the application demands
what the users require
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
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