2009/1/27 Joshua D. Drake <[email protected]>: > > On Tue, 2009-01-27 at 06:02 -0500, chris mollis wrote: >> Trailbender.net uses Postgresql, postgis, and pylons (on EC2), but >> it's not really finished yet. I could talk about our experiences, but >> you probably want speakers with finished products or services. >> > > Not necessarily. Software is never finished, you know that :). You have > some significant buzzword compliance up there: > > PostgreSQL (nobody should be using anything different anyway) > Postgis (GIS is the rage) > Pylons (well duh) > EC2... that's the cloud man. > > I think a talk or even mini-tutorial that breaks out specific problems > that were found and solved within the entire package would be > incredible.
Problems with postgresql? mmmm.... This is a hard problem. Postgresql works fine. An unusual example: If you have PostgreSQL running in a Freebsd jail you must setup sysvipc[1]. [1] http://www.freebsddiary.org/jail-multiple.php SQLAlchemy integrates fine with PostgreSQL and pylons does with SQLAlchemy. If you want more and more you can extend sqlalchemy (I don't do still). SQLAlchemy it's great for make easy vertical or horizontal partition. You can intercept insert and updates to keep it in one master and dispatch selects to a lot of slaves. But this is a talk for sqlalchemy gurus. I don't do these advanced things in a production environment (still). I encountered multi-master replication hard. I'm looking for a solution. All other things are easy or well documented. Regards, Javi PD: Excuse my poor english > > Sincerely, > > Joshua D. Drake > > -- > PostgreSQL - XMPP: [email protected] > Consulting, Development, Support, Training > 503-667-4564 - http://www.commandprompt.com/ > The PostgreSQL Company, serving since 1997 > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
