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.
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
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
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 understand
On 2005-06-23, Joel Rosdahl [EMAIL PROTECTED] wrote:
Or APSW http://www.rogerbinns.com/apsw.html.
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
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
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 think Dan was
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 mode, but I'm
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 think Dan was
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 or ADO
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 or whatever the
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
vulnerable in this
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 make sure
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
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 /
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,
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
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 shipped
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 restrictions or
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 without
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 /
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 recommend a
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
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 is broken.
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
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
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
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 without
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
getting it; why
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
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
31 matches
Mail list logo
