Re:Need Postgresql HTTP API Extension
by mercurial on Monday September 22, 2014 @09:46AM
(#8350503)
That'd make in a very simple case (an app with a user_profile table) one view per user? This doesn't sound particularly appealing...
[ Parent
| on HN ]
Re:Need Postgresql HTTP API Extension
by AlterEgo20 on Monday September 22, 2014 @10:12AM
(#8350599)
"one view per user" - you can have a single VIEW, that filters rows based on user name ("owner_user_name" column in the base table). Or use some kind of mapping table for "user_name" <-> "table PK id". It gets more complicated with inherited user roles, but still manageable.