[IRCServices] about Database/SQL support of ircservices
Xuefer
Xuefer at 21cn.com
Mon Jan 27 10:06:49 PST 2003
hi guys.
i've read modules/database/README
how many registered user/channel will ircservices plan to support? (including "hibernation" chans/nicks)
thousands? millions?
SQL is only in plan, but will the SQL support able to share data with Web?
i.e. sync-data in real-time
or just load data from SQL to memory, and flush it to SQL when update?
i wonder if there is a way to manage to share data with web, without any data conflict.
e.g. both web/ircservices update same NickInfo
one possible way is:
make a sock listen to localhost, and webserver(what ever language/script) connect it
and tell ircservices to reload/create(if newly register) the NickInfo of a specified user
SQL have last_insertid, will new_nickgroupinfo(which generate ngi->id) get use of it?
btw, a suggestion here:
void put_nickinfo(NickInfo *ni, char *what)
if what == NULL, update all
else, update only specified item
may not useful, but may needed by some kid of database, to improve performance