projects / irc.git / blame
| Commit | Line | Data |
|---|---|---|
| 3bd189cb JR |
1 | <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> |
| 2 | <HTML> | |
| 3 | <HEAD> | |
| 4 | <TITLE> [IRCServices] about Database/SQL support of ircservices | |
| 5 | </TITLE> | |
| 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"> | |
| 12 | </HEAD> | |
| 13 | <BODY BGCOLOR="#ffffff"> | |
| 14 | <H1>[IRCServices] about Database/SQL support of ircservices</H1> | |
| 15 | <B>Xuefer</B> | |
| 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 | |
| 18 | </A><BR> | |
| 19 | <I>Mon Jan 27 10:06:49 PST 2003</I> | |
| 20 | <P><UL> | |
| 21 | <LI>Previous message: <A HREF="003519.html">[IRCServices] sql support | |
| 22 | </A></li> | |
| 23 | <LI>Next message: <A HREF="003521.html">[IRCServices] Forcing nick changes | |
| 24 | </A></li> | |
| 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> | |
| 30 | </LI> | |
| 31 | </UL> | |
| 32 | <HR> | |
| 33 | <!--beginarticle--> | |
| 34 | <PRE>hi guys. | |
| 35 | i've read modules/database/README | |
| 36 | ||
| 37 | how many registered user/channel will ircservices plan to support? (including "hibernation" chans/nicks) | |
| 38 | thousands? millions? | |
| 39 | ||
| 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? | |
| 43 | ||
| 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 | |
| 46 | ||
| 47 | one possible way is: | |
| 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 | |
| 50 | ||
| 51 | ||
| 52 | SQL have last_insertid, will new_nickgroupinfo(which generate ngi->id) get use of it? | |
| 53 | ||
| 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 | |
| 58 | ||
| 59 | may not useful, but may needed by some kid of database, to improve performance | |
| 60 | ||
| 61 | ||
| 62 | </PRE> | |
| 63 | ||
| 64 | <!--endarticle--> | |
| 65 | <HR> | |
| 66 | <P><UL> | |
| 67 | <!--threads--> | |
| 68 | <LI>Previous message: <A HREF="003519.html">[IRCServices] sql support | |
| 69 | </A></li> | |
| 70 | <LI>Next message: <A HREF="003521.html">[IRCServices] Forcing nick changes | |
| 71 | </A></li> | |
| 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> | |
| 77 | </LI> | |
| 78 | </UL> | |
| 79 | ||
| 80 | </body></html> |