{"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":1582},{"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":1582},{"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":1582},{"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":261},{"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":261},{"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":261},{"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":87},{"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":87},{"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":87},{"id":10001,"last_2nd_month_rank":1,"last_month_rank":1,"name":"CSS Framework","rank":1,"rank_changes":0,"repo_id":106017343,"repo_name":"tailwindlabs/tailwindcss","repos":8,"visits":85},{"id":10001,"last_2nd_month_rank":2,"last_month_rank":2,"name":"CSS Framework","rank":2,"rank_changes":0,"repo_id":2126244,"repo_name":"twbs/bootstrap","repos":8,"visits":85},{"id":10001,"last_2nd_month_rank":3,"last_month_rank":3,"name":"CSS Framework","rank":3,"rank_changes":0,"repo_id":50264296,"repo_name":"jgthms/bulma","repos":8,"visits":85},{"id":10010,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Artificial Intelligence","rank":3,"rank_changes":1,"repo_id":65600975,"repo_name":"pytorch/pytorch","repos":36,"visits":70},{"id":10010,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Artificial Intelligence","rank":2,"rank_changes":0,"repo_id":458588993,"repo_name":"nebuly-ai/optimate","repos":36,"visits":70},{"id":10010,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Artificial Intelligence","rank":1,"rank_changes":0,"repo_id":155220641,"repo_name":"huggingface/transformers","repos":36,"visits":70},{"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":70},{"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":70},{"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":70},{"id":10027,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Testing Tools","rank":1,"rank_changes":0,"repo_id":221981891,"repo_name":"microsoft/playwright","repos":24,"visits":68},{"id":10027,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Testing Tools","rank":2,"rank_changes":0,"repo_id":90796663,"repo_name":"puppeteer/puppeteer","repos":24,"visits":68},{"id":10027,"last_2nd_month_rank":4,"last_month_rank":3,"name":"Testing Tools","rank":3,"rank_changes":1,"repo_id":31629751,"repo_name":"cypress-io/cypress","repos":24,"visits":68},{"id":10004,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Web Framework","rank":1,"rank_changes":0,"repo_id":331293626,"repo_name":"refinedev/refine","repos":63,"visits":68},{"id":10004,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Web Framework","rank":2,"rank_changes":0,"repo_id":80945428,"repo_name":"nestjs/nest","repos":63,"visits":68},{"id":10004,"last_2nd_month_rank":3,"last_month_rank":3,"name":"Web Framework","rank":3,"rank_changes":0,"repo_id":20904437,"repo_name":"gin-gonic/gin","repos":63,"visits":68},{"id":10019,"last_2nd_month_rank":2,"last_month_rank":2,"name":"React Framework","rank":2,"rank_changes":0,"repo_id":331293626,"repo_name":"refinedev/refine","repos":11,"visits":67},{"id":10019,"last_2nd_month_rank":3,"last_month_rank":3,"name":"React Framework","rank":3,"rank_changes":0,"repo_id":94911145,"repo_name":"facebook/docusaurus","repos":11,"visits":67},{"id":10019,"last_2nd_month_rank":1,"last_month_rank":1,"name":"React Framework","rank":1,"rank_changes":0,"repo_id":70107786,"repo_name":"vercel/next.js","repos":11,"visits":67},{"id":10029,"last_2nd_month_rank":1,"last_month_rank":1,"name":"Cross Platform GUI Tool","rank":1,"rank_changes":0,"repo_id":196701619,"repo_name":"tauri-apps/tauri","repos":12,"visits":67},{"id":10029,"last_2nd_month_rank":2,"last_month_rank":2,"name":"Cross Platform GUI Tool","rank":2,"rank_changes":0,"repo_id":31792824,"repo_name":"flutter/flutter","repos":12,"visits":67},{"id":10029,"last_2nd_month_rank":3,"last_month_rank":3,"name":"Cross Platform GUI Tool","rank":3,"rank_changes":0,"repo_id":29028775,"repo_name":"facebook/react-native","repos":12,"visits":67}],"expiresAt":"2026-07-24T02:13:18.984+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-07-23T02:13:18.984+00:00","params":{},"requestedAt":"2026-07-23T02:13:18.955+00:00","spent":0.029,"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-07-24T02:13:18.984+00:00"}