12 个仓库
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 是一个不可变的、内存中的状态存储和基于模式的三元组存储。它将应用状态作为版本化数据库进行管理,将数据存储为由实体、属性、值和事务组成的不可变事实。 该项目提供了一个用于执行 Datalog 查询的逻辑引擎,支持隐式连接、递归规则和否定。它还具有一个用于检索深度嵌套实体图和相关数据结构的声明式 pull API。 该数据库通过模式驱动的约束和属性类型强制执行数据完整性。它支持原子事务、用于持久化的可插拔存储协议,以及用于优化查找的 B 树属性索引。 该系统专为 Clojure、ClojureScript 和 JavaScript 环境设计。
Creates restricted virtual views of the database by applying filters to the existing data set.
这是一个关系型数据库速查表和 SQL 参考指南。它提供了一系列语法示例和查询文档,用于使用结构化查询语言管理关系型数据库。 该工具实现为一个带有客户端可搜索文档的静态网站,允许通过基于浏览器的索引即时过滤技术内容。 该参考涵盖了关系型数据库管理,包括数据检索、数据库模式管理和记录维护。它还包括关于通过表连接进行关系数据操作以及生成聚合报告的指导。
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.