Re: htdig: Database (MySQL)

Andrew Scherpbier (
Thu, 17 Sep 1998 09:54:39 -0700

Brian Litke wrote:
> I vote for MySQL since it is free.
> (and since I use it) :-)
> Brian Litke
> >The move to DB2 is nice. But have you thought of moving ht://dig to an SQL
> >database?
> >
> >mSQL and MySQL come to mind ...

The problem with a sql database is that they do not lend themselves well to
the variable record length database approach that ht://Dig 3 uses.
This is one of the things that I want to change in ht://Dig 4 so that a(ny)
sql database can be used.

A sql database could possibly be attached to ht://Dig 3 but I forsee a huge
performance penalty for having to rely on blobs instead of normal table
fields. (Especially if the sql database is connected through a network...)

One thing that still bothers me about a sql database approach is how to
implement all the existing fuzzy search algorithms. sql "like" is a little
limited... sure, there are databases that have extensions, but then you're
not talking sql anymore and your are locked into one db, which I want to

Andrew Scherpbier <>
Contigo Software <>
To unsubscribe from the htdig mailing list, send a message to containing the single word "unsubscribe" in
the body of the message.

This archive was generated by hypermail 2.0b3 on Sat Jan 02 1999 - 16:27:45 PST