[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Database Administration
****** message to minivend-users from Birgitt Funk <birgitt@minivend.com> ******
Frank Miedreich wrote:
> 2: Is there anything wrong with vi?
No, I even drink my coffee with it. (vi-Mug DM 18,00 ... I should sell it
in my next catalog together with JAVA Beans.
>
> Unless you specifically disable importing the products.asc file, or any
> other database source for that matter, minivend will automagically reimport
> the database when it changes. Editing a textfile is not one of the most
> powerful functions of linux.
> If you allow editing via the web (which changes the db or whatever you use)
> and the command line (changing the db source) at the same time, you may run
> into interesting consistency problems of course. This could be resolved by
> creating a file with changes to the database, incorporating the execution
> of the change-file into the reconfig script, and creating an admin page
> that exports the database and then executes reconfig.
>
> Another way may be to implement a locking scheme.
>
I wonder if I understand what you say. Let's say I have a large tab
delimited product.asc file, which will never be edited via the web and
is just updated completely on a regular basis. So I set NoImport for
it in the catalog.cfg.
On the other hand, I want to allow the input of records (same format
as in the product.asc file) into a mysql table via the web. I would
like to compare the record put into the mysql table by the web-user
against the record in the product.asc file. Only if the records match
on certain fields, I accept the mysql entry. Once accepted, do I have
to reconfig the catalog after each entry, even if I don't set a
NoImport for the mysql database table and I don't set the Import_Once
modifier in my catalog.cfg ?
Out of the docs:
IMPORT_ONCE
MiniVend does a comparison of the database file modification time
with the ASCII source every time it is accessed, and if the the ASCII
source is newer it will re-import the file.
SQL databases don't normally need this -- they will only be imported
once in normal operation.
Does this mean that I have to reconfig the catalog each time a user is
inputting a record in a MySQL table.
Sorry that I can't try it out. Last time I worked with MiniVend
was end of 1997. I am just starting out again and blow the dust of old
files and am just amazed how much enhancend and clearer the documentation
has become.
Birgitt
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
