facebookincubator / CG-SQL
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

File Change Frequency Overall
File Change Frequency Overall
The number of recorded file updates
  • There are 107 files with 31,103 lines of code.
    • 2 files changed more than 100 times (7,610 lines of code)
    • 3 files changed 51-100 times (4,281 lines of code)
    • 10 files changed 21-50 times (9,776 lines of code)
    • 23 files changed 6-20 times (5,955 lines of code)
    • 69 files changed 1-5 times (3,481 lines of code)
24% | 13% | 31% | 19% | 11%
Legend:
101+
51-100
21-50
6-20
1-5
explore: zoomable circles | data
File Change Frequency per File Extension
md, sql, c, h, sh, js, txt, java, html, gitignore, py, css, svg, l, m, json, y, yml, prettierignore, inc
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
c21% | 13% | 37% | 19% | 7%
y100% | 0% | 0% | 0% | 0%
h0% | 40% | 16% | 20% | 22%
l0% | 0% | 100% | 0% | 0%
py0% | 0% | 0% | 61% | 38%
sql0% | 0% | 0% | 37% | 62%
js0% | 0% | 0% | 42% | 57%
java0% | 0% | 0% | 0% | 100%
m0% | 0% | 0% | 0% | 100%
css0% | 0% | 0% | 0% | 100%
inc0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
sources27% | 15% | 35% | 16% | 4%
sources/cqljson0% | 0% | 0% | 100% | 0%
sources/linetester0% | 0% | 0% | 60% | 39%
sources/tester0% | 0% | 0% | 61% | 38%
sources/upgrade0% | 0% | 0% | 62% | 37%
website0% | 0% | 0% | 94% | 5%
sources/cqlrt_cf0% | 0% | 0% | 0% | 100%
sources/grammar_docs0% | 0% | 0% | 0% | 100%
sources/java0% | 0% | 0% | 0% | 100%
website/src0% | 0% | 0% | 0% | 100%
website/plugins0% | 0% | 0% | 0% | 100%
sources/common0% | 0% | 0% | 0% | 100%
Most Frequently Changed Files (Top 50)

See data for all files...

File# lines# unitslast modified
(days ago)		created
(days ago)		# changes# contributors
cg_c.c
in sources
 5269 208 23 534 106 17
y
cql.y
in sources
 2341 - 21 553 104 13
gen_sql.c
in sources
 3303 251 25 553 84 10
ast.h
in sources
 716 - 23 546 75 10
sem.h
in sources
 262 - 17 534 51 7
l
cql.l
in sources
 305 - 25 546 38 9
rewrite.c
in sources
 1196 35 23 498 35 5
cqlrt_common.c
in sources
 2465 104 43 519 35 10
1776 75 17 523 33 10
cg_schema.c
in sources
 1239 29 17 527 32 5
1322 45 44 519 27 6
cg_objc.c
in sources
 474 9 32 547 25 8
cql.h
in sources
 173 - 92 532 24 8
cqlrt_common.h
in sources
 237 1 45 519 24 6
ast.c
in sources
 589 47 23 546 22 6
cg_java.c
in sources
 439 20 39 525 20 7
rewrite.h
in sources
 35 - 45 498 18 3
rt_common.c
in sources
 320 1 78 532 18 7
780 30 44 533 17 3
18 - 73 543 15 3
cg_common.c
in sources
 329 13 44 487 14 3
cg_query_plan.c
in sources
 534 20 44 491 14 4
cqlrt.h
in sources
 223 - 108 549 13 6
gen_sql.h
in sources
 61 - 17 486 11 4
upgrade_validate.sql
in sources/upgrade
 102 - 17 378 11 3
145 - 42 547 11 3
cqlrt.c
in sources
 310 31 108 534 11 3
dbhelp.c
in sources/tester
 283 12 108 519 10 4
eval.c
in sources
 794 41 108 501 10 3
SchemaPersistentV2.sql
in sources/upgrade
 48 - 21 378 7 2
SchemaPersistentV3.sql
in sources/upgrade
 50 - 21 378 7 2
cg_common.h
in sources
 139 - 108 487 7 2
linetest.c
in sources/linetester
 339 6 108 491 7 3
cqljson.py
in sources/cqljson
 404 18 65 109 7 4
eval.h
in sources
 25 - 108 501 6 3
dbhelp.h
in sources/tester
 27 - 87 519 6 2
encoders.c
in sources
 215 12 67 144 6 4
printf.c
in sources
 335 11 108 240 6 2
