home

Menu
  • GraphQL API
  • Search all tables

System

Table actions
  • GraphQL API for system
Site infrastructure - blogroll, quotes, people, locations, tools, TIL

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

Custom SQL query

Tables

blogroll

id, title, url, description, category, slug, publish_date, status, confidence, importance, created_at, rss, last_post_date, last_post_title, last_checked, platform, username, publication_url

224 rows

blogroll_important_urls

id, blogroll_id, title, url

0 rows

blogroll_socials

id, blogroll_id, platform, url

2 rows

blogroll_tags

id, blogroll_id, tag

1,258 rows

changelog_content

id, day, weekday, month, year, text, kind

6 rows

changelog_infra

id, day, weekday, month, year, text, kind

19 rows

locations

id, name, description, longitude, latitude, type, visit_date, duration, highlights, rating, created_at

61 rows

now

id, title, preview, date, category, slug, cover_image, status, confidence, importance, state, created_at

3 rows

now_tags

id, now_id, tag

9 rows

people

id, slug, name, type, image, wiki, sort_actor, sort_artist, sort_author, sort_designer, sort_mathematician, sort_musician, sort_philosopher, sort_poet

109 rows

quotes

id, text, author, source, character

1,731 rows

sources

id, from_user, content, date, link, type, profile_link

20 rows

sqlite_sequence

name, seq

20 rows

supporters

id, name, contribution

30 rows

til

id, title, preview, date, category, slug, cover_image, status, confidence, importance, state, created_at

119 rows

til_tags

id, til_id, tag

238 rows

tools

id, name, slug, description, authors, languages, repo_url, repo_path, status, state, created_at, updated_at

5 rows

tools_commits

id, tool_id, hash, author, date, message

6 rows

tools_source

id, tool_id, filename, language, content

10 rows

tools_tags

id, tool_id, tag

15 rows

words

id, title, type, definition

5 rows

... and 33 hidden tables

Powered by Datasette · 650.954ms · krisyotam.com