[IRCServices] Database WAS: out of buffer?

[Craig McLure]

As a note, a 'fairly large userbase' would have to be something like 
15,000 users.. Our database updates very quickly, and we have over 7,000 
nicknames registered.

If you are looking for implementation into a website, we have created 
code to do just that, but rather than porting the database to MySQL, we 
have created a 'go-between' between the services structs, and a php 
script. The pseudoclient opens a socket on 127.0.0.1, and any 
connections made to it start with an A token, for example, A NICK 
PASSWORD, the service will then query the users struct, return A OK / 
FORBIDDEN / INVALID, based on what it finds there :)

Its a simple system, but works well for us :)

This may not be what you use XML exporting for, but a lot of people ask 
about using seperate database archetectures(sp) for services, to make it 
easier for manipulation from the 'outside', maybe concider coding a 
pseudo like we have that makes the task easier :)


/****************************************
  *     Craig "FrostyCoolSlug" McLure
  *       Craig at FrostyCoolSlug.com
  * InspIRCd   - http://www.inspircd.org
  * ChatSpike  - http://www.chatspike.net
  ****************************************/

Everett B. Simonds wrote:
> I don't really for see the need to embed a whole SQL engine into 
> services.  I have looked at some of the database code in there and I'm 
> wondering if the system would benefit from having some sort of write 
> behind log so that services doesn't burn time rewriting the whole 
> database every time it flushes them out to disk.  This would certainly 
> help those who have a significantly sized user base.  This would also 
> eliminate the need to have two copies of the database on disk while it 
> writes it out, good for those who might be strapped for disk space.
> 
> If you're going to embed any sort of database option into services, you 
> might as well use the Berkeley DB system from Sleepy Cat.  No need to 
> get fancy with an SQL parser/optimizer for something like this, 
> especially when all you're doing is a simple SELECT or INSERT/UPDATE 
> with no joins.
> 
> Though I'm all for a nice home grown solution as well.
> 
> Kelmar K. Firesun (Bryce Simonds)
> Co-admin: dream.esper.net
> 
> Anton Wolkov wrote:
> 
>> a nice feature would be a module (like database/exportxml) that would
>> have a parameter, how many minutes to wait between an xml export and a
>> parameter for target filename, that would eliminate the need for
>> crontab.
>> also if your into innovation and all, consider implementing sqlite to
>> ircservices, it's so much more expandable and would also make services
>> fly on select operations.
>> the httpd module is not most frequently used mainly because of it's
>> stability issues, it may be a good idea to have an export module for
>> html pages and then to serve them over apache, this would also provide
>> more options to integrate services to existing websites.
>> other nice feature i think would be widely used is the vhost parameter
>> for nickserv, it is supported by many popular protocols.
>> -- 
>> PHANTOm
>> http://www.irc.nix.co.il/ -- irc.nix.co.il
>> ------------------------------------------------------------------
>> To unsubscribe or change your subscription options, visit:
>> http://lists.ircservices.za.net/mailman/listinfo/ircservices
>>
> ------------------------------------------------------------------
> To unsubscribe or change your subscription options, visit:
> http://lists.ircservices.za.net/mailman/listinfo/ircservices
>