Tremulous Forum

General => Feedback => Topic started by: Paradox on April 28, 2008, 07:52:27 pm

Title: Replace admin.dat with a MySQL table
Post by: Paradox on April 28, 2008, 07:52:27 pm

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?

Title: Re: Replace admin.dat with a MySQL table
Post by: Rocinante on April 28, 2008, 08:04:56 pm

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

Title: Re: Replace admin.dat with a MySQL table
Post by: Paradox on April 28, 2008, 11:37:24 pm

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

Title: Re: Replace admin.dat with a MySQL table
Post by: kevlarman on April 29, 2008, 02:43:05 am

Quote from: Paradox on April 28, 2008, 11:37:24 pm

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.

Title: Re: Replace admin.dat with a MySQL table
Post by: Paradox on April 29, 2008, 07:40:17 pm

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

Title: Re: Replace admin.dat with a MySQL table
Post by: kevlarman on April 29, 2008, 08:55:38 pm

Quote from: Paradox on April 29, 2008, 07:40:17 pm

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

that would make the lag much much worse.

Title: Re: Replace admin.dat with a MySQL table
Post by: kangounator on April 29, 2008, 10:13:43 pm

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 )

Title: Re: Replace admin.dat with a MySQL table
Post by: Memorex >.< on April 29, 2008, 10:23:32 pm

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.. :)

Title: Re: Replace admin.dat with a MySQL table
Post by: Paradox on May 01, 2008, 12:45:37 am

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

Title: Re: Replace admin.dat with a MySQL table
Post by: Memorex >.< on May 01, 2008, 11:59:46 am

i sent you the code on your gmail address

Title: Re: Replace admin.dat with a MySQL table
Post by: Paradox on May 02, 2008, 05:35:41 am

Thanks

Title: Re: Replace admin.dat with a MySQL table
Post by: Le Compilateur on May 26, 2008, 03:36:30 pm

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

Title: Re: Replace admin.dat with a MySQL table
Post by: daenyth on May 28, 2008, 03:40:11 pm

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