Mysql

Romcenter 4 support discussion. Please do not post roms requests or illegal links, posts will be deleted.

Moderators: Wanderer, Logiqx, Iron Man

Forum rules
No roms requests or illegal links
davide.duca
Pong
Pong
Posts: 1
Joined: Sat Nov 11, 2017 1:38 pm

Mysql

Post by davide.duca » Sat Nov 11, 2017 1:44 pm

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

User avatar
Wanderer
Board master
Board master
Posts: 645
Joined: Wed Oct 03, 2001 10:37 am
Location: Floating around

Re: Mysql

Post by Wanderer » Sat Nov 25, 2017 12:41 pm

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.
- Wanderer -

For Romcenter bug reporting or enhancement requests, click here.

User avatar
RomCenter
Author
Author
Posts: 1294
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Mysql

Post by RomCenter » Sat Dec 02, 2017 3:11 pm

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 :?
Eric - RomCenter developer
http://www.romcenter.com

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests