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 PocockNetCommerce Ltdhttp://www.NetCommerce.co.uk----------------------------------------------------------------------Tel: +44 (0)1703 456656Fax: +44 (0)1703 453231----------------------------------------------------------------------Email address : jpocock@NetCommerce.co.uk----------------------------------------------------------------------Buy It On-Line in 97!http://www.ShopsOnTheNet.co.ukhttp://www.ShopsOnTheNet.com----------------------------------------------------------------------InfoDisk - Address and Telephone Numbersfor over 44 million UK residents on CD-RomOrder Your Copy Now from IDDirect!http://www.iddirect.co.uk----------------------------------------------------------------------Europe's Premier On-Line CD Rom Retailerhttp://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 PocockNetCommerce Ltdhttp://www.NetCommerce.co.uk----------------------------------------------------------------------Tel: +44 (0)1703 456656Fax: +44 (0)1703 453231----------------------------------------------------------------------Email address : jpocock@NetCommerce.co.uk----------------------------------------------------------------------Buy It On-Line in 97!http://www.ShopsOnTheNet.co.ukhttp://www.ShopsOnTheNet.com----------------------------------------------------------------------InfoDisk - Address and Telephone Numbersfor over 44 million UK residents on CD-RomOrder Your Copy Now from IDDirect!http://www.iddirect.co.uk----------------------------------------------------------------------Europe's Premier On-Line CD Rom Retailerhttp://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:
FM fields with CR - How to export/import? (2000)
Formulas What if. (1999)
Simple counter - how? (1997)
[Webcat 2]Next (1997)
WebCatalog for guestbook ? (1997)
Help returning tracking data from USPS website (2004)
Webmerchant (2000)
Weird error/limit - something amiss? (1997)
Close-to Comparison Code (1998)
Version f1 status (1997)
&fieldsdir=ra truely random?? (2000)
Re:quit command on NT (1997)
Was random sort ever dealt with effectively??? (2002)
using showpage and showcart commands (1996)
Help name our technology! I found it (1997)
Error Page? (1997)
Pop-up menu (1998)
Repeating Fields (1997)
pictures / referrer etc. (1998)
Referrer field to header field conversion (1997)