[Rule-list] rule database

[hairylarry at deltaboogie.com]

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 Project HOME PAGE:  http://www.freesoftware.fsf.org/rule/
Original Rule Development Site http://savannah.gnu.org/projects/rule/Rule-list at mail.freesoftware.fsf.org
http://mail.freesoftware.fsf.org/mailman/listinfo/rule-list