1 <!DOCTYPE HTML PUBLIC
"-//W3C//DTD HTML 3.2//EN">
4 <TITLE> [IRCServices] Database WAS: out of buffer?
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=41F931CE.9090807%40ix.netcom.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=
"004785.html">
11 <LINK REL=
"Next" HREF=
"004769.html">
13 <BODY BGCOLOR=
"#ffffff">
14 <H1>[IRCServices] Database WAS: out of buffer?
</H1>
16 <A HREF=
"mailto:ircservices%40ircservices.esper.net?Subject=%5BIRCServices%5D%20Database%20WAS%3A%20out%20of%20buffer%3F&In-Reply-To=41F931CE.9090807%40ix.netcom.com"
17 TITLE=
"[IRCServices] Database WAS: out of buffer?">Craig at frostycoolslug.com
19 <I>Thu Jan
27 11:
05:
07 PST
2005</I>
21 <LI>Previous message:
<A HREF=
"004785.html">[IRCServices] Database WAS: out of buffer?
23 <LI>Next message:
<A HREF=
"004769.html">[IRCServices] Problem on IRCservices
25 <LI> <B>Messages sorted by:
</B>
26 <a href=
"date.html#4786">[ date ]
</a>
27 <a href=
"thread.html#4786">[ thread ]
</a>
28 <a href=
"subject.html#4786">[ subject ]
</a>
29 <a href=
"author.html#4786">[ author ]
</a>
34 <PRE>As a note, a 'fairly large userbase' would have to be something like
35 15,
000 users.. Our database updates very quickly, and we have over
7,
000
38 If you are looking for implementation into a website, we have created
39 code to do just that, but rather than porting the database to MySQL, we
40 have created a 'go-between' between the services structs, and a php
41 script. The pseudoclient opens a socket on
127.0.0.1, and any
42 connections made to it start with an A token, for example, A NICK
43 PASSWORD, the service will then query the users struct, return A OK /
44 FORBIDDEN / INVALID, based on what it finds there :)
46 Its a simple system, but works well for us :)
48 This may not be what you use XML exporting for, but a lot of people ask
49 about using seperate database archetectures(sp) for services, to make it
50 easier for manipulation from the 'outside', maybe concider coding a
51 pseudo like we have that makes the task easier :)
54 /****************************************
55 * Craig
"FrostyCoolSlug
" McLure
56 *
<A HREF=
"http://lists.ircservices.za.net/mailman/listinfo/ircservices">Craig at FrostyCoolSlug.com
</A>
57 * InspIRCd -
<A HREF=
"http://www.inspircd.org">http://www.inspircd.org
</A>
58 * ChatSpike -
<A HREF=
"http://www.chatspike.net">http://www.chatspike.net
</A>
59 ****************************************/
61 Everett B. Simonds wrote:
62 ><i> I don't really for see the need to embed a whole SQL engine into
63 </I>><i> services. I have looked at some of the database code in there and I'm
64 </I>><i> wondering if the system would benefit from having some sort of write
65 </I>><i> behind log so that services doesn't burn time rewriting the whole
66 </I>><i> database every time it flushes them out to disk. This would certainly
67 </I>><i> help those who have a significantly sized user base. This would also
68 </I>><i> eliminate the need to have two copies of the database on disk while it
69 </I>><i> writes it out, good for those who might be strapped for disk space.
71 </I>><i> If you're going to embed any sort of database option into services, you
72 </I>><i> might as well use the Berkeley DB system from Sleepy Cat. No need to
73 </I>><i> get fancy with an SQL parser/optimizer for something like this,
74 </I>><i> especially when all you're doing is a simple SELECT or INSERT/UPDATE
75 </I>><i> with no joins.
77 </I>><i> Though I'm all for a nice home grown solution as well.
79 </I>><i> Kelmar K. Firesun (Bryce Simonds)
80 </I>><i> Co-admin: dream.esper.net
82 </I>><i> Anton Wolkov wrote:
84 </I>>><i> a nice feature would be a module (like database/exportxml) that would
85 </I>>><i> have a parameter, how many minutes to wait between an xml export and a
86 </I>>><i> parameter for target filename, that would eliminate the need for
87 </I>>><i> crontab.
88 </I>>><i> also if your into innovation and all, consider implementing sqlite to
89 </I>>><i> ircservices, it's so much more expandable and would also make services
90 </I>>><i> fly on select operations.
91 </I>>><i> the httpd module is not most frequently used mainly because of it's
92 </I>>><i> stability issues, it may be a good idea to have an export module for
93 </I>>><i> html pages and then to serve them over apache, this would also provide
94 </I>>><i> more options to integrate services to existing websites.
95 </I>>><i> other nice feature i think would be widely used is the vhost parameter
96 </I>>><i> for nickserv, it is supported by many popular protocols.
98 </I>>><i> PHANTOm
99 </I>>><i> <A HREF=
"http://www.irc.nix.co.il/">http://www.irc.nix.co.il/
</A> -- irc.nix.co.il
100 </I>>><i> ------------------------------------------------------------------
101 </I>>><i> To unsubscribe or change your subscription options, visit:
102 </I>>><i> <A HREF=
"http://lists.ircservices.za.net/mailman/listinfo/ircservices">http://lists.ircservices.za.net/mailman/listinfo/ircservices
</A>
104 </I>><i> ------------------------------------------------------------------
105 </I>><i> To unsubscribe or change your subscription options, visit:
106 </I>><i> <A HREF=
"http://lists.ircservices.za.net/mailman/listinfo/ircservices">http://lists.ircservices.za.net/mailman/listinfo/ircservices
</A>
114 <LI>Previous message:
<A HREF=
"004785.html">[IRCServices] Database WAS: out of buffer?
116 <LI>Next message:
<A HREF=
"004769.html">[IRCServices] Problem on IRCservices
118 <LI> <B>Messages sorted by:
</B>
119 <a href=
"date.html#4786">[ date ]
</a>
120 <a href=
"thread.html#4786">[ thread ]
</a>
121 <a href=
"subject.html#4786">[ subject ]
</a>
122 <a href=
"author.html#4786">[ author ]
</a>
projects / irc.git / blob