[Engine-devel] Move SQL out of stored procedures

[Laszlo Hornyak]

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 at redhat.com>
> To: engine-devel at 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:
> 
> http://gerrit.ovirt.org/13347
> 
> 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/engine-devel
>