Hacker News new | ask | show | jobs
by majkinetor 2087 days ago
So far other answers are limited in what they consider a 'database'. If you need full blown relational db support, you could for example utilize PostgreRest to get db API with minimal effort that you can use as a service. This is not generation time (it could be), the point is to work run time. This is similar to how you would handle comments via for example discuss service. You basically have full SQL capabilities via REST interface - you can choose, order, sort and filter any db column, 100% of CRUD and even have actions via stored procedures. After taking a time to learn it, you can create a production grade service in few hours.

Data onboarding is as trivial as creating a table in a database - it will get automagically exposed as REST endpoint.

Performance is epic (my tests show ~2K req/s).

There are alternative services, such as hasura, you might wanna take a look at.

http://postgrest.org/en/v7.0.0/

Here is my Windows setup/test and in the notes section you have another one for Nix.

https://github.com/majkinetor/postgrest-test