sqlalchemy and desktop apps

[Joel Mohler]

Hello,

I'm a happy user of sqlalchemy on small personal projects of my own
(http://bitbucket.org/jbmohler/pyhacc is one of them which is not
ready for use yet). At my day job we are in the process of evaluating
platforms for a rewrite of our small business accounting system. We
expect this rewrite to have 200k-300k LOC and sqlalchemy stands up
well in many ways to some of the C# alternatives we are considering.
The notion of writing the entire project in python is quite daunting
to management who is new to opensource.

I'm wondering if anyone would be kind enough to give an example of a
large desktop app written in sqlalchemy (even better if it's using
PyQt for the gui). We're pondering the viability of such a project in
python. In particular, we do a fair bit of document logic client side
with several hundred line invoice documents which we wish to edit as a
whole locally and send back to the server on an explicit user save
command. This is something which I wouldn't expect to typically be
needful in a web application.

I can certainly find examples of large websites on python via django,
but desktop business applications are a bit harder to come by. I
believe that eric4 is a good example but I was hoping for a largish
project involving sqlalchemy as well.

Thanks,
Joel

[avdd]

Hi Joel,

Although my application is deployed on the web it was written with the
goal of being redeployable as a desktop app, and to this end I have
been able to abstract away the web details so that I can code my
application very similarly to a desktop app.

The relevance here is that all database objects are pickled and
stashed in the session while the client interacts with it via AJAX
messages, upon which the server unpickles the object, updates it and
repickles it. This works very well, even on large trees of objects
and relationships. My next step here is to stash the draft objects
into the database rather than the session so that the user would be
able to work on a draft over a long period before committing the
changes. SQLAlchemy's optimistic concurrency control is vital here.
I intend to open source my framework as soon as I have time to get it
into a packagable state, but I'd be happy to share, especially if
someone is able to work on a GUI shell.

On Jul 24, 11:21 am, Joel Mohler <goo...@kiwistrawberry.us> wrote:
> Hello,
>
> I'm a happy user of sqlalchemy on small personal projects of my own

> (http://bitbucket.org/jbmohler/pyhaccis one of them which is not

[Tamás Bajusz]

Hi Joel!

pypapi.org is the bigest example a know.
It's using pyqt4, sqlalchemy and zope interfaces/schema/etc.
The only drawback for me, the code using too much italiano :)

Regards,
gbtami

> --
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
>
>

[Joel Mohler]

gbtami, Thanks!

> pypapi.org is the bigest example a know.
> It's using pyqt4, sqlalchemy and zope interfaces/schema/etc.
> The only drawback for me, the code using too much italiano :)

Indeed, too Italiano for me too, but the picture at
http://www.pypapi.org/chrome/site/pypapi.gif is worth a 1000 words for
my evaluation purposes and it's a nice picture! It does look like a
very similar project as what we are undertaking, but not quite so
large.

[erikj]

Hello Joel,

you can have a look at our pyqt-sqlalchemy framework :

http://www.python-camelot.com/

we use it in some large scale apps with millions of records
in the db.

should you have more questions, feel free to contact me.

Best regards,

Erik

On Jul 24, 3:21 am, Joel Mohler <goo...@kiwistrawberry.us> wrote:
> Hello,
>
> I'm a happy user of sqlalchemy on small personal projects of my own

> (http://bitbucket.org/jbmohler/pyhaccis one of them which is not

[Tim Black]

I'm not sure to what extent it works at present, but someone ported OpenERP server to work with SQLAlchemy:

http://openerp-team.blogspot.com/2009/08/open-erp-server-with-mysql.html

And some parts of OpenERP look like they use SQLAlchemy:

http://doc.openerp.com/bi/architecture/architecture.html?highlight=sqlalchemy
http://doc.openerp.com/bi/architecture/openobject_module.html?highlight=sqlalchemy
https://blueprints.launchpad.net/openobject-server/+spec/saserver

In May 2009 the following page said "30) The ORM layer is being ported to SQL Alchemy."

http://openerp-team.blogspot.com/2009/05/r-planning-of-may_15.html

Tim

[erikj]

Development of the OpenERP sqlalchemy branch was stopped.
(I asked that question at europython)

If somebody is interested, I have a bunch of code to port OpenERP
modules to Elixir/Sqlalchemy, but it's very raw code...

On Sep 14, 3:02 am, Tim Black <t...@alwaysreformed.com> wrote:
> I'm not sure to what extent it works at present, but someone ported
> OpenERP server to work with SQLAlchemy:
>
> http://openerp-team.blogspot.com/2009/08/open-erp-server-with-mysql.html
>
> And some parts of OpenERP look like they use SQLAlchemy:
>

> http://doc.openerp.com/bi/architecture/architecture.html?highlight=sq...http://doc.openerp.com/bi/architecture/openobject_module.html?highlig...https://blueprints.launchpad.net/openobject-server/+spec/saserver