Re: ORM opinion

2014-12-04 Thread Chris Angelico
On Fri, Dec 5, 2014 at 5:14 AM, Joseph L. Casale jcas...@activenetwerx.com wrote: Begrudgingly, I need to migrate away from SQLAlchemy onto a package that has fast imports and very fast model build times. I have a less than ideal application that uses Python as a plugin interpreter which is

RE: ORM opinion

2014-12-04 Thread Joseph L. Casale
First recommendation: Less layers. Instead of SQLAlchemy, just import sqlite3 and use it directly. You should be able to switch out import sqlite as db for import psycopg2 as db or any other Python DB API module, and still have most/all of the benefit of the extra layer, without any extra

Re: ORM opinion

2014-12-04 Thread Mark Lawrence
On 04/12/2014 23:20, Joseph L. Casale wrote: First recommendation: Less layers. Instead of SQLAlchemy, just import sqlite3 and use it directly. You should be able to switch out import sqlite as db for import psycopg2 as db or any other Python DB API module, and still have most/all of the benefit

Re: ORM opinion

2014-12-04 Thread Chris Angelico
On Fri, Dec 5, 2014 at 10:20 AM, Joseph L. Casale jcas...@activenetwerx.com wrote: I am stuck with the current architecture, but the idea you propose has been thrown around, truth is I am not certain if we are enduring the effort of such a large rewrite that Python is the tool to use (this is a

RE: ORM opinion

2014-12-04 Thread Joseph L. Casale
Anything listed here http://www.pythoncentral.io/sqlalchemy-vs-orms/ you've not heard about? I found peewee easy to use although I've clearly no idea if it suits your needs. There's only one way to find out :) Hi Mark, I found that article before posting and some of the guys here have

Re: ORM opinion

2014-12-04 Thread Chris Angelico
On Fri, Dec 5, 2014 at 10:43 AM, Joseph L. Casale jcas...@activenetwerx.com wrote: I found that article before posting and some of the guys here have already started using peewee. I don't have much time with it yet. So far all I can say is its unfortunate some package authors take such an