{"data":[{"id":2,"last_2nd_month_rank":5,"last_month_rank":1,"name":"Open Source Database","rank":1,"rank_changes":4,"repo_id":208728772,"repo_name":"milvus-io/milvus","repos":40,"visits":2900},{"id":2,"last_2nd_month_rank":1,"last_month_rank":2,"name":"Open Source Database","rank":2,"rank_changes":-1,"repo_id":138754790,"repo_name":"duckdb/duckdb","repos":40,"visits":2900},{"id":2,"last_2nd_month_rank":2,"last_month_rank":3,"name":"Open Source Database","rank":3,"rank_changes":-1,"repo_id":60246359,"repo_name":"ClickHouse/ClickHouse","repos":40,"visits":2900},{"id":10013,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Game Engine","rank":1,"rank_changes":0,"repo_id":15634981,"repo_name":"godotengine/godot","repos":72,"visits":209},{"id":10013,"last_2nd_month_rank":5,"last_month_rank":2,"name":"Game Engine","rank":2,"rank_changes":3,"repo_id":11007313,"repo_name":"BabylonJS/Babylon.js","repos":72,"visits":209},{"id":10013,"last_2nd_month_rank":2,"last_month_rank":3,"name":"Game Engine","rank":3,"rank_changes":-1,"repo_id":234798675,"repo_name":"bevyengine/bevy","repos":72,"visits":209},{"id":10005,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Javascript Framework","rank":1,"rank_changes":0,"repo_id":10270250,"repo_name":"facebook/react","repos":32,"visits":37},{"id":10005,"last_2nd_month_rank":5,"last_month_rank":2,"name":"Javascript Framework","rank":2,"rank_changes":3,"repo_id":137078487,"repo_name":"vuejs/core","repos":32,"visits":37},{"id":10005,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Javascript Framework","rank":3,"rank_changes":1,"repo_id":11730342,"repo_name":"vuejs/vue","repos":32,"visits":37},{"id":10063,"last_2nd_month_rank":2,"last_month_rank":1,"name":"Kubernetes Tooling","rank":1,"rank_changes":1,"repo_id":59239347,"repo_name":"portainer/portainer","repos":33,"visits":28},{"id":10063,"last_2nd_month_rank":1,"last_month_rank":3,"name":"Kubernetes Tooling","rank":3,"rank_changes":-2,"repo_id":527578222,"repo_name":"komodorio/helm-dashboard","repos":33,"visits":28},{"id":10063,"last_2nd_month_rank":8,"last_month_rank":2,"name":"Kubernetes Tooling","rank":2,"rank_changes":6,"repo_id":359419233,"repo_name":"kubeshark/kubeshark","repos":33,"visits":28},{"id":10050,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Open Source Forum Software","rank":1,"rank_changes":0,"repo_id":542931741,"repo_name":"apache/answer","repos":9,"visits":24},{"id":10050,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Open Source Forum Software","rank":2,"rank_changes":0,"repo_id":7569578,"repo_name":"discourse/discourse","repos":9,"visits":24},{"id":10050,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Open Source Forum Software","rank":3,"rank_changes":1,"repo_id":170729130,"repo_name":"LemmyNet/lemmy","repos":9,"visits":24},{"id":10030,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Finance","rank":1,"rank_changes":0,"repo_id":323048702,"repo_name":"OpenBB-finance/OpenBB","repos":14,"visits":23},{"id":10030,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Finance","rank":2,"rank_changes":0,"repo_id":31522041,"repo_name":"vnpy/vnpy","repos":14,"visits":23},{"id":10030,"last_2nd_month_rank":5,"last_month_rank":3,"name":"Finance","rank":3,"rank_changes":2,"repo_id":287463830,"repo_name":"microsoft/qlib","repos":14,"visits":23},{"id":1,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Static Site Generator","rank":1,"rank_changes":0,"repo_id":70107786,"repo_name":"vercel/next.js","repos":35,"visits":21},{"id":10047,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Terminal","rank":2,"rank_changes":0,"repo_id":77213120,"repo_name":"Eugeny/tabby","repos":20,"visits":21},{"id":10047,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Terminal","rank":3,"rank_changes":1,"repo_id":384219990,"repo_name":"warpdotdev/Warp","repos":20,"visits":21},{"id":10047,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Terminal","rank":1,"rank_changes":0,"repo_id":291137,"repo_name":"ohmyzsh/ohmyzsh","repos":20,"visits":21},{"id":1,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Static Site Generator","rank":3,"rank_changes":1,"repo_id":94911145,"repo_name":"facebook/docusaurus","repos":35,"visits":21},{"id":1,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Static Site Generator","rank":2,"rank_changes":0,"repo_id":348060227,"repo_name":"withastro/astro","repos":35,"visits":21},{"id":10064,"last_2nd_month_rank":null,"last_month_rank":1,"name":"Javascript Build Tool","rank":1,"rank_changes":null,"repo_id":476642602,"repo_name":"web-infra-dev/rspack","repos":13,"visits":21},{"id":10064,"last_2nd_month_rank":1,"last_month_rank":2,"name":"Javascript Build Tool","rank":2,"rank_changes":-1,"repo_id":257485422,"repo_name":"vitejs/vite","repos":13,"visits":21},{"id":10064,"last_2nd_month_rank":2,"last_month_rank":3,"name":"Javascript Build Tool","rank":3,"rank_changes":-1,"repo_id":413918947,"repo_name":"vercel/turborepo","repos":13,"visits":21},{"id":10025,"last_2nd_month_rank":3,"last_month_rank":2,"name":"Distributed File Storage","rank":2,"rank_changes":1,"repo_id":21827146,"repo_name":"seaweedfs/seaweedfs","repos":16,"visits":20},{"id":10025,"last_2nd_month_rank":2,"last_month_rank":3,"name":"Distributed File Storage","rank":3,"rank_changes":-1,"repo_id":327859577,"repo_name":"juicedata/juicefs","repos":16,"visits":20},{"id":10025,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Distributed File Storage","rank":1,"rank_changes":0,"repo_id":29261473,"repo_name":"minio/minio","repos":16,"visits":20}],"expiresAt":"2026-06-07T15:10:59.295+00:00","fields":[{"columnType":8,"name":"id"},{"columnType":253,"name":"name"},{"columnType":3,"name":"visits"},{"columnType":8,"name":"repo_id"},{"columnType":253,"name":"repo_name"},{"columnType":8,"name":"rank"},{"columnType":3,"name":"last_month_rank"},{"columnType":3,"name":"last_2nd_month_rank"},{"columnType":8,"name":"rank_changes"},{"columnType":8,"name":"repos"}],"finishedAt":"2026-06-06T15:10:59.295+00:00","params":{},"requestedAt":"2026-06-06T15:10:59.265+00:00","spent":0.03,"sql":"WITH top_10_collections AS (\n\tSELECT c.id, c.name, c.past_month_visits\n\tFROM collections c\n\tORDER BY c.past_month_visits DESC\n\tLIMIT 10\n)\nSELECT *\nFROM (\n\tSELECT\n\t\ttc.id,\n\t\ttc.name,\n\t\ttc.past_month_visits AS visits,\n\t\tci.repo_id,\n\t\tci.repo_name,\n\t\tROW_NUMBER() OVER (PARTITION BY ci.collection_id ORDER BY IFNULL(ci.last_month_rank, 999999)) AS `rank`,\n\t\tci.last_month_rank,\n\t\tci.last_2nd_month_rank,\n\t\t(ci.last_2nd_month_rank - ci.last_month_rank) AS rank_changes,\n\t\tCOUNT(*) OVER (PARTITION BY ci.collection_id) AS repos\n\tFROM collection_items ci\n\tJOIN top_10_collections tc ON ci.collection_id = tc.id\n) sub\nWHERE `rank` <= 3\nORDER BY visits DESC;\n","expiredAt":"2026-06-07T15:10:59.295+00:00"}