apache / cloudberry

182	632	994	832	2587	3482	4368	5105	6499	4796	2690	2172	1395	1759	2165	1995	1559	1912	2179	2143
27	103	152	133	160	145	151	161	164	163	74	19	18	13	14	16	16	13	14	11
2025	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	2011	2010	2009	2008	2007	2006

	travis github actions maven make docker
Standard analyses:
		Main Code: 1,446,295 LOC (6235 files) = C (63%) + CPP (12%) + H (12%) + SQL (4%) + XML (2%) + CC (1%) + L (<1%) + PL (<1%) + Y (<1%) + PM (<1%) + PY (<1%) + IN (<1%) + XSD (<1%) + HTML (<1%) + WXS (<1%) + XSL (<1%) + VCXPROJ (<1%) + CMAKE (<1%) + BASH (<1%) + XS (<1%) + PROTO (<1%) + CSS (<1%) + FILTERS (<1%) + SPEC (<1%) + GV (<1%) + S (<1%) + D (<1%) + RB (<1%) + YAML (<1%) + PROJ (<1%) + MAN (<1%) + PROLOG (<1%) + SED (<1%) + INC (<1%) + CFG (<1%) Secondary code: Test: 502,340 LOC (2731); Generated: 499 LOC (3); Build & Deploy: 3,566 LOC (54); Other: 58,757 LOC (251);
		File Size: 46% long (>1000 LOC), 19% short (<= 200 LOC)
		Logical Component Decomposition: primary (9 components)
		28 years, 10 months old 98% of code older than 365 days 60% of code not updated in the past 365 days
		46% of code updated more than 50 times Also see temporal dependencies for files frequently changed in same commits.
		Goals: Keep the system simple and easy to change (4)
Experimental analyses (less reliable heuristic analyses):
		Unit Size: 34% long (>100 LOC), 19% short (<= 10 LOC)
		Conditional Complexity: 27% complex (McCabe index > 50), 34% simple (McCabe index <= 5)
		Static Component Dependencies: primary (9 components)

	Features of interest: TODOs 354 files

All Analysis Reports

Source Code Overview

Components

Temporal Dependencies

Duplication

File Size

File Age & Freshness

File Change Frequency

Commits

Contributors

Unit Size*

Conditional Complexity*

Features of Interest

All Metrics

Goals & Controls

Component Dependencies*

Trend

Notes & Findings

Overall Activity Per Year

Latest commit date: 2025-04-29

Reference analysis date: 2025-05-07

14

commits
(30 days)

7

contributors
(30 days)

182	632	994	832	2587	3482	4368	5105	6499	4796	2690	2172	1395	1759	2165	1995	1559	1912	2179	2143
27	103	152	133	160	145	151	161	164	163	74	19	18	13	14	16	16	13	14	11
2025	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	2011	2010	2009	2008	2007	2006

Activity Per File Extension

commits

	2025	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	2011	2010	2009	2008	2007	2006	2005
	97	266	451	470	1408	2060	2204	2803	3156	2590	1706	1395	930	1181	1360	1201	995	1058	1036	1066	1191	c
	58	240	366	199	534	923	955	1164	1351	1248	609	481	295	416	465	376	333	416	371	448	443	h
	48	190	343	228	489	665	777	910	1144	718	403	248	182	170	213	142	151	131	154	121	114	sql
	21	157	131							71												cc
	19	82	174	95	108	165	165	219	255	321	37											cpp
	13	29	26	14	54	91	215	122	321	172	22											yaml
	6	34	2			1			4	2	2											cmake
	4	15	57	42	141	112	261	287	440	222	27											py
proto	1	16	7																			proto
y	1	13	22	9	44	68	54	88	112	83	72	43	45	44	63	43	72	80	64	87	71	y
	4	8	16	37	178	190	198	168	219	117	85	42	10	28	37	38	19	21	31	15	3	pl
in	2	6	9	2	26	72	102	134	184	78	94	66	34	51	47	56	69	74	102	115	83	in
		6	20	3	34	36	82	64	145	52	12											bash
	2	3	19	17	203	150	315	296	418	43	15											xml
	4	1	9	16	65	85	100	104	127	96	94	56	26	20	36	38	21	36	73	6		pm
