12 repositorios
Virtual tables defined by queries for data abstraction and reuse.
Distinguishing note: No candidates provided; minting under Data & Databases.
Explore 12 awesome GitHub repositories matching data & databases · Database Views. Refine with filters or upvote what's useful.
Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.
Allows declaration and management of database views within the schema.
This is a mobile object database and NoSQL local data store that replaces relational tables with a schema-based model. It functions as a reactive data store, using live object observations and change notifications to trigger automatic user interface refreshes. The system provides built-in mobile cloud data synchronization to keep local datasets consistent with a remote server across multiple devices. It also includes security features for encrypted local storage, protecting sensitive on-disk data using at-rest encryption keys and fine-grained access control. Broad capabilities include object
Binds database results to SwiftUI views, triggering automatic visual updates when data changes.
Markmap is an interactive diagramming library that transforms hierarchical Markdown documents into navigable mindmaps. It functions as a data visualization component, converting structured text into graphical representations to assist in organizing and visualizing complex information. The library utilizes a parsing engine to interpret indentation levels and list markers, mapping them into nested data objects. These objects are rendered as scalable vector graphics, providing users with dynamic, zoomable, and collapsible diagrams that update reactively as the underlying source text changes. Th
Synchronizes visual diagrams reactively with underlying Markdown source text changes.
WatermelonDB is an offline-first data synchronization engine and reactive database library designed for mobile and web applications. It provides a persistent storage layer backed by SQLite, enabling applications to maintain full functionality and data consistency while operating without an internet connection. The framework distinguishes itself through a reactive data binding system that automatically updates user interface components whenever underlying database records change. It utilizes schema-driven model mapping to generate type-safe interfaces and employs lazy object materialization to
Automatically updates user interface components whenever underlying database records change.
Realm Java is a NoSQL mobile object database and reactive database engine. It provides a persistent local data store that saves native objects directly to disk, replacing traditional SQL storage and object-relational mapping layers. The system functions as a real-time data synchronizer, coordinating local database changes with a cloud backend across multiple devices. It integrates a reactive engine that uses change listeners and asynchronous event streams to automatically update user interfaces when underlying data changes. The project covers object-oriented data modeling, CRUD operations, a
Provides mechanisms that automatically update user interface components in response to underlying database changes.
Perspective is a columnar data analytics engine and high-performance visualization component powered by WebAssembly. It provides a system for analyzing and visualizing large or streaming datasets through interactive data grids and charts, utilizing a compiled binary to achieve near-native performance within the browser. The project distinguishes itself through a WebSocket-based data streaming interface and deep Apache Arrow integration, which minimize memory overhead when synchronizing tables between servers and clients. It acts as a remote query proxy capable of translating visualization con
Automatically recalculates aggregates and filters in dependent visualizations when the underlying source data changes.
Ibis is a portable Python dataframe library and multi-backend query engine that provides a unified interface for executing data transformations across diverse compute engines. It functions as a Python SQL expression compiler and dialect transpiler, allowing users to define data logic once and execute it across cloud warehouses, embedded databases, and distributed clusters without rewriting code. The project distinguishes itself through a database backend abstraction that decouples transformation logic from the underlying execution engine. It enables polyglot data workflows by mixing raw SQL s
Generates virtual tables from transformation expressions and stores them within the backend.
Datascript es un almacén de estado inmutable en memoria y un almacén de triples basado en esquemas. Gestiona el estado de la aplicación como una base de datos versionada, almacenando datos como hechos inmutables que consisten en una entidad, atributo, valor y transacción. El proyecto proporciona un motor lógico para ejecutar consultas Datalog con soporte para joins implícitos, reglas recursivas y negación. También cuenta con una API de extracción declarativa para recuperar grafos de entidades profundamente anidados y estructuras de datos relacionadas. La base de datos impone la integridad de los datos a través de restricciones basadas en esquemas y tipos de atributos. Admite transacciones atómicas, protocolos de almacenamiento conectables para persistencia e indexación de atributos B-tree para optimizar las búsquedas. El sistema está diseñado para su uso en entornos Clojure, ClojureScript y JavaScript.
Creates restricted virtual views of the database by applying filters to the existing data set.
Este proyecto es una hoja de trucos de bases de datos relacionales y una guía de referencia de SQL. Proporciona una colección de ejemplos de sintaxis y documentación de consultas para gestionar bases de datos relacionales utilizando lenguaje de consulta estructurado. La herramienta está implementada como un sitio estático con documentación buscable en el lado del cliente, lo que permite el filtrado inmediato de contenido técnico a través de un índice basado en navegador. La referencia cubre la gestión de bases de datos relacionales, incluyendo la recuperación de datos, la gestión de esquemas de bases de datos y el mantenimiento de registros. También incluye orientación sobre la manipulación de datos relacionales mediante uniones de tablas (joins) y la generación de informes agregados.
Includes guidance on creating and managing virtual tables through database views.
Sequel is a relational database toolkit for Ruby that provides object-relational mapping, a fluent SQL query builder, and schema migration capabilities. It maps database tables to Ruby classes with support for associations, validations, lifecycle hooks, and eager loading, offering a comprehensive ORM layer for building data-centric applications. Sequel distinguishes itself through a plugin-based extension architecture that allows composable customization of models, databases, and datasets without relying on deep inheritance hierarchies. It includes a thread-safe connection pool with support f
Creates, replaces, or drops virtual tables defined by SELECT statements.
cr-sqlite is a multi-master database replication system that uses conflict-free replicated data types to ensure eventual consistency across distributed nodes. It provides the core capabilities for offline-first data synchronization, allowing multiple database instances to merge concurrent updates and reach a consistent state. The project distinguishes itself through a combination of CRDT-based data replication and a WASM-based database engine, enabling full SQL execution and state persistence within web browsers. It supports peer-to-peer replication and cross-tab synchronization, utilizing ca
Provides mechanisms that automatically update the user interface in response to underlying database changes.
Ever Gauzy is an integrated business management suite providing an ERP and CRM framework for professional services automation. It functions as a multi-tenant SaaS platform that combines time tracking, billing, and human resource management into a unified system. The project is distinguished by its headless architecture, utilizing a REST and GraphQL API gateway to expose business operations. It features a Model Context Protocol server that allows AI assistants to interact with system data and execute functional tools for automated business workflows. The platform covers a broad operational su
Uses database views to wrap intricate queries into virtual tables for easier reporting.