mergestat-lite

What's Changed

• fix(deps): update module golang.org/x/term to v0.9.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/364
• fix(deps): update module github.com/pullrequestinc/go-gpt3 to v1.1.15 by @renovate in https://github.com/mergestat/mergestat-lite/pull/373
• fix(deps): update module github.com/charmbracelet/lipgloss to v0.7.1 by @renovate in https://github.com/mergestat/mergestat-lite/pull/377
• fix(deps): update go.riyazali.net/sqlite digest to 80a51d3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/378
• fix: revert to last known working version of go.riyazali.net/sqlite by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/389
• chore(deps): bump github.com/cloudflare/circl from 1.3.3 to 1.3.7 by @dependabot in https://github.com/mergestat/mergestat-lite/pull/397
• fix(deps): update module github.com/go-git/go-git/v5 to v5.11.0 [security] by @renovate in https://github.com/mergestat/mergestat-lite/pull/396
• fix(deps): update module github.com/clbanning/mxj/v2 to v2.7.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/393
• fix(deps): update module github.com/lib/pq to v1.10.9 by @renovate in https://github.com/mergestat/mergestat-lite/pull/383
• fix(deps): update github.com/shurcool/githubv4 digest to 6cea62e by @renovate in https://github.com/mergestat/mergestat-lite/pull/376
• fix(deps): update module github.com/mattn/go-sqlite3 to v1.14.22 by @renovate in https://github.com/mergestat/mergestat-lite/pull/384
• fix(deps): update module github.com/burntsushi/toml to v1.3.2 by @renovate in https://github.com/mergestat/mergestat-lite/pull/386
• fix(deps): update github.com/shurcool/graphql digest to ed46e5a by @renovate in https://github.com/mergestat/mergestat-lite/pull/398
• chore: upgrade dependencies by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/400
• chore(deps): update actions/checkout action to v4 by @renovate in https://github.com/mergestat/mergestat-lite/pull/402
• fix(deps): update module github.com/data-dog/go-sqlmock to v1.5.2 by @renovate in https://github.com/mergestat/mergestat-lite/pull/401
• chore(deps): update codecov/codecov-action action to v4 by @renovate in https://github.com/mergestat/mergestat-lite/pull/404
• chore(deps): update actions/setup-go action to v5 by @renovate in https://github.com/mergestat/mergestat-lite/pull/403

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.6.1...v0.6.2

What's Changed

• fix(deps): update module github.com/rs/zerolog to v1.29.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/362
• chore(deps): bump golang.org/x/net from 0.5.0 to 0.7.0 by @dependabot in https://github.com/mergestat/mergestat-lite/pull/369
• fix(deps): update module github.com/charmbracelet/bubbletea to v0.23.2 by @renovate in https://github.com/mergestat/mergestat-lite/pull/366
• fix(deps): update module golang.org/x/mod to v0.8.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/365
• fix(deps): update github.com/shurcool/githubv4 digest to 420ad09 by @renovate in https://github.com/mergestat/mergestat-lite/pull/370
• fix(deps): update module github.com/go-enry/go-enry/v2 to v2.8.4 by @renovate in https://github.com/mergestat/mergestat-lite/pull/375
• fix(deps): update module golang.org/x/mod to v0.9.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/374
• fix(deps): update module golang.org/x/text to v0.8.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/367
• feat: add file mode columns to stats table-valued-function by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/379
• chore(deps): bump github.com/cloudflare/circl from 1.3.1 to 1.3.3 by @dependabot in https://github.com/mergestat/mergestat-lite/pull/380
• commit summary fails on 'author_email' being NULL by @dray92 in https://github.com/mergestat/mergestat-lite/pull/381

New Contributors

• @dependabot made their first contribution in https://github.com/mergestat/mergestat-lite/pull/369
• @dray92 made their first contribution in https://github.com/mergestat/mergestat-lite/pull/381

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.6.0...v0.6.1

What's Changed

• fix(deps): update module github.com/charmbracelet/bubbles to v0.15.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/360
• feat: initial codex experiment - natural language to SQL by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/361

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.5.11...v0.6.0

What's Changed