spec	1	2	6	4	19	15	31	43	21	27	15	12	8	4	6							spec
l		2	3	2	11	20	29	36	34	45	31	23	17	14	26	15	37	26	19	46	22	l
wxs	2		1			2	6	1	2													wxs
		1	1			4	1		1	2	1					3	2					css
vcxproj		1				1				1												vcxproj
		1	1					3			1			1		4	2	293	306	345	394	html
cfg		1	5					3		1	3					2						cfg
filters		1				1																filters
		1			1	1	3	1	9	3												rb
xsd			1	2		1	1	3	1													xsd
xsl			1		2	12	8	12	16	8	3	3	6	6	1	3	2	1		1		xsl
sed			1		2	2	3	8	4	1	2	1	1	1	1	2	1	3				sed
man						1		2	2		1		2	1		2				1		man
					1			1	1	12												inc
			1		1	2	5	9	7	4	2	3	1	2	1	5	6	4		1		d
proj			1			1	1	2	2		1	1				1			4			proj
prolog			1		1																	prolog
gv			1			1	2															gv
s			1		1	2	4	10	3	1	2	3	1	1	1	3	1	1		11	1	s
xs						1	1	2	3	1	3			1	3	3				3	6	xs

contributors

	2025	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015	2014	2013	2012	2011	2010	2009	2008	2007	2006	2005
	22	73	105	93	103	99	100	109	105	88	52	19	18	13	13	15	14	12	13	10	10	c
	17	51	76	59	71	76	84	85	93	74	45	15	16	12	12	14	13	11	13	9	9	h
	15	52	83	67	87	85	79	77	93	70	33	15	14	10	10	11	10	8	12	8	8	sql
	5	23	33	24	26	32	30	34	31	36	13											cpp
	6	10	15	10	23	33	57	45	59	50	5											yaml
	4	12	30	24	47	43	56	51	66	66	14											py
	5	9	6							8												cc
	4	6	2			1			2	1	1											cmake
	3	7	14	13	19	22	30	27	22	23	15	9	5	7	8	8	6	6	8	4	3	pl
y	1	8	17	5	19	16	20	30	24	19	16	9	12	9	10	9	8	6	8	7	7	y
proto	1	5	4																			proto
in	2	4	9	1	11	26	30	27	43	21	21	9	8	6	7	10	9	10	10	10	6	in
		4	13	3	14	17	35	35	45	34	3											bash
	2	2	9	9	23	19	32	30	49	18	10											xml
	3	1	8	7	11	15	25	27	18	18	15	10	7	7	8	6	5	5	7	2		pm
spec	1	2	6	3	9	8	10	16	11	8	8	6	3	3	2							spec
l		1	2	1	4	6	10	15	13	13	12	6	7	7	6	7	4	6	6	5	4	l
wxs	1		1			2	3	1	2													wxs
		1	1			1	1		1	1	1					2	1					css
vcxproj		1				1				1												vcxproj
		1	1					2			1			1		3	1	5	2	4	3	html
cfg		1	2					3		1	2					2						cfg
filters		1				1																filters
		1			1	1	2	1	5	3												rb
xsd			1	2		1	1	2	1													xsd
xsl			1		2	4	3	7	3	1	3	1	1	1	1	2	1	1		1		xsl
sed			1		2	2	3	6	3	1	2	1	1	1	1	2	1	3				sed
man						1		2	1		1		1	1		2				1		man
					1			1	1	4												inc
			1		1	2	4	7	4	4	2	3	1	2	1	3	2	2		1		d
proj			1			1	1	2	2		1	1				1			1			proj
prolog			1		1																	prolog
gv			1			1	2															gv
s			1		1	2	3	7	2	1	2	2	1	1	1	3	1	1		1	1	s
xs						1	1	2	2	1	2			1	3	3				2	2	xs

Visual Code Explorers

