OSS Insight public API demand collection

[Mini256]

We are planning to publicize more APIs and add them to the API documentation, if you have any idea about the public API, you can propose it through comments.

• An API should be designed to be generic.
• Do not provide APIs containing specific personal data. Personal data will be provided only after aggregation.
• If GitHub has provided relevant APIs, we will not provide them repeatedly.

The data table schema

github_events table:

+------------------------+--------------+------+-----+---------------------+-------+
| Field                  | Type         | Null | Key | Default             | Extra |
+------------------------+--------------+------+-----+---------------------+-------+
| id                     | bigint(20)   | NO   | MUL | 0                   |       |
| type                   | varchar(29)  | NO   |     | Event               |       |
| created_at             | datetime     | NO   | MUL | 1970-01-01 00:00:00 |       |
| repo_id                | bigint(20)   | NO   | MUL | 0                   |       |
| repo_name              | varchar(140) | NO   | MUL |                     |       |
| actor_id               | bigint(20)   | NO   | MUL | 0                   |       |
| actor_login            | varchar(40)  | NO   | MUL |                     |       |
| language               | varchar(26)  | NO   |     |                     |       |
| additions              | bigint(20)   | NO   |     | 0                   |       |
| deletions              | bigint(20)   | NO   |     | 0                   |       |
| action                 | varchar(11)  | NO   |     |                     |       |
| number                 | int(11)      | NO   |     | 0                   |       |
| commit_id              | varchar(40)  | NO   |     |                     |       |
| comment_id             | bigint(20)   | NO   |     | 0                   |       |
| org_login              | varchar(40)  | NO   |     |                     |       |
| org_id                 | bigint(20)   | NO   |     | 0                   |       |
| state                  | varchar(6)   | NO   |     |                     |       |
| closed_at              | datetime     | NO   |     | 1970-01-01 00:00:00 |       |
| comments               | int(11)      | NO   |     | 0                   |       |
| pr_merged_at           | datetime     | NO   |     | 1970-01-01 00:00:00 |       |
| pr_merged              | tinyint(1)   | NO   |     | 0                   |       |
| pr_changed_files       | int(11)      | NO   |     | 0                   |       |
| pr_review_comments     | int(11)      | NO   |     | 0                   |       |
| pr_or_issue_id         | bigint(20)   | NO   |     | 0                   |       |
| event_day              | date         | NO   |     | <null>              |       |
| event_month            | date         | NO   |     | <null>              |       |
| event_year             | int(11)      | NO   |     | <null>              |       |
| push_size              | int(11)      | NO   |     | 0                   |       |
| push_distinct_size     | int(11)      | NO   |     | 0                   |       |
| creator_user_login     | varchar(40)  | NO   |     |                     |       |
| creator_user_id        | bigint(20)   | NO   | MUL | 0                   |       |
| pr_or_issue_created_at | datetime     | NO   |     | 1970-01-01 00:00:00 |       |
+------------------------+--------------+------+-----+---------------------+-------+

github_users table:

+------------------------+---------------+------+-----+---------------------+-------+
| Field                  | Type          | Null | Key | Default             | Extra |
+------------------------+---------------+------+-----+---------------------+-------+
| id                     | int(11)       | NO   | PRI | <null>              |       |
| login                  | varchar(255)  | NO   | MUL | <null>              |       |
| type                   | char(3)       | NO   |     | N/A                 |       |
| is_bot                 | tinyint(1)    | NO   |     | 0                   |       |
| name                   | varchar(255)  | NO   |     |                     |       |
| email                  | varchar(255)  | NO   |     |                     |       |
| organization           | varchar(255)  | YES  | MUL |                     |       |
| organization_formatted | varchar(255)  | YES  |     |                     |       |
| address                | varchar(255)  | YES  | MUL |                     |       |
| country_code           | char(3)       | NO   |     | N/A                 |       |
| region_code            | char(3)       | NO   |     | N/A                 |       |
| state                  | varchar(255)  | NO   |     |                     |       |
| city                   | varchar(255)  | NO   |     |                     |       |
| longitude              | decimal(11,8) | NO   |     | 0                   |       |
| latitude               | decimal(10,8) | NO   |     | 0                   |       |
| public_repos           | int(11)       | NO   |     | 0                   |       |
| followers              | int(11)       | NO   |     | 0                   |       |
| followings             | int(11)       | NO   |     | 0                   |       |
| created_at             | timestamp     | NO   |     | 0000-00-00 00:00:00 |       |
| updated_at             | timestamp     | NO   |     | 0000-00-00 00:00:00 |       |
| is_deleted             | tinyint(1)    | NO   |     | 0                   |       |
| refreshed_at           | timestamp     | NO   |     | CURRENT_TIMESTAMP   |       |
+------------------------+---------------+------+-----+---------------------+-------+

github_repos table:

+--------------------+--------------+------+-----+---------------------+-------+
| Field              | Type         | Null | Key | Default             | Extra |
+--------------------+--------------+------+-----+---------------------+-------+
| repo_id            | int(11)      | NO   | PRI | <null>              |       |
| repo_name          | varchar(150) | NO   | MUL | <null>              |       |
| owner_id           | int(11)      | NO   | MUL | <null>              |       |
| owner_login        | varchar(255) | NO   | MUL | <null>              |       |
| owner_is_org       | tinyint(1)   | NO   |     | <null>              |       |
| description        | varchar(512) | NO   |     |                     |       |
| primary_language   | varchar(32)  | NO   |     |                     |       |
| license            | varchar(32)  | NO   |     |                     |       |
| size               | bigint(20)   | NO   |     | 0                   |       |
| stars              | int(11)      | NO   | MUL | 0                   |       |
| forks              | int(11)      | NO   |     | 0                   |       |
| parent_repo_id     | int(11)      | YES  |     | <null>              |       |
| is_fork            | tinyint(1)   | NO   |     | 0                   |       |
| is_archived        | tinyint(1)   | NO   |     | 0                   |       |
| is_deleted         | tinyint(1)   | NO   |     | 0                   |       |
| latest_released_at | timestamp    | YES  |     | <null>              |       |
| pushed_at          | timestamp    | YES  |     | <null>              |       |
| created_at         | timestamp    | NO   | MUL | 0000-00-00 00:00:00 |       |
| updated_at         | timestamp    | NO   |     | 0000-00-00 00:00:00 |       |
| last_event_at      | timestamp    | NO   |     | 0000-00-00 00:00:00 |       |
| refreshed_at       | timestamp    | NO   |     | 0000-00-00 00:00:00 |       |
+--------------------+--------------+------+-----+---------------------+-------+

github_repo_topics table

+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| repo_id | int(11)     | NO   | PRI | <null>  |       |
| topic   | varchar(50) | NO   | PRI | <null>  |       |
+---------+-------------+------+-----+---------+-------+

github_repo_languages table

+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| repo_id  | int(11)     | NO   | PRI | <null>  |       |
| language | varchar(32) | NO   | PRI | <null>  |       |
| size     | bigint(20)  | NO   |     | 0       |       |
+----------+-------------+------+-----+---------+-------+