[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: realtime database????
On Mon, 9 Aug 1999, Birgitt Funk wrote:
> On Mon, 9 Aug 1999, Christopher Gray wrote:
> > 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??
> >
>
> 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.
The POS system would have to be reachable via TCP/IP 24x7
If it's in the same shop as the MV server this is no problem.
The POS system needs to be running an SQL database.
If it is then just tell MV to use it in your catalog.cfg file. See
the example Database directives for various SQL databases and change
localhost to suit.
Most POS systems do a *lot* more than just insert order master and
detail records and update inventory when you finalize a transaction.
You'll need to mirror everything it does or risk the integrity of
the POS database.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
