On Wed, Sep 9, 2009 at 2:48 AM, Jules Stevenson<[email protected]> wrote: > >> If the database itself is accessible over the network (e.g., with >> MySQL or PostgreSQL), you can write a standalone SQLAlchemy >> application that users can run on their desktops, which connects to >> the database via a remote engine. To access the model in the Pylons >> application, install the application on everybody's desktops, then >> have the standalone application import the model and call >> init_model(engine). >> >> If the database is not accessible over the network or you prefer to go >> through a central web application, you can make the application's >> actions accept JSON input/output instead of HTML, and then write a >> separate standalone application users would run on their desktops, >> which packages up their data to JSON and sends it to the web >> application. > > Thanks Mike, much appreciated. I've got JSON to work and it's looking pretty > good, although possibly a bit slow [I guess because of the HTTP connections > overhead, I'm using HTTPlib to do this], however its ease of use probably > outweighs any speed benefits :).
Is there some reason you can't connect to the database remotely? That's the most efficient way. -- Mike Orr <[email protected]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
