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