awesome-repositories.com
Blog
awesome-repositories.com

Découvrez les meilleurs dépôts open-source grâce à notre recherche par IA.

ExplorerRecherches sélectionnéesAlternatives open sourceLogiciels auto-hébergésBlogPlan du site
ProjetÀ proposNotre méthodologiePresseServeur MCP
Mentions légalesConfidentialitéConditions d'utilisation
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·

57 dépôts

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

Trouvez les meilleurs dépôts grâce à l'IA.Nous recherchons les dépôts les plus pertinents grâce à l'IA.
  • vapor/vaporAvatar de vapor

    vapor/vapor

    26,138Voir sur 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
    Voir sur GitHub↗26,138
  • cube-js/cubeAvatar de cube-js

    cube-js/cube

    20,251Voir sur 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
    Voir sur GitHub↗20,251
  • tencent/apijsonAvatar de Tencent

    Tencent/APIJSON

    18,395Voir sur 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
    Voir sur GitHub↗18,395
  • rstacruz/cheatsheetsAvatar de rstacruz

    rstacruz/cheatsheets

    14,429Voir sur 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
    Voir sur GitHub↗14,429
  • graphile/crystalAvatar de graphile

    graphile/crystal

    12,931Voir sur 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
    Voir sur GitHub↗12,931
  • emdash-cms/emdashAvatar de emdash-cms

    emdash-cms/emdash

    10,887Voir sur 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
    Voir sur GitHub↗10,887
  • doctrine/ormAvatar de doctrine

    doctrine/orm

    10,172Voir sur 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
    Voir sur GitHub↗10,172
  • studio3t/robomongoAvatar de Studio3T

    Studio3T/robomongo

    9,369Voir sur 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++
    Voir sur GitHub↗9,369
  • seaql/sea-ormAvatar de SeaQL

    SeaQL/sea-orm

    9,410Voir sur 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
    Voir sur GitHub↗9,410
  • googleapis/google-api-python-clientAvatar de googleapis

    googleapis/google-api-python-client

    8,863Voir sur GitHub↗

    Ce projet est une bibliothèque cliente d'API REST et un composant du Google Cloud SDK qui intègre les applications Python aux services Google. Il fonctionne comme un client d'API basé sur la découverte, utilisant une bibliothèque d'intégration OAuth 2.0 pour sécuriser les requêtes et vérifier l'identité via des jetons d'accès et des comptes de service. La bibliothèque se distingue par l'utilisation de documents de découverte pour générer dynamiquement des clients à l'exécution. En analysant les métadonnées JSON, elle mappe les appels de méthodes Python vers des requêtes HTTP et construit des modèles de ressources basés sur l'interface qui reflètent la structure hiérarchique du service distant. Ses capacités plus larges couvrent la gestion de l'infrastructure cloud, l'automatisation de la publicité numérique et l'administration de comptes d'entreprise. La boîte à outils inclut des utilitaires pour gérer la pagination de grands ensembles de résultats, exécuter des protocoles de téléchargement reprenables pour les données binaires, et simuler le comportement des services via le mocking de réponses API pour l'assurance qualité. La bibliothèque fournit également une génération de documentation technique en combinant les documents de découverte avec l'interface de service disponible.

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

    Python
    Voir sur GitHub↗8,863
  • aws/aws-sdk-goAvatar de aws

    aws/aws-sdk-go

    8,687Voir sur 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
    Voir sur GitHub↗8,687
  • modelcontextprotocol/inspectorAvatar de modelcontextprotocol

    modelcontextprotocol/inspector

    8,721Voir sur 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
    Voir sur GitHub↗8,721
  • paradedb/paradedbAvatar de paradedb

    paradedb/paradedb

    8,370Voir sur 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
    Voir sur GitHub↗8,370
  • thinkgem/jeesiteAvatar de thinkgem

    thinkgem/jeesite

    8,044Voir sur 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
    Voir sur GitHub↗8,044
  • civitai/civitaiAvatar de civitai

    civitai/civitai

    7,158Voir sur 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
    Voir sur GitHub↗7,158
  • hyperf/hyperfAvatar de hyperf

    hyperf/hyperf

    6,855Voir sur 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
    Voir sur GitHub↗6,855
  • ankane/searchkickAvatar de ankane

    ankane/searchkick

    6,717Voir sur 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
    Voir sur GitHub↗6,717
  • hazelcast/hazelcastAvatar de hazelcast

    hazelcast/hazelcast

    6,570Voir sur 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
    Voir sur GitHub↗6,570
  • aws/aws-sdk-phpAvatar de aws

    aws/aws-sdk-php

    6,191Voir sur 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
    Voir sur GitHub↗6,191
  • redisearch/redisearchAvatar de RediSearch

    RediSearch/RediSearch

    6,161Voir sur 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
    Voir sur GitHub↗6,161
Préc.123Suivant
  1. Home
  2. Data & Databases
  3. Query Aggregates

Explorer les sous-tags

  • Aggregate Push-Ups1 sous-tagOptimization 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 sous-tagsMechanisms 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.