Rev Stacks for "tiny" read only backend web dBases
katir at hindu.org
Fri Feb 11 23:27:00 EST 2005
Thanks to all for the recommendations:
A text file could work... I'm just not sure how big it will be.. I
could have the stack simply dump the text and FTP that to the site...
On Feb 11, 2005, at 1:02 PM, J. Landman Gay wrote:
> On 2/11/05 1:45 PM, Sivakatirswami wrote:
>> For a small amount of data to be delivered on the web e.g. 1000
>> records or less; in this case, word definitions of a glossary. where
>> the record has only two pieces of data
>> -- definition, am wondering if a back end revolution stack can serve
> I would think so. Even if you just use "find" to locate the words, it
> wouldn't be too bad (though the "find" command isn't the fastest thing
> in the world.) The fastest way to locate a card is by ID though, so
> you might want to create a lookup table instead. Before you publish
> the stack, run a handler that walks through the cards and stores the
> word and the card ID in a list somewhere. Then have the CGI get the
> lookup table, extract the ID, and grab the definition from that card.
> Which actually means that someone else's suggestion of just using a
> text file might work just as well, though maybe a little less esthetic
> for data entry.
>> Since input will be by a single admin individual, access would be
>> read only. It's so simple, I'm not sure we need a macho PostGreSQL
>> dbase for this and a Rev Stack would be so easy-portable. I can have
>> someone working on a stack on his own machine... then just move it to
>> the server how efficient is that... very...
> Right. Very easy.
>> The question would be: are there any read access concurrency issues
>> in such a web app context?
> Not if the file is only being read. It can be opened multiple times by
> any number of instances of the engine.
>> Anyone else doing this? what's your experience?
>> if a cgi calls
>> "start using stack "../html/books/master_lexicon.rev"
>> ... does that mean another person hitting the same CGI within
>> milliseconds will have a problem?
> I have a CGI on my site that does this. There hasn't been any problem,
> as long as the files are read-only.
> Jacqueline Landman Gay | jacque at hyperactivesw.com
> HyperActive Software | http://www.hyperactivesw.com
> use-revolution mailing list
> use-revolution at lists.runrev.com
More information about the Use-livecode