Created
October 8, 2022 02:49
-
-
Save carols10cents/fbb6610030e1a2909300c76a6372f2e7 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT crates.name, created_date, num_versions | |
| FROM ( | |
| SELECT crate_id, date_trunc('day', versions.created_at) AS created_date, count(1) as num_versions | |
| FROM versions | |
| GROUP BY crate_id, created_date | |
| HAVING count(1) > 10 | |
| ) AS foo | |
| INNER JOIN crates ON foo.crate_id = crates.id | |
| ORDER BY num_versions DESC | |
| ; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | created_date | num_versions | |
|---|---|---|---|
| sctpx | 2020-10-18 00:00:00 | 210 | |
| myutil | 2020-10-18 00:00:00 | 210 | |
| myutil | 2020-10-17 00:00:00 | 194 | |
| sctpx | 2020-10-17 00:00:00 | 192 | |
| sctpx | 2020-10-16 00:00:00 | 166 | |
| myutil | 2020-10-16 00:00:00 | 165 | |
| myutil | 2020-10-19 00:00:00 | 65 | |
| gnir | 2019-02-03 00:00:00 | 46 | |
| cargo-pkg | 2020-10-22 00:00:00 | 45 | |
| sctpx | 2020-10-19 00:00:00 | 41 | |
| legal_chess | 2020-10-12 00:00:00 | 41 | |
| resume | 2022-03-04 00:00:00 | 33 | |
| checkout_core | 2022-03-02 00:00:00 | 31 | |
| checkout_server_derive | 2022-03-02 00:00:00 | 31 | |
| air-interpreter-wasm | 2022-09-13 00:00:00 | 30 | |
| test-monorepo-cd1 | 2022-05-13 00:00:00 | 29 | |
| test-monorepo-cd2 | 2022-05-13 00:00:00 | 29 | |
| test-monorepo-cd | 2022-05-13 00:00:00 | 29 | |
| firestore_grpc | 2020-06-10 00:00:00 | 28 | |
| nifty | 2019-05-22 00:00:00 | 24 | |
| solp | 2021-03-09 00:00:00 | 23 | |
| solv | 2021-03-09 00:00:00 | 23 | |
| rustengine | 2020-05-11 00:00:00 | 23 | |
| chwp | 2022-06-20 00:00:00 | 22 | |
| d3ne | 2021-03-03 00:00:00 | 22 | |
| a11ywatch_cli | 2022-05-03 00:00:00 | 22 | |
| air-interpreter-wasm | 2022-09-08 00:00:00 | 21 | |
| hyperlink | 2022-06-04 00:00:00 | 21 | |
| air-interpreter-wasm | 2022-09-06 00:00:00 | 21 | |
| otpcli | 2020-05-03 00:00:00 | 20 | |
| libscemu | 2022-10-05 00:00:00 | 20 | |
| wat-ast | 2020-11-25 00:00:00 | 20 | |
| ttclient | 2020-10-18 00:00:00 | 20 | |
| ttcore | 2020-10-18 00:00:00 | 19 | |
| ttcore_def | 2020-10-18 00:00:00 | 19 | |
| apca | 2020-05-13 00:00:00 | 19 | |
| ttrexec | 2020-10-18 00:00:00 | 19 | |
| speedruns | 2020-02-09 00:00:00 | 19 | |
| kravl-parser | 2017-03-17 00:00:00 | 19 | |
| ejdb2-sys-windows | 2022-06-08 00:00:00 | 19 | |
| ttproxy | 2020-10-18 00:00:00 | 19 | |
| ttserver_def | 2020-10-18 00:00:00 | 18 | |
| flxy | 2021-10-17 00:00:00 | 18 | |
| cargo-pkg | 2020-10-19 00:00:00 | 18 | |
| air-interpreter-wasm | 2022-06-30 00:00:00 | 18 | |
| jstime | 2020-08-21 00:00:00 | 18 | |
| ttserver | 2020-10-18 00:00:00 | 18 | |
| save | 2022-01-11 00:00:00 | 18 | |
| frac | 2021-09-22 00:00:00 | 17 | |
| multisql | 2022-05-12 00:00:00 | 17 | |
| dont_disappear | 2018-09-17 00:00:00 | 17 | |
| hello_exercism | 2019-09-21 00:00:00 | 17 | |
| armory_lib | 2022-05-09 00:00:00 | 17 | |
| air-interpreter-wasm | 2022-09-14 00:00:00 | 17 | |
| snekdown | 2020-05-31 00:00:00 | 16 | |
| kv-derive-impl | 2022-05-17 00:00:00 | 16 | |
| bot_server_client | 2022-08-29 00:00:00 | 16 | |
| ic_scalable_canister | 2022-09-01 00:00:00 | 16 | |
| lichessbot | 2021-01-13 00:00:00 | 16 | |
| assemble_app | 2020-12-27 00:00:00 | 16 | |
| mdi | 2022-07-19 00:00:00 | 16 | |
| test_library | 2019-03-18 00:00:00 | 16 | |
| mdd-soundcloud | 2020-10-01 00:00:00 | 15 | |
| slack-chat-api | 2021-09-17 00:00:00 | 15 | |
| fb_messenger | 2021-01-02 00:00:00 | 15 | |
| envful | 2022-01-24 00:00:00 | 15 | |
| restrust | 2017-01-09 00:00:00 | 15 | |
| cursed-trying-to-break-cargo | 2022-06-25 00:00:00 | 15 | |
| pentest-toolbox | 2019-02-04 00:00:00 | 15 | |
| rdxl_static | 2020-07-22 00:00:00 | 15 | |
| validators | 2018-09-01 00:00:00 | 15 | |
| ffmpeg-dev | 2019-12-09 00:00:00 | 14 | |
| printnanny-api-client | 2022-02-17 00:00:00 | 14 | |
| pwnies | 2017-11-17 00:00:00 | 14 | |
| xapian-rusty | 2020-05-18 00:00:00 | 14 | |
| sml | 2019-04-06 00:00:00 | 14 | |
| cratesio-placeholder-package | 2022-04-28 00:00:00 | 14 | |
| zub | 2020-05-14 00:00:00 | 14 | |
| temprs | 2021-11-20 00:00:00 | 14 | |
| astrolab-smart-coffee-types | 2020-01-23 00:00:00 | 14 | |
| shindanmaker-rs | 2022-09-07 00:00:00 | 14 | |
| dogehouse-rs | 2021-04-10 00:00:00 | 14 | |
| crypto-crawler | 2021-09-30 00:00:00 | 14 | |
| cargo-pants | 2020-07-01 00:00:00 | 14 | |
| render-cli | 2022-04-01 00:00:00 | 14 | |
| libscemu | 2022-10-03 00:00:00 | 14 | |
| doe | 2022-09-22 00:00:00 | 14 | |
| air-interpreter-wasm | 2021-05-10 00:00:00 | 14 | |
| juxr | 2020-07-11 00:00:00 | 14 | |
| ltv | 2021-06-19 00:00:00 | 14 | |
| checkout_core | 2022-03-09 00:00:00 | 14 | |
| coc-rs | 2022-08-29 00:00:00 | 14 | |
| serialize_deserialize_u8_i32 | 2020-03-23 00:00:00 | 14 | |
| surge-constants | 2021-10-25 00:00:00 | 14 | |
| crate-test-xxx | 2020-07-13 00:00:00 | 14 | |
| slack-blocks | 2021-05-10 00:00:00 | 13 | |
| stratum-server | 2020-02-21 00:00:00 | 13 | |
| hck | 2021-07-08 00:00:00 | 13 | |
| stratum-server | 2022-02-17 00:00:00 | 13 | |
| uciengine | 2021-01-05 00:00:00 | 13 | |
| tonic-parser | 2021-10-14 00:00:00 | 13 | |
| scriptisto | 2019-10-25 00:00:00 | 13 | |
| mit-commit | 2020-06-28 00:00:00 | 13 | |
| mancala_board | 2021-02-07 00:00:00 | 13 | |
| air-interpreter-wasm | 2021-09-20 00:00:00 | 13 | |
| stratum-server | 2020-02-20 00:00:00 | 13 | |
| arrsingh-lists | 2021-03-28 00:00:00 | 13 | |
| useful_macro | 2022-03-28 00:00:00 | 13 | |
| imperium | 2020-03-18 00:00:00 | 13 | |
| solp | 2021-03-05 00:00:00 | 13 | |
| mpileup | 2022-09-10 00:00:00 | 13 | |
| broker | 2020-01-01 00:00:00 | 13 | |
| zub | 2020-05-11 00:00:00 | 13 | |
| queue-rs | 2022-09-12 00:00:00 | 13 | |
| htr | 2022-07-28 00:00:00 | 13 | |
| air-interpreter-wasm | 2021-06-01 00:00:00 | 13 | |
| arrows | 2022-01-24 00:00:00 | 13 | |
| expire_map | 2022-07-21 00:00:00 | 13 | |
| e-utils | 2022-08-12 00:00:00 | 13 | |
| indy-crypto | 2017-09-27 00:00:00 | 13 | |
| bdflib | 2020-03-15 00:00:00 | 13 | |
| orasis-plugin | 2019-10-14 00:00:00 | 13 | |
| timetracking | 2021-04-13 00:00:00 | 13 | |
| air-interpreter-wasm | 2021-08-24 00:00:00 | 12 | |
| surge-macros | 2021-10-25 00:00:00 | 12 | |
| air-interpreter-wasm | 2021-12-15 00:00:00 | 12 | |
| minicdn_macros | 2022-07-04 00:00:00 | 12 | |
| int | 2018-11-18 00:00:00 | 12 | |
| assure | 2021-03-31 00:00:00 | 12 | |
| mir | 2019-07-21 00:00:00 | 12 | |
| crypto-cli-tools | 2022-06-10 00:00:00 | 12 | |
| rcut | 2020-04-17 00:00:00 | 12 | |
| nom-packrat-macros | 2019-07-25 00:00:00 | 12 | |
| ross-config | 2021-11-27 00:00:00 | 12 | |
| minicdn | 2022-07-04 00:00:00 | 12 | |
| indy-sys | 2021-03-24 00:00:00 | 12 | |
| cronos-program | 2022-02-08 00:00:00 | 12 | |
| robin_core | 2017-09-15 00:00:00 | 12 | |
| arrsingh | 2021-03-28 00:00:00 | 12 | |
| air-interpreter-wasm | 2021-10-05 00:00:00 | 12 | |
| genco-macros | 2020-06-21 00:00:00 | 12 | |
| manifest-dir-macros | 2021-05-05 00:00:00 | 12 | |
| cuprite | 2021-12-09 00:00:00 | 12 | |
| wasmir | 2021-06-09 00:00:00 | 12 | |
| shess | 2021-03-20 00:00:00 | 12 | |
| hcal | 2020-12-25 00:00:00 | 12 | |
| elf-utilities | 2020-04-30 00:00:00 | 12 | |
| file-watcher | 2019-05-01 00:00:00 | 12 | |
| pikkr | 2017-09-01 00:00:00 | 12 | |
| flaky-finder | 2019-09-18 00:00:00 | 12 | |
| tailwind-css | 2022-02-25 00:00:00 | 12 | |
| sn_routing | 2021-04-21 00:00:00 | 12 | |
| rhyoea-common | 2021-01-19 00:00:00 | 12 | |
| genco | 2020-06-21 00:00:00 | 12 | |
| sv-parser-error | 2019-12-12 00:00:00 | 12 | |
| zapp | 2022-06-17 00:00:00 | 12 | |
| http-protocol | 2021-04-24 00:00:00 | 12 | |
| bracket | 2020-11-24 00:00:00 | 12 | |
| a11ywatch_cli | 2022-08-03 00:00:00 | 12 | |
| macademia | 2022-09-07 00:00:00 | 12 | |
| aspiesolutions_core | 2022-03-21 00:00:00 | 12 | |
| chrono_elapsed | 2021-07-04 00:00:00 | 12 | |
| mmr-crypto-primitives | 2022-03-14 00:00:00 | 12 | |
| ruwren | 2020-05-31 00:00:00 | 12 | |
| gzlib | 2021-01-27 00:00:00 | 12 | |
| swears | 2019-12-11 00:00:00 | 12 | |
| set_slice | 2018-07-17 00:00:00 | 12 | |
| checkout_server_derive | 2022-02-05 00:00:00 | 11 | |
| robin_core | 2017-12-03 00:00:00 | 11 | |
| art_p256 | 2020-12-20 00:00:00 | 11 | |
| qcs | 2022-09-23 00:00:00 | 11 | |
| lsd | 2018-12-06 00:00:00 | 11 | |
| printnanny-api-client | 2021-11-25 00:00:00 | 11 | |
| astrolab-smart-coffee-types | 2020-10-26 00:00:00 | 11 | |
| poloto | 2022-03-17 00:00:00 | 11 | |
| chwp | 2022-07-03 00:00:00 | 11 | |
| a11ywatch_cli | 2022-08-02 00:00:00 | 11 | |
| nwn-rs-tool | 2022-08-07 00:00:00 | 11 | |
| cargo_crates-io_docs-rs_test | 2019-01-04 00:00:00 | 11 | |
| k8s-cluster-api | 2021-12-09 00:00:00 | 11 | |
| advent_of_code_rs | 2020-09-09 00:00:00 | 11 | |
| print-nanny-client | 2021-07-17 00:00:00 | 11 | |
| easylog | 2018-06-09 00:00:00 | 11 | |
| jwt-simple | 2020-08-30 00:00:00 | 11 | |
| wordcrab | 2019-10-18 00:00:00 | 11 | |
| flow-rust-sdk | 2021-10-15 00:00:00 | 11 | |
| surge-samplerate | 2021-10-25 00:00:00 | 11 | |
| minicdn_core | 2022-07-04 00:00:00 | 11 | |
| crossbow | 2022-08-10 00:00:00 | 11 | |
| cargo-cvm | 2020-08-11 00:00:00 | 11 | |
| kafka-threadpool | 2022-09-22 00:00:00 | 11 | |
| zub | 2020-05-19 00:00:00 | 11 | |
| surge-math | 2021-10-25 00:00:00 | 11 | |
| rustengine | 2020-05-13 00:00:00 | 11 | |
| easy_cargo_dep_B | 2022-03-21 00:00:00 | 11 | |
| air-interpreter-wasm | 2021-12-29 00:00:00 | 11 | |
| rcz | 2022-09-22 00:00:00 | 11 | |
| checkout_core | 2022-02-07 00:00:00 | 11 | |
| synterm | 2020-03-27 00:00:00 | 11 | |
| surge-param | 2021-10-25 00:00:00 | 11 | |
| triangle | 2020-12-13 00:00:00 | 11 | |
| ejdb2-sys-windows | 2022-06-14 00:00:00 | 11 | |
| fixed-vectors | 2022-01-17 00:00:00 | 11 | |
| sovrin-client | 2017-05-05 00:00:00 | 11 | |
| a11ywatch_cli | 2022-05-19 00:00:00 | 11 | |
| rust-clacc | 2020-07-18 00:00:00 | 11 | |
| kya | 2021-10-31 00:00:00 | 11 | |
| llvm-sys | 2020-08-27 00:00:00 | 11 | |
| dbg-swc | 2022-09-28 00:00:00 | 11 | |
| json-rpc2 | 2021-02-24 00:00:00 | 11 | |
| serialize_deserialize_u8_i32 | 2020-04-03 00:00:00 | 11 | |
| buldak | 2020-10-15 00:00:00 | 11 | |
| rvmti | 2022-08-19 00:00:00 | 11 | |
| parsley-rs | 2022-07-20 00:00:00 | 11 | |
| checkout_core | 2022-02-06 00:00:00 | 11 | |
| dinghy-build | 2021-02-15 00:00:00 | 11 | |
| libruster | 2021-11-24 00:00:00 | 11 | |
| advent-of-code | 2020-12-09 00:00:00 | 11 | |
| gnir | 2019-08-09 00:00:00 | 11 | |
| maxmind_geo_ip2 | 2021-04-18 00:00:00 | 11 | |
| genpass | 2018-05-05 00:00:00 | 11 | |
| rmodbus | 2020-09-13 00:00:00 | 11 | |
| mailslurp | 2021-04-24 00:00:00 | 11 | |
| syscoin | 2019-02-04 00:00:00 | 11 | |
| windows_macros | 2021-07-07 00:00:00 | 11 | |
| air-interpreter-wasm | 2022-02-25 00:00:00 | 11 | |
| circular-resources | 2022-03-11 00:00:00 | 11 | |
| dinghy-test | 2021-02-15 00:00:00 | 11 | |
| actix-web-utils | 2022-08-31 00:00:00 | 11 | |
| afk | 2021-12-17 00:00:00 | 11 | |
| u-siem | 2021-10-16 00:00:00 | 11 | |
| cargo-webassembly | 2020-11-27 00:00:00 | 11 | |
| sv-parser-macros | 2019-12-12 00:00:00 | 11 | |
| crusty-core | 2021-06-23 00:00:00 | 11 | |
| windows_gen | 2021-07-07 00:00:00 | 11 | |
| closest-sum-pair | 2021-07-24 00:00:00 | 11 | |
| systemathics-apis | 2022-09-06 00:00:00 | 11 | |
| simple-syrup | 2022-02-05 00:00:00 | 11 | |
| do-not-use-this-hello_cratesio | 2022-07-07 00:00:00 | 11 | |
| air-interpreter-wasm_security_tetraplets_reborn | 2020-12-22 00:00:00 | 11 | |
| svecli | 2022-02-19 00:00:00 | 11 | |
| air-interpreter-wasm | 2021-02-16 00:00:00 | 11 | |
| uniffi_swiftpkg_gen | 2022-02-14 00:00:00 | 11 | |
| html-to-react | 2022-07-13 00:00:00 | 11 | |
| yaksay | 2020-06-10 00:00:00 | 11 | |
| swc_core | 2022-09-10 00:00:00 | 11 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment