Question:
How feasible would it be to create this functionality in PostgreSQL:
One creates a test version of a database that initially consists of
read-links to the production version of the same database. Any code he/she
then writes that reads from a table reads from the production database but
any code that modifies data copies that table to the test database.
The benefits of this are obviously huge for IT shops that need to constantly
work on data in test environments as similar as possible to the production
environment.
Usually, this is a very difficult aspect of one's work and represents a great
deal of risk. We always try to hard to ensure that what we migrate into
production is going to work there the same as it did in test. And we should
not do testing in a production environment.
Such a feature would give PostgreSQL a major advantage over Oracle or DB2.
And some day when PostgreSQL is also distributable, it'll be ideal for the
enterprise.
Matthew
--
Anything that can be logically explained, can be programmed.