Re: [infobot] infobot thoughts

[Tim R. <Ti...@Ri...>]

Have you used sqlite? It uses a single local file to store all the 
tables in a database. No separate RDBMS process is needed.

http://www.sqlite.org/

There are Perl DBI modules for it of course.

SQL as an option, but not a requirement means that you cannot take good 
advantage of the search features of the SQL server. So you'd get the 
bloat without any real improvement.

Using an sqlite file instead of multiple dbm files means that you do get 
the sql features while keeping simple administration.

David Cantrell wrote:
> Tim Riker wrote:
> 
>> 3) I'd like to see sql backend instead of dbm. I'd prefer sqlite and 
>> mysql, and any more that others want to add. sqlite allows for simple 
>> file based access like dbm, but with the richer search capabilities.
> 
> I'd like a SQL backend as an option, but requiring an RDBMS would, IMO, 
> be a Bad Thing.
> 
> I believe that dipsy (and #london.pm infobot) already has one, and 
> expect that whoever is caring for it this month is on one of these lists.
-- 
Tim Riker - http://rikers.org/ - Ti...@De...
Linux Technologist - Ti...@TI... - http://www.TI.com/
BZFlag maintainer - http://BZFlag.org/ - for fun!