MAIN (6235)	Circles	Sunburst
TEST (2731)	Circles	Sunburst
BUILD AND DEPLOYMENT (54)	Circles	Sunburst
GENERATED (3)	Circles	Sunburst
OTHER (251)	Circles	Sunburst

File Visualizations

File size views:

File age views:

	files grouped by age category files grouped by folder
	files grouped by freshness category files grouped by folder

File change frequency views:

Contributors per file views:

Contributor Visualizations

Contributor dependency views:

past 30 days: graphviz | 2D graph | 2D graph (with files) | 2D graph (with shared files only) | 3D graph | 3D graph (with files) | 3D graph (with shared files only)
past 3 months: graphviz | 2D graph | 2D graph (with files) | 2D graph (with shared files only) | 3D graph | 3D graph (with files) | 3D graph (with shared files only)
past 6 months: graphviz | 2D graph | 2D graph (with files) | 2D graph (with shared files only) | 3D graph | 3D graph (with files) | 3D graph (with shared files only)
past year: graphviz | 2D graph | 2D graph (with files) | 2D graph (with shared files only) | 3D graph | 3D graph (with files) | 3D graph (with shared files only)

Components and Dependencies Visualizations

Components

Temporal Dependencies

Duplication

Commits Racing Charts

30 days

3 months

6 months

PRIMARY (9)

Bubble Chart

Tree Map

graphviz

2D

3D

graphviz

2D

3D

graphviz

2D

3D

Duplication Graph

All Time

12 Months

File Dependencies Visualizations

Temporal dependencies among files:

past 30 days: graphviz | 2D graph | 2D graph (with commits) | 3D graph | 3D graph (with commits)
past 3 months: graphviz | 2D graph | 2D graph (with commits) | 3D graph | 3D graph (with commits)
past 6 months: graphviz | 2D graph | 2D graph (with commits) | 3D graph | 3D graph (with commits)

Units Visualizations

Unit size and conditional complexity views:

Lists of Files Per Scope

Analysis Results

CONFIGURATION: JSON
ALL ANALYSIS RESULTS: JSON
DUPLICATES: TXT | JSON
UNITS: TXT | JSON
CONTRIBUTORS: TXT | JSON
LOGICAL DECOMPOSITIONS: JSON
CONCERNS: JSON
CONTROLS: TXT
ALL METRICS: TXT

Zipped Files

GIT HISTORY: ZIP
ALL FILES IN ALL ANALYSIS SCOPES: ZIP

Generative AI tools, like ChatGPT or Gemini, can help you explore and discuss various aspects of source code repositories using simple prompts and file uploads. Sokrates provides you with curated data that you can use to analyze your source code further.

Example Prompt 1: Repository Evolution Analyzer (based on git history)

Try on: OpenAI ChatGPT | Claude.ai Chat | Google Gemini

Files to upload: git-history.zip

Prompt:

You are an experienced software architect tasked with analyzing Git commit history.
Context:
- Repository Name: apache / cloudberry
- Repository Description: One advanced and mature open-source MPP (Massively Parallel Processing) database. Open source alternative to Greenplum Database.
- Data Provided: A plain text file containing Git commit records. Source code is not available.
- Analysis Basis: Your analysis must be based solely on inferring context from the provided file paths, file names, file extensions, commit timestamps, and author information within the commit records.

Input Format:
The commit records are provided in the following format per line:
[YYYY-MM-DD] [author email] [commit hash] [file path changed]

Requested Insights:

Please analyze the provided commit history and generate a report covering the following sections:

1. Management Summary
- Provide a concise, high-level overview suitable for non-technical stakeholders.
- Summarize the repository's likely purpose, main development phases observed, and key takeaways about the team structure/activity.

2. Functional Overview
- Based only on file/module/class names, infer and describe the primary functions and capabilities of the software in this repository.
- What services or features does the codebase seem to support?

3. Key Business/Domain Concepts
- Identify and list core business or domain concepts reflected in the file and directory names (e.g., reporting, analytics, data export, user management, sourcecode analysis, landscape, visualization).

4. Inferred Architecture & Design
- Infer potential architectural patterns (e.g., modular, layered, microservices) based on directory structures and file naming conventions.
- Highlight notable design choices evident from the structure, such as separation of concerns (e.g., common module), use of configuration files, or templating engines.

