News for hackers. Stuff that matters.
Re:Automatic REST API for Any Postgres Database by dyadic on Saturday January 03, 2015 @06:23PM (#8832459)
Interesting. So instead of having a full copy of the database in each schema you would only create the delta and then simulate the rest with views?

And then creating a bar with version 1 to 7 would use the views in each schema to insert it, but it would actually be inserted into the database in schema 1?

Re:Automatic REST API for Any Postgres Database by joevandyk on Saturday January 03, 2015 @07:19PM (#8832622)
The database tables don't have to be in schema 1, they can be in any schema, probably the default "public" one.

But yes, you don't have to have copies of the data in each schema. You only put the view definition into each schema, and the view definition is responsible for reading/putting data from/to the right place. And you bump the version whenever the view definition's columns need to change.