Re: Working with databases (ODBC and ORMs) in Python 3.2

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed6.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<nathan.alexander.rice@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.013
X-Spam-Evidence	'H': 0.97; 'S': 0.00; 'python.': 0.04; '2.7': 0.04; '3.2': 0.05; 'subject:Python': 0.06; 'decent': 0.07; 'python': 0.08; 'relational': 0.09; 'shop.': 0.09; 'library': 0.14; 'cc:addr:python-list': 0.15; '2.01': 0.16; '3.2,': 0.16; '3.2.': 0.16; 'alchemy': 0.16; 'showcase': 0.16; 'advance': 0.17; 'wrote:': 0.18; '2.x': 0.18; 'driver': 0.18; "haven't": 0.20; 'trying': 0.21; 'cc:no real name:20': 0.21; 'stuff': 0.22; 'received:209.85.213.46': 0.23; 'received:mail- yw0-f46.google.com': 0.23; 'header:In-Reply-To:1': 0.23; 'cc:20': 0.25; 'code': 0.25; 'statement': 0.25; "i'm": 0.26; 'url:mailman': 0.27; 'fine.': 0.28; 'cc:addr:python.org': 0.29; 'message-id:@mail.gmail.com': 0.29; 'server': 0.30; '3.x': 0.30; 'least': 0.31; 'thanks': 0.31; 'nov': 0.31; 'pm,': 0.31; 'anyone': 0.31; 'thu,': 0.32; 'url:listinfo': 0.32; 'does': 0.32; "won't": 0.32; 'there': 0.33; 'it?': 0.33; 'decide': 0.33; 'probably': 0.34; 'platform,': 0.34; 'url:python': 0.35; 'post': 0.35; 'google': 0.36; 'but': 0.37; 'using': 0.37; 'subject:with': 0.38; 'run': 0.38; 'received:google.com': 0.38; 'some': 0.38; 'received:209.85': 0.38; 'url:org': 0.38; "there's": 0.39; 'subject: (': 0.39; 'subject:: ': 0.39; 'received:209': 0.40; 'only.': 0.40; 'connect': 0.60; 'your': 0.61; 'stop': 0.62; '2011': 0.62; 'view': 0.65; 'making': 0.67; 'iron': 0.67; '3-4': 0.71; 'email addr:hotmail.com': 0.71; '2.7.': 0.84; '5-10': 0.84; 'honestly,': 0.84; 'nathan': 0.84; 'odbc': 0.84; 'shop,': 0.84; 'specifics': 0.84; 'to:addr:hotmail.com': 0.89; 'philips': 0.91
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=TRMb6sSc6X1aaEUCtmIcWjFQII11KK4bYZ6scX/LdTU=; b=Nxh9V/Sp6As9hetlxeH0rYdOCzU8YvDyT2B03ZtI/xiMx/XFJdDBQidJfb14yuDyBc wKhAOtU9/Ax/Q469fAXBTWLNuyaYV0BHlFzLpFmGpOtRoKmCyh2u+upw1sDcT6/2S0NQ VPICA92mQ7LcZGgY2RmoZN6V0gxLpxeuQKGvI=
MIME-Version	1.0
In-Reply-To	<63858437-450a-4c09-979d-e35f335fd12a@cc2g2000vbb.googlegroups.com>
References	<63858437-450a-4c09-979d-e35f335fd12a@cc2g2000vbb.googlegroups.com>
Date	Thu, 10 Nov 2011 15:35:22 -0500
Subject	Re: Working with databases (ODBC and ORMs) in Python 3.2
From	Nathan Rice <nathan.alexander.rice@gmail.com>
To	"tkpmep@hotmail.com" <tkpmep@hotmail.com>
Content-Type	text/plain; charset=ISO-8859-1
Cc	python-list@python.org
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.12
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.2620.1320957325.27778.python-list@python.org> (permalink)
Lines	29
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1320957325 news.xs4all.nl 6979 [2001:888:2000:d::a6]:53003
X-Complaints-To	abuse@xs4all.nl
Xref	x330-a1.tempe.blueboxinc.net comp.lang.python:15558

Show key headers only | View raw

For now, get started in Python 2.7.  Write code with an eye to 3.x
portability, and you will be fine.  You probably won't see 3.x
overtake 2.x for at least 3-4 years, and a decent amount of stuff is
still 2.x only.  Since it sounds like you are a windows/net shop, go
ahead and use Iron Python.

SQL Alchemy is your one stop shop.  It is basically 3.x compatible,
but see my previous statement about 3.x.  I haven't used SQL Alchemy
with SQL Server but honestly, SQL Alchemy is THE showcase python
library -- I doubt you will run into any issues.  Just google
"sqlalchemy sql server", I'm sure there's a blog post explaining the
specifics in detail.

Nathan

On Thu, Nov 10, 2011 at 1:56 PM, tkpmep@hotmail.com <tkpmep@hotmail.com> wrote:
> We are in the process of trying to decide between Python 2.7 and 3.2
> with a view to making a 5-10 year commitment to the right platform,
> and would appreciate some guidance on how best to connect to SQL
> databases in 3.2. ceODBC 2.01 provides an ODBC driver for Python 3.2,
> does anyone have experience using it? Also, are there any ORMs (object
> relational mapper)s that work well with 3,2?
>
> Thanks in advance
>
> Thomas Philips
> --
> http://mail.python.org/mailman/listinfo/python-list
>

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Working with databases (ODBC and ORMs) in Python 3.2 "tkpmep@hotmail.com" <tkpmep@hotmail.com> - 2011-11-10 10:56 -0800
  Re: Working with databases (ODBC and ORMs) in Python 3.2 Nathan Rice <nathan.alexander.rice@gmail.com> - 2011-11-10 15:35 -0500

csiph-web