Ideas

[GeniusTechnoMystic]

Ideas/Tasks/Design

• Create Python script to do the following things:

  • automate pulling of JSON from gh search query results into sqlite3 database
    • consider using API directly instead of gh cli client
    • add logic to increase stars filter until <1000 results are returned
  • use github API to pull any other useful metrics for each repo
  • reformat dates
  • add age field
  • calculate age from createdAt field
  • add flat fields for owner and ownerType
  • add fields for normalized fork and starGazers data
  • add field for rank
  • calculate rank
  • export sorted data with forks, starGazers, age and rank field to various formats: XML, CSV, SQL, JSON, LUA, YAML, HTML
  • use Google Sheets API, to create/update a Google Spreadsheet
  • push HTML to a webpage using React or Flutter?

• Create bash/PowerShell/nushell/fish wrapper script

• Install script

  • use pyinstaller to package script into standalone executable
  • provide option to install executable, or check/install/configure python venv

• Packaging:

  • docker - probably overkill
  • AppImage - y?
  • Homebrew - y
  • Chocolatey/Winget/Scoop/OneGet - not necessary
  • Puppet/Chef/Ansible - not necessary
  • standalone zip file - y

[GeniusTechnoMystic]

As I posted in the discussions tab, on further thought, the smart thing to do would be to create a generic tool first and configure it for this project. I will write a design document to formulate my thinking further.