linetest.h
in sources/linetester
 8 - 108 491 5 2
printf.h
in sources
 10 - 108 240 5 2
Sample.sql
in sources/java
 26 - 108 416 5 3
SchemaPersistentV0.sql
in sources/upgrade
 30 - 21 378 5 1
CGSQLMain.java
in sources/java
 33 2 108 416 5 3
SchemaPersistentV1.sql
in sources/upgrade
 42 - 21 378 5 1
SchemaPersistentV4.sql
in sources/upgrade
 48 - 21 156 5 1
linetest.sql
in sources/linetester
 106 - 108 491 5 2
index.js
in website/src/pages
 142 2 52 547 5 3
flow.c
in sources
 308 24 108 120 5 2
cg_schema.h
in sources
 6 - 108 197 4 2
sidebars.js
in website
 6 - 108 547 4 2
Files With Most Contributors (Top 50)
Files sorted by the number of unique email addresses found in commits.

See data for all files...

File# lines# unitslast modified
(days ago)		created
(days ago)		# changes# contributors
cg_c.c
in sources
 5269 208 23 534 106 17
y
cql.y
in sources
 2341 - 21 553 104 13
gen_sql.c
in sources
 3303 251 25 553 84 10
ast.h
in sources
 716 - 23 546 75 10
sem.h
in sources
 262 - 17 534 51 7
l
cql.l
in sources
 305 - 25 546 38 9
rewrite.c
in sources
 1196 35 23 498 35 5
cqlrt_common.c
in sources
 2465 104 43 519 35 10
1776 75 17 523 33 10
cg_schema.c
in sources
 1239 29 17 527 32 5
1322 45 44 519 27 6
cg_objc.c
in sources
 474 9 32 547 25 8
cqlrt_common.h
in sources
 237 1 45 519 24 6
cql.h
in sources
 173 - 92 532 24 8
ast.c
in sources
 589 47 23 546 22 6
cg_java.c
in sources
 439 20 39 525 20 7
rewrite.h
in sources
 35 - 45 498 18 3
rt_common.c
in sources
 320 1 78 532 18 7
780 30 44 533 17 3
18 - 73 543 15 3
cg_common.c
in sources
 329 13 44 487 14 3
cg_query_plan.c
in sources
 534 20 44 491 14 4
cqlrt.h
in sources
 223 - 108 549 13 6
cqlrt.c
in sources
 310 31 108 534 11 3
upgrade_validate.sql
in sources/upgrade
 102 - 17 378 11 3
145 - 42 547 11 3
gen_sql.h
in sources
 61 - 17 486 11 4
eval.c
in sources
 794 41 108 501 10 3
dbhelp.c
in sources/tester
 283 12 108 519 10 4
cg_common.h
in sources
 139 - 108 487 7 2
SchemaPersistentV2.sql
in sources/upgrade
 48 - 21 378 7 2
SchemaPersistentV3.sql
in sources/upgrade
 50 - 21 378 7 2
linetest.c
in sources/linetester
 339 6 108 491 7 3
cqljson.py
in sources/cqljson
 404 18 65 109 7 4
dbhelp.h
in sources/tester
 27 - 87 519 6 2
printf.c
in sources
 335 11 108 240 6 2
eval.h
in sources
 25 - 108 501 6 3
encoders.c
in sources
 215 12 67 144 6 4
SchemaPersistentV4.sql
in sources/upgrade
 48 - 21 156 5 1
SchemaPersistentV1.sql
in sources/upgrade
 42 - 21 378 5 1
SchemaPersistentV0.sql
in sources/upgrade
 30 - 21 378 5 1
printf.h
in sources
 10 - 108 240 5 2
linetest.h
in sources/linetester
 8 - 108 491 5 2
linetest.sql
in sources/linetester
 106 - 108 491 5 2
flow.c
in sources
 308 24 108 120 5 2
CGSQLMain.java
in sources/java
 33 2 108 416 5 3
Sample.sql
in sources/java
 26 - 108 416 5 3
index.js
in website/src/pages
 142 2 52 547 5 3
dbhelp.sql
in sources/tester
 65 - 108 491 4 1
diags.h
in sources
 30 - 108 549 4 2
Correlations

File Size vs. Number of Changes: 107 points

