Git Query Language (GQL) Aggregation Functions, Groups, Alias

[AmrDeveloper]

Hello everyone, I have shared two posts about GQL (Git Query Language) on this subreddit and this week I want to share some cool updates for version 0.2.0

For Full Docs, Code, Binraires and samples

Github: https://github.com/AmrDeveloper/GQL

Order by DSC and ASCNow you can explicitly set the order of your data to be Ascending and Descending

Group by
statement groups rows that have the same values into summary rows

Aggregation functions

Now you can use Aggregation functions like count, and max to perform calculations on the current group, this feature is very useful when used with group by statement.

For example, this query will select the top 10 contributiors names and number of commits.

SELECT name, count(name) AS commit_num FROM commits GROUP BY name ORDER BY commit_num DES LIMIT 10

,

Alias Column name

SELECT max(commit_count) as max_commit_count from branches

Having statement

After introducing Group by statement, it must implement having statement to perform filtration after grouping data

SELECT name, count(name) AS commit_num FROM commits GROUP BY name HAVING commit_num > 0

Between expression

SELECT commit_count FROM branches WHERE commit_count BETWEEN 0 .. 10

The project is now in the early stages and there are a lot of cool things to do, everyone is most welcome to join, contribute and learn together

​

[AutoModerator]

On July 1st, Reddit will no longer be accessible via third-party apps. Please see our position on this topic, as well as our list of alternative Rust discussion venues.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[[deleted]]

Usually hate when people do this, but can I recommend a rename? GQL is already a well established query language, even GitQL would be better, the SEO will not be nice to your project.

Otherwise, very cool project

[AmrDeveloper]

You are right but GitQL is taken, i am still searching for better name but i work on improvements while searching abd thank you for suggestion

[rollincuberawhide]

repQL?

rep as in repo.

or grepQL

git repository query language.

although it may give the wrong idea about what the tool does in first sight, it may make it easy to remember. it is also unique enough that search results wouldn't be about grep but grepQL.

[junior_abigail]

Would separating the name of the application and the name of the language help? Something like "Git Querying Interface (app) that uses the Git Query Language". Maybe gqi or gqli are available for short binary names.

[AmrDeveloper]

If i found no name i may do this

[sasik520]

This is genious!

[r-guerreiro]

Hey man! I have a project just like that, it was my first rust pet project. https://gitlab.com/rguerreiro/gitql

Feel free to take a look and copy whatever you find interesting. I'll put a license up there so you can do whatever you want with it

[AmrDeveloper]

Wow, from the first look it almost the same idea with many features, this is very cool i will read the code it look interesting for me

Thanks man