awesome-repositories.com
Blog
awesome-repositories.com

Descoperă cele mai bune repository-uri open source cu căutare AI.

ExploreazăCăutări recomandateAlternative open-sourceSoftware self-hostedBlogHartă site
ProiectDespreCum realizăm clasamentulPresăServer MCP
LegalConfidențialitateTermeni
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
·

57 repository-uri

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

Găsește cele mai bune repo-uri cu AI.Vom căuta cele mai potrivite repository-uri folosind AI.
  • vapor/vaporAvatar vapor

    vapor/vapor

    26,138Vezi pe 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
    Vezi pe GitHub↗26,138
  • cube-js/cubeAvatar cube-js

    cube-js/cube

    20,251Vezi pe 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
    Vezi pe GitHub↗20,251
  • tencent/apijsonAvatar Tencent

    Tencent/APIJSON

    18,395Vezi pe 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
    Vezi pe GitHub↗18,395
  • rstacruz/cheatsheetsAvatar rstacruz

    rstacruz/cheatsheets

    14,429Vezi pe 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
    Vezi pe GitHub↗14,429
  • graphile/crystalAvatar graphile

    graphile/crystal

    12,931Vezi pe 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
    Vezi pe GitHub↗12,931
  • emdash-cms/emdashAvatar emdash-cms

    emdash-cms/emdash

    10,887Vezi pe 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
    Vezi pe GitHub↗10,887
  • doctrine/ormAvatar doctrine

    doctrine/orm

    10,172Vezi pe 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
    Vezi pe GitHub↗10,172
  • studio3t/robomongoAvatar Studio3T

    Studio3T/robomongo

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

    SeaQL/sea-orm

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

    googleapis/google-api-python-client

    8,863Vezi pe GitHub↗

    Acest proiect este o bibliotecă client REST API și o componentă Google Cloud SDK care integrează aplicațiile Python cu serviciile Google. Funcționează ca un client API bazat pe descoperire (discovery-based), utilizând o bibliotecă de integrare OAuth 2.0 pentru a securiza cererile și a verifica identitatea prin token-uri de acces și conturi de serviciu. Biblioteca se distinge prin utilizarea documentelor de descoperire pentru a genera dinamic clienți la runtime. Prin parsarea metadatelor JSON, mapează apelurile de metode Python către cereri HTTP și construiește modele de resurse bazate pe interfețe care oglindesc structura ierarhică a serviciului la distanță. Capabilitățile sale mai largi acoperă gestionarea infrastructurii cloud, automatizarea publicității digitale și administrarea conturilor enterprise. Toolkit-ul include utilitare pentru gestionarea paginării seturilor mari de rezultate, executarea protocoalelor de upload reluabile pentru date binare și simularea comportamentului serviciului prin mocking-ul răspunsurilor API pentru asigurarea calității. Biblioteca oferă, de asemenea, generarea de documentație tehnică prin combinarea documentelor de descoperire cu interfața de serviciu disponibilă.

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

    Python
    Vezi pe GitHub↗8,863
  • aws/aws-sdk-goAvatar aws

    aws/aws-sdk-go

    8,687Vezi pe 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
    Vezi pe GitHub↗8,687
  • modelcontextprotocol/inspectorAvatar modelcontextprotocol

    modelcontextprotocol/inspector

    8,721Vezi pe 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
    Vezi pe GitHub↗8,721
  • paradedb/paradedbAvatar paradedb

    paradedb/paradedb

    8,370Vezi pe 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
    Vezi pe GitHub↗8,370
  • thinkgem/jeesiteAvatar thinkgem

    thinkgem/jeesite

    8,044Vezi pe 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
    Vezi pe GitHub↗8,044
  • civitai/civitaiAvatar civitai

    civitai/civitai

    7,158Vezi pe 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
    Vezi pe GitHub↗7,158
  • hyperf/hyperfAvatar hyperf

    hyperf/hyperf

    6,855Vezi pe 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
    Vezi pe GitHub↗6,855
  • ankane/searchkickAvatar ankane

    ankane/searchkick

    6,717Vezi pe 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
    Vezi pe GitHub↗6,717
  • hazelcast/hazelcastAvatar hazelcast

    hazelcast/hazelcast

    6,570Vezi pe 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
    Vezi pe GitHub↗6,570
  • aws/aws-sdk-phpAvatar aws

    aws/aws-sdk-php

    6,191Vezi pe 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
    Vezi pe GitHub↗6,191
  • redisearch/redisearchAvatar RediSearch

    RediSearch/RediSearch

    6,161Vezi pe 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
    Vezi pe GitHub↗6,161
Înapoi123Înainte
  1. Home
  2. Data & Databases
  3. Query Aggregates

Explorează sub-etichetele

  • Aggregate Push-Ups1 sub-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 sub-tag-uriMechanisms 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.