Show HN: Rest – Instant RESTful API on Any SQL Database

https://github.com/rest-go/rest

by shellfly • 3 years ago

26 11 3 years ago

github.com

prenoob• 3 years ago

Nice, does it support JSON/JSONB fields for psql?

Edit after RTFM: it apparently does. https://rest-go.com/docs/guides/api#query-json-columns

nesarkvechnep• 3 years ago

Fully RESTful, yet no mention of hypermedia.

shellfly3• 3 years ago

Thanks for mention it, it should be a feature for this kind of tool, put it on my plan.

ElectricalUnion• 3 years ago

No mention of HATEOAS, hypertext, not even bare minimum "RESTful hyperlinks".

varunsharma07• 3 years ago

It would be great if it could support NoSQL databases as well. I use DynamoDb as an example, and I had to write REST APIs myself.

SOLAR_FIELDS• 3 years ago

Yes it would be great. But this is kind of like saying people who have a pattern for making quilts should use their techniques to get into the sheet business. On the surface it makes sense, but when you dig into the details it turns out that the way you make quilts and the way you make sheets are so fundamentally different it’s not even worth exploring a common ground. Yes we both make things that go on peoples beds, but the manufacturing internals are so completely different that it’s not even worth having the conversation about how they could be married.

masukomi• 3 years ago

While yes, this makes a ton of sense, I'm voting this up specifically for using a quilting metaphor to explain geekery. ;)

thecosmicfrog• 3 years ago

Curious about the name. Why just "Rest"?

shellfly3• 3 years ago

I didn't spend much time on naming, the original idea was inspired by an interesting project PostgREST which is a similar tool bind to Postgres, so I just name it as Rest which could provide RESTFul API for any SQL database.

dantetheinferno• 3 years ago

Pretty cool - wonder how it compares to Postgrest (https://postgrest.org/).

Generally been a fan of these sorts of models - SQL data is very malleable - and treating the tables as movable from the start really helps move faster as a developer - database migrations become easier as you don't need to do a lot of work with API.

I can see how this would cause problems if you always used this in production after finding a fit for the data model - but for rapid prototyping and development - big fan.

shellfly3• 3 years ago

The original idea was inspired by PostgREST, the obvious difference is Rest tries to support all SQL databases, and it results in some design principle that Rest prefers to use a universal method instead of bind to PG features(e.g. use PG role for user authorization). Generally PostgREST is more mature now if you are using PG. Thanks for liking it, I also think it could be a good tool to help developers for rapid prototyping and development.

Show HN: Rest – Instant RESTful API on Any SQL Database

Related Stories