[plug] Database Recomendations

[Russell Steicke]

On Wed, Mar 28, 2001 at 03:42:55PM +0800, Brad Campbell wrote:
> At the risk of increasing traffic x10.
> I have a need for an SQL database.
> Not relational, not journalled.
> I would use a flat file format, and do it myself, but it's time
> I started to use a grown-ups database and learn about them.
> It must be small, and quick.
> Only really needs to be able to create, update, drop and select
> from tables, as I'm using it in a logger and need to generate
> statistics with CGI.

If you don't need lots of features, and want something really small, you
could take a look at NoSQL, a database written in awk, that uses ascii
flat files for its tables.  It's certainly small (the debian package
uses about 800k including docs), and awk in some flavour will probably
already be installed.  Don't know how you would access it directly via
TCP (in the same way as "mysql --port=6666 --host=foo.bar"), though
writing CGI to access the tables should be trivial.

Lots of people wouldn't call this a grown-up's database, but it can be
used effectively for data collection.

http://www.linux.it/~carlos/nosql/

> Brad....

-- 
Russell Steicke

-- Fortune says:
Cruickshank's Law of Committees:
	If a committee is allowed to discuss a bad idea long enough, it
	will inevitably decide to implement the idea simply because so
	much work has already been done on it.