Mailing List Archive: Python: Python

using SQLalchemy

Index | Next | Previous | View Threaded

andrea.crotti.0 at gmail

Jun 21, 2012, 3:50 AM

Post #1 of 3 (142 views)
Permalink

using SQLalchemy

We have a very chaotic database (on MySql) at the moment, with for
example table names used as keys to query other tables (but that's just
an example).

We are going to redesign it but first I still have to replace the
perl+vbscript system with only one Python program, so I still have to
deal with the current state.

I'm trying to use SQLalchemy and it looks absolutely great, but in
general as a policy we don't use external dependencies..

To try to do an exception in this case:
- are there any problems with SQLalchemy on Windows?
- are there any possibly drawbacks of using SQLalchemy instead of the
MySqlDB interface?

For the second point I guess that we might have a bit less fine
tuning, but the amount of data is not so much and speed is also not a
bit issue (also because all the queries are extremely inefficient
now).

Any other possible issue?

Thanks,
Andrea
--
http://mail.python.org/mailman/listinfo/python-list

chris at python

Jun 22, 2012, 11:08 AM

Post #2 of 3 (139 views)
Permalink

Re: using SQLalchemy [In reply to]

On 21/06/2012 11:50, andrea crotti wrote:
> We have a very chaotic database (on MySql) at the moment, with for
> I'm trying to use SQLalchemy and it looks absolutely great, but in
> general as a policy we don't use external dependencies..

That's a very foolish general policy, a lot of the power of python is in
the huge array of excellent third party libraries and frameworks, but
each to their own...

> To try to do an exception in this case:
> - are there any problems with SQLalchemy on Windows?

No.

> - are there any possibly drawbacks of using SQLalchemy instead of the
> MySqlDB interface?

You won't be using it instead of mysqldb, you'll be using it as a layer
over mysqldb.

> For the second point I guess that we might have a bit less fine
> tuning,

Not so, any tuning you can do direct against the dbapi driver can still
be done through SQLAalchemy.

> Any other possible issue?

If you have problems, I'd suggest asking on the sqlalchemy mailing list:

http://groups.google.com/group/sqlalchemy

cheers,

Chris

--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
--
http://mail.python.org/mailman/listinfo/python-list

ramit.prasad at jpmorgan

Jun 22, 2012, 1:49 PM

Post #3 of 3 (137 views)
Permalink

RE: using SQLalchemy [In reply to]

> > We have a very chaotic database (on MySql) at the moment, with for
> > I'm trying to use SQLalchemy and it looks absolutely great, but in
> > general as a policy we don't use external dependencies..
>
> That's a very foolish general policy, a lot of the power of python is in
> the huge array of excellent third party libraries and frameworks, but
> each to their own...

That applies to Perl, Python, Java and probably most major languages.
I do not know about you, but I do not want to be writing everything
from scratch and language developers have better things to do than
implementing a dozen (or more) major libraries like lxml and xlwt
just to name a few.

For that matter, I do not think mysqldb is a built-in Python package.
:)

Ramit

Ramit Prasad | JPMorgan Chase Investment Bank | Currencies Technology
712 Main Street | Houston, TX 77002
work phone: 713 - 216 - 5423

--

This email is confidential and subject to important disclaimers and
conditions including on offers for the purchase or sale of
securities, accuracy and completeness of information, viruses,
confidentiality, legal privilege, and legal entity disclaimers,
available at http://www.jpmorgan.com/pages/disclosures/email.
--
http://mail.python.org/mailman/listinfo/python-list

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads