How to explore github repos via Databend

 Databend now supports GitHub as a data source, and you can read the relevant code at storages/github.

create github-engine based database
Before running databend, your Github Access Token should be set.
export GITHUB_TOKEN=<your_token>;
Create a Github powered database.
Next, start up databend.
databend :) create database datafuselabs engine=github;0 rows in set. Elapsed: 2.611 sec. 

show all tables
Show all tables in this database, which are currently flattened. This means that Repos, issues and PRs are all in the form of tables.
databend :) use datafuselabs;​0 rows in set. Elapsed: 0.013 sec.​databend :) show tables;​+---------------------------------+| name                            |+---------------------------------+| .github                         || .github_comments                || .github_issues                  || .github_prs                     || databend                        || databend-playground             || databend-playground_comments    || databend-playground_issues      || databend-playground_prs         || databend_comments               || databend_issues


View basic information about a repo
databend :) select * from databend;​+------------+----------+------------+------------+-------------+----------------+-------------------+-------------------+| reposiroty | language | license    | star_count | forks_count | watchers_count | open_issues_count | subscribers_count |+------------+----------+------------+------------+-------------+----------------+-------------------+-------------------+| databend   | Rust     | apache-2.0 |       2661 |         252 |           2661 |               349 |                63 |+------------+----------+------------+------------+-------------+----------------+-------------------+-------------------+​1 rows in set. Elapsed: 1.368 sec.


Eg

1、 How to find good for fist issue ？

2、 Calculate the average time of issue closing / PR closing?

Comments

Post a Comment

Popular posts from this blog

The Databend Community Actively Embraces The Rust Ecosystem

Image
The Databend Community Actively Embraces The Rust Ecosystem Databend aims to become an open source, flexible, and reliable serverless data warehouse, it can query fast as lightning, and organically combined with flexible, simple, and low-cost cloud services. The construction of data cloud has never been easier! What Databend Means to The Rust Community Most Databend's team members have rich experience in database/data platform development and open source collaboration. So we choose Rust to develop the next-generation data cloud services which can performance higher performance and more reliable. 1.  Create the top seed player in the Rust data warehouse field, show the charm of Rust, and promote the further application of Rust in the database field. 2.  Continue to promote Rust's efforts in data governance/database/cloud native and other domains to improve the ecosystem and tools. 3.  Provide more learning/practice/job opportunities for Rustacean, and cultivate a group of ...
Read more

This week in Databend #26

[Databend](https://github.com/datafuselabs/databend) aimed to be an open source **elastic** and **reliable** cloud warehouse, it offers blazing fast query and combines elasticity, simplicity, low cost of the cloud, built to make the Data Cloud easy. ## Big changes Below is a list of some major changes that we don't want you to miss. ### Features - **add bloom filter for single column equivalent expression** by [@junli1026](https://github.com/junli1026) ([#3887](https://github.com/datafuselabs/databend/pull/3887)) - **Jwt Auth for http handler** by [@youngsofun](https://github.com/youngsofun) ([#3993](https://github.com/datafuselabs/databend/pull/3993)) ## Improvement - **add partitions_scanned and partitions_total to planner statistics** by [@BohuTANG](https://github.com/BohuTANG). ([#3909](https://github.com/datafuselabs/databend/pull/3909)) - **clean up metasrv code and test** by [@drmingdrmer](https://github.com/drmingdrmer). ([#3925](https://github.com/datafuselabs/databend/pul...
Read more

Databend Design | Whitepapers

Image
Databend is an open source   elastic   and   scalable   cloud warehouse, it offers blazing fast query and combines elasticity, simplicity, low cost of the cloud, built to make the Data Cloud easy. Databend is intended for executing workloads with data stored in cloud storage systems, such as AWS S3 and Azure Blob Storage or others. We design Databend with the following key functionalities in mind: Elastic  In Databend storage and compute resources can dynamically scale up and down on demand. Secure  All data files and network traffic in Databend is encrypted end-to-end, and provider  Role Based Access Control  in SQL level. User-friendly  Databend is an ANSI SQL compliant cloud warehouse, it is easy for data scientist and engineers to use. Cost-efficient  Databend processes queries with high performance, and the user only pays for what is actually used. The picture above shows the high-level architecture of Databend, it consists of three...
Read more