Looking for some real-world advice on what is the best way to
access MS SQL Server 2008R2 databases via Python 2.7 running
under Windows XP, Vista, and Windows 7 and Windows Server 2005
and 2008.
Based on my research, here's my list of choices:
mxODBC
[1]http://www.egenix.com/products/python
On 17/06/2011 16:01, pyt...@bdurham.com wrote:
Looking for some real-world advice on what is the best way to access MS
SQL Server 2008R2 databases via Python 2.7 running under Windows XP,
Vista, and Windows 7 and Windows Server 2005 and 2008.
Based on my research, here's my list of choices
pyt...@bdurham.com wrote:
Looking for some real-world advice on what is the best way to access
MS SQL Server 2008R2 databases via Python 2.7 running under Windows XP,
Vista, and Windows 7 and Windows Server 2005 and 2008.
Based on my research, here's my list of choices:
mxODBC
http
On Jun 17, 2011, at 17:01, pyt...@bdurham.com wrote:
Looking for some real-world advice on what is the best way to access MS SQL
Server 2008R2 databases via Python 2.7 running under Windows XP, Vista, and
Windows 7 and Windows Server 2005 and 2008.
I use the COM interface to ADO, for a few
databases in python 2.6 are not compatible with python 2.5 and are
slow in python 2.6
type: crash
versions: Python 2.6
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8504
Martin v. Löwis mar...@v.loewis.de added the comment:
Jesus, any idea?
--
assignee: - jcea
nosy: +jcea, loewis
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8504
___
Jesús Cea Avión j...@jcea.es added the comment:
The database compatibility is dictated by the underlying Berkeley DB library
used. Reporter, please do this: (asuming you are using bsddb lib in the
standard lib, not external project pybsddb)
1. Open a python2.5 shell.
2. import bsddb
3.
Peter Landgren peter.tal...@telia.com added the comment:
I could add what I have found using bsddb in Python 2.5 and 2.6 under Windows
XP SP3. In my installation:
Python 2.5.4 bsddb 4.4.5.3
Python 2.6.4 bsddb 4.7.3
What I did: In Gramps imported an XML backup file to a empty bsddb database. It
Jesús Cea Avión j...@jcea.es added the comment:
I need to know the Berkeley DB version you are using in python 2.5, 2.6, both
with bsddb and pybsddb (bsddb3).
Also, I would need a testcase I can try without installing Gram myself.
--
___
Python
Peter Landgren peter.tal...@telia.com added the comment:
Requested data on my Windows box:
Python 2.5 bsddb 4.4.5.3 4.4.20
Python 2.6 bsddb 4.7.3 4.7.25
Python 2.6 bsddb 4.8.4 4.8.26
OK?
--
___
Python tracker rep...@bugs.python.org
Peter Landgren peter.tal...@telia.com added the comment:
Maybe I should add that there is no speed degradation between 2.5 and 2.5 when
doing the same thing in Linux.
--
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8504
Jesús Cea Avión j...@jcea.es added the comment:
Peter, and which Berkeley DB versions are used in Linux?.
--
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8504
___
Peter Landgren peter.tal...@telia.com added the comment:
In Linux it is:
4.4.5.3 (4, 6, 21)
You asked for a test case. I'm not sure how I can provide one without you
having Gramps installed to test it.
Do you mean the whole database environment?
--
Tim Lyons guy.lin...@gmail.com added the comment:
On Mac OS X,I get
tim$ python
Python 2.5.5 (r255:77872, Mar 21 2010, 22:08:39)
[GCC 4.0.1 (Apple Computer, Inc. build 5367)] on darwin
Type help, copyright, credits or license for more information.
import bsddb
print bsddb.__version__,
Peter Landgren peter.tal...@telia.com added the comment:
To make it 100% clear:
The versions are almost the same for Linux and Windows.
Python 2.5Python 2.6
Windows 4.4.5.3 (4, 6, 20)4.7.3 (4.7.25)
Linux4.4.5.3 (4, 6, 21)4.7.3 (4.7.25)
--
report; anybody interested in them should create a separate bug report.
One bug per bug report, please.
--
title: bsddb databases in python 2.6 are not compatible with python 2.5 and are
slow in python 2.6 - bsddb databases in python 2.6 are not compatible with
python 2.5
Martin v. Löwis mar...@v.loewis.de added the comment:
I just noticed that Tim reports in msg104030 that the original problem is
resolved. So I'm closing this report as fixed.
If you create a new one on the performance issue, please make sure to include a
repeatable test case, with
Changes by Martin v. Löwis mar...@v.loewis.de:
--
resolution: - invalid
status: open - closed
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8504
___
Hi All,
I am interested in playing with python some more and am looking at
writing an app with data stored in a database. I have experience with
mysql but thought that their may be other better databases that can be
more easily distributed with the program does anyone have any
suggestions
Anthony Irwin wrote:
Hi All,
I am interested in playing with python some more and am looking at
writing an app with data stored in a database. I have experience with
mysql but thought that their may be other better databases that can be
more easily distributed with the program does
On Apr 13, 1:02 am, Anthony Irwin [EMAIL PROTECTED] wrote:
Hi All,
I am interested in playing with python some more and am looking at
writing an app with data stored in a database. I have experience with
mysql but thought that their may be other better databases that can be
more easily
Anthony Irwin wrote:
Also is wxpython the best cross platform gui library it seems to be the
best I have seen so far.
IMO, it's an extremely mature and well-supported library. I have no
experience with others (except a brief stint with Tkinter) but the
consensus I hear seems to be that
Dennis Lee Bieber wrote:
On Fri, 28 Apr 2006 21:29:32 +0100, Steve Holden [EMAIL PROTECTED]
declaimed the following in comp.lang.python:
Dennis Lee Bieber wrote:
Given that his web-site implies that he does these for a living, it
may not be a publicly available item.
Nah, he's a
Thank you very much, Steve.
Petr Jakes
--
http://mail.python.org/mailman/listinfo/python-list
Petr Jakes wrote:
Thank you very much, Steve.
Happy to oblige. You did me a favor, as I had promised the students I
would put the notes up on the net. Must remember to include them in the
permanent site build process now :-)
regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494
I would like to know if anybody can point me to the site, where it is
possible to find the tutorial Using Databases in Python which is
mentioned by Steve Holden here: http://tinyurl.com/ectj8
Thanks
Petr Jakes
--
http://mail.python.org/mailman/listinfo/python-list
It might be in his book, Python Web Programming, or just go to
http://www.holdenweb.com/
and ask him yourself using the contact form.
He's a generous contributor here.
rick
--
http://mail.python.org/mailman/listinfo/python-list
I have got Steven's book of course (it is excellent IMHO). I was just
thinking some new approaches can be found in the tutorial.
Petr Jakes
--
http://mail.python.org/mailman/listinfo/python-list
Dennis Lee Bieber wrote:
On 28 Apr 2006 08:20:35 -0700, Petr Jakes [EMAIL PROTECTED] declaimed the
following in comp.lang.python:
I would like to know if anybody can point me to the site, where it is
possible to find the tutorial Using Databases in Python which is
mentioned by Steve Holden
Dan Stromberg wrote:
I've been putting a little bit of time into a file indexing engine
[...]
To solve the O.P.'s first problem, the facility we need is an
efficient externally-stored multimap. A multimap is like a map,
except that each key is associated with a collection of values,
not just a
About the filename ID - word ID table: Any good database (good with
large amounts of data) will handle the memory management for you. If
you get enough data, it may make sense to get bothered with PostgreSQL.
That has a pretty good record on handling very large sets of data, and
intermediate sets
About indexes everywhere: Yes, you don't have to be a DB expert to know
that indexes everywhere is bad. But look at this example. There are
really two ways that the data is going to get accessed in regular use.
Either they are going to ask for all files that have a word (most
likely) or they are
On Thu, 16 Feb 2006 10:09:42 +0100, Rene Pijlman wrote:
Dan Stromberg:
is there a python database interface that would allow me to define a
-lot- of tables? Like, each word becomes a table, and then the fields
in that table are just the filenames that contained that word.
Give ZODB a try.
Dan Stromberg wrote:
Bryan Olson wrote:
[...]
Well, you could use simple files instead of fancy database tables.
That's an interesting thought. Perhaps especially if australopithecine
were saved in a filename like:
~/indices/au/st/ra/lo/pi/th/ec/in/e
Right, though the better
On Fri, 17 Feb 2006 12:32:52 +0100, Rene Pijlman wrote:
Dan Stromberg:
My first attempt would be: a BTree with the word as key, and a 'list of
filenames' as value.
http://www.zope.org/Wikis/ZODB/FrontPage/guide/node6.html#SECTION00063
This is basically what I'm doing now,
Dan Stromberg:
Rene Pijlman:
Right. My second attempt would be: a BTree with the word as key, and a
BTree of filenames as value
Would ZODB let me do that?
Yes.
I'm puzzled, because:
d1={}
d={}
d[d1] = ''
TypeError: dict objects are unhashable
This is using a dict as _key_, whereas I
I've been putting a little bit of time into a file indexing engine in
python, which you can find here:
http://dcs.nac.uci.edu/~strombrg/pyindex.html
It'll do 40,000 mail messages of varying lengths pretty well now, but I
want more :)
So far, I've been taking the approach of using a single-table
Dan Stromberg:
is there a python database interface that would allow me to define a
-lot- of tables? Like, each word becomes a table, and then the fields
in that table are just the filenames that contained that word.
Give ZODB a try.
http://www.zope.org/Wikis/ZODB/FrontPage
Jonathan Gardner wrote:
I'm no expert in BDBs, but I have spent a fair amount of time working
with PostgreSQL and Oracle. It sounds like you need to put some
optimization into your algorithm and data representation.
I would do pretty much like you are doing, except I would only have the
On Thu, 16 Feb 2006 13:45:28 +, Bryan Olson wrote:
Dan Stromberg wrote:
I've been putting a little bit of time into a file indexing engine
[...]
So far, I've been taking the approach of using a single-table database
like gdbm or dbhash [...] and making each entry keyed by
a word, and
On Wed, 15 Feb 2006 23:37:31 -0800, Jonathan Gardner wrote:
I'm no expert in BDBs, but I have spent a fair amount of time working
with PostgreSQL and Oracle. It sounds like you need to put some
optimization into your algorithm and data representation.
I would do pretty much like you are
I'm no expert in BDBs, but I have spent a fair amount of time working
with PostgreSQL and Oracle. It sounds like you need to put some
optimization into your algorithm and data representation.
I would do pretty much like you are doing, except I would only have the
following relations:
- word to
42 matches
Mail list logo