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

24 rows

tag url description post_count entry_count blogmark_count quotation_count
llm https://simonwillison.net/tags/llm/ [LLM](https://llm.datasette.io/) is my command-line tool for running prompts against Large Language Models. 58 34 24 0
annotatedtalks https://simonwillison.net/tags/annotatedtalks/ 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/). 22 22 0 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
codeinterpreter https://simonwillison.net/tags/codeinterpreter/ 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. 13 10 3 0
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. 387 229 158 0
datasette https://simonwillison.net/tags/datasette/ [Datasette](https://datasette.io/) is an open source tool for exploring and publishing data. 400 226 172 2
sqliteutils https://simonwillison.net/tags/sqliteutils/ [sqlite-utils](https://sqlite-utils.datasette.io/) is a Python library and command-line utility for creating and manipulating SQLite databases. 82 58 24 0
shotscraper https://simonwillison.net/tags/shotscraper/ [shot-scraper](https://shot-scraper.datasette.io/) is a command-line utility for taking screenshots of websites and scraping content from them using JavaScript. 21 13 8 0
claude https://simonwillison.net/tags/claude/ [Claude](https://www.anthropic.com/claude) is Anthropic's family of Large Language Models. 40 9 27 4
anthropic https://simonwillison.net/tags/anthropic/ [Anthropic](https://www.anthropic.com/) are the AI research company behind [Claude](https://claude.ai/). 41 11 25 5
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/). 534 95 313 126
openai https://simonwillison.net/tags/openai/ [OpenAI](https://openai.com/) build [ChatGPT](https://chatgpt.com/) and the GPT series of Large Language Models. 160 44 91 25
githubcopilot https://simonwillison.net/tags/githubcopilot/ [GitHub Copilot](https://github.com/features/copilot) is GitHub's extension for VS Code that uses LLMs to provide context-driven code completion suggestions. 10 4 5 1
slop https://simonwillison.net/tags/slop/ **Slop** describes AI-generated content that is both *unrequested* and *unreviewed*. 6 2 3 1
mistral https://simonwillison.net/tags/mistral/ [Mistral AI](https://mistral.ai/) release both openly licensed and API-hosted Language Models. 10 2 7 1
valtown https://simonwillison.net/tags/valtown/ [Val Town](https://www.val.town/) provides a web interface for building, running and deploying server-side JavaScript apps. 4 1 3 0
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). 252 70 171 11
embeddings https://simonwillison.net/tags/embeddings/ See [Embeddings: What they are and why they matter](https://simonwillison.net/2023/Oct/23/embeddings/). 31 6 25 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. 932 126 780 26
vscode https://simonwillison.net/tags/vscode/ Microsoft's partially open source text editor [Visual Studio Code](https://code.visualstudio.com/). 4 0 4 0
markdownexfiltration https://simonwillison.net/tags/markdownexfiltration/ **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
promptinjection https://simonwillison.net/tags/promptinjection/ **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/). 57 19 30 8
Copy and export data

Duration: 8.95ms