Create an API endpoint to save data on PostgreSQL about daf-dataportal HOT 6 OPEN

Would postgrest suffice?

from daf-dataportal.

PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations. @ruphy what do you think? if you want we can create an example project on the daf-recipes project

from daf-dataportal.

yes for me is perfect. The goal is to have some endpoints where data csv and json go into postgres and can be queried easily. Seems perfect. Maybe can be added more functionality on top of the API.

from daf-dataportal.

ok, cool

from daf-dataportal.

What about using PostgreSQL Json query engine over No-sql data? The form can be serialized to JSON and saved into a PostgreSQL's json field. I think is viable and more flexible compared to structuring the data. What kind of use cases do you have in mind?

from daf-dataportal.

Yes, @ermannob the use case is to use postgres instead of the big data layer for working locally with DAF without connecting to a cluster. We have many tools (metabase, superset, jupyter via spark), api ecc that can interact with postgres and could be useful to have a single entry point for the data

from daf-dataportal.