12 dépôts
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 est un magasin d'état immuable en mémoire et un magasin de triplets basé sur un schéma. Il gère l'état de l'application comme une base de données versionnée, stockant les données sous forme de faits immuables consistant en une entité, un attribut, une valeur et une transaction. Le projet fournit un moteur logique pour exécuter des requêtes Datalog avec prise en charge des jointures implicites, des règles récursives et de la négation. Il dispose également d'une API de pull déclarative pour récupérer des graphes d'entités profondément imbriqués et des structures de données associées. La base de données impose l'intégrité des données via des contraintes basées sur le schéma et des types d'attributs. Elle prend en charge les transactions atomiques, les protocoles de stockage enfichables pour la persistance, et l'indexation d'attributs en arbre B pour optimiser les recherches. Le système est conçu pour être utilisé dans les environnements Clojure, ClojureScript et JavaScript.
Creates restricted virtual views of the database by applying filters to the existing data set.
Ce projet est une antisèche de base de données relationnelle et un guide de référence SQL. Il fournit une collection d'exemples de syntaxe et de documentation de requêtes pour gérer des bases de données relationnelles en utilisant le langage de requête structuré (SQL). L'outil est implémenté sous forme de site statique avec une documentation interrogeable côté client, permettant un filtrage immédiat du contenu technique via un index basé sur le navigateur. La référence couvre la gestion de bases de données relationnelles, incluant la récupération de données, la gestion de schémas de base de données et la maintenance des enregistrements. Elle inclut également des conseils sur la manipulation de données relationnelles via des jointures de tables et la génération de rapports agrégés.
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.