Re: DB access without object-relation mapping?

2008-07-29 Thread Ben Finney
kj <[EMAIL PROTECTED]> writes: > The word on the street is to use something like SQLAlchemy for > database access in Python, but my experience in the past with > packages that perform automated SQL generation has been awful, so I > always return to lighter-weight solutions that allow me to write m

Re: DB access without object-relation mapping?

2008-07-29 Thread kj
In <[EMAIL PROTECTED]> Tim Henderson <[EMAIL PROTECTED]> writes: >I believe there are a couple of options but pyscopg, and PyGreSQL seem >to be popular. Great. Thanks! kynn -- NOTE: In my address everything before the first period is backwards; and the last period, and everything after it, sho

Re: DB access without object-relation mapping?

2008-07-29 Thread Paul Boddie
On 29 Jul, 17:20, kj <[EMAIL PROTECTED]> wrote: > > So what's the > standard Python way to send SQL directly to a Postgres database > and get back results? Take a look at this page: http://wiki.python.org/moin/DatabaseInterfaces I've used psyco

Re: DB access without object-relation mapping?

2008-07-29 Thread Tim Henderson
On Jul 29, 11:20 am, kj <[EMAIL PROTECTED]> wrote: > Python noob here. > > I want to write a script that creates and populates a simple Postgres > database. > > The word on the street is to use something like SQLAlchemy for > database access in Python, but my experience in the past with > packages

Re: db access

2006-12-29 Thread vasudevram
king kikapu wrote: > On Dec 29, 12:12 am, johnf <[EMAIL PROTECTED]> wrote: > > king kikapu wrote: > > > Hi to all, > > > > > is there a way to use an RDBMS (in my case, SQL Server) from Python by > > > using some built-in module of the language (v. 2.5) and through ODBC ?? > > > I saw some samples

Re: db access

2006-12-29 Thread king kikapu
Hi Johnf, are you referring to this ? http://www.freetds.org/ And how i can get psmssql.py so i can get a shot on it, is it included in FreeTDS ?? On Dec 29, 12:12 am, johnf <[EMAIL PROTECTED]> wrote: > king kikapu wrote: > > Hi to all, > > > is there a way to use an RDBMS (in my case, SQL Se

Re: db access

2006-12-28 Thread johnf
king kikapu wrote: > Hi to all, > > is there a way to use an RDBMS (in my case, SQL Server) from Python by > using some built-in module of the language (v. 2.5) and through ODBC ?? > I saw some samples that use statements like "import dbi" or "import > odbc" but neither modules (dbi, odbc) are pr

Re: db access

2006-12-28 Thread Chris Mellon
On 12/28/06, Martin P. Hellwig <[EMAIL PROTECTED]> wrote: > king kikapu wrote: > > Hey Martin, > > > > thanks for the fast reply! > > > > I have already seen that link and i just downloaded the pyodbc module > > but isn't Python already containing a "built-in" odbc module so to > > allow for db com

Re: db access

2006-12-28 Thread Laszlo Nagy
king kikapu írta: > Hey Martin, > > thanks for the fast reply! > > I have already seen that link and i just downloaded the pyodbc module > but isn't Python already containing a "built-in" odbc module so to > allow for db communication ?? > There is no built-in ODBC module. We all know that Pytho

Re: db access

2006-12-28 Thread Martin P. Hellwig
king kikapu wrote: > Hey Martin, > > thanks for the fast reply! > > I have already seen that link and i just downloaded the pyodbc module > but isn't Python already containing a "built-in" odbc module so to > allow for db communication ?? > Not that I'm aware of, but it is possible to do odbc w

Re: db access

2006-12-28 Thread king kikapu
Hey Martin, thanks for the fast reply! I have already seen that link and i just downloaded the pyodbc module but isn't Python already containing a "built-in" odbc module so to allow for db communication ?? On Dec 28, 6:06 pm, "Martin P. Hellwig" <[EMAIL PROTECTED]> wrote: > king kikapu wrote: >

Re: db access

2006-12-28 Thread Martin P. Hellwig
king kikapu wrote: > Hi to all, > > is there a way to use an RDBMS (in my case, SQL Server) from Python by > using some built-in module of the language (v. 2.5) and through ODBC ?? > I saw some samples that use statements like "import dbi" or "import > odbc" but neither modules (dbi, odbc) are pre