Which desktop database to choose Database? [Archive]

View Full Version : Which desktop database to choose Database?

perlom

07-25-07, 10:58

Hi all,

We are developing a client side application in C# that uses a local desktop database in its operation. The application was built using FireBird database which is a small footprint file based DB. However it doesn't support 64-Bit. Seeking another options, I looked into SQLite engine. Although it seemed that it has some popularity in that domain, however it lacked some important features that we need (i.e. some SQL commands are omitted like "ALTER TABLE ADD Constraint" or "CREAT DOMAIN"). Now I am looking into MS. Access as well,. My question is there any recommendation for a desktop DB that support 64-Bit (x64 machines), has good technical support, .NET implementation and has low administration over head. Any advice?

Cheers

Satya

07-26-07, 05:15

Have you looked at SQLExpress edition whcih is free to use in thsi case, http://www.microsoft.com/sql/editions/express/default.mspx fyi.

pootle flump

07-26-07, 05:47

Moving to desktop database forum.

healdem

07-26-07, 06:23

In those circumstances Id seriously consider MySQL. It fullfills all of those criteria.. its scaleable, it runs on 32 & 64 bit OS's, it doesn't have the cost implications of SQL server, or the limitations of SQL server express.

there are sufficient tools out there to support it in the field.

its pretty good on ANSI/ISO SQL compliance.. its aint perfect, but no SQL product is.

it supports triggers & stored procedures (at least V5 on does.....)

perlom

07-26-07, 09:19

Thanks for the replies.. I have looked into SQL Express. However we are more concerned about the distributions file size (35 MB to 80 MB), since our application is downloadable from the web.

I have also looked into Access, but it is not clear to me yet it supports 64-Bit development or not.

MySQL seems to be a decent solution that we should consider. Does it have a good .NET interface/driver? How about the distribution file size? Any link would be helpful :).

Cheers

perlom

07-26-07, 09:19

jezemine

07-26-07, 10:30

a .net client api for mysql is called Connector/NET and is available here:

http://dev.mysql.com/downloads/connector/net/5.0.html

r937

07-26-07, 11:05

a quick google for "64 bit database small footprint" turns up your post on the microsoft forums yesterday as the #1 result

shows you how clever and up-to-date google is, eh

the other results contain some actual products, e.g.
http://www.mcobject.com/extremedbfamily.shtml

perlom

07-26-07, 11:43

Google rocks lol.

ExtremeDb is an In-Memory Db, we have ruined out that direction before :(

I wonder if anybody has an expraince using MS Access in 64-Bit enviroment. Does it actually work?

stevegra

09-05-07, 12:53

There is a new member of the eXtremeDB product family; eXtremeDB Fusion, which is so named because it fuses in-memory and on-disk database storage modality. In a single database definition, you can designate some tables (classes) as being in-memory and others as being on-disk (cached, of course, like any other on-disk DBMS, but writes are written through the cache to persistent storage). eXtremeDB Fusion also offers different transaction logging policies (UNDO and REDO) that you can select from according to your application requirements, available memory, etc.

It is available in 32- and 64-bit versions, with SQL, and with High Availability.

r937

09-05-07, 13:26

whoa, that's fabulous, that's the first database i've heard of that has modalities

i'm not sure i like the idea of my memory being fused to my hard disk, though

loquin

09-05-07, 14:18

The full distribution of PostgreSQL is a bit over 20 MB. If you want to customize it, it could be pared down considerably. In addition, it's truly free, for any application, commercial or private. And, it's probably the most ANSI compliant of any database.