Re: Database recommendations for Windows app

Thomas Bartkus wrote: > I was thinking of Win32com which I expect lets you put a wrapper around ADO > and work the ADO (or any other ActiveX) object model from within Python. Sure, but since others have made wrappers around ADO for Python before, you'd either reivent the wheel or or use e.g. http

Re: Database recommendations for Windows app

"Will McGugan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 /

Re: Database recommendations for Windows app

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, Tho

Re: Database recommendations for Windows app

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 > servi

Re: Database recommendations for Windows app

On 2005-06-22, Will McGugan <[EMAIL PROTECTED]> wrote: > 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 s

Re: Database recommendations for Windows app

Will McGugan wrote: > 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 restriction

Re: Database recommendations for Windows app

Thomas Bartkus wrote: > 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. I disagree. What does .mdb/jet wi

Re: Database recommendations for Windows app

Will McGugan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 /

Re: Database recommendations for Windows app

On 6/22/2005 11:38 AM, Thomas Bartkus wrote: > Will McGugan" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > >>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

RE: Database recommendations for Windows app

Firebird is cross platform (you would need the classic server version) look at the following post: http://mail.python.org/pipermail/python-list/2005-June/286366.html Chad -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Will McGugan Sent: Wednesday, June

Re: Database recommendations for Windows app

"Dan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On 6/22/2005 11:38 AM, Thomas Bartkus wrote: > > Will McGugan" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > And then XP Autoupdate executes, some of those Access/MSDE libraries are > updated, and you app

Re: Database recommendations for Windows app

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 fo

Re: Database recommendations for Windows app

In article <[EMAIL PROTECTED]>, Dan <[EMAIL PROTECTED]> wrote: . . . >> 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 >>

Re: Database recommendations for Windows app

On 2005-06-22, Cameron Laird <[EMAIL PROTECTED]> wrote: > Are you saying that Python-based applications are particularly > vulnerable in this all-too-common scenario? If so, I'm not > getting it; why is the architecture described more fragile than > more traditional Windows-oriented development p

Re: Database recommendations for Windows app

On 6/22/2005 1:14 PM, Dave Cook wrote: > On 2005-06-22, Cameron Laird <[EMAIL PROTECTED]> wrote: > > >>Are you saying that Python-based applications are particularly >>vulnerable in this all-too-common scenario? If so, I'm not >>getting it; why is the architecture described more fragile than >>m

Re: Database recommendations for Windows app

At 3:14 PM +0100 6/22/05, Will McGugan wrote: >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 wi

Re: Database recommendations for Windows app

In article <[EMAIL PROTECTED]>, Dan <[EMAIL PROTECTED]> wrote: >On 6/22/2005 1:14 PM, Dave Cook wrote: >> On 2005-06-22, Cameron Laird <[EMAIL PROTECTED]> wrote: >> >> >>>Are you saying that Python-based applications are particularly >>>vulnerable in this all-too-common scenario? If so, I'm not

Re: Database recommendations for Windows app

Thanks for the replies. I think I'm going to go with sqllite for now. For the curious, Im writing an interface to a nutritional database. So you can type in a foodstuff and it will tell you whats in it.. Will McGugan -- http://www.willmcgugan.com "".join({'*':'@','^':'.'}.get(c,0) or chr(97+(o

Re: Database recommendations for Windows app

Will McGugan wrote: > Thanks for the replies. I think I'm going to go with sqllite for now. Your list didn't mention a few things that might be critical. Referential integrity? Type checking? SQLite currently supports neither. Just make sure you check the list of supported features to see th

Re: Database recommendations for Windows app

On 2005-06-23, Peter Hansen <[EMAIL PROTECTED]> wrote: > Your list didn't mention a few things that might be critical. > Referential integrity? You can implement it in sqlite with triggers. I only bother with cascading delete triggers, myself. >Type checking? SQLite currently supports > ne

Re: Database recommendations for Windows app

