Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
patricius
on Nov 14, 2017
|
parent
|
context
|
favorite
| on:
Show HN: Datasette – Create and publish an API for...
Hi. I'd like to know how you design the database to separate data available via REST and data that is not.
hucker
on Nov 14, 2017
|
next
[–]
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.
evv555
on Nov 14, 2017
|
prev
[–]
SQL View queries get their own REST endpoints or you can use Postgrest like a language agnostic ORM.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
