Re: New command suggestion (was Re: Modifying databases manually)

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13832
interpreted = N
texte = >Changing out databases has become a problem for us, since we generally have >20 or more connections at any given time. I hate to deny users access to >our site by quitting Webstar or Refusing Connections for ANY amount of >time, so I have a proposal. > >A new command called $Reload with the argument db=file.db. This command >would cause Webcat to throw away the database in RAM and reload the data >from disk. Obviously, if this database is being modified, you would want >to flush it before making any changes to the file. This would allow the >user to perform the following sequence without shutting down Webstar or the >CGI: > >1) $Flushdatabases (to write out any changes) >2) Load a template with an [Applescript] to rename file.db to file.db.old, >file.db.new to file.db or manually copy the file in the Finder (meanwhile >someone accesses the site and reopens the old database) >3) $Reload?db=file.db (dump file.db from RAM without writing to disk, load >new file.db into RAM) > >Note that this only makes sense for databases that aren't being modified by >webcat all the time (or at all). We have several databases that are only >modified by Admin pages or by an external program (like Excel or 4D), and >having a way to swap the database in without restarting Webstar would be a >big help. > >We would still have to resort to a shutdown to change out webcat-modified >database files to ensure consistency. > >What does everyone think? Or am I missing an easier way to do this? > >Thanks, > >-Dale > >--- >Dale LaFountain | mailto:dalel@dhorse.com >Director of MIS, WebMaster | http://www.dhorse.com/ >Dark Horse Comics, Inc. |Phone: 503-652-8815 x324 > > Yes please, This would be a very useful facility.jeremyJeremy Pocock NetCommerce Ltd http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 456656 Fax: +44 (0)1703 453231 ---------------------------------------------------------------------- Email address : jpocock@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 97! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk Associated Messages, from the most recent to the oldest:

    
>Changing out databases has become a problem for us, since we generally have >20 or more connections at any given time. I hate to deny users access to >our site by quitting Webstar or Refusing Connections for ANY amount of >time, so I have a proposal. > >A new command called $Reload with the argument db=file.db. This command >would cause Webcat to throw away the database in RAM and reload the data >from disk. Obviously, if this database is being modified, you would want >to flush it before making any changes to the file. This would allow the >user to perform the following sequence without shutting down Webstar or the >CGI: > >1) $Flushdatabases (to write out any changes) >2) Load a template with an [Applescript] to rename file.db to file.db.old, >file.db.new to file.db or manually copy the file in the Finder (meanwhile >someone accesses the site and reopens the old database) >3) $Reload?db=file.db (dump file.db from RAM without writing to disk, load >new file.db into RAM) > >Note that this only makes sense for databases that aren't being modified by >webcat all the time (or at all). We have several databases that are only >modified by Admin pages or by an external program (like Excel or 4D), and >having a way to swap the database in without restarting Webstar would be a >big help. > >We would still have to resort to a shutdown to change out webcat-modified >database files to ensure consistency. > >What does everyone think? Or am I missing an easier way to do this? > >Thanks, > >-Dale > >--- >Dale LaFountain | mailto:dalel@dhorse.com >Director of MIS, WebMaster | http://www.dhorse.com/ >Dark Horse Comics, Inc. |Phone: 503-652-8815 x324 > > Yes please, This would be a very useful facility.jeremyJeremy Pocock NetCommerce Ltd http://www.NetCommerce.co.uk ---------------------------------------------------------------------- Tel: +44 (0)1703 456656 Fax: +44 (0)1703 453231 ---------------------------------------------------------------------- Email address : jpocock@NetCommerce.co.uk ---------------------------------------------------------------------- Buy It On-Line in 97! http://www.ShopsOnTheNet.co.uk http://www.ShopsOnTheNet.com ---------------------------------------------------------------------- InfoDisk - Address and Telephone Numbers for over 44 million UK residents on CD-Rom Order Your Copy Now from IDDirect! http://www.iddirect.co.uk ---------------------------------------------------------------------- Europe's Premier On-Line CD Rom Retailer http://www.CDDirect.co.uk Jeremy Pocock

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:

Lookup Notfound (1998) [sendmail] on NT? (1997) Bug (feature) in v6 listfiles shows hidden files ... (2004) Weird Math and SV (1997) upgrading (1997) Multiple prices (1997) Re2: frames & carts (1997) FW: WebCat Contest (1998) RE: Checkboxes to add to cart... (1998) Speed/performance issues using .hdr (1997) Formating found categories (1997) Practice runs ? (1997) Nested vs conditional (1997) Separate SSL Server (1997) WebCatalog sales (1997) Catalogs and W* (1996) Software & Sites (1998) [WebDNA] www.webdna.us store down?? (2012) autosensing lanague selection (1997) absolute paths for databases? (1997)