--- title: Analyzing Git commits with ArangoDB - ArangoDB description: I often find myself searching for certain commits using git log and friends. While I really love the power and flexibility that come with the git and other Unix command-line tools, sometimes it can be more convenient to use a database to filter and aggregate commit data. I gave it a quick try yesterday and… --- ArangoDB 3.12 Product Release Announcement! Read the blog for details. [Read Blog](https://arangodb.com/2024/03/arangodb-3-12-performance-for-all-your-data-models/) [![logo](https://blog.arangodb.com/hs-fs/hubfs/Imported_Blog_Media/logo.png?width=301&height=50&name=logo.png "logo")](https://arango.ai) ### Why Graph [The Rise of Graph](https://arangodb.com/the-rise-of-graph/) [The Graph ML Gamechanger](https://arangodb.com/the-graph-ml-gamechanger/) [Consolidate to Graph](https://arangodb.com/graph-vs-relational/) [Graph DB Basics](https://arangodb.com/graph-database/) ### Products [Managed Graph DB](https://arangodb.com/arangograph-managedgraphdb/) [Self-Managed Graph DB](https://arangodb.com/arangograph-selfmanaged/) [Managed Graph ML](https://arangodb.com/managed-ml-graph/) [Community Edition](https://arangodb.com/community-server/) [Compare Products](https://arangodb.com/subscriptions/) ### Solutions Use Cases Industries Solution Accelerators - [Cyber/Threat Mgmt](https://arangodb.com/solutions/use-cases/cyber-threat-management/) - [Fraud Detection](https://arangodb.com/solutions/use-cases/fraud-detections/) - [Supply Chain](https://arangodb.com/solutions/use-cases/supply-chain/) - [Network Asset Management](https://arangodb.com/solutions/use-cases/network-asset-management/) - [Customer & Patient 360](https://blog.arangodb.com/solutions/use-case/customer-and-patient-360/) - [Recommendations](https://arangodb.com/solutions/use-cases/recommendations/) - [Case Management](https://blog.arangodb.com/solutions/use-case/case-management/) - [Geospatial Analysis](https://arangodb.com/solutions/use-cases/geospatial/) - [Master Data Mgmt](https://arangodb.com/solutions/use-cases/master-data-management/) - [Software & Technology](https://arangodb.com/arangodb-for-software-tech/) - [Financial Services](https://arangodb.com/arangodb-for-financial-services/) - [Tele Communication](https://arangodb.com/telecommunications-and-network/) - [E-commerce](https://arangodb.com/arangodb-for-e-commerce/) - [Healthcare](https://arangodb.com/arangodb-for-healthcare/) - [Government](https://arangodb.com/arangodb-for-government/) - [Aerospace & Defence](https://arangodb.com/arangodb-for-aerospace-defense/) - [Manufacturing](https://arangodb.com/arangodb-for-manufacturing/) - [Enterprise Knowledge Graphs](https://arangodb.com/resources/white-papers/enterprise-knowledge-graphs/) - [Entity Resolution](https://arangodb.com/entity-resolution/) - [Traceability/Lineage](https://arangodb.com/traceability-and-lineage/) - [Contexual Relevance](https://arangodb.com/contextual-relevance/) ### Developers Capabilities Integrations Differentiators - [Graph Traversals](https://arangodb.com/graph-traversals/) - [Multi-Model DB](https://arangodb.com/multi-model-db/) - [LLM + Knowledge Graph](https://arangodb.com/llm-knowledge-graph/) - [Graph ML](https://arangodb.com/managed-ml-graph/) - [Advanced Geospatial](https://arangodb.com/advanced-geospatial/) - [Document Store](https://arangodb.com/document-store/) - [Search Engine](https://arangodb.com/full-text-search-engine/) - [Security & Compliance](https://arangodb.com/security/) - [Data Masking](https://arangodb.com/Data-masking/) - [Key/Value DB](https://arangodb.com/integrated-key-value-support/) - [Clients / Languages](https://arangodb.com/clients-languages/) - [BI Tools](https://arangodb.com/bi-tools-support/) - [Containers](https://arangodb.com/container-support/) - [Community driven](https://arangodb.com/community-driven/) - [Model Flexibility](https://arangodb.com/model-flexibility/) - [Graph Scalability](https://arangodb.com/graph-scalability/) - [Performance at Scale](https://arangodb.com/performance-at-scale/) - [Highest Availability](https://arangodb.com/highest-availability/) - [Unified Query Language](https://arangodb.com/unified-query-languageaql/) - [Graph + Native Document](https://arangodb.com/graph-document/) - [Graph + Native Search](https://arangodb.com/graph-search/) - [Cost Effective](https://arangodb.com/cost-effective-development-operation/) - [Full Geospatial](https://arangodb.com/full-geospatial/) ### Customers [All Case Studies](https://arangodb.com/solutions/solutions-customers/#all) [Government & Cyber](https://arangodb.com/solutions/solutions-customers/#Government-Cyber) [Manufacturing & Supply Chain](https://arangodb.com/solutions/solutions-customers/#Manufacturing-Supply-Chain) [Healthcare & Science](https://arangodb.com/solutions/solutions-customers/#Healthcare-Science) [Retail & Commerce](https://arangodb.com/solutions/solutions-customers/#Retail-Commerce) [Technology](https://arangodb.com/solutions/solutions-customers/#Technology) [Education](https://arangodb.com/solutions/solutions-customers/#Education) [Telco](https://arangodb.com/solutions/solutions-customers/#Telco) [Financial Services](https://arangodb.com/solutions/solutions-customers/#Financial-Services) ### Learn [Documentation](https://docs.arangodb.com/stable/) [Developer Hub](https://developer.arangodb.com/) [ArangoDB University](https://university.arangodb.com/) [Blog](https://arangodb.com/blog/) [Certification](https://arangodb.com/learn/certification/) [Community](https://arangodb.com/community/) [Events](https://arangodb.com/events/) [Resources](https://arangodb.com/resources/) [Training Center](https://arangodb.com/learn/) ### Company [About Us](https://arangodb.com/about-us/) [Team](https://arangodb.com/about-arangodb/) [Partners](https://arangodb.com/partners/) [News](https://arangodb.com/news/) [Careers](https://arangodb.applytojob.com/apply) ### Pricing - Why Graph - [The Rise of Graph](https://arangodb.com/the-rise-of-graph/) - [The Graph ML Gamechanger](https://arangodb.com/the-graph-ml-gamechanger/) - [Consolidate to Graph](https://arangodb.com/graph-vs-relational/) - [Graph DB Basics](https://arangodb.com/graph-database/) - Products - [Managed Graph DB](https://arangodb.com/arangograph-managedgraphdb/) - [Self-Managed Graph DB](https://arangodb.com/arangograph-selfmanaged/) - [Managed Graph ML](https://arangodb.com/managed-ml-graph/) - [Community Edition](https://arangodb.com/community-server/) - [Compare Products](https://arangodb.com/subscriptions/) - Solutions - Use Cases - [Cyber/Threat Mgmt](https://arangodb.com/solutions/use-cases/cyber-threat-management/) - [Fraud Detection](https://arangodb.com/solutions/use-cases/fraud-detections/) - [Supply Chain](https://arangodb.com/solutions/use-cases/supply-chain/) - [Network Asset Management](https://arangodb.com/solutions/use-cases/network-asset-management/) - [Customer & Patient 360](https://arangodb.com/solutions/use-cases/customer-and-patient-360/) - [Recommendations](https://arangodb.com/solutions/use-cases/recommendations/) - [Case Management](https://arangodb.com/solutions/use-cases/case-management/) - [Geospatial Analysis](https://arangodb.com/solutions/use-cases/geospatial/) - [Master Data Mgmt](https://arangodb.com/solutions/use-cases/master-data-management/) - Industries - [Software & Technology](https://arangodb.com/arangodb-for-software-tech/) - [Financial Services](https://arangodb.com/arangodb-for-financial-services/) - [Tele Communication](https://arangodb.com/telecommunications-and-network/) - [E-commerce](https://arangodb.com/arangodb-for-e-commerce/) - [Healthcare](https://arangodb.com/arangodb-for-healthcare/) - [Government](https://arangodb.com/arangodb-for-government/) - [Aerospace & Defence](https://arangodb.com/arangodb-for-aerospace-defense/) - [Manufacturing](https://arangodb.com/arangodb-for-manufacturing/) - Solution Accelerators - [Enterprise Knowledge Graphs](https://arangodb.com/resources/white-papers/enterprise-knowledge-graphs/) - [Entity Resolution](https://arangodb.com/entity-resolution/) - [Traceability/Lineage](https://arangodb.com/traceability-and-lineage/) - [Contexual Relevance](https://arangodb.com/contextual-relevance/) - Customers - [All Case Studies](https://arangodb.com/solutions/solutions-customers/#all) - [Government & Cyber](https://arangodb.com/solutions/solutions-customers/#Government-Cyber) - [Manufacturing & Supply Chain](https://arangodb.com/solutions/solutions-customers/#Manufacturing-Supply-Chain) - [Healthcare & Science](https://arangodb.com/solutions/solutions-customers/#Healthcare-Science) - [Retail & Commerce](https://arangodb.com/solutions/solutions-customers/#Retail-Commerce) - [Technology](https://arangodb.com/solutions/solutions-customers/#Technology) - [Education](https://arangodb.com/solutions/solutions-customers/#Education) - [Telco](https://arangodb.com/solutions/solutions-customers/#Telco) - [Financial Services](https://arangodb.com/solutions/solutions-customers/#Financial-Services) - Learn - [Documentation](https://docs.arangodb.com/stable/) - [Developer Hub](https://developer.arangodb.com/) - [ArangoDB University](https://university.arangodb.com/) - [Blog](https://arangodb.com/blog/) - [Certification](https://arangodb.com/learn/certification/) - [Community](https://arangodb.com/community/) - [Events](https://arangodb.com/events/) - [Resources](https://arangodb.com/resources/) - [Training Center](https://arangodb.com/learn/) - Company - [About Us](https://arangodb.com/about-us/) - [Team](https://arangodb.com/about-arangodb/) - [Partners](https://arangodb.com/partners/) - [News](https://arangodb.com/news/) - [Careers](https://arangodb.applytojob.com/apply) - [Pricing](https://arangodb.com/download-major/pricing/) [**Start Free** ArangoGraph Cloud](https://dashboard.arangodb.cloud/signup?acceptedTermsAndConditions=1) [**Download Now** ArangoDB Enterprise](https://arangodb.com/download-arangodb-enterprise/) ![Vector-5](https://blog.arangodb.com/hubfs/Imported_Blog_Media/search.svg) # Analyzing Git commits with ArangoDB March 11, 2015 Tags: [API](https://blog.arangodb.com/blog/topic/api), [Query Language](https://blog.arangodb.com/blog/topic/query-language), [Tutorial](https://blog.arangodb.com/blog/topic/tutorial) [Twitter](https://twitter.com/intent/tweet?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [Reddit](https://www.reddit.com/share?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [Yahoo](https://plus.google.com/share?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits%3Futm_medium%3Dsocial%26utm_source%3Dgoogle_plus) ![](https://blog.arangodb.com/hubfs/ArangoDB-Blog/clock.svg)Estimated reading time: 1 minutes I often find myself searching for certain commits using `git log` and friends. While I really love the power and flexibility that come with the git and other Unix command-line tools, sometimes it can be more convenient to use a database to filter and aggregate commit data. I gave it a quick try yesterday and imported the commit history of ArangoDB’s Git repository into ArangoDB and ran some queries on the data. ``` // retrieving number of commits per month / year query = 'FOR commit IN commits COLLECT year = DATE_YEAR(commit.date), month = DATE_MONTH(commit.date) WITH COUNT INTO count RETURN { month: CONCAT(year, "/", month), count: count }'; db._query(query).toArray(); ``` While the query results for our repository may not be interesting for everyone, I think it is still worth sharing what I did. Even though I didn’t try it, I think the overall procedure is applicable with any other Git repository. More queries and how to convert and import Git commits in ArangoDB: [Read on in Jan’s Blog](http://jsteemann.github.io/blog/2015/03/11/analyzing-git-commits-with-arangodb/) [Twitter](https://twitter.com/intent/tweet?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [Reddit](https://www.reddit.com/share?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits) [Yahoo](https://plus.google.com/share?url=https://blog.arangodb.com/blog/2015/03/analyzing-git-commits%3Futm_medium%3Dsocial%26utm_source%3Dgoogle_plus) ![Picture of Jan Steemann](https://blog.arangodb.com/hubfs/Imported_Blog_Media/Authors/Jan-Steemann-100x100.webp) March 11, 2015 , [Jan Steemann](https://blog.arangodb.com/blog/author/jan-steemann) After more than 30 years of playing around with 8 bit computers, assembler and scripting languages, Jan decided to move on to work in database engineering. Jan is now a senior C/C++ developer with the ArangoDB core team, being there from version 0.1. He is mostly working on performance optimization, storage engines and the querying functionality. He also wrote most of AQL (ArangoDB’s query language). ### Leave a Comment Tags - [General](https://blog.arangodb.com/blog/topic/general) - [Release](https://blog.arangodb.com/blog/topic/release) - [Community](https://blog.arangodb.com/blog/topic/community) - [Releases](https://blog.arangodb.com/blog/topic/releases) - [Performance](https://blog.arangodb.com/blog/topic/performance) - [Tutorial](https://blog.arangodb.com/blog/topic/tutorial) - [Foxx](https://blog.arangodb.com/blog/topic/foxx) - [AQL](https://blog.arangodb.com/blog/topic/aql) - [API](https://blog.arangodb.com/blog/topic/api) - [Newsletter](https://blog.arangodb.com/blog/topic/newsletter) - [Cluster](https://blog.arangodb.com/blog/topic/cluster) - [Graph](https://blog.arangodb.com/blog/topic/graph) - [Graphs](https://blog.arangodb.com/blog/topic/graphs) - [Documentation](https://blog.arangodb.com/blog/topic/documentation) - [Javascript](https://blog.arangodb.com/blog/topic/javascript) - [Query Language](https://blog.arangodb.com/blog/topic/query-language) - [Architecture](https://blog.arangodb.com/blog/topic/architecture) - [NoSQL](https://blog.arangodb.com/blog/topic/nosql) - [Enterprise](https://blog.arangodb.com/blog/topic/enterprise) - [Ruby](https://blog.arangodb.com/blog/topic/ruby) - [RocksDB](https://blog.arangodb.com/blog/topic/rocksdb) - [testing](https://blog.arangodb.com/blog/topic/testing) - [ArangoML](https://blog.arangodb.com/blog/topic/arangoml) - [Machine Learning](https://blog.arangodb.com/blog/topic/machine-learning) - [Benchmark](https://blog.arangodb.com/blog/topic/benchmark) - [Java](https://blog.arangodb.com/blog/topic/java) - [driver](https://blog.arangodb.com/blog/topic/driver) - [multi-model](https://blog.arangodb.com/blog/topic/multi-model) - [geo](https://blog.arangodb.com/blog/topic/geo) - [how to](https://blog.arangodb.com/blog/topic/how-to) - [Drivers](https://blog.arangodb.com/blog/topic/drivers) - [PHP](https://blog.arangodb.com/blog/topic/php) - [Security](https://blog.arangodb.com/blog/topic/security) - [nodejs](https://blog.arangodb.com/blog/topic/nodejs) - [python](https://blog.arangodb.com/blog/topic/python) - [ArangoSearch](https://blog.arangodb.com/blog/topic/arangosearch) - [Kubernetes](https://blog.arangodb.com/blog/topic/kubernetes) - [Presentation](https://blog.arangodb.com/blog/topic/presentation) - [open-source](https://blog.arangodb.com/blog/topic/open-source) - [Future-of-nosql](https://blog.arangodb.com/blog/topic/future-of-nosql) - [GitHub](https://blog.arangodb.com/blog/topic/github) - [ARM: Raspberry + Co.](https://blog.arangodb.com/blog/topic/arm-raspberry-co-) - [Fraud Detection](https://blog.arangodb.com/blog/topic/fraud-detection) - [Managed Service](https://blog.arangodb.com/blog/topic/managed-service) - [arangosh](https://blog.arangodb.com/blog/topic/arangosh) - [C++](https://blog.arangodb.com/blog/topic/c) - [Cloud](https://blog.arangodb.com/blog/topic/cloud) - [Conferences](https://blog.arangodb.com/blog/topic/conferences) - [Data Science](https://blog.arangodb.com/blog/topic/data-science) - [HTTP](https://blog.arangodb.com/blog/topic/http) - [ML](https://blog.arangodb.com/blog/topic/ml) - [Pregel](https://blog.arangodb.com/blog/topic/pregel) - [Replication](https://blog.arangodb.com/blog/topic/replication) - [WebUI](https://blog.arangodb.com/blog/topic/webui) - [graph database](https://blog.arangodb.com/blog/topic/graph-database) - [monitoring](https://blog.arangodb.com/blog/topic/monitoring) - [pytorch](https://blog.arangodb.com/blog/topic/pytorch) - [Application Server](https://blog.arangodb.com/blog/topic/application-server) - [ArangoGraphML](https://blog.arangodb.com/blog/topic/arangographml) - [Community Edition](https://blog.arangodb.com/blog/topic/community-edition) - [Compliance](https://blog.arangodb.com/blog/topic/compliance) - [Linux](https://blog.arangodb.com/blog/topic/linux) - [Publication](https://blog.arangodb.com/blog/topic/publication) - [Relational Database](https://blog.arangodb.com/blog/topic/relational-database) - [SOC 2](https://blog.arangodb.com/blog/topic/soc-2) - [Windows](https://blog.arangodb.com/blog/topic/windows) - [licensing](https://blog.arangodb.com/blog/topic/licensing) - [networkx](https://blog.arangodb.com/blog/topic/networkx) - [storage](https://blog.arangodb.com/blog/topic/storage) - [ARM](https://blog.arangodb.com/blog/topic/arm) - [Alliances](https://blog.arangodb.com/blog/topic/alliances) - [ArangoDB Cloud](https://blog.arangodb.com/blog/topic/arangodb-cloud) - [ArangoSync](https://blog.arangodb.com/blog/topic/arangosync) - [Arangograph](https://blog.arangodb.com/blog/topic/arangograph) - [CNFC](https://blog.arangodb.com/blog/topic/cnfc) - [DC/OS](https://blog.arangodb.com/blog/topic/dc-os) - [DGL Adaptor](https://blog.arangodb.com/blog/topic/dgl-adaptor) - [Data Loader](https://blog.arangodb.com/blog/topic/data-loader) - [Dev Days 2021](https://blog.arangodb.com/blog/topic/dev-days-2021) - [Developer Hub](https://blog.arangodb.com/blog/topic/developer-hub) - [Funding Announcement](https://blog.arangodb.com/blog/topic/funding-announcement) - [GO](https://blog.arangodb.com/blog/topic/go) - [GenAI](https://blog.arangodb.com/blog/topic/genai) - [Graph DB](https://blog.arangodb.com/blog/topic/graph-db) - [Graph DBs](https://blog.arangodb.com/blog/topic/graph-dbs) - [Graph Databases](https://blog.arangodb.com/blog/topic/graph-databases) - [Graph Neural Networks](https://blog.arangodb.com/blog/topic/graph-neural-networks) - [GraphDB](https://blog.arangodb.com/blog/topic/graphdb) - [Inside ArangoDB](https://blog.arangodb.com/blog/topic/inside-arangodb) - [Intel](https://blog.arangodb.com/blog/topic/intel) - [Intel PyG](https://blog.arangodb.com/blog/topic/intel-pyg) - [Intel Xeon CPU](https://blog.arangodb.com/blog/topic/intel-xeon-cpu) - [KG](https://blog.arangodb.com/blog/topic/kg) - [Knowledge Graphs](https://blog.arangodb.com/blog/topic/knowledge-graphs) - [LLM](https://blog.arangodb.com/blog/topic/llm) - [Large Language Models](https://blog.arangodb.com/blog/topic/large-language-models) - [Migrate to Graph](https://blog.arangodb.com/blog/topic/migrate-to-graph) - [NetworkX Adaptor](https://blog.arangodb.com/blog/topic/networkx-adaptor) - [Oasis](https://blog.arangodb.com/blog/topic/oasis) - [Partners](https://blog.arangodb.com/blog/topic/partners) - [PyG](https://blog.arangodb.com/blog/topic/pyg) - [PyTorch Geometric](https://blog.arangodb.com/blog/topic/pytorch-geometric) - [RDF](https://blog.arangodb.com/blog/topic/rdf) - [Series B](https://blog.arangodb.com/blog/topic/series-b) - [adapter](https://blog.arangodb.com/blog/topic/adapter) - [analytics](https://blog.arangodb.com/blog/topic/analytics) - [analyzers](https://blog.arangodb.com/blog/topic/analyzers) - [arangopipe](https://blog.arangodb.com/blog/topic/arangopipe) - [atomics](https://blog.arangodb.com/blog/topic/atomics) - [aws](https://blog.arangodb.com/blog/topic/aws) - [collaboration](https://blog.arangodb.com/blog/topic/collaboration) - [concurrency](https://blog.arangodb.com/blog/topic/concurrency) - [dev days](https://blog.arangodb.com/blog/topic/dev-days) - [fuzzy search](https://blog.arangodb.com/blog/topic/fuzzy-search) - [graphsage](https://blog.arangodb.com/blog/topic/graphsage) - [licence](https://blog.arangodb.com/blog/topic/licence) - [memory model](https://blog.arangodb.com/blog/topic/memory-model) - [plugin](https://blog.arangodb.com/blog/topic/plugin) - [preprocessing](https://blog.arangodb.com/blog/topic/preprocessing) - [recommendation](https://blog.arangodb.com/blog/topic/recommendation) - [resource description framework](https://blog.arangodb.com/blog/topic/resource-description-framework) - [semantic web](https://blog.arangodb.com/blog/topic/semantic-web) - [torch](https://blog.arangodb.com/blog/topic/torch) - [turtle](https://blog.arangodb.com/blog/topic/turtle) - [x86](https://blog.arangodb.com/blog/topic/x86) - [— Relational Database](https://blog.arangodb.com/blog/topic/-relational-database) [![logo](https://blog.arangodb.com/hs-fs/hubfs/Imported_Blog_Media/logo.png?width=301&height=50&name=logo.png "logo")](https://arango.ai) ArangoGraph Insights Platform Accelerate application innovation and performance with our next-generation graph data and analytics platform. - - - - - #### Quick Links - [Quick Start](https://docs.arangodb.com/3.11/) - [Roadmap](https://arangodb.com/roadmap/) - [Language Drivers](https://docs.arangodb.com/3.11/develop/drivers/) - [Case Studies](https://arangodb.com/solutions/solutions-customers/#all) - [BI Connectors](https://arangodb.com/community-driven/bi-connector-arangodb/) - [Certification Exam](https://arangodb.com/learn/certification/) #### Info - [Community](https://arangodb.com/community/) - [Events](https://arangodb.com/events) - [Online Meetup](https://www.meetup.com/online-ArangoDB-meetup/) - [Logo/Resources](https://arangodb.com/resources/logos/) - [Stackoverflow](https://stackoverflow.com/questions/tagged/arangodb) - [Slack](https://join.slack.com/t/arangodb-community/shared_invite/zt-2d4p43cma-flyf72j9a9wq4A2OtuMFkA) #### About Us - [About Us](https://arangodb.com/about-us/) - [Jobs](https://arangodb.applytojob.com/apply) - [Imprint](https://arangodb.com/imprint/) - [Contact Us](https://arangodb.com/contact/) - [News](https://arangodb.com/news/) - [Google Groups](https://groups.google.com/g/arangodb) #### Stay In Touch Keep up with the latest news from the ArangoDB ©2023 ArangoDB. All Rights Reserved. [Terms & Conditions](https://cloud.arangodb.com/terms-and-conditions)|[Our Privacy Policy](https://cloud.arangodb.com/privacy-policy) ![](https://www.facebook.com/tr?id=336858843477853&ev=PageView&noscript=1)