A Poor Man's API • Hacker News Board

Re: A Poor Man's API

#31

Post by nikita » Tue, Nov 29, 2022, 8:26 AM UTC

boomskats wrote: post #27

quickthrower2 wrote: post #4

Earlier quoted context omitted.

NKOTB: https://neon.tech/ Free Tier includes: compute up to 1 vCPU / 256 MB storage up to 10 GiB 3 projects per user

Neon is fresh out of private beta (or should be soon). I can't wait to play with it. However they're all about Hasura lately rather than PostgREST, which this article talks about. Nikita, their CEO, was a guest on the Changelog[0] podcast a month or so ago. Well worth a listen, great episode. [0] https://changelog.com/podcast/510

Out of private beta in the 6th of December

Re: A Poor Man's API

#32

Post by sgt » Tue, Nov 29, 2022, 8:31 AM UTC

Is APISIX any good?

Re: A Poor Man's API

#33

Post by quickthrower2 » Tue, Nov 29, 2022, 8:32 AM UTC

55555 wrote: post #11

Check out this simple, easy API replacement: just set up Docker, APISIX, Grafana, Prometheus, etc. Does anyone else miss the old days of just editing your site's code and adding new columns to your MYSQL database while people were surfing your website? That was fun. Tip: Another way to turn your DB into an API is to just connect to it and then write SQL queries.

hostgator.com still exists. install some wordpress, edit the PHP files, add some tables in MySQL, have fun!

Re: A Poor Man's API

#34

Post by quickthrower2 » Tue, Nov 29, 2022, 8:36 AM UTC

tasuki wrote: post #17

> Creating a full-fledged API [...]. You need to think about [...] the REST principles I can assure you you don't need to do that. And most people don't. It's perfectly possible to create a useful API without adhering to the REST principles. [Edit, having read the rest of the article]: Case in point, this very PostgREST tool promoted in the article appears very useful, while not thinking about the REST principles.

What is the acronym for when something needs to be done, so you create an endpoint to do that thing, maybe return HTML if convenient (if it is a page request) or JSON if it is XHR, and then move on to the next user story?

Re: A Poor Man's API

#35

Post by [deleted] » Tue, Nov 29, 2022, 8:59 AM UTC

[deleted]

Re: A Poor Man's API

#36

Post by quickthrower2 » Tue, Nov 29, 2022, 9:03 AM UTC

quickthrower2 wrote: post #4

brianjacobs wrote: post #2

Not to be mean, but from my reading this needs Heroku free tier which no longer exists? I am very sorry if I got that wrong.

NKOTB: https://neon.tech/ Free Tier includes: compute up to 1 vCPU / 256 MB storage up to 10 GiB 3 projects per user

Edit: that was beta free tier. might change.

Re: A Poor Man's API

#37

Post by [deleted] » Tue, Nov 29, 2022, 9:04 AM UTC

[deleted]

Re: A Poor Man's API

#38

Post by bmn__ » Tue, Nov 29, 2022, 9:14 AM UTC

> PostgREST is a fast way to construct a RESTful API.

That's false. The responses don't even have hyperlinks.

Re: A Poor Man's API

#39

Post by 12tvende » Tue, Nov 29, 2022, 9:33 AM UTC

Pretty cool postgress feature

Re: A Poor Man's API

#40

Post by GolDDranks » Tue, Nov 29, 2022, 9:34 AM UTC

bmn__ wrote: post #38

> PostgREST is a fast way to construct a RESTful API. That's false. The responses don't even have hyperlinks.

Just to clear things up a bit (as I remember not knowing about this side of "RESTfulness" a while ago myself): an important part of REST is relying on hypertext, that is pointing to other resources by using URLs. Just returning an ID of a referenced object/resource as a plain number isn't very RESTful, but returning an URL of that object/resource is.