With MySQL taking on more and more advanced features such as triggers, stored procedures and stored functions - and the whole SOA conundrum, how do you connect your database to the service bus with little to no hassle?
Recently I was thinking about the possibilities of abusing MySQL as the model for your applications, if you have a good DBA they can design and prototype most of the functionality from one place, and provide a domain barrier between applications and the data.
This could be considered tiresome to some (e.g. performing updates or complex user-customizable queries with a stored procedure barrier), but for some situations it fits in well. One of these is if you want to export a simple, yet well defined interface to third party developers without writing a single line of front-end code.
So for this I'll be using XML-RPC, automatically exporting all functions in a database and making them available.
Leave a Reply