sources/cg_json_schema.c x: 1776 lines of code y: 33 # changes sources/cg_schema.c x: 1239 lines of code y: 32 # changes sources/sem.h x: 262 lines of code y: 51 # changes sources/gen_sql.h x: 61 lines of code y: 11 # changes sources/upgrade/upgrade_validate.sql x: 102 lines of code y: 11 # changes sources/upgrade/SchemaPersistentV0.sql x: 30 lines of code y: 5 # changes sources/upgrade/SchemaPersistentV1.sql x: 42 lines of code y: 5 # changes sources/upgrade/SchemaPersistentV2.sql x: 48 lines of code y: 7 # changes sources/upgrade/SchemaPersistentV4.sql x: 48 lines of code y: 5 # changes sources/cql.y x: 2341 lines of code y: 104 # changes sources/cg_c.c x: 5269 lines of code y: 106 # changes sources/ast.c x: 589 lines of code y: 22 # changes sources/ast.h x: 716 lines of code y: 75 # changes sources/rewrite.c x: 1196 lines of code y: 35 # changes sources/cql.l x: 305 lines of code y: 38 # changes sources/gen_sql.c x: 3303 lines of code y: 84 # changes sources/cg_objc.c x: 474 lines of code y: 25 # changes sources/cg_java.c x: 439 lines of code y: 20 # changes website/docusaurus.config.js x: 145 lines of code y: 11 # changes website/src/css/custom.css x: 45 lines of code y: 4 # changes sources/cqlrt_common.c x: 2465 lines of code y: 35 # changes sources/run_test_client.c x: 1322 lines of code y: 27 # changes sources/cg_common.c x: 329 lines of code y: 14 # changes sources/cg_query_plan.c x: 534 lines of code y: 14 # changes sources/cg_test_helpers.c x: 780 lines of code y: 17 # changes sources/cqlrt_common.h x: 237 lines of code y: 24 # changes sources/rewrite.h x: 35 lines of code y: 18 # changes website/src/pages/index.js x: 142 lines of code y: 5 # changes sources/cqljson/cqljson.py x: 404 lines of code y: 7 # changes sources/encoders.c x: 215 lines of code y: 6 # changes sources/encoders.h x: 14 lines of code y: 4 # changes sources/upgrade/errortrace.inc x: 2 lines of code y: 2 # changes website/sidebarsGuide.js x: 18 lines of code y: 15 # changes sources/cg_query_plan.h x: 3 lines of code y: 3 # changes sources/cg_stats.c x: 100 lines of code y: 1 # changes sources/cg_stats.h x: 3 lines of code y: 1 # changes sources/rt_common.c x: 320 lines of code y: 18 # changes sources/tester/dbhelp.h x: 27 lines of code y: 6 # changes sources/compat.c x: 60 lines of code y: 4 # changes sources/cql.h x: 173 lines of code y: 24 # changes sources/grammar_docs/ys.c x: 120 lines of code y: 4 # changes sources/cqlrt_cf/cqlrt_cf.c x: 197 lines of code y: 2 # changes sources/cqlrt_cf/cqlrt_cf.h x: 205 lines of code y: 2 # changes sources/cqlrt_cf/cqlholder.m x: 75 lines of code y: 2 # changes sources/cqlrt_cf/demo_main.m x: 54 lines of code y: 3 # changes sources/cqlrt_cf/demo_todo.sql x: 23 lines of code y: 2 # changes sources/grammar_docs/tree_sitter.py x: 253 lines of code y: 4 # changes sources/java/com/facebook/cgsql/CQLResultSet.java x: 99 lines of code y: 4 # changes website/plugins/my-loaders/index.js x: 19 lines of code y: 3 # changes sources/cg_common.h x: 139 lines of code y: 7 # changes sources/cg_schema.h x: 6 lines of code y: 4 # changes sources/cg_udf.c x: 62 lines of code y: 3 # changes sources/charbuf.c x: 111 lines of code y: 4 # changes sources/charbuf.h x: 36 lines of code y: 3 # changes sources/cqlrt.c x: 310 lines of code y: 11 # changes sources/cqlrt.h x: 223 lines of code y: 13 # changes sources/crc64xz.c x: 80 lines of code y: 2 # changes sources/diags.h x: 30 lines of code y: 4 # changes sources/eval.c x: 794 lines of code y: 10 # changes sources/flow.c x: 308 lines of code y: 5 # changes sources/java/Sample.sql x: 26 lines of code y: 5 # changes sources/java/TestResult.c x: 17 lines of code y: 2 # changes sources/java/com_facebook_cgsql_CQLResultSet.c x: 85 lines of code y: 3 # changes sources/linetester/linetest.c x: 339 lines of code y: 7 # changes sources/linetester/linetest.h x: 8 lines of code y: 5 # changes sources/linetester/linetest.sql x: 106 lines of code y: 5 # changes sources/linetester/linetest_main.c x: 106 lines of code y: 3 # changes sources/minipool.c x: 54 lines of code y: 2 # changes sources/minipool.h x: 24 lines of code y: 3 # changes sources/printf.c x: 335 lines of code y: 6 # changes sources/printf.h x: 10 lines of code y: 5 # changes sources/symtab.c x: 186 lines of code y: 2 # changes sources/symtab.h x: 29 lines of code y: 2 # changes sources/tester/dbhelp.c x: 283 lines of code y: 10 # changes sources/tester/main.c x: 132 lines of code y: 2 # changes
106.0
# changes
  min: 1.0
  average: 11.05
  25th percentile: 3.0
  median: 4.0
  75th percentile: 11.0
  max: 106.0