• fix(deps): update module golang.org/x/text to v0.3.8 by @renovate in https://github.com/mergestat/mergestat-lite/pull/318
• fix(deps): update module github.com/spf13/cobra to v1.6.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/319
• fix: failing test cases that uses github.com/mergestat/mergestat by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/324
• fix(deps): update golang.org/x/term digest to 8365914 by @renovate in https://github.com/mergestat/mergestat-lite/pull/322
• fix(deps): update go.riyazali.net/sqlite digest to 77a6464 by @renovate in https://github.com/mergestat/mergestat-lite/pull/321
• fix(deps): update golang.org/x/oauth2 digest to 6fdb5e3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/320
• fix(deps): update module golang.org/x/text to v0.4.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/323
• fix(deps): update module golang.org/x/time to v0.1.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/325
• chore: run go mod tidy by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/326
• feat: replace @patrickdevivo with @mergestat/core-maintainers by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/327
• fix(deps): update module golang.org/x/term to v0.1.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/331
• fix(deps): update module golang.org/x/oauth2 to v0.1.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/330
• fix(deps): update module golang.org/x/mod to v0.6.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/332
• fix(deps): update github.com/shurcool/githubv4 digest to a134b14 by @renovate in https://github.com/mergestat/mergestat-lite/pull/333
• fix(deps): update module github.com/spf13/cobra to v1.6.1 by @renovate in https://github.com/mergestat/mergestat-lite/pull/335
• fix(deps): update module github.com/burntsushi/toml to v1.2.1 by @renovate in https://github.com/mergestat/mergestat-lite/pull/334
• fix(deps): update module github.com/mattn/go-sqlite3 to v1.14.16 by @renovate in https://github.com/mergestat/mergestat-lite/pull/336
• fix(deps): update go.riyazali.net/sqlite digest to bd9e30b by @renovate in https://github.com/mergestat/mergestat-lite/pull/337
• fix(deps): update module golang.org/x/mod to v0.7.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/342
• fix(deps): update github.com/shurcool/githubv4 digest to 0b5c4c7 by @renovate in https://github.com/mergestat/mergestat-lite/pull/344
• fix(deps): update module golang.org/x/time to v0.2.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/340
• fix: add flag to enable sqlite3_unlock_notify() by @riyaz-ali in https://github.com/mergestat/mergestat-lite/pull/350
• chore: upgrade some go dependencies by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/352
• fix(deps): update module golang.org/x/text to v0.6.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/356
• fix(deps): update module golang.org/x/term to v0.4.0 by @renovate in https://github.com/mergestat/mergestat-lite/pull/355
• chore: upgrade libgit2 and git2go versions by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/358
• chore: update go dependencies by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/359

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.5.10...v0.5.11

What's Changed

• chore: upgrade some dependencies by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/303
• Configure Renovate by @renovate in https://github.com/mergestat/mergestat-lite/pull/304
• chore(deps): update codecov/codecov-action action to v3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/308
• chore(deps): update golang docker tag to v1.19 by @renovate in https://github.com/mergestat/mergestat-lite/pull/305
• chore(deps): update actions/setup-go action to v3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/311
• chore(deps): update actions/checkout action to v3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/310
• fix: try adding gomodMassage to renovate config by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/316
• fix: clone sub modules when running renovate by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/317
• fix(deps): update go.riyazali.net/sqlite digest to df6a26c by @renovate in https://github.com/mergestat/mergestat-lite/pull/315
• fix(deps): update module github.com/go-enry/go-enry/v2 to v2.8.3 by @renovate in https://github.com/mergestat/mergestat-lite/pull/313
• fix(deps): update golang.org/x/oauth2 digest to b44042a by @renovate in https://github.com/mergestat/mergestat-lite/pull/314
• chore(deps): update module go to 1.19 by @renovate in https://github.com/mergestat/mergestat-lite/pull/306

New Contributors

• @renovate made their first contribution in https://github.com/mergestat/mergestat-lite/pull/304

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.5.9...v0.5.10

What's Changed

• Fixed log messages for commits from comments to commits by @amenowanna in https://github.com/mergestat/mergestat-lite/pull/297
• chore: rename repo to mergestat-lite by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/301
• chore: update some lint issues (deprecated std lib packages) by @patrickdevivo in https://github.com/mergestat/mergestat-lite/pull/302

New Contributors

• @amenowanna made their first contribution in https://github.com/mergestat/mergestat-lite/pull/297

Full Changelog: https://github.com/mergestat/mergestat-lite/compare/v0.5.8...v0.5.9

What's Changed

• feat: implement a github_org_audit_log table by @patrickdevivo in https://github.com/mergestat/mergestat/pull/295 👮
• feat: add actor_location column to the github_org_audit_log table by @patrickdevivo in https://github.com/mergestat/mergestat/pull/296 🌏

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.7...v0.5.8

What's Changed

• Add labels column to github_repo_issues and github_repo_prs tables by @patrickdevivo in https://github.com/mergestat/mergestat/pull/291
• fix: use default git log order, instead of CommitterTime by default by @patrickdevivo in https://github.com/mergestat/mergestat/pull/292

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.6...v0.5.7

What's Changed

• feat: implement a "hook" for dealing with github API rate limit responses by @patrickdevivo in https://github.com/mergestat/mergestat/pull/270
• fix: refactor github rate limit handler to be settable by @patrickdevivo in https://github.com/mergestat/mergestat/pull/271
• feat: add hook for running a function before a GitHub API request by @patrickdevivo in https://github.com/mergestat/mergestat/pull/272
• feat: add GitHub post request hook by @patrickdevivo in https://github.com/mergestat/mergestat/pull/273
• fix: implement WithGitHubPostRequestHook by @patrickdevivo in https://github.com/mergestat/mergestat/pull/274
• chore: update dependencies, including sqlite by @patrickdevivo in https://github.com/mergestat/mergestat/pull/278
• feat: add table-valued-function for listing GitHub PR reviews by @patrickdevivo in https://github.com/mergestat/mergestat/pull/279
• fix: use a sync.Map instead of a plain map in the CachedLocator by @patrickdevivo in https://github.com/mergestat/mergestat/pull/281
• feat: add id column to github_pr_reviews table by @patrickdevivo in https://github.com/mergestat/mergestat/pull/283
• fix: proper types for some columns on github_pr_reviews table by @patrickdevivo in https://github.com/mergestat/mergestat/pull/284
• chore: upgrade libgit2 by @patrickdevivo in https://github.com/mergestat/mergestat/pull/287
• fix: add constraints for github_repo_prs table by @patrickdevivo in https://github.com/mergestat/mergestat/pull/288

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.5...v0.5.6

