in reply to Large Constant Database in Text File

Obviously, you need *some* sort of indexing.

I use BerkeleyDB (formerly http://www.sleepycat.com/ - now bought by oracle) with BerkeleyDB to index large flatfiles (on substrings, regexen, whatever).

This will let you keep a setup with the original text files (as you seem to prefer over parsing it to bits into a regular rdbms). Of course, after editing the text file you have to rebuild the index.

Update: BerkelyDB bought by Oracle? Out with it! :) (that data is now in postgresql)

  • Comment on Re: Large Constant Database in Text File