Re: Many backends (WAS: Re: [Phpwiki-talk] Wiki spam and the future of phpwiki)

[Jim C. <ji...@in...>]

Matthew Palmer wrote:
> On Fri, Apr 01, 2005 at 08:51:41AM -0600, Joel Uckelman wrote:
>>There's a huge performance hit if we force everyone not using an SQL server
>>to use flatfile; nor do I think that we want to force everyone to use an SQL
>>server. That's why I think we should keep both dba and flatfile.
> 
> *cough*sqlite*cough*  If you're going to go with a DB out-of-the-box, (and I'm
> not saying that's a good or bad thing), I can't imagine an easier type to
> support than SQLite.  It's built-in for PHP5, the PECL module for php4
> is simple to install... it's all easy.

I'd second sqlite - it's used in as a backend for the Trac svn-aware, 
ticketing wiki (http://edgewall.com/trac/).

It's very easy to be able to run up a SQL monitor from the command-line, 
and grab table schemas, run queries, all that jazz, without having to 
have a server process as the dbm.

-jim