DB2Rest VS postgrest

DB2Rest builds on its RSQL core to make it very easy to combine data from one table with another table and fetch the single result of data through DB2Rest's automatically provided REST API. With DB2Rest, it is also very easy to retrieve rows and apply filters. Let's dive in!

DB2Rest can automatically generate TSID primary keys as it inserts data through its instant API into your database tables. It does this by auto detecting an existing primary key column in the table you are writing to and will use the datatype category (Integer-based or Text/String based) to generate the appropriate TSID format (Long/Number or Text).

DB2Rest is open source middleware that offers a no-code way to safely expose data from your database for your applications to consume. It's runs as a service that you can host locally or in the cloud. It even has an easy to use Docker deployment.

One thing that is missing is a standard no-LLM policy, like the "Contributor Covenant Code of Conduct". On PostgREST we recently added a strict no-LLM policy [1], basically linking Gentoo's AI policy, which we found the most apt in lack of a standard.

[1]: https://github.com/PostgREST/postgrest/blob/main/CONTRIBUTIN...

Cool project, I recently moved a project off supabase entirely, my thoughts:

- better-auth is amazing and made moving off supabase a lot less scary for. auth is very sticky.

- Is this offering an alternative to https://github.com/PostgREST/postgrest or a wrapper around it?

- I tried to self-host supabase/realtime recently and couldn't even get it working locally, so i migrated to postgres LISTEN/NOTIFY, which doesn't work for a lot of uses, but is perfectly fine for mine. Not sure what adoption is like of realtime, but helping people migrate off that could have value.

- Re: storage, is this only for cases when using supabase-js to access storage? In my case, I was already using AWS SDKs to access the supabase bucket so there were zero code changes.

- I kind of miss the supabase security & performance advisor, do any other postgres hosts have this feature? or is there a pg security tool I can run myself on a schedule?

Documentation: https://postgrest.org/

> I was tired of writing backend APIs with the only purpose that they get consumed by the same app's frontend (typically React).

PostgREST is great for this: https://postgrest.org

I run 6 React apps in prod, which used to consume APIs built with Flask, Django and FastAPI. Now they all consume APIs from PostgREST, I no longer write APIs. I define SQL views for the tables I want to expose, and optionally a bunch of SQL grants and SQL policies if I have different roles in the app, and PostgREST automatically transforms the views into endpoints, adds all the CRUD + UPSERT capabilities, handle the permissions, filtering, ordering, returning, pagination, and so on.

I think I know what you're talking about because I ran into this too. In defense of Supabase, you can still use transactions in other ways. Transactions through the client are messy and not easily supported by PostgREST.

The GitHub issue here sums up the conversation about this:

https://github.com/PostgREST/postgrest/issues/286

So... your comment is a bit disingenuous. Regardless of Hacker News's thoughts on MCP servers, there is a cohort of users that are finding them to be immensely useful. Myself included.

This is especially helpful because Supabase uses PostegREST under the hood, which does not support OpenAPI 3.x. Note that some Postgres specific features like enums are not converted to JSON Schema enums as Sequelize doesn't expose that information.

PostgREST stands out as the leading solution for PostgreSQL databases. It turns your database directly into a RESTful API with minimal configuration. The tool automatically creates endpoints for tables and views, supports complex filters, and leverages PostgreSQL's row-level security for fine-grained access control. If you'd like to see this in action, check out our Neon PostgresQL sample.

PostgREST