Laurent, Regarding QCMagritte I don't know, since I don't use it. I've used Magritte and Glorp, but didn't bind them, the only special thing I built for it was an "evented memento" that let me edit a tree of objects (1:N relations derived from the edited object) within a single DB transaction.
Regarding migrations I recently found that in VisualWorks Glorp provides a migration-like strategy, where you define a subclass of a root Description system, and then can use the diffing to create the migration. According to the VW docs, you can do it like this: sessOld := MyDescriptorSystem new sessionForLogin: aLogin. sessNew := MyDescriptorSystem01 new sessionForLogin: aLogin. sessOld system migrateTo: sessNew system. Such feature is not available in the Pharo port, and migrations are not automatic, since you need a new class for each migration. It is something I'd need to play with before porting it to Pharo, if it's worth it. Maybe we think about another strategy but still using the DDL objects of Glorp. Regards! Esteban A. Maringolo 2017-09-18 7:22 GMT-03:00 laurent <laurent.laff...@gmail.com>: > Hi all, > > it's been a long time :) At work we are currently comparing several > technologies to start a business project that will hopefully be used by > thousands of people for several years ;) > > We need a web stack and we put Pharo & co in the comparative process. My > team have strong experience in load-balanced php / mysql deployment that > handles millions of records but we are ready to build on something else > though MySQL is still a requirement. > > Thanks for Garage + Glorp, I can prototype things. I wonder how to handle > database schema migrations. With our PHP projects we have versionned PHP > scripts that are automatically run given a database revision number ( see > http://git.afi-sa.fr/afi/opacce/tree/master/cosmogramme/sql/patch ). What > are the practices with Glorp ? > > > We try QCMagritte and we enjoy what we see so far. What are the best > practices to glue Magritte and Glorp together ? Especially when you > load-balance requests on several images. Some examples ? > > ( FYI, I cannot load QCMagritte in a fresh Pharo 6 image ( for #stable > version, MADescriptionBuilder missing. For #development versions of Magritte > and QCMagritte, QCConfiguration missing ). So actually I use the one built > on CI. ) > > > May be you have some other suggestions on a framework you love ? > > > Best regards, > > Laurent Laffont > > > > >