97 Repos
Techniques for organizing data into structured tables with defined relationships.
Distinguishing note: Focuses on the schema design aspect of data management.
Explore 97 awesome GitHub repositories matching data & databases · Relational Data Modeling. Refine with filters or upvote what's useful.
Twenty is a headless customer relationship management framework that enables developers to build, version, and deploy custom business applications using code. By utilizing a declarative approach to data modeling, the platform allows for the definition of custom objects, fields, and complex relationships directly within the source code. This schema-driven architecture automatically generates corresponding REST and GraphQL APIs, ensuring that data structures and interface components remain synchronized across development and production environments. The platform distinguishes itself through a m
Follow best practices for data modeling by planning relationships, using consistent naming conventions, and limiting the number of relations to maintain workspace performance.
MobX is a reactive state management library and fine-grained reactivity engine. It provides an observable data store that automatically triggers updates in the user interface when data structures change, functioning as a transparent functional reactive store to maintain a consistent source of truth. The system utilizes a dependency-graph mapping and proxy-based object observation to track data dependencies. This ensures that only the specific components dependent on changed data are updated, which reduces unnecessary re-renders and optimizes frontend performance. The library supports decoupl
Defines structured observable data and actions to maintain a single source of truth across the application.
RethinkDB is a distributed, document-oriented database designed to store and manage JSON-formatted data across scalable clusters. It utilizes a custom log-structured storage engine with B-Tree indexing to ensure high-performance disk I/O and data persistence. The system maintains high availability through automatic sharding and replication, employing a primary-replica voting consensus mechanism to handle node failures and ensure consistent cluster operations. A defining characteristic of the platform is its reactive changefeed engine, which allows applications to subscribe to live data update
RethinkDB models relationships across separate tables by using foreign keys and join operations to handle large datasets that exceed the size limits of embedded arrays.
Monica is a self-hosted personal relationship manager and CRM designed to track personal and professional connections. It functions as a contact management system and personal information manager, providing a centralized repository for detailed contact profiles, interaction logs, and relationship history. The system distinguishes itself by focusing on the nuances of personal connections, including gift cataloging, debt tracking, and personal journaling. It features a time-triggered notification system for scheduling contact reminders, such as birthdays and follow-up intervals. Broad capabili
Uses a schema-defined relational database to structure contacts, interactions, and relationship links.
DataEase is an open-source, self-hosted business intelligence platform designed for building interactive data visualizations and managing analytical reporting. It provides a centralized environment where users can construct dashboards through a drag-and-drop interface, connecting to diverse data sources including relational databases, data warehouses, and external APIs. The platform distinguishes itself through its focus on embedded analytics and enterprise-grade governance. It allows for the seamless integration of charts, dashboards, and management modules into third-party web applications
Joins multiple tables from different sources using configurable connection types and field mappings.
This project serves as a comprehensive technical reference for the architecture and design of data-intensive applications. It provides a structured analysis of the fundamental principles required to build reliable, scalable, and maintainable software systems, covering the core trade-offs inherent in modern data infrastructure. The repository explores the mechanics of distributed data management, including strategies for replication, partitioning, and achieving consensus across multiple nodes. It details the design of storage engines, indexing techniques, and transaction management models, whi
Provides foundational techniques for organizing data into structured tables with defined relationships.
Joi is a JavaScript data validation library used to define schemas that validate, cast, and sanitize data objects. It functions as an object schema validator and parser, ensuring that input data matches specific types and formats before it is processed by an application. The library features a conditional validation engine capable of dynamic schema enforcement, where validation logic and dependencies change based on the values of other keys within an object. It also serves as a data casting and sanitization tool, transforming input values into target types and removing sensitive keys from the
Defines strict relationships and dependencies between fields in large objects to maintain integrity.
normalizr is a JSON data normalization library and schema-based data transformer. It functions as a state management helper designed to flatten deeply nested JSON structures into a relational format based on predefined schemas. The library transforms complex nested objects into flat entities to prevent data duplication in client-side caches and stores. It organizes API responses into a relational format that mimics a database, facilitating consistent updates and easier retrieval within global state managers. Its core capabilities include relational data modeling and the ability to transform
Transforms hierarchical API data into a relational format that mimics a database for easier retrieval.
TOML is a configuration file format designed for human readability and unambiguous mapping to hash tables. It serves as a standardized language for structured data, enabling consistent parsing and data exchange across diverse programming environments. The format distinguishes itself through a strict type-system specification that ensures data is interpreted identically regardless of the implementation. It utilizes a line-oriented lexical structure that supports both hierarchical organization through bracketed sections and compact inline embedding for nested objects. This approach allows for t
Models nested or repeating data sets using arrays, inline tables, and arrays of tables.
The Reactive Extensions for JavaScript
Ships a full observable framework with lazy evaluation, subscription lifecycle management, and cancellation support.
Subql is a blockchain data indexing framework and TypeScript-based indexer used to extract raw blockchain events and transactions and transform them into structured, queryable data entities. It functions as a data API and a tool for building decentralized application backends, providing a query interface for type-safe access to indexed blockchain data. The project includes an AI-powered query engine that utilizes large language models to translate natural language questions into structured GraphQL queries. This system can orchestrate multi-step queries by breaking down complex requests into s
Implements techniques for organizing blockchain data into structured entities with defined relationships.
DevOps-Roadmap is a comprehensive educational repository and knowledge base designed to guide technical professionals through the complexities of modern software engineering. It functions as a structured curriculum and reference library, covering the full spectrum of skills required to master system architecture, infrastructure management, and cloud operations. The project distinguishes itself by bridging the gap between high-level architectural design and the practical realities of engineering leadership. It provides curated insights into distributed systems, data consistency, and scalable d
Offers guidance on selecting appropriate data models based on access patterns and relationship complexity.
Agent Zero is an autonomous AI agent framework designed to execute complex, multi-step workflows by managing its own environment, persistent memory, and external tool interactions. It functions as a Python-based automation library that enables agents to write code, execute terminal commands, and perform system-level tasks independently. The system is built to handle large-scale operations through hierarchical agent delegation, allowing for the coordination of subordinate agents to maintain focus and context. The platform distinguishes itself through a focus on secure, isolated execution and s
Extracts and processes information from web and enterprise sources to generate actionable insights and automated reports.
This project is a collection of official plugin packages and a native integration library designed to provide a consistent interface for accessing hardware and software functionality across different mobile and desktop platforms. It serves as a native platform bridge, enabling cross-platform applications to invoke native code and manage operating system dependencies. The project utilizes a federated plugin architecture, splitting plugins into common interfaces and separate platform implementations to allow for independent development and extension. It further supports native integration throu
Organizes related information across multiple tables using foreign keys to reduce duplication.
New-Grad-Positions is a centralized job aggregation platform designed to track and filter entry-level career opportunities for recent graduates across technical industries. The system functions as an automated career search tool, utilizing a relational database schema to organize job listings and user profiles for efficient querying. The platform distinguishes itself through integrated browser-based automation that populates online job application fields to reduce manual data entry. It further supports career search automation by monitoring new listings and triggering email alerts based on sp
Organizes job listings and user profiles into structured tables to facilitate efficient querying.
FoundationDB is an ACID-compliant distributed transactional key-value store. It functions as a scalable database engine that ensures strict serializability and data consistency across a cluster of servers using a shared-nothing architecture. The system is distinguished by its multi-region replication capabilities, allowing data to be synchronized across different datacenters for high availability and disaster recovery. It utilizes optimistic concurrency control to manage distributed transactions and employs a majority-based coordination system to maintain cluster state. The platform provides
Builds custom models such as queues, vectors, and tables using the underlying key-value API.
Faker is a library for generating synthetic data and mock information to populate development and testing environments. It provides a structured way to create realistic values such as names, addresses, and dates, allowing developers to validate application logic and visualize user interfaces without relying on production data. The library distinguishes itself through its support for deterministic generation, which uses fixed seeds to ensure that data sequences remain identical across multiple test executions. It also features a modular architecture that separates generation logic into indepen
Constructs structured data by chaining generation functions to ensure logical consistency across related fields.
This project is a multi-model database system designed to store and manage information as documents, graphs, and key-value pairs within a single engine. It functions as a graph database and knowledge graph platform, providing the infrastructure to build, query, and visualize structured data models. By integrating vector search capabilities, the system serves as a vector database that supports retrieval-augmented generation for artificial intelligence applications. The platform distinguishes itself through a unified query language that allows users to perform document lookups, graph traversals
Persists information as documents, graphs, and key-value pairs within a single flexible database system.
Gel is an object-relational database system that models data as a graph of interconnected objects. By utilizing a strongly typed schema, it enables complex relational queries and polymorphic data structures without the need for traditional join tables. The system integrates native vector storage and similarity search operators, allowing it to function as both a relational and a vector database for semantic data retrieval. The platform distinguishes itself through a comprehensive suite of developer-centric automation tools. It features a declarative migration system that tracks and versions sc
Structures complex object graphs with inheritance, polymorphic links, and constraints to represent real-world data relationships efficiently.
This project is a type-safe database toolkit and object-relational mapper designed to enforce structural consistency between database schemas and application code. By leveraging compile-time validation, it ensures that SQL queries and data structures remain synchronized, preventing common errors before the application executes. It provides a comprehensive framework for relational data modeling, allowing developers to define table associations and map database results directly into strongly-typed language objects. The library distinguishes itself through its focus on compile-time safety and au
Provides a framework for defining table associations and mapping relational data to application structures.