tabularis-hackernews-plugin/.tabularium at main · TabularisDB/tabularis-hackernews-plugin · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
{
  "name": "hackernews",
  "version": "0.1.1",
  "kind": "driver",
  "description": "Query Hacker News stories, comments, users and polls as SQL tables using the public API.",
  "engine": "hackernews",
  "paradigms": [
    "document"
  ],
  "executable": "tabularis-hackernews-plugin",
  "color": "#ff6600",
  "icon": "https://raw.githubusercontent.com/TabularisDB/tabularis-hackernews-plugin/main/hackernews-logo.png",
  "lucide_icon": "rss",
  "capabilities": {
    "schemas": false,
    "views": false,
    "routines": false,
    "file_based": false,
    "folder_based": false,
    "identifier_quote": "\"",
    "alter_primary_key": false,
    "alter_column": false,
    "create_foreign_keys": false,
    "no_connection_required": true
  },
  "data_types": [
    {
      "name": "VARCHAR",
      "category": "string",
      "requires_length": false,
      "requires_precision": false
    },
    {
      "name": "BIGINT",
      "category": "numeric",
      "requires_length": false,
      "requires_precision": false
    },
    {
      "name": "INTEGER",
      "category": "numeric",
      "requires_length": false,
      "requires_precision": false
    },
    {
      "name": "BOOLEAN",
      "category": "other",
      "requires_length": false,
      "requires_precision": false
    }
  ],
  "settings": [
    {
      "key": "story_type",
      "label": "Feed",
      "type": "select",
      "options": [
        "top",
        "new",
        "best",
        "ask",
        "show",
        "jobs"
      ],
      "default": "top",
      "description": "Which Hacker News feed to load into the stories table."
    },
    {
      "key": "max_items",
      "label": "Max Stories",
      "type": "number",
      "default": 30,
      "description": "How many stories to fetch from the feed (max 500)."
    },
    {
      "key": "include_comments",
      "label": "Include Comments",
      "type": "boolean",
      "default": false,
      "description": "Load comments for each story (enables the comments table)."
    },
    {
      "key": "comment_depth",
      "label": "Comment Depth",
      "type": "number",
      "default": 1,
      "description": "How many nesting levels of comments to fetch (1–3). Higher values fetch many more requests."
    },
    {
      "key": "max_comments",
      "label": "Max Comments",
      "type": "number",
      "default": 500,
      "description": "Global cap on the total number of comments fetched (max 5000)."
    },
    {
      "key": "include_users",
      "label": "Include Users",
      "type": "boolean",
      "default": false,
      "description": "Fetch author profiles (karma, bio) for all story (and comment) authors. Enables the users table."
    },
    {
      "key": "include_polls",
      "label": "Include Poll Options",
      "type": "boolean",
      "default": false,
      "description": "Fetch voting options for poll-type stories. Enables the poll_options table."
    },
    {
      "key": "timeout",
      "label": "Timeout (s)",
      "type": "number",
      "default": 10,
      "description": "HTTP request timeout in seconds for the HN API."
    },
    {
      "key": "cache_ttl_minutes",
      "label": "Cache TTL (min)",
      "type": "number",
      "default": 0,
      "description": "Automatically refresh data after this many minutes. Set to 0 to disable."
    }
  ]
}