Multiple DBs, One app, How to do relations?
От | Eric Dahnke |
---|---|
Тема | Multiple DBs, One app, How to do relations? |
Дата | |
Msg-id | 00a601c427df$f952cd00$c305a8c0@x850 обсуждение исходный текст |
Ответы |
Re: Multiple DBs, One app, How to do relations?
|
Список | pgsql-general |
Dear List, We have a large project with three of the larger components (of the project) being the eventual creation of a Global Product DB and a Global Customer DB and a Global Dealer DB. Because of certain legacy issues, the schema has evolved to be one large application specific schema containing product, customer, and dealer tables. A better design would be three separate databases (and we can pull them apart easily enough), but the question becomes how to make the product to customer to dealer relations between distinct databases using Postgres. The following would be ideal (Oracle supports the following) SELECT foo FROM customerDB.addressTable, productDB.priceTable WHERE customerDB.addressTable.customer_id = productDB.priceTable.customer_id Does anyone have any experience or suggestions working with multiple db's within the same application. How best to do the relations. Within the application code space? Using stored procedures? or other? Sincerely, Eric Dahnke Sr. Engineer Yamaha Music Division
В списке pgsql-general по дате отправления: