egghelp.org community

[kmail]

Hello,
Could anyone tell me if there are some solutions available what would enable to use mySQL database instead of Eggdrops userfile? I mean that eggdrop gets everything concerding the users from a mySQL database and saves everything there too + the old userfile system would be no longer used.
I would appreciate any information concerning this problem

[kmail]

Cmon, I cannot believe that anyone has never thought about it

[metroid]

People might have, but it'd just be slow. I can assure you that the eggdrop using memory for users is a hell lot faster than querying the mysql server.

[De Kus]

I would suggest doing either timed exports to mysql or drop it at all. for updates you can connect to the bot via telnet either as user or as bot, for the later one you could request to download current zipped userfile.
_________________
De Kus
StarZ|De_Kus, De_Kus or DeKus on IRC
Copyright © 2005-2009 by De Kus - published under The MIT License
Love hurts, love strengthens...

[kmail]

Okay, thanks for the information, I'll just try to find some other way instead of using mySQL

[rosc2112]

What's so bad about using the existing method (textfile format)?

[kmail]

IMHO mysql is universal, easy access for every other program too besides eggdrop + everything is organized in tables.

[nml375]

SQL and ODBC might be universal.
Even so, many sql-engines have different features and extensions, not always 100% compatible with eachother. And to be honest, do I really want other programs tampering with my user database? Probably not..

Abit off-topic there I guess, so lets get back on topic:
First of all, I would'nt wanna bug admins to install an sql (mysql or any other) server just in order for me to run an eggie.
Next there's the immense queries you'd risk ending up with on even an average populated channel.. Whenever any user-permissions are checked, you'd be required to send queries (which would include, but not be limited to, any binding supporting flags, etc)

You could always manually dump the userlist data into a sql-database every 5minutes or so I guess, assuming that you do not intend to use sql-queries to alter data. Should'nt be too hard to accomplish with either a commandline client (such as mysqlclient), or some extensions such as libmytcl (or something like that, should be able to find a few threads on compiling such with eggies on the forum)
_________________
NML_375, idling at #eggdrop@IrcNET

[ZEXEL]

I think textfile is better and simple more than SQL database coz it's have minimum risky!
_________________
.:[ Knowledge Is The Power ]:.

[rosc2112]

[SkIRmiS]

[rosc2112]

Skirmis: Did you release this modification for the public, is it available?

[r0t3n]

Im currently making such a modification at the moment using TCL to overwrite the main proc's and to use a mysql module for the mysql crap. I might make it in C as a proper eggdrop module. I will finish it and release it for testing soon.
_________________
r0t3n @ #r0t3n @ Quakenet

[innu]

[demond]

using SQL is an overkill for the simple task of reading userfile ONCE (on (re)start) and writing it back ONCE an hour

another matter is that the proprietary text format eggdrop uses should be replaced with XML schema, thus allowing for easy userfile manipulation by external tools; but eggdrop is an antiquated piece of software anyway and that won't happen
_________________
connection, sharing, dcc problems? click <here>
before asking for scripting help, read <this>
use [code] tag when posting logs, code