Re: realtime database????

[Birgitt Funk <birgitt@minivend.com>]

On Mon, 9 Aug 1999, Christopher Gray wrote:

> Hi,
> 
>         We're working on an in-store internet/Point of sale sever.  We want to be able to use the same database as we do in the actual store as we do online, and have each system update the database on the fly so that both the in store system and the web site are up to date all the time.  
> 
> How, if possible, can I set minivend up to access a database that is being changed on the fly??  
> 
> Thanks 
> 
> Christopher
> 

I was wondering about that one too a bit a long time ago. Other than
getting your POS-PC being an 24h/7d online web-server at the same time
and using an inventory system for your POS that uses the MV product.asc
or inventory.asc file as the POS-database, I could not imagine how that
would be done. (May be mirroring on an hourly basis your inventory
database to the online mv/web-server and upgrading the product.asc
file hourly. Or if your in-store POS-PC is already the minivend/web
server online, then finding a way to read your inventory database from
your POS-program into MySQL constantly and use MV with MySQL. 

But I am a non-techie, so I ask humbly the experts for some more obvious
solutions than my above puppy-dreams. 8-)


Birgitt Funk