Notable Changes

• Upgraded to SQLite 2.38.0, which supports new JSON operators -> and ->> 🎉
• Added csv-noheader and tsv-noheader output formats for excluding CSV/TSV headers 📋
• New time formatting utility functions time_diff and approx_dur 🕐
• New github_repo scalar function for retrieving GitHub repo info as JSON ℹ️

Overall Changes

• fix: address issue with mailmap parsing not occurring by @patrickdevivo in https://github.com/mergestat/mergestat/pull/255
• fix: rename scalar funs to time_diff and approx_dur by @patrickdevivo in https://github.com/mergestat/mergestat/pull/262
• feat: time formatting sqlite print functions by @Vialeon in https://github.com/mergestat/mergestat/pull/261
• feat: implement github_repo scalar function by @patrickdevivo in https://github.com/mergestat/mergestat/pull/263
• feat: upgrade sqlite to 2.38.0 (and other go deps as well) by @patrickdevivo in https://github.com/mergestat/mergestat/pull/264
• feat: add some screenshots to the README by @patrickdevivo in https://github.com/mergestat/mergestat/pull/265
• feat: implement csv-noheader and tsv-noheader output formats by @patrickdevivo in https://github.com/mergestat/mergestat/pull/267
• feat: vendor libgit2 (via git2go) by @patrickdevivo in https://github.com/mergestat/mergestat/pull/266

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.4...v0.5.5

What's Changed

• feat: refactor summary command, rename to summarize by @patrickdevivo in https://github.com/mergestat/mergestat/pull/249
• feat: implement .mailmap parsing by @patrickdevivo in https://github.com/mergestat/mergestat/pull/250
• fix: add short description to summary command by @patrickdevivo in https://github.com/mergestat/mergestat/pull/251
• fix: don't show "more" footer when there's no limit provided by @patrickdevivo in https://github.com/mergestat/mergestat/pull/252
• fix: error handling for summarize commands by @patrickdevivo in https://github.com/mergestat/mergestat/pull/253

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.3...v0.5.4

What's Changed

• feat: allow specifying a sqlite db to mount, add --append mode to export command by @patrickdevivo in https://github.com/mergestat/mergestat/pull/244
• feat: add date filtering and --json output to the summary sub command by @patrickdevivo in https://github.com/mergestat/mergestat/pull/245
• feat: implement blame subcommand to show summary of blame info by @patrickdevivo in https://github.com/mergestat/mergestat/pull/246
• feat: add support for GIT_SSL_NO_VERIFY when cloning repos by @patrickdevivo in https://github.com/mergestat/mergestat/pull/247

mergestat summary --start "-30 days"

mergestat blame

Full Changelog: https://github.com/mergestat/mergestat/compare/v0.5.2...v0.5.3

Improvements to the mergestat summary command:

• Use charmbracelet/bubbletea to animate loading indicators ⏳
• Add a file pattern argument to allow for filtering of commits based on which files were modified 📁

• SQLite upgraded v3.35.0 ➡️ v3.37.0
• ---clone-dir flag (and clone func) added, now trivial to clone all repos in an org (or any set of repositories from GitHub) ⬇️
• Implement service mode, run an HTTP API server that executes queries and responds with JSON results 🌐
• Add summary command for printing out a commit and author summary for the default repo 📊
• New GitHub tables: github_repo_branches, github_repo_pr_commits and github_repo_commits 🎉
• Rename prior json output mode behavior to ndjson, and add a json output 👩‍💻
• Allow GITHUB_TOKEN to be used when cloning https repos 🔐

Example of mergestat summary

• Rename from askgit to mergestat 🎉

• Bump libgit2 / git2go to v1.3.0 and v33 respectively ⬆️
• Make the -v and --repo flags global to subcommands 🌍

• Adds grep and str_split table-valued-functions, useful for simple code search 🔍
• Adds the topics column in github_org_repos and github_user_repos 📝
• Some improvements in the Postgres sync functionality 🤫
• Bug fixes in GitHub API tables 🐛

• Add a github_repo_branch_protections GitHub API table 🔒
• Add an npm_get_package NPM Registry API helper function
• Add logging functionality via a -v or --verbose flag to show what a query is doing "under the hood" 🎉
• Errors also use the new logger
• Upgrade libgit2 dependency to v.1.2.x ⬆️
• Add affiliations as a param to github_user_repos and github_org_repos tables
• Add an SSH repo locator (ssh:// repos will now work)

• Update various column types to be more descriptive (DATETIMEs and BOOLEANs)
• Add experimental sourcegraph_search table

• Fix a bug in the go_mod_to_json scalar function