Awesome GitHub RepositoriesForeign Key Constraints

Vapor is a comprehensive server-side web framework designed for building scalable, high-performance applications and APIs in Swift. It provides a non-blocking, event-loop-based runtime that manages concurrent task processing, background job queues, and asynchronous request handling. The framework is built around a dependency injection container that manages the lifecycle and resolution of services, configurations, and database connections throughout the request pipeline. The framework distinguishes itself through a protocol-oriented design that emphasizes type safety across all layers of the

Vitess is a database clustering system for horizontal scaling of MySQL. It functions as a middleware layer that abstracts complex sharding and physical topology, allowing applications to interact with a distributed database environment through a unified interface. By intercepting and routing SQL queries across multiple shards, it enables large-scale data management while maintaining the appearance of a single database instance. The platform distinguishes itself through its ability to perform online schema migrations and distributed transaction coordination without requiring application downti

Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL. The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions. The capability surface inc

This project is a Go language driver for the SQLite database. It provides a relational database interface and a Cgo wrapper that connects Go applications to SQLite for persistent local data storage and query execution. The implementation serves as a provider for JSON document storage and local full-text search. It enables the creation, querying, and modification of JSON data and the implementation of searchable indexes for large text datasets directly within the database. The driver supports standard SQL query execution for both file-based and in-memory storage. It includes capabilities for

sqlboiler is a database-first ORM generator for Go that analyzes an existing database schema to produce strongly typed structures and query helpers. It functions as a schema-driven code generator, transforming database tables and relationships into executable Go source code. The project distinguishes itself through a type-safe query builder that uses chainable modifiers to construct SQL statements, eliminating the need for raw string concatenation. It utilizes customizable text templates to generate source code, allowing for the aliasing of schema entities and the creation of custom templates

jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f

CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools

Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop. The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS

This repository is a curated study resource of interview questions and answers for data science roles. It covers the core domains of machine learning, statistics, Python programming, SQL databases, deep learning, and algorithmic problem solving. The content is organized as static Markdown files with a structured question-and-answer format, making it easy to read and navigate without any server-side processing. The material distinguishes itself by pairing each question with a detailed explanation and often a code example, covering both conceptual knowledge and practical application. Topics ran

ihp is a type-safe web framework and full-stack application orchestrator designed for PostgreSQL. It functions as a server-side rendering framework and a type-safe ORM that automatically generates record types from SQL schemas to ensure compile-time query validation. The platform distinguishes itself by verifying routing, database queries, and templates at compile time to prevent runtime crashes. It implements real-time web interfaces using WebSockets for instant data synchronization and employs server-driven hypermedia for partial DOM patching. The framework covers a broad range of integrat

Mathesar is a no-code database manager and PostgreSQL GUI that provides a visual interface for managing relational database structures and records. It functions as a low-code data platform for administering schemas, tables, and relationships without the need to write manual SQL commands. The platform allows for the creation of shareable forms to collect data and the management of file attachments linked directly to database records. It includes a PostgreSQL administration tool for controlling database roles, user permissions, and data validation rules. The system covers relational data model

Goravel Go प्रोग्रामिंग भाषा का उपयोग करके वेब एप्लिकेशन, REST API और gRPC सेवाएं बनाने के लिए एक पूर्ण-विशेषीकृत डेवलपमेंट स्कैफोल्ड और फ्रेमवर्क है। यह मॉडल-व्यू-कंट्रोलर आर्किटेक्चर को लागू करता है और उच्च-प्रदर्शन रिमोट प्रोसीजर कॉल सर्वर्स और क्लाइंट्स के लिए एक व्यापक टूलकिट प्रदान करता है। यह फ्रेमवर्क अपने व्यापक एकीकृत इकोसिस्टम द्वारा प्रतिष्ठित है, जिसमें डेटाबेस मैनेजमेंट के लिए एक फ्लुएंट ऑब्जेक्ट-रिलेशनल मैपर और प्रशासनिक ऑटोमेशन और प्रोजेक्ट स्कैफोल्डिंग के लिए एक समर्पित कमांड-लाइन इंटरफ़ेस टूलकिट शामिल है। इसमें एक ड्राइवर-आधारित सर्विस एब्स्ट्रैक्शन है जो डेवलपर्स को एप्लिकेशन लॉजिक को बदले बिना स्टोरेज, कैश और सेशन बैकएंड को स्वैप करने की अनुमति देता है। यह प्लेटफ़ॉर्म एप्लिकेशन क्षमताओं की एक विस्तृत सतह को कवर करता है, जिसमें डिस्ट्रीब्यूटेड क्यूज़ के साथ एसिंक्रोनस टास्क प्रोसेसिंग, टोकन-आधारित प्रमाणीकरण के माध्यम से सुरक्षित आइडेंटिटी मैनेजमेंट, और एन्क्रिप्शन और एक्सेस कंट्रोल के साथ एक मजबूत सुरक्षा परत शामिल है। यह कंटेंट लोकलाइजेशन, टेम्पलेट रेंडरिंग और डिपेंडेंसी मॉकिंग के साथ एक ऑटोमेटेड टेस्टिंग इंफ्रास्ट्रक्चर के लिए टूल्स भी प्रदान करता है।

