Replace admin.dat with a MySQL table

[Paradox]

There are many reasons why this would be a good idea, and i actually have some people working on it. What i propose is replacing admin.dat with a mysql table. Trem would reference into said table.

This would allow for many things, such as an online ban database viewer, online admin viewer, and easy searching.

Ideally, it would be an alternate solution, for those ops who dont know how to run MySQL, they could opt out and still use admin.dat.

Any feedback?

[Rocinante]

Go with SQLite instead.  Same benefits of a RDB, but without the overhead of another daemon.

[Paradox]

Many of us are running a MySQL server on our server allready, and so SQLite would be yet another thing to use.

[kevlarman]

Many of us are running a MySQL server on our server allready, and so SQLite would be yet another thing to use.

mysqld doesn't exactly play well with tremded, i would avoid running it on any servers that are used to host trem servers.

[Paradox]

You could always remote it out, that would be the beauty of such a system.

[kevlarman]

You could always remote it out, that would be the beauty of such a system.

that would make the lag much much worse.

[kangounator]

I'd use SQLite for that, it is really light to use and as Rocinante said, you don't have to run a SQL server, only tremulous' binary. (that again some more syscalls :x )

[Memorex >.<]

i already coded something for that, but i didnt replace the admin.dat by sql, i just update a sql table with the admin.dat content

http://www.amsterdam-unlimited.net/page4/page5/page6/page6.html

it's of course still in developpement since i only worked 20min on it, so be lenient please, there is no filter yet, no design, trem color sheme isnt supported yet etc..

[Paradox]

Thats actually a good solution, while imperfect.
If at all possible, could i see the code?

[Memorex >.<]

i sent you the code on your gmail address

[Paradox]

Thanks

[Le Compilateur]

It would take a bit of coding but yeah, good idea.

[daenyth]

Not a bad idea, but I'd also say to either go with sqlite or have a system where the admin can connect it to any *sql db