Just another Perl shrine | |
PerlMonks |
Re: Flat File Databaseby Steeeeeve (Initiate) |
on Feb 02, 2001 at 02:36 UTC ( [id://55881]=note: print w/replies, xml ) | Need Help?? |
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
In Section
Seekers of Perl Wisdom
|
|