api

GraphQL fragments

One of the scripts that builds and deploys datasette.io uses a GraphQL query to retrieve information from GitHub about the repositories used for the various Datasette tools and plugins.

How to get credentials for a new Twitter bot

I wanted to build a Twitter bot that would tweet Covid sewage graphs from this page every day. To do that, I needed the following four credentials for a new @covidsewage Twitter account.

Combined release notes from GitHub with jq and paginate-json

Matt Holt asked: Is there a tool that uses the GitHub API to generate a doc with all release notes from a repo?

Generating OpenAPI specifications using GPT-3

I wanted to start playing around with OpenAPI. I decided to see if I could get GPT-3 to generate the first version of a specification for me.

How streaming LLM APIs work

I decided to have a poke around and see if I could figure out how the HTTP streaming APIs from the various hosted LLM providers actually worked. Here are my notes so far.

Bulk fetching repository details with the GitHub GraphQL API

I wanted to be able to fetch details of a list of different repositories from the GitHub GraphQL API by name in a single operation.

Exploring OpenAI's deep research API model o4-mini-deep-research

I was reviewing some older PRs and landed this one by Manuel Solorzano adding pricing for o4-mini-deep-research and o3-deep-research to my llm-prices.com site.

Google OAuth for a CLI application

:warning: The OOB flow described in this document has been scheduled for deprecation by Google. See issue 39 for notes on how to replace it.

get-graphql-schema

The GraphQL schema language is a concise way to represent the available schema provided by a GraphQL endpoint.

How to read Hacker News threads with most recent comments first

Hacker News displays comments in a tree. This can be frustrating if you want to keep track of a particular conversation, as you constantly have to seek through the tree to find the latest comment.

Attaching a generated file to a GitHub release using Actions

For Datasette Desktop I wanted to run an action which, when I created a release, would build an asset for that release and then upload and attach it.

A simple Python wrapper for the ChatGPT API

OpenAI released an API for ChatGPT yesterday. It's 1/10th of the price of the model! Their official openai Python package has been upgraded to add support for it (in this commit).

Calculating the AQI based on the Purple Air API for a sensor

Purple Air sensors have an API at , which returns JSON that looks something like this: There's just one problem with this: it doesn't give you the AQI number that is displayed on their site!

Export a Mastodon timeline to SQLite

I've been playing around with the Mastodon timelines API. It's pretty fun! I'm running my own instance which means I don't feel limited by politeness in terms of rate limits - if I'm just using my own…

Finding uses of an API with the new GitHub Code Search

The GitHub Code Search beta is really powerful - it allows advanced search - including regular expression matches - against every public repo on GitHub.

Accessing repository dependencies in the GitHub GraphQL API

Access to a Repositories Dependency Graph describes a preview API for accessing GitHub repository dependencies.

Helper function for pagination using AWS boto3

I noticed that a lot of my boto3 code in s3-credentials looked like this: This was enough verbosity that I was hesitating on implementing pagination properly for some method calls.

Creating GitHub repository labels with an Actions workflow

Newly created GitHub repositories come with a default set of labels. I have several labels I like to add on top of these.

A simple Python implementation of the ReAct pattern for LLMs

A popular nightmare scenario for AI is giving it access to tools, so it can make API calls and execute its own code and generally break free of the constraints of its initial environment.