Mysql

Forum rules
No roms requests or illegal links

Post a reply

Smilies
:D :) :( :o :shock: :? 8) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: :clap: :hum: :gnak: :lol: :super: :uh: :toobad:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Mysql

Re: Mysql

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 :?

Re: Mysql

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.

Mysql

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

Top