Page 1 of 1

Mysql

Posted: Sat Nov 11, 2017 1:44 pm
by davide.duca
Hi,

I lookng for a software for to organize the roms of Mame and Tosec but i need work with a server Mysql and have a front end in a client.

i prefer work wih client Windows, Linux and Mac, but it's ok if work only with Windows.

Do you think to create a version of ROMCenter like this?


Thansk
Davide

Re: Mysql

Posted: Sat Nov 25, 2017 12:41 pm
by Wanderer
Hi there.

Indeed, it would be interesting if romcenter could use an external database to keep its data. I suspect though that it would need quite some work to create all the necessary structure for romcenter to work, in various databases that exist outside. For instance, i would find it interesting if it worked with sql server. This might require the creation of a custom set of stored procedures though. And Eric would have to maintain this too.

Still, it's an interesting idea though. Eric could say if it's feasible, perhaps with some help from the community. Whoever is interested in a certain DB, could be set responsible for maintaining the necessary changes in db structure.

Re: Mysql

Posted: Sat Dec 02, 2017 3:11 pm
by RomCenter
Romcenter uses an internal sql database (firebird 2). A lot of processes are handled through stored proc, which are specific to fb.
Using external database requires to rewrite proc into the new db, or rewrite these processes in the main program, getting rid of stored proc.
I'm not sure a lot of users have a personnal db server installed to hook rc on it :?