awesome-repositories.com
博客
awesome-repositories.com

通过 AI 驱动的搜索,发现最优秀的开源仓库。

探索精选搜索开源替代品自托管软件博客网站地图
项目关于排名机制媒体报道MCP 服务器
法律隐私政策服务条款
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·

57 个仓库

Awesome GitHub RepositoriesQuery Aggregates

Utilities for performing mathematical calculations on database query results.

Distinguishing note: Focuses on aggregate functions like count and sum.

Explore 57 awesome GitHub repositories matching data & databases · Query Aggregates. Refine with filters or upvote what's useful.

Awesome Query Aggregates GitHub Repositories

用 AI 发现最棒的仓库。我们将通过 AI 为您搜索最匹配的仓库。
  • vapor/vaporvapor 的头像

    vapor/vapor

    26,138在 GitHub 上查看↗

    Vapor is a comprehensive server-side web framework designed for building scalable, high-performance applications and APIs in Swift. It provides a non-blocking, event-loop-based runtime that manages concurrent task processing, background job queues, and asynchronous request handling. The framework is built around a dependency injection container that manages the lifecycle and resolution of services, configurations, and database connections throughout the request pipeline. The framework distinguishes itself through a protocol-oriented design that emphasizes type safety across all layers of the

    Calculates aggregates like counts and sums directly within database queries.

    Swiftframeworkhttphttp2
    在 GitHub 上查看↗26,138
  • cube-js/cubecube-js 的头像

    cube-js/cube

    20,251在 GitHub 上查看↗

    Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orches

    Converts aggregate measures into per-row values to enable complex nested calculations.

    Rustagentic-analyticsagentsai
    在 GitHub 上查看↗20,251
  • tencent/apijsonTencent 的头像

    Tencent/APIJSON

    18,395在 GitHub 上查看↗

    APIJSON is a no-code database API generator and object-relational mapping layer that automatically transforms relational database schemas into functional HTTP endpoints. It provides a system for generating CRUD operations and technical documentation without the need to write manual backend code. The project is distinguished by its ability to allow clients to define custom JSON response structures and field aliases directly within the request. It features dynamic query translation that converts structured JSON parameters into optimized SQL for complex relational joins, subqueries, and data agg

    Provides utilities for performing mathematical calculations like count and sum on database query results.

    Javabaasclickhousecrud
    在 GitHub 上查看↗18,395
  • rstacruz/cheatsheetsrstacruz 的头像

    rstacruz/cheatsheets

    14,429在 GitHub 上查看↗

    This project is a comprehensive collection of web development reference guides and technical cheat sheets. It provides a curated set of markdown-based documentation designed to help developers quickly locate syntax patterns and API examples for common web technologies and programming languages. The repository serves as a specialized reference library covering several distinct technical domains. It includes extensive guides for CSS, focusing on selectors, Flexbox, Grid, and responsive layout properties, as well as a DevOps command reference for Docker, Kubernetes, AWS, Ansible, and general she

    Offers a reference for performing mathematical calculations like count and sum on database results.

    SCSS
    在 GitHub 上查看↗14,429
  • graphile/crystalgraphile 的头像

    graphile/crystal

    12,931在 GitHub 上查看↗

    🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!

    Implement cursor-based pagination compatible with Relay specifications for efficient traversal of large result sets.

    TypeScriptapiautomatic-apiexpress
    在 GitHub 上查看↗12,931
  • emdash-cms/emdashemdash-cms 的头像

    emdash-cms/emdash

    10,887在 GitHub 上查看↗

    EmDash is an open-source content management system built on Astro that combines a visual admin panel with a plugin-driven architecture and server-side rendering. It provides a complete content management system with structured content modeling, a rich text editor using Portable Text format, and a TypeScript API for type-safe content queries. The system supports authentication through passkeys, OAuth 2.1, and external providers, with role-based access control and fine-grained permission scopes. What distinguishes EmDash is its plugin development framework, which supports both native plugins ru

    Returns cursor-based paginated lists from storage queries, matching the platform's standard pagination shape.

    TypeScriptastrocmsemdash
    在 GitHub 上查看↗10,887
  • doctrine/ormdoctrine 的头像

    doctrine/orm

    10,172在 GitHub 上查看↗

    Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

    Supports computing aggregate values like sums, counts, and minimums directly through query logic.

    PHPhacktoberfest
    在 GitHub 上查看↗10,172
  • studio3t/robomongoStudio3T 的头像

    Studio3T/robomongo

    9,369在 GitHub 上查看↗

    RoboMongo is a cross-platform database manager and graphical interface for administering MongoDB databases. It serves as a shell integrated development environment and query tool for managing NoSQL data stores and exploring collections across multiple server instances. The application provides a visual environment for writing and executing modern JavaScript scripts and native shell commands. It includes capabilities for running aggregate queries with paginated results and supports side-by-side views for comparing data outputs. The tool covers remote database connectivity through SSH tunnelin

    Navigates through large aggregate result sets using page-based loading to maintain high performance.

    C++
    在 GitHub 上查看↗9,369
  • seaql/sea-ormSeaQL 的头像

    SeaQL/sea-orm

    9,410在 GitHub 上查看↗

    Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements. The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan

    Calculates summary statistics such as sums, averages, and counts across database records.

    Rustdatabasehacktoberfestloco
    在 GitHub 上查看↗9,410
  • googleapis/google-api-python-clientgoogleapis 的头像

    googleapis/google-api-python-client

    8,863在 GitHub 上查看↗

    该项目是一个 REST API 客户端库和 Google Cloud SDK 组件,将 Python 应用程序与 Google 服务集成。它作为一个基于发现的 API 客户端,利用 OAuth 2.0 集成库通过访问令牌和服务帐户来保护请求并验证身份。 该库的特色在于使用发现文档在运行时动态生成客户端。通过解析 JSON 元数据,它将 Python 方法调用映射到 HTTP 请求,并构建镜像远程服务层次结构的基于接口的资源模型。 其更广泛的功能涵盖云基础设施管理、数字广告自动化和企业帐户管理。该工具包包括用于处理大数据集分页、为二进制数据执行可恢复上传协议以及通过 API 响应模拟进行质量保证的实用程序。 该库还通过将发现文档与可用的服务接口相结合,提供技术文档生成功能。

    Iterates through large datasets by automatically extracting and passing continuation tokens from server responses.

    Python
    在 GitHub 上查看↗8,863
  • aws/aws-sdk-goaws 的头像

    aws/aws-sdk-go

    8,687在 GitHub 上查看↗

    The AWS SDK for Go is a software development kit and cloud infrastructure library used to programmatically interact with AWS cloud services. It provides a programmatic interface for authenticating requests, executing operations against regional endpoints, and automating the creation and management of cloud resources. The toolkit utilizes model-driven code generation to create service clients and employs a session-based configuration system to share credentials and global settings across those clients. It implements signature-based request authentication to verify identity and integrity throug

    Handles large result sets using callback functions to iterate through paginated API responses.

    Go
    在 GitHub 上查看↗8,687
  • modelcontextprotocol/inspectormodelcontextprotocol 的头像

    modelcontextprotocol/inspector

    8,721在 GitHub 上查看↗

    The inspector is a diagnostic and validation tool for the Model Context Protocol. It provides an interactive interface and a transport proxy to discover, inspect, and execute the tools, prompts, and resources provided by an MCP server. The project serves as a debugger and compliance tester to verify that server implementations adhere to the protocol specification and JSON-RPC standards. It allows for real-time monitoring of message exchanges and logs between clients and servers across various transport layers, such as standard input/output and Server-Sent Events. The tool covers a broad rang

    Returns lists of available resources, templates, and tools in smaller paginated chunks to optimize performance.

    TypeScript
    在 GitHub 上查看↗8,721
  • paradedb/paradedbparadedb 的头像

    paradedb/paradedb

    8,370在 GitHub 上查看↗

    ParadeDB is a database extension that integrates full-text search, vector database capabilities, and real-time analytics directly into a relational engine. It functions as a plugin that adds new storage and query execution capabilities to an existing database architecture. The project distinguishes itself by supporting hybrid search workflows that combine lexical keyword matching with dense and sparse vector similarity in a single query. It utilizes reciprocal rank fusion to merge these ranked result sets and employs logical replication to synchronize data from external instances, removing th

    Executes JSON aggregate queries using a columnar index to accelerate data counting and summarization.

    Rustaggregationsanalyticsbm25
    在 GitHub 上查看↗8,370
  • thinkgem/jeesitethinkgem 的头像

    thinkgem/jeesite

    8,044在 GitHub 上查看↗

    Jeesite is a full-stack low-code development framework designed for building enterprise administrative portals using Spring Boot, MyBatis, and Vue. It functions as a comprehensive platform for creating administrative dashboards with integrated role-based access control and organizational data permission systems. The framework distinguishes itself through a combination of automated CRUD code generation and an integrated RAG platform that connects large language models to enterprise data via vector stores. It further incorporates a BPMN-based workflow engine to automate complex business process

    Implements request-based pagination across application layers to return large data sets in chunks.

    Vue
    在 GitHub 上查看↗8,044
  • civitai/civitaicivitai 的头像

    civitai/civitai

    7,158在 GitHub 上查看↗

    Civitai is a platform for generative media creation and AI model distribution. It provides a centralized service for producing images, videos, audio, and music, while serving as a repository where users can share, discover, and browse custom model weights and fine-tuned adaptations. The platform distinguishes itself through a provider-agnostic orchestration layer that manages multi-step generation pipelines and complex workflows across different backends. It integrates with autonomous AI agents and editors via the Model Context Protocol, allowing external tools to access generation pipelines

    Uses server-provided tokens for sequential retrieval of large datasets to manage system load.

    TypeScriptaisocial-networkstable-diffusion
    在 GitHub 上查看↗7,158
  • hyperf/hyperfhyperf 的头像

    hyperf/hyperf

    6,855在 GitHub 上查看↗

    Hyperf is a high-performance PHP coroutine framework designed for building microservices and middleware. It utilizes non-blocking coroutines to handle high concurrency and low-latency request processing, providing a foundation for scalable distributed systems. The framework is distinguished by an aspect-oriented programming based dependency injector that enables pluggable components and meta-programming. It includes a coroutine-optimized object-relational mapper with integrated model caching and an orchestration toolkit for microservice governance, featuring service discovery, circuit breaker

    Provides built-in aggregate functions like sum, average, and count for database datasets.

    PHP
    在 GitHub 上查看↗6,855
  • ankane/searchkickankane 的头像

    ankane/searchkick

    6,717在 GitHub 上查看↗

    Searchkick is an integration library and wrapper that connects application models to search engines such as Elasticsearch and OpenSearch. It functions as a search index synchronizer, automatically mirroring database records to a search server to enable full-text and vector retrieval. The project provides a high-level interface for implementing keyword search, semantic vector search, and hybrid search. It distinguishes itself through the ability to combine traditional keyword matching with vector embeddings using reranking and fusion techniques to improve precision. The library covers the end

    Chunks large search result sets into pages with support for deep paging.

    Ruby
    在 GitHub 上查看↗6,717
  • hazelcast/hazelcasthazelcast 的头像

    hazelcast/hazelcast

    6,570在 GitHub 上查看↗

    Hazelcast is a distributed data platform that combines an in-memory data grid with a stream processing engine to support real-time analytics and event-driven applications. It functions as a partitioned, distributed key-value store that replicates data across cluster nodes to provide low-latency access and high availability. The platform also serves as a distributed SQL query engine, allowing users to execute standard SQL statements against both in-memory datasets and external data sources. What distinguishes Hazelcast is its use of a distributed consensus subsystem to maintain strongly consis

    Retrieves filtered query results in discrete pages to manage large datasets and reduce memory overhead.

    Javabig-datacachingdata-in-motion
    在 GitHub 上查看↗6,570
  • aws/aws-sdk-phpaws 的头像

    aws/aws-sdk-php

    6,191在 GitHub 上查看↗

    The AWS SDK for PHP is a software development kit that provides HTTP client classes for every supported Amazon Web Service, enabling PHP applications to send authenticated requests and receive structured, typed response objects. It includes a credential resolution chain that automatically locates credentials from environment variables, instance profiles, or configuration files, and supports promise-based asynchronous execution for running multiple API calls concurrently to improve throughput. The SDK distinguishes itself through a middleware pipeline architecture that allows interception and

    Iterates over large result sets from AWS services automatically, fetching subsequent pages without manual pagination logic.

    PHP
    在 GitHub 上查看↗6,191
  • redisearch/redisearchRediSearch 的头像

    RediSearch/RediSearch

    6,161在 GitHub 上查看↗

    RediSearch is a Redis module that adds secondary indexing, full-text search, aggregation, and vector similarity search directly into the in-memory data store. It operates as an in-process search engine, extending the core key-value store with capabilities for indexing hash and JSON documents, enabling fast field-level lookups beyond primary key access. The module provides a full-text search engine built on inverted indexes, supporting stemming, fuzzy matching, and relevance scoring via tf-idf. It also includes a vector similarity search engine using a Hierarchical Navigable Small World graph

    Retrieves aggregation results incrementally using server-provided cursor tokens for pagination.

    Cfulltextgeospatialgis
    在 GitHub 上查看↗6,161
上一个123下一个
  1. Home
  2. Data & Databases
  3. Query Aggregates

探索子标签

  • Aggregate Push-Ups1 个子标签Optimization that moves aggregate computation from a subquery into the outer query to avoid redundant calculations. **Distinct from Query Aggregates:** Distinct from Query Aggregates: focuses on the optimization technique of relocating aggregation, not the aggregate functions themselves.
  • Paginated Results6 个子标签Mechanisms for loading aggregated query results in discrete pages to optimize performance. **Distinct from Query Aggregates:** Focuses on the pagination of aggregate outputs for readability rather than the math of the aggregation
  • Subquery AggregationsCalculating scalar aggregate values from related records within a subquery for every row in a result set. **Distinct from Query Aggregates:** Focuses specifically on using subqueries to produce aggregate scalars, whereas Query Aggregates is for general results.