News for hackers. Stuff that matters.
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.