Hacker News new | ask | show | jobs
by hucker 3136 days ago
Yes, with good results. Anything specific you're curious about?
1 comments
patricius 3136 days ago
Hi. I'd like to know how you design the database to separate data available via REST and data that is not.
link
hucker 3136 days ago
We use a separate schema for the API (that way we can easily version our APIs as well). The API schemas only contain views/function that expose the tables/fields/etc that we want to expose.
link
evv555 3136 days ago
SQL View queries get their own REST endpoints or you can use Postgrest like a language agnostic ORM.
link