Skip to content

Instantly share code, notes, and snippets.

@abo-abo

abo-abo/query.sql

Last active September 8, 2020 08:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abo-abo/9607099 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abo-abo/9607099 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. abo-abo revised this gist Mar 17, 2014. 1 changed file with 102 additions and 0 deletions.
    102 changes: 102 additions & 0 deletions result.org
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,102 @@
    | repository_name | pushes | repository_url | repository_description |
    |-------------------------+--------+-------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
    | emacswiki.org | 517 | https://github.com/emacsmirror/emacswiki.org | The official Emacswiki repository |
    | emacs-archive-tracker | 355 | https://github.com/Bruce-Connor/emacs-archive-tracker | A script in emacs-lisp to track some statistics about emacs package archives. |
    | lispy | 305 | https://github.com/abo-abo/lispy | vi-like Paredit |
    | helm | 284 | https://github.com/emacs-helm/helm | Emacs incremental completion and selection narrowing framework |
    | melpa | 278 | https://github.com/milkypostman/melpa | Scripts for building Emacs packages from Version Control |
    | remirepo | 265 | https://github.com/remicollet/remirepo | Spec files and patches |
    | gnu-apl-mode | 180 | https://github.com/lokedhs/gnu-apl-mode | GNU APL mode for Emacs |
    | flycheck | 176 | https://github.com/flycheck/flycheck | Modern on the fly syntax checking for GNU Emacs |
    | config | 170 | https://github.com/muflax/config | personal dotfiles |
    | magit | 156 | https://github.com/magit/magit | It's Magit! An Emacs mode for Git. |
    | deepin-emacs | 156 | https://github.com/linuxdeepin/deepin-emacs | Deepin emacs |
    | structured-haskell-mode | 133 | https://github.com/chrisdone/structured-haskell-mode | Structured editing minor mode for Haskell in Emacs |
    | org-trello | 131 | https://github.com/ardumont/org-trello | Org minor mode - 2-way sync org & trello |
    | .emacs.d | 129 | https://github.com/NateEag/.emacs.d | Nate Eagleson's Emacs config. |
    | dot-emacs | 127 | https://github.com/chrisbarrett/dot-emacs | My emacs configuration |
    | ebib | 127 | https://github.com/joostkremers/ebib | A BibTeX database manager for Emacs |
    | ergoemacs-mode | 125 | https://github.com/ergoemacs/ergoemacs-mode | ergoemacs-mode |
    | el-get | 122 | https://github.com/dimitri/el-get | Manage the external elisp bits and pieces upon which you depend! |
    | emacs.d | 121 | https://github.com/redguardtoo/emacs.d | purcell's emacs configuration plus C/C++ support |
    | notes | 121 | https://github.com/beacoder/notes | learning notes |
    | otfrom-org-emacs | 117 | https://github.com/otfrom/otfrom-org-emacs | |
    | aquamacs-emacs | 116 | https://github.com/davidswelt/aquamacs-emacs | The Aquamacs development repo |
    | .emacs.d | 113 | https://github.com/expez/.emacs.d | An opinionated configuration for the One True Editor |
    | settings | 110 | https://github.com/mtanda/settings | |
    | dotfiles | 110 | https://github.com/10sr/dotfiles | my dot files |
    | emacsql | 109 | https://github.com/skeeto/emacsql | A high-level Emacs Lisp front-end for SQLite. |
    | dotfiles-thomasf-emacs | 106 | https://github.com/thomasf/dotfiles-thomasf-emacs | Emacs configuration |
    | emacs_conf | 106 | https://github.com/jixiuf/emacs_conf | all emacs config files on linux |
    | emacs.d | 105 | https://github.com/weareconvo/emacs.d | An Emacs configuration bundle with batteries included |
    | cask | 103 | https://github.com/cask/cask | Emacs dependency management made easy |
    | Pyrulis | 103 | https://github.com/bigos/Pyrulis | Playing with programming languages |
    | emacs-live-packs | 102 | https://github.com/ardumont/emacs-live-packs | My emacs-live packs the git submodule way. |
    | dotemacs | 101 | https://github.com/dholm/dotemacs | My Emacs settings |
    | Emacs_config | 100 | https://github.com/xcv58/Emacs_config | |
    | cider | 99 | https://github.com/clojure-emacs/cider | CIDER is a Clojure IDE and REPL for Emacs |
    | roguel-ike | 98 | https://github.com/stevenremot/roguel-ike | Coffee-break roguelike for Emacs |
    | dotfiles | 98 | https://github.com/andreastt/dotfiles | ato's dotfiles |
    | config | 98 | https://github.com/XANi/config | My configs |
    | emacs | 95 | https://github.com/sunwayforever/emacs | emacs config files |
    | chrisdone-emacs | 95 | https://github.com/chrisdone/chrisdone-emacs | My Emacs configuration |
    | configs | 87 | https://github.com/Kelsin/configs | My personal unix config files |
    | emacs.d | 85 | https://github.com/cbpark/emacs.d | Emacs init files |
    | .emacs.d | 80 | https://github.com/Wilfred/.emacs.d | My emacs configuration, written as literate elisp |
    | dot-emacs | 79 | https://github.com/dhaley/dot-emacs | My .emacs.el file and other personal Emacs goodies |
    | dotfiles | 77 | https://github.com/CQQL/dotfiles | My config files |
    | dotfiles | 77 | https://github.com/asmeurer/dotfiles | A collection of a bunch of my .files |
    | dotemacsd | 77 | https://github.com/mytoh/dotemacsd | |
    | project-explorer | 76 | https://github.com/sabof/project-explorer | A project explorer sidebar |
    | .emacs.d | 75 | https://github.com/littlestone/.emacs.d | null |
    | nae | 75 | https://github.com/hellobear/nae | ������emacs������ |
    | cider | 74 | https://github.com/jonpither/cider | An Emacs client for nREPL, the Clojure networked REPL server |
    | lesliezhu.github.com | 74 | https://github.com/LeslieZhu/lesliezhu.github.com | My GitHub Blog������������������������ |
    | .emacs.d | 73 | https://github.com/ychubachi/.emacs.d | |
    | prodigy.el | 73 | https://github.com/rejeep/prodigy.el | Manage external services from within Emacs |
    | Schimpy | 72 | https://github.com/Chobbes/Schimpy | Language for the formal verification of Arduino code. The compiler generates executable Arduino code, as well as models for both the NuSMV model checker and the PRISM model checker which can be used to verify that certain properties on the program hold. |
    | emacs.d | 72 | https://github.com/RangiLin/emacs.d | My Emacs configurations |
    | emacs.d | 71 | https://github.com/antonio/emacs.d | emacs configuration |
    | zzemacs | 70 | https://github.com/zhoujd/zzemacs | emacs configure |
    | zaufi-overlay | 69 | https://github.com/zaufi/zaufi-overlay | My gentoo ebuilds |
    | clj-refactor.el | 69 | https://github.com/magnars/clj-refactor.el | A tiny collection of clojure refactoring functions for Emacs |
    | dotfiles | 69 | https://github.com/itiut/dotfiles | My dotfiles |
    | malabar-mode | 68 | https://github.com/m0smith/malabar-mode | A better Java mode for Emacs |
    | dotEmacs | 67 | https://github.com/iqbalansari/dotEmacs | My Emacs configuration |
    | .emacs.d | 66 | https://github.com/krismolendyke/.emacs.d | Emacs settings and customizations. |
    | EmacsConfig | 66 | https://github.com/bwolf/EmacsConfig | Emacs configuration, last-recent. |
    | .emacs.d | 64 | https://github.com/scfrazer/.emacs.d | Emacs Config Files |
    | helm-dash | 63 | https://github.com/areina/helm-dash | Browse Dash docsets inside emacs |
    | qachina | 63 | https://github.com/sw2wolf/qachina | |
    | dotfiles | 62 | https://github.com/mcandre/dotfiles | Configuration files |
    | emacsandcheese | 62 | https://github.com/bjoska/emacsandcheese | emacs conf collaboration |
    | dotfiles | 61 | https://github.com/wakiya/dotfiles | |
    | bbdb3 | 60 | https://github.com/barak/bbdb3 | Mirror and debian packaging of reboot of the BBDB Insidious Big Brother Database for Emacs |
    | tubo-env | 60 | https://github.com/yangyingchao/tubo-env | my personal desktop enviroment, including emacs, fvwm, et.al |
    | .emacs.d | 60 | https://github.com/kototama/.emacs.d | Emacs configuration files |
    | dot_files | 59 | https://github.com/syohex/dot_files | My dot files |
    | dot.emacs.d | 59 | https://github.com/muratayusuke/dot.emacs.d | my emacs configration |
    | dotfiles | 59 | https://github.com/knupfer/dotfiles | |
    | .emacs.d | 58 | https://github.com/wkmkymt/.emacs.d | This is my .emacs.d setting files of Emacs23 |
    | emacs.d | 58 | https://github.com/kyleam/emacs.d | emacs configuration |
    | dotemacs | 58 | https://github.com/bling/dotemacs | emacs configuration for vim users |
    | emacs-pow | 58 | https://github.com/yukihr/emacs-pow | Pow (http://pow.cx) apps management on emacs |
    | baboon-emacs | 58 | https://github.com/LouisKottmann/baboon-emacs | Repo for my .emacs |
    | arch-xmonad-zsh | 57 | https://github.com/beloglazov/arch-xmonad-zsh | Arch Linux, Xmonad, Zsh, and friends - my configuration |
    | worf | 56 | https://github.com/abo-abo/worf | vi-like bindings for org-mode |
    | .emacs.d | 56 | https://github.com/senior7515/.emacs.d | my .emacs.d |
    | idris-mode | 55 | https://github.com/idris-hackers/idris-mode | Idris syntax highlighting, compiler-supported editing, interactive REPL and more things for emacs. |
    | es-windows | 55 | https://github.com/sabof/es-windows | Window-management utilities |
    | .emacs.d | 55 | https://github.com/goofansu/.emacs.d | Borrowed from Prelude and Purcell's .emacs.d |
    | steckemacs | 54 | https://github.com/steckerhalter/steckemacs | Emacs configuration/init file that tries to fetch everything necessary from ELPA, Marmelade and MELPA on startup. |
    | .emacs.d | 54 | https://github.com/ermanno/.emacs.d | |
    | helm | 54 | https://github.com/YorkZ/helm | Emacs incremental completion and selection narrowing framework |
    | emacs | 54 | https://github.com/kaz-yos/emacs | my emacs configuration |
    | Emacs.d | 54 | https://github.com/AlexBaranosky/Emacs.d | |
    | rc | 54 | https://github.com/sharad/rc | rc |
    | org | 53 | https://github.com/ardumont/org | My org-mode files, sources for my blog articles, emails, and other notes. |
    | ede-compdb | 52 | https://github.com/randomphrase/ede-compdb | Emacs Development Environment (EDE) wrapper for Compilation Database projects |
    | dotfiles | 52 | https://github.com/pharpend/dotfiles | Various configuration files |
    | xiongyw | 52 | https://github.com/xiongyw/xiongyw | |
    | prog-stuff | 51 | https://github.com/proofit404/prog-stuff | Development environment with it's own package manager. |
    | emacs-helper | 51 | https://github.com/tumashu/emacs-helper | |
  2. abo-abo created this gist Mar 17, 2014.
    8 changes: 8 additions & 0 deletions query.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,8 @@
    select repository_name, count(repository_name) as pushes, repository_description, repository_url
    from [githubarchive:github.timeline]
    where type="PushEvent"
    and repository_language="Emacs Lisp"
    and parse_utc_usec(created_at) >= parse_utc_usec('2014-01-01 00:00:00')
    group by repository_name, repository_description, repository_url
    order by pushes desc
    limit 100