DEV Community: Caitin

Most Popular Data Warehouse Repos on GitHub

Caitin — Wed, 22 Feb 2023 09:07:53 +0000

I used an AI-powered querying tool to find the most popular data warehouse repos on GitHub:

How to talk to AI to get it to do what you want

Caitin — Thu, 16 Feb 2023 03:05:00 +0000

But it also makes mistakes. Sometimes, I ask about A, but it thinks I‘m asking about B; I ask only about A, but it thinks I‘m asking about A, B, and C.

This leads to incorrect SQL statements generated by AI. For example, when I asked about the most interesting metrics store projects, it thought I asked about the most popular, active, similar, fastest growing, and most contributors metrics store projects in GitHub. This resulted in invalid SQL generation.

The question link is here, if you're interested: https://ossinsight.io/explore/?id=3e634886-471c-4191-a65c-ae7fbcb5ffb1

It seems that AI can make things more complex than necessary sometimes. We should learn how to talk to AI to get it to do what we want.

Here is a course on prompt engineering. With content labeled with difficulty levels, it fits different levels of learners.

I'm learning this course. Hope it helps. :-)

Which metric best measures the popularity of a GitHub repo? Stars, forks, or watchers?

Caitin — Tue, 14 Feb 2023 10:20:59 +0000

I used an AI-powered querying tool to check the most popular front-end repos on GitHub in 2022.

The result is as follows:

This tool uses "Stars" to measure a repo's popularity.
But it seems that many developers don't agree. Some people think that a better measurement can be pull requests, number of incoming vs outgoing contributors, dependents (i.e. how many projects consider this project important) and so on.

I asked ChatGPT which metric best measures the popularity of a GitHub repo. It replied that:

The most popular metric for measuring the popularity of a GitHub repo is "Stars," which represents the level of attention and endorsement from users. Additionally, "Forks" and "Watchers" are also commonly used metrics for evaluating the popularity of a repo.

OSS Insight used to rank repos only by stars. But in September, 2022, they updated their ranking algorithm:

What do you think? Which metric best measures the popularity of a GitHub repo?

Top AI projects in 2022

Caitin — Mon, 13 Feb 2023 11:54:38 +0000

Check out top AI projects in 2022

The data comes from Data Explorer, a free, AI-powered querying tool that lets you explore 5 billion rows of GitHub data. You can ask it anything about GitHub and gain insights from the data.

Top 10 repos with the highest watch to star ratio

Caitin — Mon, 13 Feb 2023 09:47:18 +0000

Check out the Top 10 repos with the highest watch to star ratio

The data comes from Data Explorer, a free, AI-powered querying tool to explore GitHub data and gain insights. You can ask it anything about GitHub.

Why does AI seem to make things more complex than necessary?

Caitin — Fri, 10 Feb 2023 09:24:34 +0000

Recently, I've been using a free, AI-powered querying tool to explore GitHub data and gain insights. I can ask it any questions about GitHub, and AI will generate SQL based on that and tell me the answer. In most cases, it will accurately answer my questions. For example, the most popular front-end projects in the last decade on GitHub.
However, it also often makes mistakes. Sometimes, I only ask about A, but it thinks I‘m asking about A, B, C, and D. This leads to incorrect SQL generated by AI. For example, when I asked about the most interesting metrics store projects, it thought I asked about the most popular, active, similar, fastest growing, and most contributors metrics store projects in GitHub. This resulted in invalid SQL generation.
The question link is here, if you're interested: https://ossinsight.io/explore/?id=3e634886-471c-4191-a65c-ae7fbcb5ffb1
Why does AI seem to make things more complex than necessary?

Why did a GPT-powered SQL generator write a fake SQL statement in response to my question?

Caitin — Fri, 10 Feb 2023 07:00:31 +0000

My question was "TiDB vs MySQL" and it generated the SQL below.

This is the question link: https://ossinsight.io/explore/?id=ab3ed547-01eb-4e7e-b70e-ff70c8836af9

Area distribution of developers with cats

Caitin — Tue, 07 Feb 2023 06:48:53 +0000

It seems that many developers love cats. To find area distribution of developers with cats in their GitHub profiles, I used Data Explorer, a GPT-powered querying tool for effortless data exploration on GitHub and got the result: https://ossinsight.io/explore/?id=26dd5ff1-d61e-4aa0-ae1d-923d4842007f

This tool is easy to use. Simply ask a question, and it will:

Generate an SQL statement
Query 5+ billion rows of GitHub data
Visualize the results

For example:
How many pull requests does Apache have

Try it out and share your findings with us. :-)

Top 10 AI projects on GitHub

Caitin — Mon, 06 Feb 2023 10:13:03 +0000

What are the top 10 AI projects with most stars on GitHub?
I used a GPT-powered querying tool to find the answer:
What are the top 10 AI projects?

I also used this tool to find the stars and contributors growth trending of EbookFoundation/free-programming-books each month:

This AI-powered tool is for effortless data exploration on GitHub. It's easy to use.

Simply ask a question, and it will:

Generate an SQL statement
Query 5+ billion rows of GitHub data
Visualize the results

After ChatGPT comes out, are low-code projects useless?

Caitin — Mon, 06 Feb 2023 09:46:08 +0000

Major companies invested a lot of resources to build low-code projects.
What are the top 10 low-code projects?
A GPT-powered querying tool shows:

After ChatGPT comes out, are these projects useless?

Do you think Indian and Chinese developers are the hardest working?

Caitin — Sun, 05 Feb 2023 06:58:09 +0000

Which country has the hardest working developers based on the number of pull requests and number of commits on GitHub?

Many people may think the answer is India or China. However, I used an AI-powered tool to find the answer:
https://ossinsight.io/explore/?id=9e44cda5-6284-4748-b80a-3ccf1337b5d2

US developers work hardest.

If you'd like to gain more insights about GitHub data, try this tool: https://ossinsight.io/explore/

What's happening in the open source software word?An AI-powered querying tool can tell us.

Caitin — Fri, 03 Feb 2023 08:41:32 +0000

Data Explorer is a GPT-powered querying tool for effortless data exploration on GitHub.

Simply ask a question, and it will:

Generate an SQL statement
Query 5+ billion rows of GitHub data
Visualize the results

For example:
How many pull requests does Apache have

Where are @kubernetes/kubernetes contributors from?

Who writes the best Linux project?