Dave Cook <[EMAIL PROTECTED]> writes: > On 2005-06-22, Will McGugan <[EMAIL PROTECTED]> wrote: > > [...] >> Can anyone recommend a database that runs on Windows, is fast / >> efficient and can be shipped without restrictions or extra >> downloads? > > http://pysqlite.org Or APSW

Re: Database recommendations for Windows app

Cameron Laird wrote: > OK, I'm with you part of the way. Typical "Access" developers > are *always* involved with DLL hell, right? You're surely not > saying that Python worsens that frustration, are you? I think Dan was commenting on flaws in Microsoft's products, not in Python. As I understan

Re: Database recommendations for Windows app

On 2005-06-23, Joel Rosdahl <[EMAIL PROTECTED]> wrote: > Or APSW . Interesting. I was hoping it would not have one pysqlite2 limitation: if you have an empty database, cursor.description always returns None, even if you have "pragma empty_result_callbacks=1"

Re: Database recommendations for Windows app

Dennis Lee Bieber wrote: > Firebird might be a contender... I recently completed a 5 user Java based Windows reporting system that used Firebird as the SQL server based database. I found Firebird performed very well and I would not hesitate to use it again. Jussi Jumppanen Author of: Zeus for

Re: Database recommendations for Windows app

"Magnus Lycka" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Cameron Laird wrote: > > OK, I'm with you part of the way. Typical "Access" developers > > are *always* involved with DLL hell, right? You're surely not > > saying that Python worsens that frustration, are you? > > I th

Re: Database recommendations for Windows app

In article <[EMAIL PROTECTED]>, Dave Cook <[EMAIL PROTECTED]> wrote: >On 2005-06-23, Peter Hansen <[EMAIL PROTECTED]> wrote: . . . >>Type checking? SQLite currently supports >> neither. > >sqlite3 has a "strict affinity" m

Re: Database recommendations for Windows app

"Magnus Lycka" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Cameron Laird wrote: > > OK, I'm with you part of the way. Typical "Access" developers > > are *always* involved with DLL hell, right? You're surely not > > saying that Python worsens that frustration, are you? > > I thi

Re: Database recommendations for Windows app

Thomas Bartkus wrote: > "Magnus Lycka" <[EMAIL PROTECTED]> wrote in message > > The O.P. wanted a database for his > > Python app, and Thomas Bartkus suggested Access. > > Not exactly! Sorty, I meant Jet or whatever the backend is called these days. > I suggested the built in Microsoft DAO o

Re: Database recommendations for Windows app

"Magnus Lycka" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thomas Bartkus wrote: > > "Magnus Lycka" <[EMAIL PROTECTED]> wrote in message > > > The O.P. wanted a database for his > > > Python app, and Thomas Bartkus suggested Access. > > > > Not exactly! > > Sorty, I meant Jet

Re: Database recommendations for Windows app

On 6/22/2005 3:08 PM, Cameron Laird wrote: > In article <[EMAIL PROTECTED]>, Dan <[EMAIL PROTECTED]> wrote: > >>On 6/22/2005 1:14 PM, Dave Cook wrote: >> >>>On 2005-06-22, Cameron Laird <[EMAIL PROTECTED]> wrote: >>> >>> >>> Are you saying that Python-based applications are particularly v

Re: Database recommendations for Windows app

On 6/22/2005 9:51 PM, Peter Hansen wrote: > Will McGugan wrote: > >> Thanks for the replies. I think I'm going to go with sqllite for now. > > > Your list didn't mention a few things that might be critical. > Referential integrity? Type checking? SQLite currently supports > neither. Just ma

Re: Database recommendations for Windows app

Dan wrote: > So in SQLLite, what happens of you try to store XYZ in an integer field? Without your having enabled any of the "affinity" options mentioned by Dave Cook, SQLite will happily store 'XYZ' in that column, and return it to you when you query that row. The types are either ignored, or