Hi, I agree with the idea. The stored procedures/UDF's are just one more place to go when trying to find out what is really happening. It is not a good solution for database portability. Laszlo ----- Original Message -----
From: "Juan Hernandez" <jhernand@redhat.com> To: engine-devel@ovirt.org Sent: Tuesday, March 26, 2013 6:34:04 PM Subject: [Engine-devel] Move SQL out of stored procedures
Hello,
I would like to start a discussion about the subject. I think this is something we need to do if one day we want to be able to use any database other than PostgreSQL.
I did an small example of what it takes and how it looks like to have the SQL code into the DAOs:
It isn't rocket science, it isn't an exciting task, it isn't fun, but something I think we should eventually do.
I appreciate any comment about how and when to do this, including those saying that instead of this primitive approach we should use this or that ORM framework.
Regards, Juan Hernandez -- Dirección Comercial: C/Jose Bardasano Baos, 9, Edif. Gorbea 3, planta 3ºD, 28016 Madrid, Spain Inscrita en el Reg. Mercantil de Madrid – C.I.F. B82657941 - Red Hat S.L. _______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel