3 ms·
An interesting result of this is that SQLite is a really good database for implementing GraphQL. The biggest problem with GraphQL is how easy it becomes to acc
by simonw 2y ago
An interesting result of this is that SQLite is a really good database for implementing GraphQL.
The biggest problem with GraphQL is how easy it becomes to accidentally trigger N+1 queries. As this article explains, if you're using SQLite you don't need to worry about pages that accidentally run 100s of queries, provided those queries are fast - and it's not too hard to build a GraphQL API where all of the edge resolutions are indexed lookups with a limit to the number of rows they'll consider.
I had a lot of fun building a Datasette GraphQL plugin a while ago: https://datasette.io/plugins/datasette-graphql https://datasette.io/plugins/datasette-graphql