supabase-js is a comprehensive client library designed to integrate frontend applications with a hosted backend-as-a-service. It provides a unified interface for interacting with a PostgreSQL database, identity management systems, cloud object storage, and real-time data synchronization. The library features an isomorphic client design that operates across both browser and server environments. It distinguishes itself through a type-safe approach, utilizing TypeScript to map database schemas directly to client-side definitions, and employs a PostgREST-based API to translate JavaScript calls in

TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features

Graphene-Django is a GraphQL integration framework and schema mapper used to build typed APIs for Django applications. It functions as a database API layer that transforms Django model fields and relationships into a graph schema, allowing clients to request specific data in a single call. The project implements the Relay specification, providing tools for global object identification and standardized connection-based pagination to manage large datasets. It distinguishes itself by mapping database models, forms, and serializers directly into GraphQL object types and mutations. The framework

tbls is a Go-based command line utility used for documenting, analyzing, and linting relational database schemas. It functions as a documentation tool that generates structured reports and entity-relationship diagrams in Markdown, JSON, or Excel formats, as well as a schema diff tool for identifying discrepancies between a live database and its documentation. The project allows for schema augmentation and the definition of virtual relationships through external configuration files, enabling metadata overrides and table connections without requiring database migrations or native constraints. I

Vue.NetCore is a full-stack scaffolding tool that automatically generates frontend and backend code using .NET Core and Vue.js based on database schemas. It functions as a CRUD boilerplate generator and database orchestrator that maps entities into business logic to create administrative interfaces and API endpoints. The project provides a multi-platform UI scaffold, producing compatible code for web, iOS, Android, and WeChat mini-programs. It utilizes a TypeScript web framework with Vite and leverages SqlSugar to automate the mapping of database entities. The system covers enterprise CRUD a

Gorp is a lightweight object-relational mapper for Go that binds structs to relational database tables. It functions as a relational data mapper and SQL dialect abstraction layer, automating the translation between application data and relational rows. The project provides a translation layer that generates vendor-specific SQL for PostgreSQL, MySQL, SQLite, Oracle, and SQL Server. It distinguishes itself by implementing optimistic locking via version columns to prevent concurrent update conflicts and providing a database schema generator to create tables and indexes from object definitions.

LazySQL is a terminal user interface database manager and SQL client. It functions as a query runner and connection manager for interacting with SQL databases from the command line. The project features a read-only connection mode that blocks mutation commands to prevent accidental data loss. It supports automated pre-connection tasks, including the execution of shell commands and the establishment of SSH tunnels, and allows for both global and project-specific configuration. The interface provides a tree-based schema browser for navigating tables, a dedicated SQL query editor with tabular r

Drift is a type-safe SQL persistence library and relational mapper that provides a structured way to map database tables to classes and execute SQL queries with build-time validation. It functions as a type-safe query builder and a wrapper for SQLite and PostgreSQL, eliminating manual result set parsing by binding query outputs to native objects. The project distinguishes itself through a build-time code generation system that produces type-safe APIs and validates raw SQL statements against database versions before execution. It features reactive query streaming, which transforms SQL queries