5. Inferred Technology Stack
- List the programming languages, frameworks, libraries, and tools likely used, based on file extensions (.java, .py, .js, .html, .xml, .yml, pom.xml, dockerfile), configuration files, and common directory structures (e.g., /src/main/java).
- Categorize these technologies where possible (e.g., Backend, Frontend, Build, Infrastructure).

6. Logical Components / Modules
- Identify the major logical components or modules suggested by the directory structure (e.g., codeanalyzer, reports, cli, common, web).
- Briefly describe the inferred purpose of each major component.

7. Evolution by Year
- Summarize the apparent focus of development activity for each year present in the commit history.
- Assign a thematic title to each year (e.g., "Year 1: Foundation & Core Analysis", "Year 2: Reporting & Visualization Expansion").

8. Trends Over Time
Identify and describe significant trends observed across the years, such as:
- Shifts in technology usage (e.g., introduction of Docker).
- Changes in module activity (e.g., increased focus on landscape analysis).
- Signs of project maturity, expansion into new areas, or periods of focused maintenance.
9. Team Dynamics
- Analyze contributor patterns based on author emails and commit frequency:
 - Identify core maintainer(s) vs. occasional contributors.
 - Describe observable contribution trends (e.g., stable team, high turnover, reliance on a single developer).
 - Note any appearance of automated contributors (e.g., Dependabot).
10. Risk Analysis:
- Based on the findings in all previous sections (Team Dynamics, Technology, Architecture, Evolution), identify potential key risks for the project.
- Examples: Key person dependency, technology obsolescence, maintainability challenges due to complexity, potential scalability bottlenecks, bus factor.

Input File:
You will receive the commit records in a plain text file. Please parse this file to perform your analysis.

Example Prompt 2: File name conventions

Try on: OpenAI ChatGPT | Claude.ai Chat | Google Gemini

Files to upload: files.json

Prompt:

Example Prompt 3: Technology analyzer (based of file paths)

Try on: OpenAI ChatGPT | Claude.ai Chat | Google Gemini

Files to upload: files.json

Prompt:

Analyze the provided list of file paths to identify as many technologies, frameworks, tools, programming languages, cloud services, and architectural patterns used in the project as possible.

**Input:**
Please analyze the following list of file structures (provided as a list of strings or a JSON object containing file paths and optionally extensions/metadata):

*(Example: A JSON array like the one previously provided, or a simple list like `["src/server.ts", "Dockerfile", "tests/e2e/spec.cy.js", "infra/main.tf"]`)*

**Analysis Instructions:**
When performing the analysis, please consider the following:

1. **File Extensions:** Identify languages and configuration types (e.g., `.ts`, `.js`, `.py`, `.java`, `.tf`, `.yml`, `.hcl`, `.css`, `.html`).
2. **Directory Structure & Naming:** Look for conventional directory names (`src`, `tests`, `infra`, `docs`, `cicd`) and names indicating specific components or frameworks (`packages/bff`, `features`, `controllers`, `services`, `cypress`).
3. **Specific Filenames:** Identify standard configuration or definition files (e.g., `package.json`, `pom.xml`, `docker-compose.yml`, `Dockerfile`, `Jenkinsfile`, `webpack.config.js`, `tsconfig.json`, `requirements.txt`, `terragrunt.hcl`, `lint-staged.config.js`, `commitlint.config.js`).
4. **Keywords in Paths:** Look for names of known technologies, tools, frameworks, or cloud providers within the paths (e.g., `aws`, `azure`, `lambda`, `sqs`, `react`, `nest`, `k6`, `datadog`, `pm2`).

**Output:**
Please present the findings as a list of identified technologies. If possible, group them into relevant categories such as:

* Programming Languages
* Frameworks & Runtimes
* Testing Tools
* Infrastructure as Code / Cloud Providers
* Containerization & Orchestration
* Build Tools / Bundlers
* Databases (if identifiable)
* Monitoring & Logging
* CI/CD & Dev Tools
* Architectural Patterns