software/!RELEASES/ircservices/achurch.org/services/lists/ircservices/2005/004785.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
   2 <HTML>
   3  <HEAD>
   4    <TITLE> [IRCServices] Database WAS: out of buffer?
   5    </TITLE>
   6    <LINK REL="Index" HREF="index.html" >
   7    <LINK REL="made" HREF="mailto:ircservices%40ircservices.esper.net?Subject=%5BIRCServices%5D%20Database%20WAS%3A%20out%20of%20buffer%3F&In-Reply-To=d50f59a0050127075256b29adb%40mail.gmail.com">
   8    <META NAME="robots" CONTENT="index,nofollow">
   9    <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
  10    <LINK REL="Previous"  HREF="004784.html">
  11    <LINK REL="Next"  HREF="004786.html">
  12  </HEAD>
  13  <BODY BGCOLOR="#ffffff">
  14    <H1>[IRCServices] Database WAS: out of buffer?</H1>
  15     <B>Everett B. Simonds</B>
  16     <A HREF="mailto:ircservices%40ircservices.esper.net?Subject=%5BIRCServices%5D%20Database%20WAS%3A%20out%20of%20buffer%3F&In-Reply-To=d50f59a0050127075256b29adb%40mail.gmail.com"
  17        TITLE="[IRCServices] Database WAS: out of buffer?">kfiresun at ix.netcom.com
  18        </A><BR>
  19     <I>Thu Jan 27 10:24:14 PST 2005</I>
  20     <P><UL>
  21         <LI>Previous message: <A HREF="004784.html">[IRCServices] out of buffer?
  22 </A></li>
  23         <LI>Next message: <A HREF="004786.html">[IRCServices] Database WAS: out of buffer?
  24 </A></li>
  25          <LI> <B>Messages sorted by:</B>
  26               <a href="date.html#4785">[ date ]</a>
  27               <a href="thread.html#4785">[ thread ]</a>
  28               <a href="subject.html#4785">[ subject ]</a>
  29               <a href="author.html#4785">[ author ]</a>
  30          </LI>
  31        </UL>
  32     <HR>
  33 <!--beginarticle-->
  34 <PRE>I don't really for see the need to embed a whole SQL engine into
  35 services.  I have looked at some of the database code in there and I'm
  36 wondering if the system would benefit from having some sort of write
  37 behind log so that services doesn't burn time rewriting the whole
  38 database every time it flushes them out to disk.  This would certainly
  39 help those who have a significantly sized user base.  This would also
  40 eliminate the need to have two copies of the database on disk while it
  41 writes it out, good for those who might be strapped for disk space.
  42
  43 If you're going to embed any sort of database option into services, you
  44 might as well use the Berkeley DB system from Sleepy Cat.  No need to
  45 get fancy with an SQL parser/optimizer for something like this,
  46 especially when all you're doing is a simple SELECT or INSERT/UPDATE
  47 with no joins.
  48
  49 Though I'm all for a nice home grown solution as well.
  50
  51 Kelmar K. Firesun (Bryce Simonds)
  52 Co-admin: dream.esper.net
  53
  54 Anton Wolkov wrote:
  55 &gt;<i> a nice feature would be a module (like database/exportxml) that would
  56 </I>&gt;<i> have a parameter, how many minutes to wait between an xml export and a
  57 </I>&gt;<i> parameter for target filename, that would eliminate the need for
  58 </I>&gt;<i> crontab.
  59 </I>&gt;<i> also if your into innovation and all, consider implementing sqlite to
  60 </I>&gt;<i> ircservices, it's so much more expandable and would also make services
  61 </I>&gt;<i> fly on select operations.
  62 </I>&gt;<i> the httpd module is not most frequently used mainly because of it's
  63 </I>&gt;<i> stability issues, it may be a good idea to have an export module for
  64 </I>&gt;<i> html pages and then to serve them over apache, this would also provide
  65 </I>&gt;<i> more options to integrate services to existing websites.
  66 </I>&gt;<i> other nice feature i think would be widely used is the vhost parameter
  67 </I>&gt;<i> for nickserv, it is supported by many popular protocols.
  68 </I>&gt;<i> --
  69 </I>&gt;<i> PHANTOm
  70 </I>&gt;<i> <A HREF="http://www.irc.nix.co.il/">http://www.irc.nix.co.il/</A> -- irc.nix.co.il
  71 </I>&gt;<i> ------------------------------------------------------------------
  72 </I>&gt;<i> To unsubscribe or change your subscription options, visit:
  73 </I>&gt;<i> <A HREF="http://lists.ircservices.za.net/mailman/listinfo/ircservices">http://lists.ircservices.za.net/mailman/listinfo/ircservices</A>
  74 </I>&gt;<i>
  75 </I></PRE>
  76
  77
  78 <!--endarticle-->
  79     <HR>
  80     <P><UL>
  81         <!--threads-->
  82         <LI>Previous message: <A HREF="004784.html">[IRCServices] out of buffer?
  83 </A></li>
  84         <LI>Next message: <A HREF="004786.html">[IRCServices] Database WAS: out of buffer?
  85 </A></li>
  86          <LI> <B>Messages sorted by:</B>
  87               <a href="date.html#4785">[ date ]</a>
  88               <a href="thread.html#4785">[ thread ]</a>
  89               <a href="subject.html#4785">[ subject ]</a>
  90               <a href="author.html#4785">[ author ]</a>
  91          </LI>
  92        </UL>
  93
  94 </body></html>