On 08/26/2013 03:38 PM, Thomas Raschbacher wrote:
> on another note: wouldn't it be good to have these migrations
> TRANSACTION based? (maybe even with a stored procedure?)
Of course full atomicity would be better. Also quite difficult to
achieve in this case. I have no idea what you're suggesting with regard
to stored procedures. I don't think migrating in this context could be
done in the database - unless you want to rewrite non-trivial parts of
the message handling code in some embedded language.
That said I'm sure there is a good place for stored procedures. They can
enhance performance in several places I'm sure. I just don't have to
time or inclination to pursue that path myself.
Finally, I've added automatic schema migrations to the master branch,
but neither MySQL nor SQLite are very good at atomic schema migrations.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
