blogroll_tags

Table actions

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

11 rows where blogroll_id = 75

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
685 Simon Willison 75 open source
686 Simon Willison 75 data journalism
687 Simon Willison 75 Datasette
688 Simon Willison 75 SQLite
689 Simon Willison 75 Python
690 Simon Willison 75 Django
691 Simon Willison 75 developer tools
692 Simon Willison 75 LLMs
693 Simon Willison 75 web development
694 Simon Willison 75 GitHub
695 Simon Willison 75 software infrastructure

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE blogroll_tags (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    blogroll_id INTEGER NOT NULL,
    tag TEXT NOT NULL,
    FOREIGN KEY (blogroll_id) REFERENCES blogroll(id) ON DELETE CASCADE,
    UNIQUE(blogroll_id, tag)
);