Apache SOLR et al especially the regex search abilities look interesting.
They seems to handle files in databases as well as those in filesystems.
It is likely a bit detached, overkill, and heavy for my needs but I'll keep it in mind if PostgreSQL can't fill them.
On Tue, Jun 14, 2011 at 7:23 PM, Cliff Pratt <enkiduonthenet@xxxxxxxxx> wrote:
Store the metadata in the database, and store the actual document on
the filesystem. Use Apache SOLR or any good alternative to index the
data for search.
Cheers,
Cliff