blogroll_tags

Table actions

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

10 rows where blogroll_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
98 Evgeny Zinoviev 17 Linux
99 Evgeny Zinoviev 17 FreeBSD
100 Evgeny Zinoviev 17 coreboot
101 Evgeny Zinoviev 17 embedded systems
102 Evgeny Zinoviev 17 self-hosting
103 Evgeny Zinoviev 17 privacy
104 Evgeny Zinoviev 17 networking
105 Evgeny Zinoviev 17 software minimalism
106 Evgeny Zinoviev 17 open source
107 Evgeny Zinoviev 17 cyberpunk 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)
);