1 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 3.2//EN">
4 <TITLE> [IRCServices] about Database/SQL support of ircservices
6 <LINK REL=
"Index" HREF=
"index.html" >
7 <LINK REL=
"made" HREF=
"mailto:ircservices%40ircservices.za.net?Subject=%5BIRCServices%5D%20about%20Database/SQL%20support%20of%20ircservices&In-Reply-To=">
8 <META NAME=
"robots" CONTENT=
"index,nofollow">
9 <META http-equiv=
"Content-Type" content=
"text/html; charset=us-ascii">
10 <LINK REL=
"Previous" HREF=
"003519.html">
11 <LINK REL=
"Next" HREF=
"003521.html">
13 <BODY BGCOLOR=
"#ffffff">
14 <H1>[IRCServices] about Database/SQL support of ircservices
</H1>
16 <A HREF=
"mailto:ircservices%40ircservices.za.net?Subject=%5BIRCServices%5D%20about%20Database/SQL%20support%20of%20ircservices&In-Reply-To="
17 TITLE=
"[IRCServices] about Database/SQL support of ircservices">Xuefer at
21cn.com
19 <I>Mon Jan
27 10:
06:
49 PST
2003</I>
21 <LI>Previous message:
<A HREF=
"003519.html">[IRCServices] sql support
23 <LI>Next message:
<A HREF=
"003521.html">[IRCServices] Forcing nick changes
25 <LI> <B>Messages sorted by:
</B>
26 <a href=
"date.html#3917">[ date ]
</a>
27 <a href=
"thread.html#3917">[ thread ]
</a>
28 <a href=
"subject.html#3917">[ subject ]
</a>
29 <a href=
"author.html#3917">[ author ]
</a>
35 i've read modules/database/README
37 how many registered user/channel will ircservices plan to support? (including
"hibernation
" chans/nicks)
40 SQL is only in plan, but will the SQL support able to share data with Web?
41 i.e. sync-data in real-time
42 or just load data from SQL to memory, and flush it to SQL when update?
44 i wonder if there is a way to manage to share data with web, without any data conflict.
45 e.g. both web/ircservices update same NickInfo
48 make a sock listen to localhost, and webserver(what ever language/script) connect it
49 and tell ircservices to reload/create(if newly register) the NickInfo of a specified user
52 SQL have last_insertid, will new_nickgroupinfo(which generate ngi-
>id) get use of it?
54 btw, a suggestion here:
55 void put_nickinfo(NickInfo *ni, char *what)
56 if what == NULL, update all
57 else, update only specified item
59 may not useful, but may needed by some kid of database, to improve performance
68 <LI>Previous message:
<A HREF=
"003519.html">[IRCServices] sql support
70 <LI>Next message:
<A HREF=
"003521.html">[IRCServices] Forcing nick changes
72 <LI> <B>Messages sorted by:
</B>
73 <a href=
"date.html#3917">[ date ]
</a>
74 <a href=
"thread.html#3917">[ thread ]
</a>
75 <a href=
"subject.html#3917">[ subject ]
</a>
76 <a href=
"author.html#3917">[ author ]
</a>