[go: up one dir, main page]

Simon Willison’s Weblog

Subscribe

July 2022

73 posts: 4 entries, 25 links, 2 quotes, 42 beats

July 1, 2022

Release datasette-edit-schema 0.5 — Datasette plugin for modifying table schemas

July 3, 2022

Release datasette-graphql 2.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-packages 0.2 — Show a list of currently installed Python packages
Release datasette-upload-csvs 0.7.2 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-expose-env 0.1 — Datasette plugin to expose selected environment variables at /-/env for debugging
Release datasette-unsafe-expose-env 0.1.1 — Datasette plugin to expose some environment variables at /-/env for debugging

July 4, 2022

Release datasette-redirect-to-https 0.2 — Datasette plugin that redirects all non-https requests to https

July 6, 2022

Defensive CSS (via) Fantastic new site by Ahmad Shadeed describing in detail CSS patterns which can help build layouts that adapt well to unexpected content—things like overly long titles or strange aspect ratio images, common when you are designing against UGC.

# 5:16 pm / css, frontend, ahmad-shadeed

Bun. “Bun is a fast all-in-one JavaScript runtime”—this is very interesting. It’s the first project I’ve seen written using the Zig language, which I see as somewhat equivalent to Rust. Bun provides a full Node.js-style JavaScript environment plus a host of packaged tools—an npm install client, a TypeScript transpiler, bundling tools—all wrapped up in a single binary. The JavaScript engine itself extends JavaScriptCore. Bun also ships with its own wrapper for SQLite.

# 5:24 pm / javascript, sqlite, npm, typescript, zig, bun

Helpful 404s for Jekyll (and GitHub Pages). Neat trick from Ben Balter: JavaScript that runs on your 404 page, fetches the sitemap.xml, parses all of the URLs out of it and then uses a levenshtein edit-distance comparison to find the closest URL to the one that you landed on and suggests that as a “Perhaps you’re looking for?”.

# 5:31 pm / javascript

How to Temporarily Disable Face ID or Touch ID, and Require a Passcode to Unlock Your iPhone or iPad. Hold down the power and volume up buttons for a couple of seconds, and your iPhone will no longer allow you to use FaceID to unlock it without first entering your passcode.

# 5:38 pm / iphone, security

July 7, 2022

SOC2 is about the security of the company, not the company’s products. A SOC2 audit would tell you something about whether the customer support team could pop a shell on production machines; it wouldn’t tell you anything about whether an attacker could pop a shell with a SQL Injection vulnerability.

Thomas Ptacek

# 8:31 pm / security, sql-injection, thomas-ptacek, fly

TIL Passing command arguments using heredoc syntax — This trick works for both Bash and zsh.

July 8, 2022

TIL Reporting bugs in GitHub to GitHub — I found out today (via [this post](https://github.com/github-community/community/discussions/19988)) about a dedicated interface for reporting bugs in GitHub to GitHub:
Release sqlite-comprehend 0.1a0 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-comprehend 0.1 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-diffable 0.3 — Tools for dumping/loading a SQLite database to diffable directory structure

July 9, 2022

Using GPT-3 to explain how code works

Visit Using GPT-3 to explain how code works

One of my favourite uses for the GPT-3 AI language model is generating explanations of how code works. It’s shockingly effective at this: its training set clearly include a vast amount of source code.

[... 1,983 words]

July 10, 2022

GPT-3 prompt for spotting nonsense questions (via) In response to complaints that GPT-3 will happily provide realistic sounding answers to nonsense questions, rictic recommends the following prompt:

I'll ask a series of questions. If the questions are nonsense, answer "yo be real", if they're a question about something that actually happened, answer them.

# 4:33 am / gpt-3, openai, prompt-engineering, generative-ai, llms

July 11, 2022

Release sqlite-diffable 0.4 — Tools for dumping/loading a SQLite database to diffable directory structure
Release sqlite-comprehend 0.2 — Tools for running data in a SQLite database through AWS Comprehend
Release sqlite-comprehend 0.2.1 — Tools for running data in a SQLite database through AWS Comprehend
TIL Conditionally running a second job in a GitHub Actions workflow — My [simonwillisonblog-backup workflow](https://github.com/simonw/simonwillisonblog-backup/blob/main/.github/workflows/backup.yml) periodically creates a JSON backup of my blog's PostgreSQL database, using [db-to-sqlite](https://datasette.io/tools/db-to-sqlite) and [sqlite-diffable](https://datasette.io/tools/sqlite-diffable). It then commits any changes back to the repo using this pattern:

sqlite-comprehend: run AWS entity extraction against content in a SQLite database

I built a new tool this week: sqlite-comprehend, which passes text from a SQLite database through the AWS Comprehend entity extraction service and stores the returned entities.

[... 1,146 words]

July 12, 2022

Release datasette-ics 0.5.2 — Datasette plugin for outputting iCalendar files
Release sqlite-comprehend 0.2.2 — Tools for running data in a SQLite database through AWS Comprehend
Release datasette-app-support 0.11.6 — Part of https://github.com/simonw/datasette-app

July 13, 2022

Release datasette-app 0.2.2 — The Datasette macOS application
TIL Upgrading packages with npm — There's a new version of [Vite](https://vitejs.dev/) out (3.0) and I wanted to upgrade my [datasette-table](https://github.com/simonw/datasette-table) package to use it.
Release datasette-publish-vercel 0.14 — Datasette plugin for publishing data using Vercel

2022 » July

MTWTFSS
    123
45678910
11121314151617
18192021222324
25262728293031