software/!RELEASES/ircservices/achurch.org/services/lists/ircservices/2003/003917.html

   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 &quot;hibernation&quot; 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-&gt;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>