> On Tue, Aug 24, 2010 at 10:23:55PM +0530, Roger Binns wrote: >> On 08/24/2010 09:51 PM, Artur Reilin wrote: >> > I thinking about coding a chat with sqlite. >> >> The hard part of implementing chat is not storing the messages, but >> rather dealing with all the clients at the same time especially with >> potentially hostile networking (eg reading data slower than you send >> it). >> >> If you want to write one yourself I suggest looking into the Erlang >> programming language. >> >> Instead of reinventing the wheel, I suggest you use the open XMPP chat >> protocol and open source XMPP servers. In addition to using any XMPP >> client, you can also use a web based client. > > +1. > > Moreover, because often you'll want to log chats hosted on services that > you do not control, the simplest, most popular, and most interoperable > (though not most reliable) way to log is to do it via "bots". "Bots" > are automated clients. > > The most reliable way to log chats is by modifying the service > implementation or by co-locating logger bots with the service, but this > only works when you own the service (or otherwise can get the owners to > log this way). > > Don't reinvent the wheel, just find a suitable open source bot and > modify it to suit your needs. You might even find some existing ones. > For example, the "Sqlite Users" wiki page [0] lists one exact match, > though it appears to be dead. > > Just search for "chat bot logger sqlite", "xmpp bot logger sqlite", > etcetera, and you'll find plenty. I count at least a handful just on > the first page of results for each of those searches. > > Nico > > [0] http://www.sqlite.org/cvstrac/wiki?p=SqliteUsers > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
The thing is, I don't want to log the chat text. It should just get removed after 30 messages or so. It should just save the chat messages for some time. I currently using a Ajax based chat in my phpBB3 installation. Just thought it would reduce the server <-> mysql server data traffic. I have paid hosting, so I don't think that I'll get many problems. But the thing is, that I see sometimes that the chat's are more html based and often really slow. So slow, that even sqlite could take that with 20 users at once or even more. with best wishes Artur Reilin sqlite.yuedream.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
