json_agg example

See https://til.simonwillison.net/sqlite/related-rows-single-query

Owned by simonw, visibility: Public

SQL query
select
  blog_entry.id,
  title,
  slug,
  created,
  coalesce(json_agg(json_build_object(blog_tag.id, blog_tag.tag)) filter (
    where
      blog_tag.tag is not null
  ), json_build_array()) as tags
from
  blog_entry
  left join blog_entry_tags on blog_entry.id = blog_entry_tags.entry_id
  left join blog_tag on blog_entry_tags.tag_id = blog_tag.id
group by
  blog_entry.id
order by
  blog_entry.id desc

Results were truncated

id title slug created tags
8852 Putting Gemini 2.5 Pro through its paces gemini 2025-03-25 20:45:58+00:00
[
  {
    "5601": "vision-llms"
  },
  {
    "1654": "google"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5937": "llm-release"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5475": "gemini"
  }
]
8851 New audio models from OpenAI, but how much can we rely on them? new-openai-audio-models 2025-03-20 20:39:34+00:00
[
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "4105": "text-to-speech"
  },
  {
    "263": "audio"
  },
  {
    "5937": "llm-release"
  },
  {
    "5405": "whisper"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5423": "llms"
  },
  {
    "5870": "multi-modal-output"
  }
]
8850 Calling a wrap on my weeknotes calling-a-wrap-on-my-weeknotes 2025-03-20 04:12:32+00:00
[
  {
    "5215": "weeknotes"
  },
  {
    "431": "blogging"
  },
  {
    "5836": "streaks"
  }
]
8849 Not all AI-assisted programming is vibe coding (but vibe coding rocks) vibe-coding 2025-03-19 17:57:18+00:00
[
  {
    "4845": "ai"
  },
  {
    "5938": "vibe-coding"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3626": "sandboxing"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  }
]
8848 Adding AI-generated descriptions to my tools collection tools-colophon 2025-03-13 23:48:54+00:00
[
  {
    "5444": "llm"
  },
  {
    "5446": "claude"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5490": "slop"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "4214": "tools"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  }
]
8847 Notes on Google's Gemma 3 gemma-3 2025-03-12 16:15:19+00:00
[
  {
    "5601": "vision-llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5937": "llm-release"
  },
  {
    "5933": "gemma"
  },
  {
    "1654": "google"
  },
  {
    "5475": "gemini"
  },
  {
    "5423": "llms"
  },
  {
    "5741": "ollama"
  },
  {
    "4845": "ai"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5672": "mlx"
  }
]
8846 Here's how I use LLMs to help me write code using-llms-for-code 2025-03-11 14:09:03+00:00
[
  {
    "5475": "gemini"
  },
  {
    "5938": "vibe-coding"
  },
  {
    "5220": "github-actions"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5446": "claude"
  },
  {
    "4214": "tools"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5445": "anthropic"
  }
]
8845 What's new in the world of LLMs, for NICAR 2025 nicar-llms 2025-03-08 23:19:51+00:00
[
  {
    "5449": "annotated-talks"
  },
  {
    "4845": "ai"
  },
  {
    "3886": "speaking"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "925": "data-journalism"
  },
  {
    "5475": "gemini"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5476": "nicar"
  }
]
8844 I built an automaton called Squadron squadron 2025-03-04 01:38:03+00:00
[
  {
    "3289": "projects"
  },
  {
    "219": "art"
  }
]
8843 Notes from my Accessibility and Gen AI podcast appearance accessibility-and-gen-ai 2025-03-02 14:51:43+00:00
[
  {
    "123": "alt-attribute"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "29": "accessibility"
  },
  {
    "3215": "podcasts"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5399": "generative-ai"
  }
]
8842 Hallucinations in code are the least dangerous form of LLM mistakes hallucinations-in-code 2025-03-02 06:25:33+00:00
[
  {
    "5385": "openai"
  },
  {
    "5704": "ai-agents"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5477": "boring-technology"
  },
  {
    "5446": "claude"
  },
  {
    "5423": "llms"
  },
  {
    "5445": "anthropic"
  },
  {
    "5429": "ai-assisted-programming"
  }
]
8811 Structured data extraction from unstructured content using LLM schemas llm-schemas 2025-02-28 17:07:07+00:00
[
  {
    "3289": "projects"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5444": "llm"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5475": "gemini"
  },
  {
    "5321": "annotated-release-notes"
  },
  {
    "925": "data-journalism"
  },
  {
    "5799": "structured-extraction"
  }
]
8810 Initial impressions of GPT-4.5 introducing-gpt-45 2025-02-27 22:02:59+00:00
[
  {
    "5637": "evals"
  },
  {
    "5937": "llm-release"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5394": "andrej-karpathy"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5866": "paul-gauthier"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5385": "openai"
  },
  {
    "5640": "uv"
  }
]
8809 Claude 3.7 Sonnet, extended thinking and long output, llm-anthropic 0.14 llm-anthropic-014 2025-02-25 17:50:25+00:00
[
  {
    "4845": "ai"
  },
  {
    "5446": "claude"
  },
  {
    "5444": "llm"
  },
  {
    "5445": "anthropic"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5937": "llm-release"
  },
  {
    "3289": "projects"
  },
  {
    "5321": "annotated-release-notes"
  }
]
8780 LLM 0.22, the annotated release notes llm 2025-02-17 06:19:00+00:00
[
  {
    "5385": "openai"
  },
  {
    "5475": "gemini"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5445": "anthropic"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5321": "annotated-release-notes"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  }
]
8779 Run LLMs on macOS using llm-mlx and Apple's MLX framework llm-mlx 2025-02-15 19:13:29+00:00
[
  {
    "5220": "github-actions"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5672": "mlx"
  },
  {
    "5940": "prince-canuma"
  },
  {
    "3207": "plugins"
  },
  {
    "3289": "projects"
  },
  {
    "194": "apple"
  },
  {
    "5444": "llm"
  }
]
8778 URL-addressable Pyodide Python environments url-addressable-python 2025-02-13 05:13:27+00:00
[
  {
    "5204": "webassembly"
  },
  {
    "5380": "pyodide"
  },
  {
    "5384": "datasette-lite"
  },
  {
    "3350": "python"
  },
  {
    "4344": "urls"
  },
  {
    "5110": "datasette"
  }
]
8777 Using pip to install a Large Language Model that's under 100MB pip-install-llm-smollm2 2025-02-07 06:34:59+00:00
[
  {
    "3289": "projects"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5444": "llm"
  },
  {
    "5220": "github-actions"
  },
  {
    "4845": "ai"
  },
  {
    "3342": "pypi"
  },
  {
    "3181": "pip"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5640": "uv"
  },
  {
    "3207": "plugins"
  },
  {
    "3350": "python"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5834": "o3"
  },
  {
    "5475": "gemini"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5798": "smollm"
  }
]
8776 OpenAI o3-mini, now available in LLM o3-mini 2025-01-31 21:50:36+00:00
[
  {
    "5385": "openai"
  },
  {
    "5937": "llm-release"
  },
  {
    "5834": "o3"
  },
  {
    "4845": "ai"
  },
  {
    "5739": "llm-pricing"
  },
  {
    "4240": "translation"
  },
  {
    "5444": "llm"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  }
]
8744 A selfish personal argument for releasing code as Open Source selfish-open-source 2025-01-24 21:46:03+00:00
[
  {
    "3350": "python"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "2962": "open-source"
  },
  {
    "3215": "podcasts"
  },
  {
    "5930": "podcast-appearances"
  }
]
8743 Anthropic's new Citations API anthropics-new-citations-api 2025-01-24 04:22:57+00:00
[
  {
    "5395": "prompt-engineering"
  },
  {
    "4214": "tools"
  },
  {
    "5444": "llm"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "4845": "ai"
  },
  {
    "5486": "rag"
  },
  {
    "5423": "llms"
  }
]
8711 Six short video demos of LLM and Datasette projects office-hours-demos 2025-01-22 02:09:54+00:00
[
  {
    "5489": "enrichments"
  },
  {
    "5871": "datasette-public-office-hours"
  },
  {
    "5444": "llm"
  },
  {
    "5110": "datasette"
  },
  {
    "1002": "demos"
  },
  {
    "767": "community"
  },
  {
    "4673": "youtube"
  },
  {
    "925": "data-journalism"
  },
  {
    "1014": "derek-willis"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5390": "alex-garcia"
  },
  {
    "5423": "llms"
  }
]
8710 DeepSeek-R1 and exploring DeepSeek-R1-Distill-Llama-8B deepseek-r1 2025-01-20 15:20:23+00:00
[
  {
    "5937": "llm-release"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5835": "deepseek"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5741": "ollama"
  },
  {
    "5444": "llm"
  }
]
8689 My AI/LLM predictions for the next 1, 3 and 6 years, for Oxide and Friends ai-predictions 2025-01-10 01:43:16+00:00
[
  {
    "5423": "llms"
  },
  {
    "5932": "deep-research"
  },
  {
    "5704": "ai-agents"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "925": "data-journalism"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5475": "gemini"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5638": "oxide"
  },
  {
    "4845": "ai"
  }
]
8688 Weeknotes: Starting 2025 a little slow weeknotes 2025-01-04 23:56:59+00:00
[
  {
    "5835": "deepseek"
  },
  {
    "5423": "llms"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5646": "qwen"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5110": "datasette"
  },
  {
    "5385": "openai"
  }
]
8687 I still don't think companies serve you ads based on spying through your microphone they-spy-on-you-but-not-like-that 2025-01-02 23:43:31+00:00
[
  {
    "789": "conspiracy"
  },
  {
    "5274": "misinformation"
  },
  {
    "3276": "privacy"
  },
  {
    "194": "apple"
  }
]
8686 Ending a year long posting streak ending-a-year-long-posting-streak 2025-01-02 00:25:34+00:00
[
  {
    "5836": "streaks"
  },
  {
    "4205": "tom-scott"
  },
  {
    "431": "blogging"
  }
]
8685 Things we learned about LLMs in 2024 llms-in-2024 2024-12-31 18:07:31+00:00
[
  {
    "4845": "ai"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5385": "openai"
  },
  {
    "1654": "google"
  },
  {
    "5445": "anthropic"
  },
  {
    "5475": "gemini"
  },
  {
    "5616": "meta"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5865": "long-context"
  }
]
8684 Trying out QvQ - Qwen's new visual reasoning model qvq 2024-12-24 20:49:08+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5672": "mlx"
  },
  {
    "5940": "prince-canuma"
  },
  {
    "5640": "uv"
  },
  {
    "5439": "hugging-face"
  },
  {
    "5423": "llms"
  },
  {
    "5937": "llm-release"
  },
  {
    "3350": "python"
  },
  {
    "5646": "qwen"
  },
  {
    "4845": "ai"
  },
  {
    "5833": "inference-scaling"
  }
]
8683 My approach to running a link blog link-blog 2024-12-22 18:37:16+00:00
[
  {
    "1071": "django-admin"
  },
  {
    "1070": "django"
  },
  {
    "2159": "john-gruber"
  },
  {
    "431": "blogging"
  }
]
8682 Live blog: the 12th day of OpenAI - "Early evals for OpenAI o3" live-blog-the-12th-day-of-openai 2024-12-20 17:40:47+00:00
[
  {
    "5667": "o1"
  },
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5834": "o3"
  }
]
8681 December in LLMs has been a lot december-in-llms-has-been-a-lot 2024-12-20 06:30:03+00:00
[
  {
    "5475": "gemini"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5385": "openai"
  },
  {
    "5667": "o1"
  }
]
8680 Gemini 2.0 Flash "Thinking mode" gemini-thinking-mode 2024-12-19 23:59:54+00:00
[
  {
    "5444": "llm"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5667": "o1"
  },
  {
    "5475": "gemini"
  },
  {
    "5937": "llm-release"
  }
]
8679 Building Python tools with a one-shot prompt using uv run and Claude Projects one-shot-python-tools 2024-12-19 07:00:37+00:00
[
  {
    "5640": "uv"
  },
  {
    "5446": "claude"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "284": "aws"
  },
  {
    "3610": "s3"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "3350": "python"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  }
]
8678 Gemini 2.0 Flash: An outstanding multi-modal LLM with a sci-fi streaming mode gemini-2 2024-12-11 20:16:58+00:00
[
  {
    "5870": "multi-modal-output"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5937": "llm-release"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "5475": "gemini"
  }
]
8677 ChatGPT Canvas can make API requests now, but it's complicated chatgpt-canvas 2024-12-10 21:49:55+00:00
[
  {
    "3701": "security"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5642": "cors"
  },
  {
    "5204": "webassembly"
  },
  {
    "4350": "usability"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3350": "python"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5380": "pyodide"
  }
]
8647 I can now run a GPT-4 class model on my laptop llama-33-70b 2024-12-09 15:08:40+00:00
[
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "3350": "python"
  },
  {
    "5616": "meta"
  },
  {
    "5423": "llms"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5741": "ollama"
  },
  {
    "5444": "llm"
  },
  {
    "5640": "uv"
  },
  {
    "5418": "gpt-4"
  },
  {
    "5672": "mlx"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5416": "llama"
  }
]
8646 Prompts.js prompts-js 2024-12-07 20:35:26+00:00
[
  {
    "2103": "javascript"
  },
  {
    "3289": "projects"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3477": "releases"
  },
  {
    "5423": "llms"
  },
  {
    "4718": "npm"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "5475": "gemini"
  },
  {
    "5444": "llm"
  },
  {
    "5667": "o1"
  },
  {
    "5385": "openai"
  }
]
8645 First impressions of the new Amazon Nova LLMs (via a new llm-bedrock plugin) amazon-nova 2024-12-04 15:50:50+00:00
[
  {
    "125": "amazon"
  },
  {
    "5739": "llm-pricing"
  },
  {
    "5423": "llms"
  },
  {
    "5937": "llm-release"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5870": "multi-modal-output"
  },
  {
    "5475": "gemini"
  },
  {
    "5444": "llm"
  },
  {
    "5445": "anthropic"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "3477": "releases"
  }
]
8644 Storing times for human events storing-times-for-human-events 2024-11-27 20:45:25+00:00
[
  {
    "4166": "time"
  },
  {
    "4174": "timezones"
  },
  {
    "1327": "events"
  },
  {
    "926": "databases"
  }
]
8613 Ask questions of SQLite databases and CSV/JSON files in your terminal ask-questions-of-sqlite 2024-11-25 01:33:03+00:00
[
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "3207": "plugins"
  },
  {
    "3910": "sqlite"
  },
  {
    "5444": "llm"
  },
  {
    "5273": "sqlite-utils"
  }
]
8612 Weeknotes: asynchronous LLMs, synchronous embeddings, and I kind of started a podcast weeknotes 2024-11-22 22:35:24+00:00
[
  {
    "5438": "embeddings"
  },
  {
    "5215": "weeknotes"
  },
  {
    "3215": "podcasts"
  },
  {
    "5444": "llm"
  },
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  }
]
8611 Notes from Bing Chat—Our First Encounter With Manipulative AI notes-from-bing-chat 2024-11-19 22:41:57+00:00
[
  {
    "2639": "microsoft"
  },
  {
    "5423": "llms"
  },
  {
    "403": "bing"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "1302": "ethics"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5605": "benj-edwards"
  },
  {
    "5385": "openai"
  },
  {
    "5418": "gpt-4"
  },
  {
    "4845": "ai"
  },
  {
    "3215": "podcasts"
  },
  {
    "218": "arstechnica"
  },
  {
    "4057": "talks"
  },
  {
    "5930": "podcast-appearances"
  }
]
8588 Project: Civic Band - scraping and searching PDF meeting minutes from hundreds of municipalities civic-band 2024-11-16 22:14:01+00:00
[
  {
    "5110": "datasette"
  },
  {
    "5871": "datasette-public-office-hours"
  },
  {
    "3910": "sqlite"
  },
  {
    "925": "data-journalism"
  },
  {
    "3219": "politics"
  },
  {
    "3218": "political-hacking"
  }
]
8587 Qwen2.5-Coder-32B is an LLM that can code well that runs on my Mac qwen25-coder 2024-11-12 23:37:36+00:00
[
  {
    "5937": "llm-release"
  },
  {
    "5399": "generative-ai"
  },
  {
    "2962": "open-source"
  },
  {
    "5646": "qwen"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "4845": "ai"
  },
  {
    "5672": "mlx"
  },
  {
    "5640": "uv"
  },
  {
    "5444": "llm"
  },
  {
    "5741": "ollama"
  },
  {
    "5866": "paul-gauthier"
  },
  {
    "5802": "pelican-riding-a-bicycle"
  },
  {
    "5429": "ai-assisted-programming"
  }
]
8586 Visualizing local election results with Datasette, Observable and MapLibre GL visualizing-local-election-results 2024-11-09 23:32:06+00:00
[
  {
    "1611": "geospatial"
  },
  {
    "5390": "alex-garcia"
  },
  {
    "2495": "mapping"
  },
  {
    "3219": "politics"
  },
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "1629": "gis"
  },
  {
    "5871": "datasette-public-office-hours"
  },
  {
    "5222": "datasette-cloud"
  }
]
8585 Project: VERDAD - tracking misinformation in radio broadcasts using Gemini 1.5 project-verdad 2024-11-07 18:41:51+00:00
[
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "925": "data-journalism"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5475": "gemini"
  },
  {
    "4673": "youtube"
  }
]
8584 Claude 3.5 Haiku haiku 2024-11-04 19:34:41+00:00
[
  {
    "5475": "gemini"
  },
  {
    "5937": "llm-release"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5739": "llm-pricing"
  },
  {
    "5444": "llm"
  }
]
8583 W̶e̶e̶k̶n̶o̶t̶e̶s̶ Monthnotes for October monthnotes 2024-10-30 04:20:44+00:00
[
  {
    "5423": "llms"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5444": "llm"
  }
]
8582 You can now run prompts against images, audio and video in your terminal using LLM llm-multi-modal 2024-10-29 15:09:38+00:00
[
  {
    "5444": "llm"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5459": "mistral"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  },
  {
    "5475": "gemini"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5739": "llm-pricing"
  }
]
8581 Run a prompt to generate and execute jq programs using llm-jq llm-jq 2024-10-27 04:26:36+00:00
[
  {
    "3207": "plugins"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5423": "llms"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "4145": "thomas-ptacek"
  },
  {
    "4845": "ai"
  },
  {
    "5161": "jq"
  },
  {
    "5444": "llm"
  }
]
8580 Notes on the new Claude analysis JavaScript code execution tool claude-analysis-tool 2024-10-24 20:22:52+00:00
[
  {
    "5610": "llm-tool-use"
  },
  {
    "5446": "claude"
  },
  {
    "4514": "webworkers"
  },
  {
    "5602": "alex-albert"
  },
  {
    "5445": "anthropic"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "2103": "javascript"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5395": "prompt-engineering"
  }
]
8579 Initial explorations of Anthropic's new Computer Use capability computer-use 2024-10-22 17:38:06+00:00
[
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5704": "ai-agents"
  },
  {
    "5610": "llm-tool-use"
  },
  {
    "5633": "claude-3-5-sonnet"
  }
]
8578 Everything I built with Claude Artifacts this week claude-artifacts 2024-10-21 14:32:57+00:00
[
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  },
  {
    "5380": "pyodide"
  },
  {
    "4214": "tools"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "2103": "javascript"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  }
]
8548 Running Llama 3.2 Vision and Phi-3.5 Vision on a Mac with mistral.rs mistralrs 2024-10-19 16:14:20+00:00
[
  {
    "4948": "rust"
  },
  {
    "5423": "llms"
  },
  {
    "2639": "microsoft"
  },
  {
    "4845": "ai"
  },
  {
    "5416": "llama"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5459": "mistral"
  },
  {
    "5494": "phi"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3350": "python"
  },
  {
    "5616": "meta"
  }
]
8547 Experimenting with audio input and output for the OpenAI Chat Completion API openai-audio 2024-10-18 15:17:40+00:00
[
  {
    "5739": "llm-pricing"
  },
  {
    "5446": "claude"
  },
  {
    "263": "audio"
  },
  {
    "5385": "openai"
  },
  {
    "5418": "gpt-4"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  }
]
8546 Video scraping: extracting JSON data from a 35 second screen capture for less than 1/10th of a cent video-scraping 2024-10-17 12:32:47+00:00
[
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "1641": "gmail"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "5475": "gemini"
  },
  {
    "3667": "scraping"
  },
  {
    "5399": "generative-ai"
  },
  {
    "925": "data-journalism"
  },
  {
    "5446": "claude"
  },
  {
    "1654": "google"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5619": "claude-artifacts"
  }
]
8545 ChatGPT will happily write you a thinly disguised horoscope chatgpt-horoscopes 2024-10-15 03:24:51+00:00
[
  {
    "5395": "prompt-engineering"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1302": "ethics"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "5385": "openai"
  }
]
8524 OpenAI DevDay: Let’s build developer tools, not digital God not-digital-god 2024-10-02 22:33:13+00:00
[
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5843": "prompt-caching"
  },
  {
    "4507": "websockets"
  }
]
8523 OpenAI DevDay 2024 live blog openai-devday-2024-live-blog 2024-10-01 17:17:13+00:00
[
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "431": "blogging"
  }
]
8522 Weeknotes: Three podcasts, two trips and a new plugin system weeknotes 2024-09-30 17:43:22+00:00
[
  {
    "5389": "psf"
  },
  {
    "5215": "weeknotes"
  },
  {
    "3215": "podcasts"
  },
  {
    "5670": "djp"
  },
  {
    "1070": "django"
  },
  {
    "5423": "llms"
  }
]
8521 NotebookLM's automatically generated podcasts are surprisingly effective notebooklm-audio-overview 2024-09-29 23:59:09+00:00
[
  {
    "1654": "google"
  },
  {
    "5475": "gemini"
  },
  {
    "3215": "podcasts"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "4105": "text-to-speech"
  },
  {
    "5486": "rag"
  },
  {
    "5675": "notebooklm"
  },
  {
    "263": "audio"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  }
]
8520 Themes from DjangoCon US 2024 themes-from-djangocon-us-2024 2024-09-27 23:36:02+00:00
[
  {
    "5839": "htmx"
  },
  {
    "2064": "jacob-kaplan-moss"
  },
  {
    "5671": "dsf"
  },
  {
    "3454": "redis"
  },
  {
    "29": "accessibility"
  },
  {
    "3350": "python"
  },
  {
    "1070": "django"
  },
  {
    "1075": "djangocon"
  },
  {
    "784": "conferences"
  },
  {
    "5831": "pydantic"
  }
]
8519 DJP: A plugin system for Django djp-a-plugin-system-for-django 2024-09-25 14:00:42+00:00
[
  {
    "3289": "projects"
  },
  {
    "5670": "djp"
  },
  {
    "3207": "plugins"
  },
  {
    "1070": "django"
  }
]
8518 Notes on using LLMs for code using-llms-for-code 2024-09-20 03:10:57+00:00
[
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3215": "podcasts"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5385": "openai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5399": "generative-ai"
  }
]
8517 Things I've learned serving on the board of the Python Software Foundation board-of-the-python-software-foundation 2024-09-18 14:15:37+00:00
[
  {
    "5389": "psf"
  },
  {
    "3350": "python"
  }
]
8516 Draft entry draft-entry 2024-09-18 06:26:48+00:00
[
  {
    "4099": "testing"
  }
]
8515 Notes on OpenAI's new o1 chain-of-thought models openai-o1 2024-09-12 22:36:37+00:00
[
  {
    "5395": "prompt-engineering"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5385": "openai"
  },
  {
    "5667": "o1"
  },
  {
    "5833": "inference-scaling"
  },
  {
    "5937": "llm-release"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  }
]
8514 Notes from my appearance on the Software Misadventures Podcast software-misadventures 2024-09-10 22:48:42+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "4845": "ai"
  },
  {
    "431": "blogging"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "3215": "podcasts"
  }
]
8513 Teresa T is name of the whale in Pillar Point Harbor near Half Moon Bay teresa-t-whale-pillar-point 2024-09-08 01:04:00+00:00
[
  {
    "3153": "photography"
  },
  {
    "5473": "half-moon-bay"
  },
  {
    "4556": "wildlife"
  }
]
8512 Calling LLMs from client-side JavaScript, converting PDFs to HTML + weeknotes weeknotes 2024-09-06 02:28:38+00:00
[
  {
    "3094": "pdf"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5110": "datasette"
  },
  {
    "2103": "javascript"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5642": "cors"
  },
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  },
  {
    "5475": "gemini"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "865": "css"
  }
]
8482 Building a tool showing how Gemini Pro can return bounding boxes for objects in images gemini-bounding-box-visualization 2024-08-26 04:55:28+00:00
[
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5642": "cors"
  },
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  },
  {
    "5475": "gemini"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "5601": "vision-llms"
  }
]
8481 Claude's API now supports CORS requests, enabling client-side applications anthropic-dangerous-direct-browser-access 2024-08-23 02:29:08+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "187": "apis"
  },
  {
    "5642": "cors"
  },
  {
    "3289": "projects"
  },
  {
    "2103": "javascript"
  },
  {
    "3701": "security"
  },
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  }
]
8480 Optimizing Datasette (and other weeknotes) optimizing-datasette 2024-08-22 15:46:43+00:00
[
  {
    "5215": "weeknotes"
  },
  {
    "5110": "datasette"
  },
  {
    "3910": "sqlite"
  },
  {
    "3107": "performance"
  },
  {
    "3907": "sql"
  }
]
8479 django-http-debug, a new Django app mostly written by Claude django-http-debug 2024-08-08 15:26:27+00:00
[
  {
    "1071": "django-admin"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "4492": "webhooks"
  },
  {
    "4845": "ai"
  },
  {
    "1070": "django"
  },
  {
    "5423": "llms"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3350": "python"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5633": "claude-3-5-sonnet"
  }
]
8452 Weeknotes: a staging environment, a Datasette alpha and a bunch of new LLMs staging 2024-08-06 15:41:14+00:00
[
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5110": "datasette"
  },
  {
    "5215": "weeknotes"
  }
]
8451 Datasette 1.0a14: The annotated release notes datasette-1a14 2024-08-05 23:20:01+00:00
[
  {
    "3289": "projects"
  },
  {
    "5321": "annotated-release-notes"
  },
  {
    "5876": "sqlite-busy"
  },
  {
    "5444": "llm"
  },
  {
    "3477": "releases"
  },
  {
    "3910": "sqlite"
  },
  {
    "5110": "datasette"
  }
]
8450 Weeknotes: GPT-4o mini, LLM 0.15, sqlite-utils 3.37 and building a staging environment weeknotes 2024-07-19 00:11:14+00:00
[
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "3289": "projects"
  },
  {
    "5444": "llm"
  },
  {
    "5215": "weeknotes"
  }
]
8449 Big Opportunities in Small Data big-opportunities-in-small-data 2023-05-08 03:06:14+00:00
[
  {
    "3243": "postgresql"
  },
  {
    "5412": "small-data"
  },
  {
    "3910": "sqlite"
  },
  {
    "5110": "datasette"
  },
  {
    "4057": "talks"
  }
]
8448 Imitation Intelligence, my keynote for PyCon US 2024 pycon 2024-07-14 04:59:56+00:00
[
  {
    "5449": "annotated-talks"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3350": "python"
  },
  {
    "3328": "pycon"
  },
  {
    "4057": "talks"
  },
  {
    "4845": "ai"
  }
]
8447 The denormalized query engine design pattern denormalized-query-engine 2017-08-16 22:49:22+00:00
[
  {
    "1008": "denormalisation"
  },
  {
    "1070": "django"
  },
  {
    "204": "architecture"
  },
  {
    "1018": "design-patterns"
  },
  {
    "4057": "talks"
  },
  {
    "1239": "elasticsearch"
  },
  {
    "1075": "djangocon"
  }
]
8446 Give people something to link to so they can talk about your features and ideas give-people-something-to-link-to 2024-07-13 16:06:28+00:00
[
  {
    "5385": "openai"
  },
  {
    "3720": "seo"
  },
  {
    "1631": "github"
  },
  {
    "5477": "boring-technology"
  },
  {
    "5446": "claude"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5403": "chatgpt"
  },
  {
    "2512": "marketing"
  },
  {
    "4595": "writing"
  }
]
8414 Weeknotes: a livestream, a surprise keynote and progress on Datasette Cloud billing weeknotes 2024-07-02 04:46:44+00:00
[
  {
    "5222": "datasette-cloud"
  },
  {
    "5454": "stripe"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5110": "datasette"
  },
  {
    "431": "blogging"
  }
]
8413 Open challenges for AI engineering ai-worlds-fair 2024-06-27 16:35:18+00:00
[
  {
    "5396": "prompt-injection"
  },
  {
    "4735": "dropbox"
  },
  {
    "5501": "markdown-exfiltration"
  },
  {
    "4955": "slack"
  },
  {
    "5423": "llms"
  },
  {
    "3886": "speaking"
  },
  {
    "4845": "ai"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5490": "slop"
  }
]
8382 Building search-based RAG using Claude, Datasette and Val Town search-based-rag 2024-06-21 20:44:24+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5619": "claude-artifacts"
  },
  {
    "5633": "claude-3-5-sonnet"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5423": "llms"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5471": "val-town"
  },
  {
    "5736": "steve-krouse"
  },
  {
    "3289": "projects"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "4845": "ai"
  },
  {
    "5486": "rag"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5110": "datasette"
  }
]
8381 Weeknotes: Datasette Studio and a whole lot of blogging datasette-studio 2024-06-19 04:30:26+00:00
[
  {
    "3289": "projects"
  },
  {
    "1631": "github"
  },
  {
    "5215": "weeknotes"
  },
  {
    "431": "blogging"
  },
  {
    "5464": "github-codespaces"
  },
  {
    "5110": "datasette"
  }
]
8380 Language models on the command-line cli-language-models 2024-06-17 16:44:39+00:00
[
  {
    "5423": "llms"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5110": "datasette"
  },
  {
    "4057": "talks"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5572": "llamafile"
  },
  {
    "3289": "projects"
  },
  {
    "4845": "ai"
  },
  {
    "5741": "ollama"
  },
  {
    "5385": "openai"
  },
  {
    "5445": "anthropic"
  },
  {
    "5444": "llm"
  }
]
8379 A homepage redesign for my blog's 22nd birthday homepage-redesign 2024-06-12 19:59:17+00:00
[
  {
    "431": "blogging"
  }
]
8346 Thoughts on the WWDC 2024 keynote on Apple Intelligence apple-intelligence 2024-06-10 20:19:13+00:00
[
  {
    "5385": "openai"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "4252": "trust"
  },
  {
    "5403": "chatgpt"
  },
  {
    "194": "apple"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "3701": "security"
  },
  {
    "3276": "privacy"
  },
  {
    "5423": "llms"
  },
  {
    "5621": "apple-intelligence"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1302": "ethics"
  }
]
8345 Accidental prompt injection against RAG applications accidental-prompt-injection 2024-06-06 14:00:12+00:00
[
  {
    "5396": "prompt-injection"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5486": "rag"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5444": "llm"
  }
]
8344 Training is not the same as chatting: ChatGPT and other LLMs don't remember everything you say training-not-chatting 2024-05-29 10:51:56+00:00
[
  {
    "5611": "training-data"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5385": "openai"
  }
]
8343 Weeknotes: PyCon US 2024 weeknotes 2024-05-28 20:08:52+00:00
[
  {
    "3328": "pycon"
  },
  {
    "3289": "projects"
  },
  {
    "5444": "llm"
  },
  {
    "5215": "weeknotes"
  }
]
8342 ChatGPT in "4o" mode is not running the new features yet chatgpt-in-4o-mode 2024-05-15 18:25:07+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "4105": "text-to-speech"
  },
  {
    "5423": "llms"
  },
  {
    "4350": "usability"
  },
  {
    "4941": "userexperience"
  },
  {
    "5385": "openai"
  }
]
8341 Slop is the new name for unwanted AI-generated content slop 2024-05-08 18:24:33+00:00
[
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1302": "ethics"
  },
  {
    "5490": "slop"
  },
  {
    "5423": "llms"
  },
  {
    "5936": "ai-ethics"
  }
]
8340 Weeknotes: more datasette-secrets, plus a mystery video project datasette-secrets 2024-05-07 19:49:02+00:00
[
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5489": "enrichments"
  }
]
8339 Weeknotes: Llama 3, AI for Data Journalism, llm-evals and datasette-secrets weeknotes 2024-04-23 16:30:00+00:00
[
  {
    "925": "data-journalism"
  },
  {
    "3289": "projects"
  },
  {
    "5637": "evals"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5110": "datasette"
  },
  {
    "5444": "llm"
  }
]
8338 Options for accessing Llama 3 from the terminal using LLM llama-3 2024-04-22 13:38:09+00:00
[
  {
    "5444": "llm"
  },
  {
    "5609": "groq"
  },
  {
    "5937": "llm-release"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "3289": "projects"
  },
  {
    "5416": "llama"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5572": "llamafile"
  }
]
8337 AI for Data Journalism: demonstrating what we can do with this stuff right now ai-for-data-journalism 2024-04-17 21:04:07+00:00
[
  {
    "925": "data-journalism"
  },
  {
    "5444": "llm"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5601": "vision-llms"
  },
  {
    "2187": "journalism"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5110": "datasette"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "4057": "talks"
  },
  {
    "5799": "structured-extraction"
  },
  {
    "5489": "enrichments"
  },
  {
    "5480": "code-interpreter"
  }
]
8336 Three major LLM releases in 24 hours (plus weeknotes) weeknotes-llm-releases 2024-04-10 05:09:20+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "3289": "projects"
  },
  {
    "5937": "llm-release"
  },
  {
    "5475": "gemini"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5215": "weeknotes"
  }
]
8335 Building files-to-prompt entirely using Claude 3 Opus files-to-prompt 2024-04-08 20:40:08+00:00
[
  {
    "4845": "ai"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5444": "llm"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5423": "llms"
  },
  {
    "5395": "prompt-engineering"
  }
]
8334 Running OCR against PDFs and images directly in your browser ocr-pdfs-images 2024-03-30 17:59:56+00:00
[
  {
    "925": "data-journalism"
  },
  {
    "3094": "pdf"
  },
  {
    "4098": "tesseract"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "2905": "ocr"
  },
  {
    "3289": "projects"
  }
]
8333 llm cmd undo last git commit - a new plugin for LLM llm-cmd 2024-03-26 15:37:24+00:00
[
  {
    "5395": "prompt-engineering"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5444": "llm"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  }
]
8332 Building and testing C extensions for SQLite with ChatGPT Code Interpreter building-c-extensions-for-sqlite-with-chatgpt-code-interpreter 2024-03-23 17:50:30+00:00
[
  {
    "4845": "ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "538": "c"
  },
  {
    "3289": "projects"
  },
  {
    "3910": "sqlite"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5423": "llms"
  }
]
8331 Claude and ChatGPT for ad-hoc sidequests claude-and-chatgpt-case-study 2024-03-22 19:44:12+00:00
[
  {
    "4845": "ai"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "1629": "gis"
  },
  {
    "3746": "shapefiles"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5446": "claude"
  },
  {
    "4838": "geojson"
  },
  {
    "5445": "anthropic"
  }
]
8330 Weeknotes: the aftermath of NICAR weeknotes-the-aftermath-of-nicar 2024-03-16 18:36:12+00:00
[
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5476": "nicar"
  },
  {
    "5222": "datasette-cloud"
  }
]
8329 The GPT-4 barrier has finally been broken gpt-4-barrier 2024-03-08 18:02:39+00:00
[
  {
    "5459": "mistral"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5418": "gpt-4"
  },
  {
    "5475": "gemini"
  },
  {
    "5399": "generative-ai"
  }
]
8328 Prompt injection and jailbreaking are not the same thing prompt-injection-jailbreaking 2024-03-05 16:05:11+00:00
[
  {
    "4845": "ai"
  },
  {
    "2068": "jailbreaking"
  },
  {
    "3701": "security"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  }
]
8327 Interesting ideas in Observable Framework interesting-ideas-in-observable-framework 2024-03-03 17:54:21+00:00
[
  {
    "4961": "jupyter"
  },
  {
    "4954": "d3"
  },
  {
    "5115": "mike-bostock"
  },
  {
    "5114": "observable"
  },
  {
    "5634": "observable-framework"
  },
  {
    "5701": "observable-plot"
  },
  {
    "2103": "javascript"
  },
  {
    "2962": "open-source"
  }
]
8326 Weeknotes: Getting ready for NICAR weeknotes-getting-ready-for-nicar 2024-02-27 04:21:55+00:00
[
  {
    "925": "data-journalism"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5476": "nicar"
  },
  {
    "3289": "projects"
  },
  {
    "5110": "datasette"
  }
]
8325 The killer app of Gemini Pro 1.5 is video gemini-pro-video 2024-02-21 19:20:48+00:00
[
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "5475": "gemini"
  },
  {
    "4845": "ai"
  },
  {
    "5865": "long-context"
  }
]
8324 Weeknotes: a Datasette release, an LLM release and a bunch of new plugins weeknotes 2024-02-09 23:59:06+00:00
[
  {
    "3289": "projects"
  },
  {
    "5110": "datasette"
  },
  {
    "5444": "llm"
  },
  {
    "5378": "shot-scraper"
  },
  {
    "5489": "enrichments"
  },
  {
    "5482": "quickjs"
  },
  {
    "5215": "weeknotes"
  }
]
8323 Datasette 1.0a8: JavaScript plugins, new plugin hooks and plugin configuration in datasette.yaml datasette-1a8 2024-02-07 16:37:46+00:00
[
  {
    "5321": "annotated-release-notes"
  },
  {
    "3289": "projects"
  },
  {
    "3207": "plugins"
  },
  {
    "5110": "datasette"
  }
]
8322 LLM 0.13: The annotated release notes llm 2024-01-26 23:08:53+00:00
[
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "5321": "annotated-release-notes"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5444": "llm"
  }
]
8321 Weeknotes: datasette-test, datasette-build, PSF board retreat weeknotes 2024-01-21 11:34:43+00:00
[
  {
    "5110": "datasette"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5389": "psf"
  },
  {
    "3289": "projects"
  },
  {
    "5377": "playwright"
  }
]
8320 Talking about Open Source LLMs on Oxide and Friends oxide-and-friends 2024-01-17 21:39:32+00:00
[
  {
    "5445": "anthropic"
  },
  {
    "5668": "bryan-cantrill"
  },
  {
    "5405": "whisper"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5399": "generative-ai"
  },
  {
    "2962": "open-source"
  },
  {
    "5423": "llms"
  },
  {
    "3215": "podcasts"
  },
  {
    "4845": "ai"
  },
  {
    "5446": "claude"
  },
  {
    "5638": "oxide"
  },
  {
    "5444": "llm"
  }
]
8319 Publish Python packages to PyPI with a python-lib cookiecutter template and GitHub Actions python-lib-pypi 2024-01-16 21:59:56+00:00
[
  {
    "1631": "github"
  },
  {
    "5232": "cookiecutter"
  },
  {
    "5220": "github-actions"
  },
  {
    "3350": "python"
  },
  {
    "3289": "projects"
  },
  {
    "3342": "pypi"
  }
]
8318 What I should have said about the term Artificial Intelligence what-i-should-have-said-about-ai 2024-01-09 21:13:45+00:00
[
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  }
]
8317 Weeknotes: Page caching and custom templates for Datasette Cloud page-caching-and-custom-templates-for-datasette-cloud 2024-01-07 20:45:11+00:00
[
  {
    "5119": "cloudflare"
  },
  {
    "4382": "varnish"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5110": "datasette"
  },
  {
    "3701": "security"
  },
  {
    "549": "caching"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "4641": "xss"
  }
]
8316 It's OK to call it Artificial Intelligence call-it-ai 2024-01-07 00:01:57+00:00
[
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  }
]
8315 Tom Scott, and the formidable power of escalating streaks escalating-streaks 2024-01-02 20:32:08+00:00
[
  {
    "5836": "streaks"
  },
  {
    "4205": "tom-scott"
  },
  {
    "1986": "inspiring"
  },
  {
    "4673": "youtube"
  },
  {
    "3280": "productivity"
  }
]
8314 Stuff we figured out about AI in 2023 ai-in-2023 2023-12-31 23:59:52+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "431": "blogging"
  }
]
8313 Last weeknotes of 2023 weeknotes 2023-12-31 04:53:13+00:00
[
  {
    "5215": "weeknotes"
  }
]
8312 Recommendations to help mitigate prompt injection: limit the blast radius mitigate-prompt-injection 2023-12-20 20:34:57+00:00
[
  {
    "5396": "prompt-injection"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "3215": "podcasts"
  },
  {
    "5423": "llms"
  },
  {
    "3701": "security"
  }
]
8311 Many options for running Mistral models in your terminal using LLM mistral 2023-12-18 18:18:44+00:00
[
  {
    "4845": "ai"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "3207": "plugins"
  },
  {
    "5444": "llm"
  },
  {
    "5459": "mistral"
  },
  {
    "5572": "llamafile"
  }
]
8310 The AI trust crisis ai-trust-crisis 2023-12-14 16:14:11+00:00
[
  {
    "4252": "trust"
  },
  {
    "5611": "training-data"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "4735": "dropbox"
  }
]
8309 Weeknotes: datasette-enrichments, datasette-comments, sqlite-chronicle weeknotes 2023-12-08 06:04:54+00:00
[
  {
    "5215": "weeknotes"
  },
  {
    "3910": "sqlite"
  },
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "5489": "enrichments"
  }
]
8308 Datasette Enrichments: a new plugin framework for augmenting your data datasette-enrichments 2023-12-01 20:14:50+00:00
[
  {
    "3207": "plugins"
  },
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "5489": "enrichments"
  }
]
8307 llamafile is the new best way to run an LLM on your own computer llamafile 2023-11-29 20:54:16+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5414": "cosmopolitan"
  },
  {
    "2737": "mozilla"
  },
  {
    "5416": "llama"
  },
  {
    "5572": "llamafile"
  },
  {
    "4845": "ai"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5423": "llms"
  },
  {
    "5573": "justine-tunney"
  }
]
8306 Prompt injection explained, November 2023 edition prompt-injection-explained 2023-11-27 03:55:08+00:00
[
  {
    "3701": "security"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5423": "llms"
  },
  {
    "3215": "podcasts"
  },
  {
    "4845": "ai"
  },
  {
    "925": "data-journalism"
  },
  {
    "5930": "podcast-appearances"
  }
]
8305 I'm on the Newsroom Robots podcast, with thoughts on the OpenAI board newsroom-robots 2023-11-25 00:29:26+00:00
[
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "3215": "podcasts"
  },
  {
    "5399": "generative-ai"
  },
  {
    "925": "data-journalism"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "4845": "ai"
  }
]
8304 Weeknotes: DevDay, GitHub Universe, OpenAI chaos weeknotes 2023-11-22 04:20:04+00:00
[
  {
    "5273": "sqlite-utils"
  },
  {
    "5110": "datasette"
  },
  {
    "5385": "openai"
  },
  {
    "5378": "shot-scraper"
  },
  {
    "3289": "projects"
  },
  {
    "4105": "text-to-speech"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5215": "weeknotes"
  }
]
8303 Deciphering clues in a news article to understand how it was reported deciphering-clues 2023-11-22 02:06:57+00:00
[
  {
    "5445": "anthropic"
  },
  {
    "5875": "sam-altman"
  },
  {
    "5385": "openai"
  },
  {
    "2829": "news"
  },
  {
    "2187": "journalism"
  },
  {
    "4845": "ai"
  }
]
8302 Exploring GPTs: ChatGPT in a trench coat? gpts 2023-11-15 15:39:59+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "4845": "ai"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5486": "rag"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5423": "llms"
  }
]
8301 Financial sustainability for open source projects at GitHub Universe universe 2023-11-10 22:48:58+00:00
[
  {
    "4057": "talks"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5110": "datasette"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "1631": "github"
  },
  {
    "2962": "open-source"
  }
]
8300 ospeak: a CLI tool for speaking text in the terminal via OpenAI ospeak 2023-11-07 04:54:42+00:00
[
  {
    "5385": "openai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5418": "gpt-4"
  },
  {
    "5444": "llm"
  }
]
8299 DALL-E 3, GPT4All, PMTiles, sqlite-migrate, datasette-edit-schema weeknotes 2023-10-30 23:59:12+00:00
[
  {
    "5273": "sqlite-utils"
  },
  {
    "2495": "mapping"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5444": "llm"
  },
  {
    "3289": "projects"
  },
  {
    "5674": "overture"
  }
]
8298 Now add a walrus: Prompt engineering in DALL‑E 3 add-a-walrus 2023-10-26 21:11:39+00:00
[
  {
    "5396": "prompt-injection"
  },
  {
    "5743": "text-to-image"
  },
  {
    "5388": "dalle"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  }
]
8297 Execute Jina embeddings with a CLI using llm-embed-jina llm-embed-jina 2023-10-26 03:47:08+00:00
[
  {
    "5700": "jina"
  },
  {
    "3289": "projects"
  },
  {
    "3207": "plugins"
  },
  {
    "5444": "llm"
  },
  {
    "5438": "embeddings"
  },
  {
    "4845": "ai"
  }
]
8296 Embeddings: What they are and why they matter embeddings 2023-10-23 13:36:21+00:00
[
  {
    "5603": "clip"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5438": "embeddings"
  },
  {
    "5486": "rag"
  },
  {
    "4845": "ai"
  },
  {
    "5444": "llm"
  }
]
8295 Weeknotes: PyBay, AI Engineer Summit, Datasette metadata and JavaScript plugins weeknotes 2023-10-22 21:32:34+00:00
[
  {
    "5110": "datasette"
  },
  {
    "5215": "weeknotes"
  }
]
8294 Open questions for AI engineering open-questions 2023-10-17 14:18:55+00:00
[
  {
    "4845": "ai"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5423": "llms"
  },
  {
    "4057": "talks"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5444": "llm"
  },
  {
    "5480": "code-interpreter"
  }
]
8293 Multi-modal prompt injection image attacks against GPT-4V multi-modal-prompt-injection 2023-10-14 02:24:25+00:00
[
  {
    "3701": "security"
  },
  {
    "5418": "gpt-4"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5601": "vision-llms"
  },
  {
    "5501": "markdown-exfiltration"
  },
  {
    "5615": "johann-rehberger"
  }
]
8292 Weeknotes: the Datasette Cloud API, a podcast appearance and more datasette-cloud-api 2023-10-01 00:03:53+00:00
[
  {
    "3910": "sqlite"
  },
  {
    "5444": "llm"
  },
  {
    "2187": "journalism"
  },
  {
    "5215": "weeknotes"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5110": "datasette"
  },
  {
    "5423": "llms"
  },
  {
    "5390": "alex-garcia"
  },
  {
    "4845": "ai"
  },
  {
    "5222": "datasette-cloud"
  }
]
8291 Things I've learned about building CLI tools in Python cli-tools-python 2023-09-30 00:12:19+00:00
[
  {
    "3350": "python"
  },
  {
    "694": "cli"
  }
]
8290 Talking Large Language Models with Rooftop Ruby llms-podcast 2023-09-29 15:39:55+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  },
  {
    "4845": "ai"
  },
  {
    "2009": "interviews"
  },
  {
    "3886": "speaking"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "3215": "podcasts"
  },
  {
    "5930": "podcast-appearances"
  }
]
8289 Weeknotes: Embeddings, more embeddings and Datasette Cloud weeknotes-embeddings 2023-09-17 05:10:13+00:00
[
  {
    "3207": "plugins"
  },
  {
    "5222": "datasette-cloud"
  },
  {
    "5444": "llm"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5438": "embeddings"
  },
  {
    "3289": "projects"
  },
  {
    "5110": "datasette"
  },
  {
    "5390": "alex-garcia"
  }
]
8288 Build an image search engine with llm-clip, chat with models with llm chat llm-clip-and-chat 2023-09-12 20:33:48+00:00
[
  {
    "5321": "annotated-release-notes"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5603": "clip"
  },
  {
    "5423": "llms"
  },
  {
    "5438": "embeddings"
  },
  {
    "5422": "edge-llms"
  },
  {
    "4845": "ai"
  },
  {
    "5444": "llm"
  }
]
8287 LLM now provides tools for working with embeddings llm-embeddings 2023-09-04 20:32:39+00:00
[
  {
    "3289": "projects"
  },
  {
    "5486": "rag"
  },
  {
    "5438": "embeddings"
  },
  {
    "5399": "generative-ai"
  },
  {
    "2962": "open-source"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "3910": "sqlite"
  },
  {
    "5444": "llm"
  }
]
8286 Datasette 1.0a4 and 1.0a5, plus weeknotes datasette-plus-weeknotes 2023-08-30 14:33:35+00:00
[
  {
    "5110": "datasette"
  },
  {
    "3207": "plugins"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "5390": "alex-garcia"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5444": "llm"
  },
  {
    "5321": "annotated-release-notes"
  },
  {
    "3289": "projects"
  }
]
8285 Making Large Language Models work for you wordcamp-llms 2023-08-27 14:35:07+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "4586": "wordpress"
  },
  {
    "4845": "ai"
  },
  {
    "3886": "speaking"
  },
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5486": "rag"
  }
]
8284 Datasette Cloud, Datasette 1.0a3, llm-mlc and more datasette-cloud-weeknotes 2023-08-16 23:19:41+00:00
[
  {
    "5222": "datasette-cloud"
  },
  {
    "5444": "llm"
  },
  {
    "3289": "projects"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5110": "datasette"
  },
  {
    "3207": "plugins"
  }
]
8283 How I make annotated presentations annotated-presentations 2023-08-06 17:15:33+00:00
[
  {
    "5446": "claude"
  },
  {
    "3289": "projects"
  },
  {
    "4845": "ai"
  },
  {
    "3886": "speaking"
  },
  {
    "5423": "llms"
  },
  {
    "4214": "tools"
  },
  {
    "5399": "generative-ai"
  },
  {
    "2905": "ocr"
  },
  {
    "4057": "talks"
  },
  {
    "5445": "anthropic"
  },
  {
    "123": "alt-attribute"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5449": "annotated-talks"
  }
]
8282 Weeknotes: Plugins for LLM, sqlite-utils and Datasette weeknotes-plugins 2023-08-05 00:32:38+00:00
[
  {
    "3289": "projects"
  },
  {
    "5444": "llm"
  },
  {
    "5215": "weeknotes"
  },
  {
    "4057": "talks"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "3207": "plugins"
  },
  {
    "5110": "datasette"
  }
]
8281 Catching up on the weird world of LLMs weird-world-of-llms 2023-08-03 14:51:43+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "5385": "openai"
  },
  {
    "5444": "llm"
  },
  {
    "1302": "ethics"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3350": "python"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "4057": "talks"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5446": "claude"
  },
  {
    "5445": "anthropic"
  }
]
8280 Run Llama 2 on your own Mac using LLM and Homebrew llama-2-mac 2023-08-01 18:56:56+00:00
[
  {
    "5868": "llama-cpp"
  },
  {
    "3289": "projects"
  },
  {
    "1851": "homebrew"
  },
  {
    "5416": "llama"
  },
  {
    "3207": "plugins"
  },
  {
    "5444": "llm"
  },
  {
    "5422": "edge-llms"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "2453": "macosx"
  },
  {
    "5399": "generative-ai"
  }
]
8279 sqlite-utils now supports plugins sqlite-utils-plugins 2023-07-24 17:06:23+00:00
[
  {
    "3207": "plugins"
  },
  {
    "3910": "sqlite"
  },
  {
    "5390": "alex-garcia"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "3289": "projects"
  }
]
8278 Accessing Llama 2 from the command-line with the llm-replicate plugin accessing-llama-2 2023-07-18 19:30:59+00:00
[
  {
    "5444": "llm"
  },
  {
    "5937": "llm-release"
  },
  {
    "5422": "edge-llms"
  },
  {
    "3207": "plugins"
  },
  {
    "5416": "llama"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5432": "replicate"
  },
  {
    "3289": "projects"
  }
]
8277 Weeknotes: Self-hosted language models with LLM plugins, a new Datasette tutorial, a dozen package releases, a dozen TILs weeknotes 2023-07-16 05:55:54+00:00
[
  {
    "5110": "datasette"
  },
  {
    "5215": "weeknotes"
  },
  {
    "3207": "plugins"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "4845": "ai"
  },
  {
    "4265": "tutorials"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5440": "symbex"
  },
  {
    "5444": "llm"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "3289": "projects"
  }
]
8276 My LLM CLI tool now supports self-hosted language models via plugins llm 2023-07-12 14:24:40+00:00
[
  {
    "5422": "edge-llms"
  },
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5445": "anthropic"
  },
  {
    "3289": "projects"
  },
  {
    "4845": "ai"
  }
]
8275 Weeknotes: symbex, LLM prompt templates, a bit of a break weeknotes 2023-06-27 16:30:57+00:00
[
  {
    "5423": "llms"
  },
  {
    "5444": "llm"
  },
  {
    "3289": "projects"
  },
  {
    "4845": "ai"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5440": "symbex"
  }
]
8274 Symbex: search Python code for functions and classes, then pipe them into a LLM symbex 2023-06-18 22:11:12+00:00
[
  {
    "4845": "ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3350": "python"
  },
  {
    "5440": "symbex"
  },
  {
    "5423": "llms"
  }
]
8273 Understanding GPT tokenizers gpt-tokenizers 2023-06-08 20:37:00+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "3289": "projects"
  },
  {
    "5418": "gpt-4"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5381": "gpt-3"
  }
]
8272 Weeknotes: Parquet in Datasette Lite, various talks, more LLM hacking parquet-in-datasette-lite 2023-06-04 21:14:27+00:00
[
  {
    "3886": "speaking"
  },
  {
    "5156": "parquet"
  },
  {
    "5384": "datasette-lite"
  },
  {
    "4265": "tutorials"
  },
  {
    "5423": "llms"
  },
  {
    "5110": "datasette"
  },
  {
    "3289": "projects"
  },
  {
    "5215": "weeknotes"
  }
]
8271 It's infuriatingly hard to understand how closed models train on their input closed-model-training 2023-06-04 18:09:48+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5611": "training-data"
  },
  {
    "5445": "anthropic"
  },
  {
    "5446": "claude"
  },
  {
    "5403": "chatgpt"
  }
]
8270 ChatGPT should include inline tips chatgpt-inline-tips 2023-05-30 19:23:27+00:00
[
  {
    "5231": "max-woolf"
  },
  {
    "5446": "claude"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5445": "anthropic"
  },
  {
    "5403": "chatgpt"
  },
  {
    "1016": "design"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  }
]
8269 Lawyer cites fake cases invented by ChatGPT, judge is not amused lawyer-chatgpt 2023-05-27 19:09:50+00:00
[
  {
    "1302": "ethics"
  },
  {
    "4845": "ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "5423": "llms"
  }
]
8268 llm, ttok and strip-tags - CLI tools for working with ChatGPT and other LLMs cli-tools-for-llms 2023-05-18 21:04:01+00:00
[
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5444": "llm"
  },
  {
    "5385": "openai"
  }
]
8267 Delimiters won't save you from prompt injection delimiters-wont-save-you 2023-05-11 15:51:10+00:00
[
  {
    "5423": "llms"
  },
  {
    "3701": "security"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "4845": "ai"
  }
]
8266 Weeknotes: sqlite-utils 3.31, download-esm, Python in a sandbox weeknotes 2023-05-10 22:07:01+00:00
[
  {
    "5380": "pyodide"
  },
  {
    "5221": "deno"
  },
  {
    "3289": "projects"
  },
  {
    "3350": "python"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5273": "sqlite-utils"
  }
]
8265 Leaked Google document: "We Have No Moat, And Neither Does OpenAI" no-moat 2023-05-04 16:05:35+00:00
[
  {
    "5422": "edge-llms"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "1654": "google"
  },
  {
    "2962": "open-source"
  }
]
8264 Midjourney 5.1 midjourney-51 2023-05-04 15:42:25+00:00
[
  {
    "5743": "text-to-image"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5427": "midjourney"
  }
]
8263 Prompt injection explained, with video, slides, and a transcript prompt-injection-explained 2023-05-02 20:22:21+00:00
[
  {
    "5396": "prompt-injection"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3701": "security"
  },
  {
    "4057": "talks"
  },
  {
    "4845": "ai"
  },
  {
    "5449": "annotated-talks"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5423": "llms"
  }
]
8262 download-esm: a tool for downloading ECMAScript modules download-esm 2023-05-02 04:47:29+00:00
[
  {
    "5429": "ai-assisted-programming"
  },
  {
    "3289": "projects"
  },
  {
    "1218": "ecmascript"
  },
  {
    "4718": "npm"
  },
  {
    "2103": "javascript"
  }
]
8261 Let's be bear or bunny lets-be-bear-or-bunny 2023-05-01 18:37:20+00:00
[
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5416": "llama"
  },
  {
    "5434": "vicuna"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5433": "mlc"
  },
  {
    "5422": "edge-llms"
  }
]
8260 Weeknotes: Miscellaneous research into Rye, ChatGPT Code Interpreter and openai-to-sqlite weeknotes 2023-05-01 05:12:09+00:00
[
  {
    "5480": "code-interpreter"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5465": "rye"
  },
  {
    "3289": "projects"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5215": "weeknotes"
  }
]
8259 Enriching data with GPT3.5 and SQLite SQL functions enriching-data 2023-04-29 23:11:10+00:00
[
  {
    "3289": "projects"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5385": "openai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "4845": "ai"
  },
  {
    "3910": "sqlite"
  }
]
8258 The Dual LLM pattern for building AI assistants that can resist prompt injection dual-llm-pattern 2023-04-25 19:00:02+00:00
[
  {
    "5704": "ai-agents"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "3701": "security"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5395": "prompt-engineering"
  }
]
8257 Weeknotes: Citus Con, PyCon and three new niche museums weeknotes 2023-04-23 04:46:25+00:00
[
  {
    "5215": "weeknotes"
  },
  {
    "3886": "speaking"
  },
  {
    "2766": "museums"
  },
  {
    "784": "conferences"
  },
  {
    "3328": "pycon"
  }
]
8256 Data analysis with SQLite and Python for PyCon 2023 pycon-2023 2023-04-20 17:03:08+00:00
[
  {
    "3910": "sqlite"
  },
  {
    "5384": "datasette-lite"
  },
  {
    "3350": "python"
  },
  {
    "3886": "speaking"
  },
  {
    "5110": "datasette"
  },
  {
    "5273": "sqlite-utils"
  },
  {
    "3328": "pycon"
  }
]
8255 What's in the RedPajama-Data-1T LLM training set redpajama-data 2023-04-17 18:57:42+00:00
[
  {
    "5437": "redpajama"
  },
  {
    "5611": "training-data"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5110": "datasette"
  },
  {
    "5384": "datasette-lite"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5416": "llama"
  }
]
8254 Web LLM runs the vicuna-7b Large Language Model entirely in your browser, and it's very impressive web-llm 2023-04-16 15:10:45+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "667": "chrome"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5434": "vicuna"
  },
  {
    "5433": "mlc"
  },
  {
    "5204": "webassembly"
  },
  {
    "5416": "llama"
  }
]
8253 sqlite-history: tracking changes to SQLite tables using triggers (also weeknotes) sqlite-history 2023-04-15 17:33:18+00:00
[
  {
    "5110": "datasette"
  },
  {
    "3910": "sqlite"
  },
  {
    "3289": "projects"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5429": "ai-assisted-programming"
  }
]
8252 Prompt injection: What's the worst that can happen? worst-that-can-happen 2023-04-14 17:35:28+00:00
[
  {
    "5385": "openai"
  },
  {
    "3701": "security"
  },
  {
    "5704": "ai-agents"
  },
  {
    "5396": "prompt-injection"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5501": "markdown-exfiltration"
  }
]
8251 Running Python micro-benchmarks using the ChatGPT Code Interpreter alpha code-interpreter 2023-04-12 01:14:33+00:00
[
  {
    "5399": "generative-ai"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "5480": "code-interpreter"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5403": "chatgpt"
  },
  {
    "3350": "python"
  },
  {
    "3910": "sqlite"
  }
]
8250 Thoughts on AI safety in this era of increasingly powerful open source LLMs ai-safety 2023-04-10 18:41:25+00:00
[
  {
    "1302": "ethics"
  },
  {
    "2962": "open-source"
  },
  {
    "5423": "llms"
  },
  {
    "2573": "media"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5416": "llama"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5422": "edge-llms"
  }
]
8249 The Changelog podcast: LLMs break the internet llms-break-the-internet 2023-04-08 00:46:43+00:00
[
  {
    "5419": "bard"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5416": "llama"
  },
  {
    "5385": "openai"
  },
  {
    "4845": "ai"
  },
  {
    "3886": "speaking"
  },
  {
    "3215": "podcasts"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5429": "ai-assisted-programming"
  }
]
8248 Working in public working-in-public 2023-04-08 00:36:10+00:00
[
  {
    "3215": "podcasts"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "2962": "open-source"
  },
  {
    "3886": "speaking"
  }
]
8247 We need to tell people ChatGPT will lie to them, not debate linguistics chatgpt-lies 2023-04-07 16:34:48+00:00
[
  {
    "1302": "ethics"
  },
  {
    "5403": "chatgpt"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  }
]
8246 Weeknotes: A new llm CLI tool, plus automating my weeknotes and newsletter llm 2023-04-04 23:28:29+00:00
[
  {
    "5110": "datasette"
  },
  {
    "5423": "llms"
  },
  {
    "5215": "weeknotes"
  },
  {
    "5114": "observable"
  },
  {
    "5444": "llm"
  },
  {
    "3289": "projects"
  }
]
8245 Semi-automating a Substack newsletter with an Observable notebook substack-observable 2023-04-04 17:55:28+00:00
[
  {
    "431": "blogging"
  },
  {
    "5110": "datasette"
  },
  {
    "5642": "cors"
  },
  {
    "3289": "projects"
  },
  {
    "5114": "observable"
  }
]
8244 Think of language models like ChatGPT as a "calculator for words" calculator-for-words 2023-04-02 16:20:21+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "5423": "llms"
  },
  {
    "4845": "ai"
  },
  {
    "5419": "bard"
  },
  {
    "5399": "generative-ai"
  },
  {
    "403": "bing"
  }
]
8243 What AI can do for you on the Theory of Change podcast what-ai-can-do-for-you 2023-04-02 00:17:59+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "3215": "podcasts"
  },
  {
    "4845": "ai"
  },
  {
    "2573": "media"
  },
  {
    "5419": "bard"
  },
  {
    "403": "bing"
  },
  {
    "5423": "llms"
  },
  {
    "5930": "podcast-appearances"
  },
  {
    "5399": "generative-ai"
  }
]
8242 AI-enhanced development makes me more ambitious with my projects ai-enhanced-development 2023-03-27 14:38:56+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "5423": "llms"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5415": "applescript"
  },
  {
    "5404": "github-copilot"
  },
  {
    "3289": "projects"
  },
  {
    "5429": "ai-assisted-programming"
  }
]
8241 I built a ChatGPT plugin to answer questions about data hosted in Datasette datasette-chatgpt-plugin 2023-03-24 15:43:59+00:00
[
  {
    "5385": "openai"
  },
  {
    "3289": "projects"
  },
  {
    "5423": "llms"
  },
  {
    "5110": "datasette"
  },
  {
    "5429": "ai-assisted-programming"
  },
  {
    "5403": "chatgpt"
  }
]
8240 Weeknotes: AI won't slow down, a new newsletter and a huge Datasette refactor weeknotes 2023-03-22 23:47:10+00:00
[
  {
    "3289": "projects"
  },
  {
    "4845": "ai"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5110": "datasette"
  },
  {
    "5215": "weeknotes"
  }
]
8239 Don't trust AI to talk accurately about itself: Bard wasn't trained on Gmail dont-trust-ai-to-talk-about-itself 2023-03-22 03:13:02+00:00
[
  {
    "5403": "chatgpt"
  },
  {
    "1641": "gmail"
  },
  {
    "1654": "google"
  },
  {
    "1302": "ethics"
  },
  {
    "403": "bing"
  },
  {
    "3276": "privacy"
  },
  {
    "4845": "ai"
  },
  {
    "5419": "bard"
  },
  {
    "5423": "llms"
  },
  {
    "5611": "training-data"
  },
  {
    "5936": "ai-ethics"
  },
  {
    "5399": "generative-ai"
  }
]
8238 A conversation about prompt engineering with CBC Day 6 cbc-day-6 2023-03-18 16:00:24+00:00
[
  {
    "2573": "media"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5423": "llms"
  },
  {
    "5395": "prompt-engineering"
  },
  {
    "4845": "ai"
  }
]
8237 Could you train a ChatGPT-beating model for $85,000 and run it in a browser? beat-chatgpt-in-a-browser 2023-03-17 15:43:38+00:00
[
  {
    "5425": "bloom"
  },
  {
    "5470": "transformers-js"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5433": "mlc"
  },
  {
    "5204": "webassembly"
  },
  {
    "5399": "generative-ai"
  },
  {
    "5416": "llama"
  },
  {
    "5403": "chatgpt"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5422": "edge-llms"
  }
]
8236 Stanford Alpaca, and the acceleration of on-device large language model development alpaca 2023-03-13 19:19:09+00:00
[
  {
    "5416": "llama"
  },
  {
    "2962": "open-source"
  },
  {
    "3937": "stanford"
  },
  {
    "4845": "ai"
  },
  {
    "5423": "llms"
  },
  {
    "5381": "gpt-3"
  },
  {
    "5422": "edge-llms"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5455": "fine-tuning"
  },
  {
    "5399": "generative-ai"
  }
]
8234 Large language models are having their Stable Diffusion moment llama 2023-03-11 19:15:37+00:00
[
  {
    "5416": "llama"
  },
  {
    "5403": "chatgpt"
  },
  {
    "1368": "facebook"
  },
  {
    "5399": "generative-ai"
  },
  {
    "4845": "ai"
  },
  {
    "5385": "openai"
  },
  {
    "5423": "llms"
  },
  {
    "5381": "gpt-3"
  },
  {
    "5868": "llama-cpp"
  },
  {
    "5405": "whisper"
  },
  {
    "5937": "llm-release"
  },
  {
    "5422": "edge-llms"
  }
]
Copy and export data

Duration: 19.93ms