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,
--
Michel Loiseleur
_______________________________________________
Ovirt-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/ovirt-devel
