>Thanks Bill
>I will be looking into these options.
>
>Another question.
>I can see where you have a database for a corporation with a number of branch offices using MySQL d/b on the Web server, but
>I am looking to have an Application on the Web Server and MySql D/B installed on each clients work station. I would be using VFP7 (w/o WestWind) or maybe PHP for the application on the server. The idea would be, when the client subscribes to the application, to install the d/b on the client work station & also install an Icon containing the URL of the application.
>I would appreciate any input you have on this.
>Bill Wright
---
Heya Bill -
I had looked at this a few years back for a paradigm of info subscribing.
if you can bind [theo-rhetically] the concept of 'subscriber' to 'domain space' then you should be ok. I would suggest a basic Primary Key -- Foreign Key Relationship - but I'm glossing over quite a lot here.
the branch office would have to have access to what? from a domain space standpoint ? answer that one, and thats about 80 percent of your design.
--
a mySql DB installed at each clients work station ? WHY ?? seems overkill, at least in me small wee heid.
I don't think the 'D/B' needs to be installed at the workstation level - but instead - some how think of a subset o data that relates back to the branch office that resides back at the server level. Could be a seperate DB with some linkage back to a MASTER, or not - depends on the design. You could get into a lot of replication issues, of course.
There are branch office constraints, of course, that could be stored back in the VFP domain, but to make a sub-domain at a branch office in EACH WORKSTATION for mySQl ? seems to me the design is flawed.
mySql is really a server-based DB - so if you ain't doing server level DB-slinging - why bother ? [big oversimplification, I Know, but I have to ram it home somehow] ..
let me know your thoughts? no personal attacks intended - my apologies if it seemed that way. I'm a fan o CJ Date and his theories o SQL and DB design.
gufen mySQL [Bill]
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only