Tags with descriptions

Owned by simonw, visibility: Public

SQL query
WITH tag_counts AS (
  SELECT 
    tag, 
    description,
    (SELECT count(DISTINCT entry_id) 
     FROM blog_entry_tags 
     WHERE blog_entry_tags.tag_id = blog_tag.id) AS entry_count,
    (SELECT count(DISTINCT blogmark_id) 
     FROM blog_blogmark_tags 
     WHERE blog_blogmark_tags.tag_id = blog_tag.id) AS blogmark_count,
    (SELECT count(DISTINCT quotation_id) 
     FROM blog_quotation_tags 
     WHERE blog_quotation_tags.tag_id = blog_tag.id) AS quotation_count
  FROM blog_tag
  WHERE description IS NOT NULL AND description != ''
)
SELECT 
  tag,
  'https://simonwillison.net/tags/' || tag || '/' as url,
  description,
  (entry_count + blogmark_count + quotation_count) AS post_count,
  entry_count,
  blogmark_count,
  quotation_count
FROM tag_counts

49 rows

tag url description post_count entry_count blogmark_count quotation_count
clip https://simonwillison.net/tags/clip/ [CLIP](https://github.com/openai/CLIP) is an embedding model by OpenAI that supports comparisons between images and text. 7 2 5 0
weeknotes https://simonwillison.net/tags/weeknotes/ I publish weeknotes once every two or three weeks documenting what I've been working on recently. 184 184 0 0
datasette-cloud https://simonwillison.net/tags/datasette-cloud/ The SaaS hosted version of Datasette, at [datasette.cloud](https://www.datasette.cloud/) 42 31 11 0
s3-credentials https://simonwillison.net/tags/s3-credentials/ [s3-credentials](https://s3-credentials.readthedocs.io/) is a CLI tool for creating and managing credentials for S3 buckets. 9 7 2 0
llm-tool-use https://simonwillison.net/tags/llm-tool-use/ Tool use is when an LLM is instructed to occasionally request that an external tool be run on its behalf, with the result passed back to the model for further processing. Sometimes also known as function calling, and one of several ideas that might be referred to as "agents". 6 0 6 0
llm https://simonwillison.net/tags/llm/ [LLM](https://llm.datasette.io/) is my command-line tool for running prompts against Large Language Models. 63 35 28 0
recall https://simonwillison.net/tags/recall/ Microsoft Recall is a feature planned for Windows 11 that allows users to search through automated screenshots taken of their previous activity on their PC. 4 0 3 1
rag https://simonwillison.net/tags/rag/ RAG stands for **Retrieval Augmented Generation**. It's a trick where you find additional context relevant to the user's request using other means (such as full-text or vector search) and populate that context as part of the prompt to a Large Language Model. 17 7 8 2
projects https://simonwillison.net/tags/projects/ Posts about projects I have worked on. 396 231 165 0
datasette https://simonwillison.net/tags/datasette/ [Datasette](https://datasette.io/) is an open source tool for exploring and publishing data. 405 228 175 2
claude https://simonwillison.net/tags/claude/ [Claude](https://www.anthropic.com/claude) is Anthropic's family of Large Language Models. 49 10 33 6
anthropic https://simonwillison.net/tags/anthropic/ [Anthropic](https://www.anthropic.com/) are the AI research company behind [Claude](https://claude.ai/). 48 11 29 8
llms https://simonwillison.net/tags/llms/ Large Language Models (LLMs) are the class of technology behind generative text AI systems like OpenAI's [ChatGPT](https://simonwillison.net/tags/chatgpt/), Google's [Gemini](https://simonwillison.net/tags/gemini/) and Anthropic's [Claude](https://simonwillison.net/tags/claude/). 573 97 340 136
openai https://simonwillison.net/tags/openai/ [OpenAI](https://openai.com/) build [ChatGPT](https://chatgpt.com/) and the GPT series of Large Language Models. 168 45 96 27
mistral https://simonwillison.net/tags/mistral/ [Mistral AI](https://mistral.ai/) release both openly licensed and API-hosted Language Models. 12 2 9 1
boring-technology https://simonwillison.net/tags/boring-technology/ [boringtechnology.club](https://boringtechnology.club/) 6 3 3 0
homebrew-llms https://simonwillison.net/tags/homebrew-llms/ LLMs you can run on your own devices. 53 14 37 2
datasette-lite https://simonwillison.net/tags/datasette-lite/ Datasette running entirely in the browser using Pyodide and WebAssembly, at [lite.datasette.io](https://lite.datasette.io/) 15 12 3 0
sqlite-utils https://simonwillison.net/tags/sqlite-utils/ [sqlite-utils](https://sqlite-utils.datasette.io/) is a Python library and command-line utility for creating and manipulating SQLite databases. 84 59 25 0
shot-scraper https://simonwillison.net/tags/shot-scraper/ [shot-scraper](https://shot-scraper.datasette.io/) is a command-line utility for taking screenshots of websites and scraping content from them using JavaScript. 22 13 9 0
training-data https://simonwillison.net/tags/training-data/ Data used to train LLMs and other machine learning models. 31 8 16 7
sqlite https://simonwillison.net/tags/sqlite/ [SQLite](https://www.sqlite.org/) is the world's [most widely deployed database engine](https://www.sqlite.org/mostdeployed.html). 257 71 174 12
embeddings https://simonwillison.net/tags/embeddings/ See [Embeddings: What they are and why they matter](https://simonwillison.net/2023/Oct/23/embeddings/). 33 6 27 0
nomic https://simonwillison.net/tags/nomic/ [Nomic AI](https://www.nomic.ai) develop various interesting AI projects, including [GPT4All](https://gpt4all.io/) and powerful [embedding models](https://gpt4all.io/). 5 0 5 0
python https://simonwillison.net/tags/python/ The [Python](https://www.python.org/) programming language. 941 127 788 26
ladybird https://simonwillison.net/tags/ladybird/ [Ladybird](https://ladybird.org/) is "a truly independent web browser". 4 0 3 1
beeware https://simonwillison.net/tags/beeware/ [BeeWare](https://beeware.org/) "allows you to write your app in Python and release it on multiple platforms". 2 0 2 0
vs-code https://simonwillison.net/tags/vs-code/ Microsoft's partially open source text editor [Visual Studio Code](https://code.visualstudio.com/). 4 0 4 0
markdown-exfiltration https://simonwillison.net/tags/markdown-exfiltration/ **Markdown Exfiltration** is a [prompt injection](https://simonwillison.net/tags/promptinjection/) attack against chatbots that have access to private information and can render Markdown images. An attacker can trick the bot into rendering an image that leaks data encoded in the URL to an external server. 8 1 7 0
val-town https://simonwillison.net/tags/val-town/ [Val Town](https://www.val.town/) provides a web interface for building, running and deploying server-side JavaScript apps. 4 1 3 0
prompt-injection https://simonwillison.net/tags/prompt-injection/ **Prompt Injection** is a security attack against applications built on top of Large Language Models, [introduced here](https://simonwillison.net/2022/Sep/12/prompt-injection/) and further described in [this series of posts](https://simonwillison.net/series/prompt-injection/). 60 19 33 8
code-interpreter https://simonwillison.net/tags/code-interpreter/ ChatGPT Code Interpreter is a mode of [ChatGPT](https://chatgpt.com/) that allows it to write and then execute Python code in a sandboxed environment. OpenAI sometimes call this feature [data analysis](https://help.openai.com/en/articles/8437071-data-analysis-with-chatgpt). 16 11 5 0
chrome https://simonwillison.net/tags/chrome/ Google's [Chrome](https://www.google.com/chrome/) browser. 29 3 19 7
slop https://simonwillison.net/tags/slop/ **Slop** describes AI-generated content that is both *unrequested* and *unreviewed*. See [Slop is the new name for unwanted AI-generated content](https://simonwillison.net/2024/May/8/slop/). 9 2 5 2
llamafile https://simonwillison.net/tags/llamafile/ [llamafile](https://github.com/Mozilla-Ocho/llamafile) provides a mechanism to distribute and run LLMs as a single file. 5 4 1 0
django https://simonwillison.net/tags/django/ The [Django](https://www.djangoproject.com/) web framework. 546 96 438 12
go https://simonwillison.net/tags/go/ The [Go](https://go.dev/) programming language. 31 4 24 3
ai-assisted-programming https://simonwillison.net/tags/ai-assisted-programming/ Using AI tools such as Large Language Models to help write code. 20 14 4 2
command-r https://simonwillison.net/tags/command-r/ The [Command R](https://cohere.com/command) family of language models from Cohere. 2 0 2 0
github-codespaces https://simonwillison.net/tags/github-codespaces/ [GitHub Codespaces](https://github.com/features/codespaces) provides cloud development environments accessible through a browser. 10 3 7 0
annotated-talks https://simonwillison.net/tags/annotated-talks/ Annotated versions of talks I have given, with extensive notes and additional links. Here's [how I make these](https://simonwillison.net/2023/Aug/6/annotated-presentations/). 23 23 0 0
datasette-desktop https://simonwillison.net/tags/datasette-desktop/ Datasette as an Electron desktop application, at [datasette.io/desktop](https://datasette.io/desktop) 6 5 1 0
vision-llms https://simonwillison.net/tags/vision-llms/ LLMs that can also be used to interpret images and video, such as GPT-4o, Claude 3 and Gemini Pro. 11 1 9 1
prompt-engineering https://simonwillison.net/tags/prompt-engineering/ The subtle art and craft of effectively prompting and building software on top of LLMs. 74 21 38 15
github-copilot https://simonwillison.net/tags/github-copilot/ [GitHub Copilot](https://github.com/features/copilot) is GitHub's extension for VS Code that uses LLMs to provide context-driven code completion suggestions. 11 4 6 1
github-actions https://simonwillison.net/tags/github-actions/ GitHub's [Actions](https://github.com/features/actions) tool for repository automation. 43 25 18 0
git-history https://simonwillison.net/tags/git-history/ [git-history](https://github.com/simonw/git-history) is a tool for analyzing data scraped to a GitHub repository using SQLite. 6 5 1 0
git-scraping https://simonwillison.net/tags/git-scraping/ [Git scraping](https://simonwillison.net/2020/Oct/9/git-scraping/) is a technique where data is scraped from an external source into a Git repository in order to record changes to that data over time. 28 22 6 0
django-sql-dashboard https://simonwillison.net/tags/django-sql-dashboard/ [Django SQL Dashboard](https://django-sql-dashboard.datasette.io) adds a read-only PostgreSQL SQL dashboard interface to a Django project. 12 8 4 0
Copy and export data

Duration: 7.13ms