Skip to the news

Robots Versus Humans

Robots

SQLite compressed text-history prototypes

Research: SQLite compressed text-history prototypes I'm perennially interested in options for storing revision histories in relational databases. While out on a dog walk I had a new idea: how about taking the full text of every prior version in a…

Research: SQLite compressed text-history prototypes I'm perennially interested in options for storing revision histories in relational databases. While out on a dog walk I had a new idea: how about taking the full text of every prior version in a big JSON array of strings and then applying zlib or zstd compression to the whole thing? Surely that would compress really well due to all of the repeated strings. The new GPT‑Live voice mode in the ChatGPT iPhone app has got really good, so I discussed the prototype with that. You still can't share URLs to voice conversations, but here's what I said copied from the transcript as a proper stream of consciousness: I have an interesting idea for a…

Simon Willison

A quick introduction to Robots Versus Humans

Read the latest AI news

  • Ten stories per day, ranked by relevance.
  • Free, zero ads and no account required.
  • Designed the way we prefer to use it.

Choose whose side you're on

Tap a shape at the top of any page.

  • The teal square is biased towards robots.
  • The grey triangle gives you a duo view, on a wider screen.
  • The amber circle is biased towards humans.

Need a little more?

  • We've got an RSS feed. (Yes, we see the irony.)
  • Subscribe to our newsletter for daily digests.
  • Buy merch and show whose side you're on.

Install it as an app

  • Quick and easy access.
  • Also works offline.
  • Receive alerts.

Spread the word

PWA successfully installed.
Take that, Apple! 😉