12 Repos
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 ist ein unveränderlicher (immutable) In-Memory-Zustandsspeicher und ein schemabasierter Triple-Store. Es verwaltet den Anwendungszustand als versionierte Datenbank und speichert Daten als unveränderliche Fakten, die aus Entität, Attribut, Wert und Transaktion bestehen. Das Projekt bietet eine Logik-Engine zur Ausführung von Datalog-Abfragen mit Unterstützung für implizite Joins, rekursive Regeln und Negation. Es verfügt zudem über eine deklarative Pull-API zum Abrufen tief verschachtelter Entitätsgraphen und zugehöriger Datenstrukturen. Die Datenbank erzwingt Datenintegrität durch schemagesteuerte Einschränkungen und Attributtypen. Sie unterstützt atomare Transaktionen, erweiterbare Speicherprotokolle für Persistenz sowie B-Baum-Attributindizierung zur Optimierung von Suchvorgängen. Das System ist für den Einsatz in Clojure-, ClojureScript- und JavaScript-Umgebungen konzipiert.
Creates restricted virtual views of the database by applying filters to the existing data set.
Dieses Projekt ist ein Cheat Sheet für relationale Datenbanken und eine SQL-Referenz. Es bietet eine Sammlung von Syntax-Beispielen und Query-Dokumentationen für die Verwaltung relationaler Datenbanken mittels Structured Query Language. Das Tool ist als statische Website mit clientseitig durchsuchbarer Dokumentation implementiert, was eine sofortige Filterung technischer Inhalte über einen browserbasierten Index ermöglicht. Die Referenz deckt das Management relationaler Datenbanken ab, einschließlich Datenabruf, Datenbank-Schema-Management und Datensatzpflege. Sie enthält zudem Anleitungen zur Manipulation relationaler Daten durch Table-Joins und die Erstellung aggregierter Berichte.
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.