I'm thinking about a general purpose system control panel for my app. 
I'd rather not use the Java config storage system since it stores
its data on the local file system (problematic if I run the app across
multiple web servers), what I was thinking is a simple string based DB table
that I can add to as I add features to the system, and at the same time
not make it so complex that there's all sorts of conditional code required
to display it.  What I was thinking is a table like this:

table SysOpParams {
   area                String(64);     // A string indicating what part
of the system (Ads, access, news, faqs...) this parameter is form. Each
"area"
                                               // is a collection of
params grouped together visually by the System Control Panel Element
   param_name  String(64);     // name of system parameter. E.g.,
MAX_NEWS_ITEMS, ALLOW_LOGINS, ALLOW_COMMENTS, etc.
   l10n_key        String(64);     // a key that can be used to localize
the control panel labels
   actual_type    String(16);     //  the actual type of the object
represented, one of: "float", "int", "boolean", "string"
   value              Text;              // the operational value,
stored as a string
   value_default Text;              // the default value, stored as a string
   value_min      Text;              // the min value (where
applicable), stored as a string
   value_max     Text;              // the max value (where applicable),
stored as a string
}

of course this pushes the multi-web-server sync problem up a layer...
but seems like a cleaner solution since the data are only in one place... 
the only big issue is how to make these data loadable and persistent at
app startup like the repository so I am not continuously beating on the
DB...
multiple server instances could be told to re-sync via a listener.

thoughts?  reasonable general solution, or am I way off in the weeds..?

David

_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

Reply via email to