| Subject | RE: [firebird-support] using multiple databases |
|---|---|
| Author | Tim |
| Post date | 2005-02-25T08:53:31Z |
In my case, a leftover from using Sybase ...
Which is a tiny little desktop DB system you might not have heard of. :-)
No seriously, I would also like this very much indeed. Instead of having
one humungous (mainframe - like) database that has everything - accounts,
customers, etc., etc., etc. all shoved in together, I would love to be able
to access multiple databases from SQL within each db.
Instead, what I have to do every time I write a new DB, is copy and paste
from the other DBs - so ALL my databases, (for example) have the same
procedures for handling customers - instead of ONE customer DB that I can
use and re - use and re - use. Or leave out, as the situation demands.
Instead, I now have to maintain several different metadatas.
It has many of the benefits of object orientation - code reusability, each
DB "knowing" what to do with its' data, that kind of thing.
And its' not just linking tables. In my case, what I found MUCH more
useful was being able to develop SPs that would (as an example) check a
customer's credit rating - and being able to call this from another DB. So,
for example, in the Transaction DB you could say something like
/*Check customer credit*/
ACCOUNTSDB.CHECKCREDIT(CustomerNumber)
Assuming that there was some SP in AccountsDB that would check the credit.
Or when doing invoices in the ACCOUNTSDB, you could say something like
SELECT * FROM CUSTOMERDB.GETADDRESS
And it's not just an issue of temporary tables Helen. I am sure that you
know Sybase well enough to know that there is much more to it than that.
However, in the meantime, I still love Firebird ... :-)
None of this is meant to be a rant in any way, or a criticism of either FB
or any person on the list.
Regards
Tim
At 10:31 25/02/2005, you wrote:
Which is a tiny little desktop DB system you might not have heard of. :-)
No seriously, I would also like this very much indeed. Instead of having
one humungous (mainframe - like) database that has everything - accounts,
customers, etc., etc., etc. all shoved in together, I would love to be able
to access multiple databases from SQL within each db.
Instead, what I have to do every time I write a new DB, is copy and paste
from the other DBs - so ALL my databases, (for example) have the same
procedures for handling customers - instead of ONE customer DB that I can
use and re - use and re - use. Or leave out, as the situation demands.
Instead, I now have to maintain several different metadatas.
It has many of the benefits of object orientation - code reusability, each
DB "knowing" what to do with its' data, that kind of thing.
And its' not just linking tables. In my case, what I found MUCH more
useful was being able to develop SPs that would (as an example) check a
customer's credit rating - and being able to call this from another DB. So,
for example, in the Transaction DB you could say something like
/*Check customer credit*/
ACCOUNTSDB.CHECKCREDIT(CustomerNumber)
Assuming that there was some SP in AccountsDB that would check the credit.
Or when doing invoices in the ACCOUNTSDB, you could say something like
SELECT * FROM CUSTOMERDB.GETADDRESS
And it's not just an issue of temporary tables Helen. I am sure that you
know Sybase well enough to know that there is much more to it than that.
However, in the meantime, I still love Firebird ... :-)
None of this is meant to be a rant in any way, or a criticism of either FB
or any person on the list.
Regards
Tim
At 10:31 25/02/2005, you wrote:
> >[Non-text portions of this message have been removed]
> > This is really my #1 on the wishlist....
> >
> > On Tue, 15 Feb 2005 14:18:38 +1100, Helen Borrie wrote:
>
>
>all you need to do is get over this need to have separate DBs (often a
>leftover habit of desktop database environments) - just normalise your data
>and put it all together... if they're on the same machine they should be in
>the same file....
>Alan
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://us.ard.yahoo.com/SIG=1299ek551/M=298184.6018725.7038619.3001176/D=groups/S=1705115386:HM/EXP=1109406880/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075>
>click here
>
>
>
>----------
>Yahoo! Groups Links
> * To visit your group on the web, go to:
> *
> <http://groups.yahoo.com/group/firebird-support/>http://groups.yahoo.com/group/firebird-support/
>
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.