Tinkering

ChatGPT Work with Apps tool

ChatGPT

vscode

ChatGPT work with Apps tool

Hosting a static website on Cloudflare

Web sites

cloudflare

hosting

web development

Cloudflare allows you to publish static websites for free. It only limits the number of “builds” per month, but even that is very generous and not a limit I am likely to…

BigQuery CSV import sucks

bigquery

csv

TIL that in bigquery, when you are importing a CSV file and all your columns are strings, it will automatically assign column headings rather than using your first row. So…

How to normalize multilingual categorical data with ChatGPT

data processing

prompting

I had a dynamically updated BigQuery table containing a column with categorical data, but the column was in multiple languages and formats. This is how I solved that problem…

Hugo is fast!

One of the things I don’t like about Quarto is that it is slow to build web pages. Even a relatively small site involves a short wait whilst it builds. Another thing is that…

Quarto notation in Bear

bear

quarto

This is a test to see what Quarto notation I can use in Bear that will be transferred to Quarto.

Workaround to export raindrop bookmark highlights to Markdown

bookmarks

study

There is currently no good way to export highlights from Raindrop bookmark manager. This is a workaround:

Use Jina to get the Markdown for a web page

markdown

The following method can be used to extract MD from a web page:

Comments in Bear app

bear

All of the methods below work. The HTML comment results in the comment being in exported HTML, the others result in nothing exported at all. Source: Comments in Markdown

Footnotes in Bear app

bear

Footnotes in Bear app use the standard method. This is the same as Quarto uses, and so no changes are needed on export to Quarto:

Comparing ChatGPT, Perplexity, Claude and Gemini

chatgpt

claude

perplexity

In this experiment I compare the generative AI platforms below. I have awarded them stars based on their overall responses to similar or identical prompts.

Understanding Perlin noise

In this little experiment I investigate Perlin noise, and end by making a fantasy map

Using OSX Shortcuts to copy Perplexity.ai responses to markdown apps (Bear, Quarto)

artificial intelligence

productivity

“I … am rarely happier than when spending an entire day programming my computer to perform automatically a task that would otherwise take me a good ten seconds to do by hand.”

Markdown features that can be exported from Quarto to Confluence

confluence

productivity

quarto

Previously I did a test to export content from Quarto to Confluence. It worked, and very well! You can read about that here: Markdown features that can be exported from…

Diagrams from Python, exported to Confluence

confluence

productivity

quarto

Final test in this series, can I include a diagram drawn with Python?

Features in Confluence’s own storage format that can be exported into Confluence

confluence

productivity

quarto

My previous test was to see which basic Quarto features I can export to Confluence. It went pretty well. You can read about that here: Markdown features that can be exported…

Using Quarto to create Confluence pages

confluence

productivity

quarto

Quarto is a great publishing system for charts and graphs. It allows you to generate data visualizations with Python and Plotly, Observable or whatever. Confluence is a…

Processing a podcast transcript with the ChatGPT API

artificial intelligence

chatgpt

python

I was going to use Python and the ChatGPT API to cut up a podcast transcript and process it. But I discovered I could just cut and paste the whole transcript (over 9k words)…

Using Google Sheets as a database for simple web applications

data

web development

Often when creating simple web apps you want a small and simple database for the data. It is also often a requirement to give someone else access to the database, and to…

Uncle Lubin - experiments with colour palettes

creativity

drawings

I’m a big fan of the ligne claire¹ illustration style, which is basically clear strong lines filled with flat colour. I am also a fan of the eccentric drawings of Heath…

Connecting to ChatGPT via the API in Python

artificial intelligence

chatgpt

python

I connected to ChatGPT using the API in Python. I ran a couple of tests, which cost $0.01 to process.
Next step - take data from a database, process it, return results to…

A curious case of JSON data being out-of-sync

drupal

json

Update: this didn’t solve the problem. It was a bug in Drupal itself.

Image tests: format and size

info design

When I did these experiments I didn’t include the webp format, which may be a better one than any of these. More experiments needed.

More experiments with Stable Diffusion

artificial intelligence

Stable Diffusion V2 was released this week (Dec ’22), so I decided to do some experimentation with it. To do this I used the ImaginAIry Python code by Bryce Drennan. I also…

Experiments with Stable Diffusion

artificial intelligence

I created these images using the Stability Photoshop Plugin by the wonderful Christian Cantrell, with images generated utilizing the Dreamstudio service. It’s a paid-for…