News for hackers. Stuff that matters.
Re:Many small queries are efficient in SQLite by topspin on Tuesday February 16, 2021 @12:28PM (#26156344)
> But I'm not aware of anyone doing this.

I have, for a bespoke internal application. PostgreSQL is actually capable of expressing GraphQL queries as (rather elaborate) SQL queries. You end up generating queries that use a lot of LATERAL sub-selects. The risk is generating queries with poor performance, and that risk is high enough that I don't think this is a viable approach for complex applications.

Which is a shame.

There are no comments on this comment yet.