Re: Simple Database close connection
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39176
interpreted = N
texte = I think that a new tag, or optional parameter, to flush a database frommemory without committing changes to disk is not an unreasonable request.Maybe [closedatabase db=....&commit=false]?Have you tried changing file permissions so that WebCatalog cannot commitchanges, even if it tried?> -----Original Message-----> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> Behalf Of John Peacock> Sent: Tuesday, October 09, 2001 7:35 AM> To: WebCatalog Talk> Subject: Re: Simple Database close connection>>> Scott Anderson wrote:> >> > WebCatalog does not track changes made to the database file> by users, other> > programs, or even certain WebDNA tags (WriteFile,> AppendFile, etc...). This> > is why you should take care to make sure the database is> flushed from memory> > before modifying the physical database file by any means> other than the> > built in database commands.>> This is, of course, the cause of the problems that I have. If> WebCatalog does not track changes made outside of its control (say by> looking at the last modified timestamp), I have no good way to get> WebCatalog to notice my changes other than [flushdatabase], which> risks stomping on my changes should WebCatalog decide that> the file in> RAM was, at some point in the past modified for whatever reason.>> I need r/o databases. WebCatalog needs to keeps its claws off of them> and NEVER write to a r/o database. I also need a tag to force the RAM> resident version to be replaced with the disk resident copy. I cannot> be expected to [flushdatabase] and THEN replace a 16MB database, all> the while hoping that no one does a query that will reload a now> partial file. This is a classic race condition and is not good> design. Even a simple [reloaddatabase db=...] which would drop the> RAM version and load the disk version would be better than the> current state of affairs.>> This is not the first time I have asked for this (as Grant will> probably be able to document) since ALL of our primary database are> extracts from our backend systems and are NEVER modified within> WebCatalog. I can, of course, shut off WebCatalog while I am in the> process of replacing my files, but I am running many sites which pass> all of their pages through WebCatalog, so that would leave me> completely dead in the water during updates.>> John>> --> John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4720 Boston Way> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5747>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I think that a new tag, or optional parameter, to flush a database frommemory without committing changes to disk is not an unreasonable request.Maybe [closedatabase db=....&commit=false]?Have you tried changing file permissions so that WebCatalog cannot commitchanges, even if it tried?> -----Original Message-----> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On> Behalf Of John Peacock> Sent: Tuesday, October 09, 2001 7:35 AM> To: WebCatalog Talk> Subject: Re: Simple Database close connection>>> Scott Anderson wrote:> >> > WebCatalog does not track changes made to the database file> by users, other> > programs, or even certain WebDNA tags (WriteFile,> AppendFile, etc...). This> > is why you should take care to make sure the database is> flushed from memory> > before modifying the physical database file by any means> other than the> > built in database commands.>> This is, of course, the cause of the problems that I have. If> WebCatalog does not track changes made outside of its control (say by> looking at the last modified timestamp), I have no good way to get> WebCatalog to notice my changes other than [flushdatabase], which> risks stomping on my changes should WebCatalog decide that> the file in> RAM was, at some point in the past modified for whatever reason.>> I need r/o databases. WebCatalog needs to keeps its claws off of them> and NEVER write to a r/o database. I also need a tag to force the RAM> resident version to be replaced with the disk resident copy. I cannot> be expected to [flushdatabase] and THEN replace a 16MB database, all> the while hoping that no one does a query that will reload a now> partial file. This is a classic race condition and is not good> design. Even a simple [reloaddatabase db=...] which would drop the> RAM version and load the disk version would be better than the> current state of affairs.>> This is not the first time I have asked for this (as Grant will> probably be able to document) since ALL of our primary database are> extracts from our backend systems and are NEVER modified within> WebCatalog. I can, of course, shut off WebCatalog while I am in the> process of replacing my files, but I am running many sites which pass> all of their pages through WebCatalog, so that would leave me> completely dead in the water during updates.>> John>> --> John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4720 Boston Way> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5747>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Scott Anderson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Multiple catalog databases and showcart (1997)
syntax question, not in online refernce (1997)
WebCat2 - [format thousands] (1997)
Lookup question (2001)
SKU generator? (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
sku not found (1997)
Where is f2? (1997)
Add to Cart & List of Products (1997)
IIS4b2 and WebCatalog b19 (1997)
Browser Info.txt (1997)
[/application] error? (1997)
problems with 2 tags (1997)
WebCatalog can't find database (1997)
Multiple catalog databases and showcart (1997)
[bump -SMSI] Sitebuilder (2004)
Online Docs? (1997)
Nested vs conditional (1997)
Quit revisited (1997)
RE: what characters are replaced for tab and CR? (1998)