soft-shell crabvietnam crab exporter

Simon Willison’s Weblog

Newsletter

“graphql” in posts

Sorted by relevance · date

GraphQL in Datasette with the new datasette-graphql plugin

Visit GraphQL in Datasette with the new datasette-graphql plugin

This week I’ve mostly been building datasette-graphql, a plugin that adds GraphQL query support to Datasette.

[... 1,249 words]

graphql-voyager. Neat tool for producing an interactive graph visualization of any GraphQL API. Click “Change schema” and then “Introspection” and it will give you a GraphQL query you can run against your own API—copy and paste back the JSON results and the visualizer will show you how your API fits together. I tested this against a datasette-graphql instance and it worked exactly as described.

# 27th January 2023, 11:58 pm / graphql

How Super Graph compiles GraphQL to a single SQL query. Super Graph is a GraphQL server that compiles arbitrarily nested GraphQL queries to “a single fast SQL query”. I’ve always wondered how that could possible work, so I asked author Vikram Rangnekar for an example of a compiled query—it turns out it uses a brilliant sequence of JSON aggregations to glue together results from nested subqueries and left outer joins.

# 16th April 2020, 10:52 pm / sql, graphql

Why, after 6 years, I’m over GraphQL (via) I've seen many of these criticisms of GraphQL before - N+1 queries, the difficulty of protecting against deeply nested queries - but Matt Bessey collects them all in one place and adds an issue I hadn't considered before: the complexity of authorization, where each field in the query might involve extra permission checks:

In my experience, this is actually the biggest source of performance issues. We would regularly find that our queries were spending more time authorising data than anything else.

The 600+ comment Hacker News thread is crammed with GraphQL war stories, mostly supporting the conclusions of the article.

# 30th May 2024, 10:36 am / graphql

datasette-graphql 1.2 (via) A new release of the datasette-graphql plugin, fixing a minor security flaw: previous versions of the plugin could expose the schema (but not the actual data) of tables in databases that were otherwise protected by Datasette’s permission system.

# 21st November 2020, 10:21 pm / projects, security, graphql, datasette

Weeknotes: Installing Datasette with Homebrew, more GraphQL, WAL in SQLite

Visit Weeknotes: Installing Datasette with Homebrew, more GraphQL, WAL in SQLite

This week I’ve been working on making Datasette easier to install, plus wide-ranging improvements to the Datasette GraphQL plugin.

[... 1,009 words]

Weeknotes: sqlite-transform 1.1, Datasette 0.58.1, datasette-graphql 1.5

Work on Project Pelican inspires new features and improvements across a number of different projects.

[... 1,419 words]

Weeknotes: datasette-indieauth, datasette-graphql, PyCon Argentina

Visit Weeknotes: datasette-indieauth, datasette-graphql, PyCon Argentina

Last week’s weeknotes took the form of my Personal Data Warehouses: Reclaiming Your Data talk write-up, which represented most of what I got done that week. This week I mainly worked on datasette-indieauth, but I also gave a keynote at PyCon Argentina and released a version of datasette-graphql with a small security fix.

[... 724 words]

SQL is a better API language than GraphQL – Convince me otherwise (via) A flippant tweet I posted this morning blew up today and ended up on the Hacker News homepage.

# 16th April 2020, 10:44 pm / hacker-news, sql, webapis, graphql

None
TIL get-graphql-schema — The GraphQL schema language is a concise way to represent the available schema provided by a GraphQL endpoint. It looks something like this:
Tool GitHub GraphQL Explorer — Explore GitHub's GraphQL API using an interactive query interface that requires authentication via a personal access token. Enter your GitHub token to connect and start writing, executing, and testing GraphQL queries against GitHub's data in real-time. The explorer provides syntax highlighting, query validation, and response inspection capabilities within an embedded GraphiQL environment.
Release datasette-graphql 1.3.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
None
TIL Using the undocumented Fly GraphQL API — [Fly](https://fly.io/) has a GraphQL API which is used by some of their own tools - I found it while [browsing around their code](https://github.com/superfly/flyctl/blob/603b0adccf5416188eabaa7dc73f9c0ec88fa6ca/api/resource_volumes.go#L5-L40) on GitHub.
Release datasette-graphql 3.0a0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.11 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.5 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 2.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 2.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.10 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.13 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.2.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.4 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
None
TIL Searching for repositories by topic using the GitHub GraphQL API — I wanted to use the GitHub GraphQL API to return all of the repositories on the https://github.com/topics/git-scraping page.
Release datasette-graphql 0.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.6 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.7 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.14 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.1a — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases