Ken Lyle
|
| Posted: 10/19/2005, 7:36 PM |
|
Can a CodeCharge Application be generated that would allow access to , and joins between multiple MySQL databases?
If not, how much modification would be required?
Say, for example, I want to have an application that matches people in my Mambo database with people in my OSCommerce database so that I can see info about the customers' usage of the web site and what they've bought in the same view.
Thanks,
Ken
|
|
|
 |
Edd
Posts: 547
|
| Posted: 10/19/2005, 8:00 PM |
|
Microsoft SQL allows you to right a view that looks across multiple databases and when you are working in CCS you can update them individually through either code or stored procedures.
The first question is, "Can MYSQL view multiple datasources in a sngle SQL statement?" If the answer is YES then CCS will can be coded to allow for this.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
peterr
Posts: 5971
|
| Posted: 10/20/2005, 12:21 AM |
|
Let me add that I think that applications shouldn't do this. The purpose of databases is to interpret an SQL statement, do with it whatever is needed and return the data. It wouldn't make much sense to try to replace database functionality with an application. Otherwise you would be creating a database engine in a way.
Some databases are able to run SQL statements across other multiple databases. If your database doesn't support this then you can request such functionality from your database vendor, or switch to a more robust database.
In my opinion it should not be implemented in an ASP/PHP/.NET application. This isn't related to CodeCharge, BTW.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
kenlyle
Posts: 7
|
| Posted: 10/21/2005, 6:55 AM |
|
Sorry to be off-topic, Peter, but I think that it may be of interest to other users.
I have Mambo, OSCommerce, a mail list program, and an email "database" in Access, and I am trying to get a complete picture of my customers.
Are you saying that this is a data warehouse question, to just reduce the data to a single database from time to time and use that database? 3 of my apps use MySQL, and one Access, btw.
Thanks,
Ken
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/21/2005, 11:41 AM |
|
No, I didn't try to say that because I wasn't sure if data warehousing is a valid option for you. For example if you need the data in real-time.
What I was trying to say is that MS Access, for example, allows you to use a single SQL query that pulls the data from multiple databases. So there is no need to change anything in the application, just send a single query to MS Access or any other database that supports this, and the database will take care of everything.
An SQL statement has to be sent to one specific place that will process it, which is a database. Therefore generated code or manually written code shouldn't try to split a single SQL statement into multiple ones and send them to different databases. It would be a nightmare to automate this, while I think that your application shouldn't even be doing what databases are supposed to be doing.
If data warehousing would work for you then indeed it could be another, possibly the best solution.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
