Database recommendations for Windows app

[Dan]

Take a look at Firebird.  It can be run in embedded mode.  It might be 
overkill for your needs though...

On 6/22/2005 10:37 AM, Gregory Piñero wrote:
> I always figured a problem with using MySQL was distribution.  Would
> you have to tell your users to install MySQL and then to leave the
> service running?  I've never found an easy way to embed MySQL into a
> python app, and even if you could, would you then have to pay for it?
> 
> -Greg
> 
> 
> On 6/22/05, Thomas Bartkus <thomasbartkus at comcast.net> wrote:
> 
>>"Will McGugan" <news at NOwillmcguganSPAM.com> wrote in message
>>news:42b97240$0$24467$da0feed9 at news.zen.co.uk...
>>
>>>Hi,
>>>
>>>I'd like to write a windows app that accesses a locally stored database.
>>>There are a number of tables, the largest of which has 455,905 records.
>>>
>>>Can anyone recommend a database that runs on Windows, is fast /
>>>efficient and can be shipped without restrictions or extra downloads?
>>>
>>>I have googled and found plenty of information on databases, its just
>>>that I dont have enough experience with databases to know which one is
>>>best for my task!
>>
>>If you are writing strictly for the MS Windows platform
>>  And
>>If the database is running single user with a "locally stored database" on a
>>Windows workstation.
>>  Then
>>The MS Access file based (.mdb) system is hard to argue with.
>>You wouldn't have to distribute the (rather expensive) Access application
>>since this is little more than a front for the underlying DAO/ADO database
>>libraries that are built into the warp and woof of MS Windows.  Your Python
>>application can address the DAO or ADO directly as these will libraries will
>>be pre-installed and/or freely available for MS Windows.  Fast, freely
>>available, no license restrictions, and no need for extra downloads for a
>>reasonably recent (Win2000, XP) operating system.
>>
>>On the other hand, if operating system portability were a concern (as it
>>should be!), I might suggest MySQL.
>>A Python/MySQL application can jump between Windows to Linux (all flavors!)
>>to Unix to BSD without need to alter a single line of code.
>>
>>You were writing a Python app, weren't you :-)
>>Thomas Bartkus
>>
>>
>>--
>>http://mail.python.org/mailman/listinfo/python-list
>>