Hmmm, 1000 records. That is a rather small database. It is large on a Pc scale, but small on a business scale which most of the SQL drivers and technology are targetting.

I once developed a module called Lady /TM to manage small persistent data indexes for a website. The use of the indexes came out of realizing that precomputed cache's can be time-saving. Actually they were crucial to the success of the project.

With Lady /TM there is compatibility with EZDB (which you could also use.) EZDB is at EZPERL.com. It is a flatfile database manager that you can use online. This means you can set it up via FTP access in a remote CGI bin and use the WWW to manage your live data. Lady /TM has no interface like EZDB. EZDB requires that you setup templates for display and entry. With Lady /TM I write scripts that need fast access to site-related data in prototyping. Lots of site data is purged, keeping the datafiles small.

Like a flatfile, Lady /TM keeps a header of the top line. Something like:

pkey|index|value1*~*value2*~*value3*~*value4*~*value5*~*|blank|

The table methods let you grab the string values from a hash after it is initialized. Processing the string is easily done with conventional flatfile processing methods.

With enough interest, I will develop the needed code to allow creation of forms, designating the index and the order of the rest of the fields and values within the flatfile record.

Lady /TM was posted to this forum under the Utilities scripts.

-Steeeeeve