News for hackers. Stuff that matters.
Re:Pg_ClickHouse: A Postgres extension for querying ClickHouse by oulipo2 on Friday December 12, 2025 @05:12PM (#46249635)
What are the typical uses of PostgREST? is it just when you want to make your database accessible to various languages over HTTP because you don't want to use an ORM and connect to your db? But besides that, for an entreprise solution, why would you use PostgREST to develop your backend rather than, say, use an ORM in your language and make direct queries? (honest question)
Re:Pg_ClickHouse: A Postgres extension for querying ClickHouse by lillecarl on Friday December 12, 2025 @05:23PM (#46249743)
You skip the backend entirely and query from the frontend. PostgREST and Postgres is your backend. If you want extra sauce on top you route those paths to an application that does whatever extra imperative operations you need.
Re:Pg_ClickHouse: A Postgres extension for querying ClickHouse by jascha_eng on Friday December 12, 2025 @06:06PM (#46250142)
This always sounds super messy to me but I guess supabase is kind of the same thing and especially for side projects it seems like a very efficient setup.
Re:Pg_ClickHouse: A Postgres extension for querying ClickHouse by oulipo2 on Friday December 12, 2025 @06:32PM (#46250350)
So a kind of "mini-Firebase" ? and then you have security through row-based security?

But this also means your users can generate their own queries, possibly doing some weird stuff taking down the db, so I assume it's more for "internal tools"?

Re:Pg_ClickHouse: A Postgres extension for querying ClickHouse by charrondev on Friday December 12, 2025 @11:53PM (#46252092)
Yeah definitely not for public facing things of any capacity.

No matter your size unless you have a trivial amount of data, if you expose a full SQL query language you can be hit be a DOS attack pretty trivially.

This ignores that row level security is also not enough on its own to implement an even moderately capable level of access controls.