[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Rule-list] rule database
From: |
hairylarry |
Subject: |
[Rule-list] rule database |
Date: |
Sat, 13 Apr 2002 12:00:24 -0500 |
Hi,
With the dataminer interface to the sql tables that I am currently
testing apostrophes can cause an error. This is fairly easily fixed but
until then avoid using apostrophes in your data. Evidently mysql is
parsing them as single quotes and it's screwing up the syntax.
I fixed the field names so they are in unabbreviated english and more
meaningful. I think english has to be the standard language for the
database. Translating it would be a never ending task.
Right now I am using two programs for the database.
PhpMyAdmin was already installed with plesk. It is standard on most
systems using mysql. I use PhpMyAdmin for all administrative
tasks, creating tables, changing field names, etc.
DataMiner is used for the user interface. It provides a browse screen,
an edit screen, and a view screen, ready to print. There is no
configuration required with dataminer for new tables or field names.
For each table I install another copy and change the table name.
That's it. Accessing multiple tables is top on his development
schedule so in the future we may avoid even that step.
When field names are changed or fields added or deleted DataMiner
automatically notices and adjusts it's screens. It is possible to
configure DataMiner in many ways. I am trying to set this up with the
least configuration possible. Minimizing the workload.
I think we can use apache http post authentication. That is restrict
post access to validated users in the /apps directory tree.
Rodolfo, will apache authentication check against the Plesk user list
or do we make a separate user file with htpasswd? User
authentication is of course desired.
Right now I have only apps and deps tables up for the Rule
Application Selector. I will add prototype tables for test pcs and
slinky translations next.
Thanks,
Hairy Larry
- [Rule-list] rule database,
hairylarry <=