[Ovirt-devel] Multi-databases support

[Mohammed Morsi]

Loiseleur Michel wrote:
> Hi,
>
> While I was hacking ovirt-server, I have found that it's currently
> restricted to Postgres DB. Even if I like postgres for serious work on
> a server, I really prefer to hack/dev locally on a Sqlite or MySQL DB.
>
> I have googled on rails in order to find a good answer for the
> "foreign key problem" which forces OVirt to stay on pg. I have found a
> plugin on this particular problem, named foreigner :
> http://github.com/matthuhiggins/foreigner
>
> It provides a rails' syntax to common operation on them. For instance :
>
>   add_foreign_key(from_table, to_table, options)
>   remove_foreign_key(from_table, options)
>   foreign_keys(table_name)
>
> I really like to keep my development computer to run as fast as
> possible (ie without a database service), so I have even tried to
> integrate this plugin into OVirt, in a transparent way for existing db.
>
> After a couple of patch on the plugin itself and some hack on
> migrations, it seems that I manage to do it. The 3 patchs following
> this email allows OVirt to support multiple open source database
> without losing functionality, without losing existing databases and
> with a small readability enhancement on db migrations.
>
> What do you think of it ? Feel free to contact me by email, on this
> list or by irc (nick: Coren`)
>
> Regards,
Thank you greatly for this. I agree, and am sure many others do that
multiple database support would be great. I applied all three patches
but ran into some problems when running them. Comments are in line in
the patches.

   -Mo