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 > Database Server Software > Other > DB desicion

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-28-08, 06:24
nlobak nlobak is offline
Registered User
 
Join Date: Dec 2008
Posts: 3
DB desicion

Hello,

Our company developing a new software for our devices.
One of the importent issues is choosing the right DB.

The requirements: simple, easy to maintanance, quick to develop.
support multiuser enviroment, and remote stations.
Thousands of records to be stored.
Will be accessed by dozens of threads simultaneously, writing and reading data.

I would appreciate you help.
Reply With Quote
  #2 (permalink)  
Old 12-28-08, 15:07
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 686
What OS do you intend the DBMS to run on? Or is that open to suggestions too?

What do you mean by "devices"? Are you looking for a system that works in embedded systems and/or servers, maybe with synch between the two?
Reply With Quote
  #3 (permalink)  
Old 12-29-08, 01:37
nlobak nlobak is offline
Registered User
 
Join Date: Dec 2008
Posts: 3
It can be any OS (different customers), but mainlly windows systems.

The devices will send online transactions to the database simultaniously.

There can be dozens of those devices.
Reply With Quote
  #4 (permalink)  
Old 12-29-08, 01:53
nlobak nlobak is offline
Registered User
 
Join Date: Dec 2008
Posts: 3
I will explain a little more:

Access doesn't fit because he doesn't treat multiple read-write very well.
SQLite and compact SQL won't fit as well.

I can't decide between SQL Express 2005 and MySQL...
Because from one hand it's important that the installation will be fast and simple (which is the case with MySQL), from the other hand it's important to be able to program and maintain it easily and fast (which is the case with SQL Express 2005).

maybe you have a tip for me?

Or maybe I'm missing something and there is anothere DB I haven't thought about?
Reply With Quote
  #5 (permalink)  
Old 01-08-09, 12:12
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,657
Don't ignore PostgreSQL either. As concurrency goes up, it outperforms MySQL, and is very extendable...
__________________
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
Reply

Thread Tools
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