0 5269.0
lines of code
min: 2.0 | average: 290.68 | 25th percentile: 17.0 | median: 54.0 | 75th percentile: 237.0 | max: 5269.0

Number of Contributors vs. Number of Changes: 107 points

sources/cg_json_schema.c x: 10 # contributors y: 33 # changes sources/cg_schema.c x: 5 # contributors y: 32 # changes sources/sem.h x: 7 # contributors y: 51 # changes sources/gen_sql.h x: 4 # contributors y: 11 # changes sources/upgrade/upgrade_validate.sql x: 3 # contributors y: 11 # changes sources/upgrade/SchemaPersistentV0.sql x: 1 # contributors y: 5 # changes sources/upgrade/SchemaPersistentV2.sql x: 2 # contributors y: 7 # changes sources/cql.y x: 13 # contributors y: 104 # changes sources/cg_c.c x: 17 # contributors y: 106 # changes sources/ast.c x: 6 # contributors y: 22 # changes sources/ast.h x: 10 # contributors y: 75 # changes sources/rewrite.c x: 5 # contributors y: 35 # changes sources/cql.l x: 9 # contributors y: 38 # changes sources/gen_sql.c x: 10 # contributors y: 84 # changes sources/cg_objc.c x: 8 # contributors y: 25 # changes sources/cg_java.c x: 7 # contributors y: 20 # changes website/src/css/custom.css x: 2 # contributors y: 4 # changes sources/cqlrt_common.c x: 10 # contributors y: 35 # changes sources/run_test_client.c x: 6 # contributors y: 27 # changes sources/cg_common.c x: 3 # contributors y: 14 # changes sources/cg_query_plan.c x: 4 # contributors y: 14 # changes sources/cg_test_helpers.c x: 3 # contributors y: 17 # changes sources/cqlrt_common.h x: 6 # contributors y: 24 # changes sources/rewrite.h x: 3 # contributors y: 18 # changes website/src/pages/index.js x: 3 # contributors y: 5 # changes sources/cqljson/cqljson.py x: 4 # contributors y: 7 # changes sources/encoders.c x: 4 # contributors y: 6 # changes sources/upgrade/errortrace.inc x: 1 # contributors y: 2 # changes website/sidebarsGuide.js x: 3 # contributors y: 15 # changes sources/cg_query_plan.h x: 1 # contributors y: 3 # changes sources/cg_stats.c x: 1 # contributors y: 1 # changes sources/rt_common.c x: 7 # contributors y: 18 # changes sources/tester/dbhelp.h x: 2 # contributors y: 6 # changes sources/cql.h x: 8 # contributors y: 24 # changes sources/grammar_docs/ys.c x: 3 # contributors y: 4 # changes sources/java/com/facebook/cgsql/EncodedString.java x: 2 # contributors y: 3 # changes sources/cqlrt.h x: 6 # contributors y: 13 # changes sources/eval.c x: 3 # contributors y: 10 # changes sources/eval.h x: 3 # contributors y: 6 # changes sources/flow.c x: 2 # contributors y: 5 # changes sources/linetester/linetest.c x: 3 # contributors y: 7 # changes sources/tester/dbhelp.c x: 4 # contributors y: 10 # changes sources/tester/dbhelp.sql x: 1 # contributors y: 4 # changes
106.0
# changes
  min: 1.0
  average: 11.05
  25th percentile: 3.0
  median: 4.0
  75th percentile: 11.0
  max: 106.0
0 17.0
# contributors
min: 1.0 | average: 2.98 | 25th percentile: 1.0 | median: 2.0 | 75th percentile: 3.0 | max: 17.0