Awesome GitHub RepositoriesDatabase Schema Initializations

Redash is a self-hosted analytics platform and SQL data visualization tool. It provides a web-based SQL query editor for writing, executing, and scheduling database queries, and functions as a business intelligence dashboard for monitoring metrics via visual widgets. The platform distinguishes itself through its data source connectors, which integrate with various SQL, NoSQL, and API-based stores to retrieve information for analysis. It enables self-service analytics by allowing users to run queries with dynamic parameters and supports shared data reporting via public links or embedded dashbo

This project is a self-hosted, cross-platform instant messaging platform featuring a Go backend and a protobuf-based messaging server. It provides a unified communication suite with native clients for iOS, Android, and web, utilizing gRPC and Protocol Buffers for efficient data exchange. The system is distinguished by an extensible chatbot framework that allows for the integration of automated bots and plugins via standardized service interfaces. It supports high-availability clustering with sharded load distribution and a pluggable database backend to ensure reliability and flexible data per

DVWA is a vulnerable web application sandbox and PHP security training environment. It serves as a deployable penetration testing target and an OWASP Top 10 lab designed for practicing exploits and simulating common web security vulnerabilities. The application allows users to adjust security difficulty levels to match their skill level and toggle between different SQL database engines to test how various systems handle injection attacks. It includes a mechanism to disable authentication, enabling automated security tools to interact directly with the environment. The project provides capabi

Testcontainers for Java is a library for launching and managing disposable Docker containers to provide isolated dependencies for automated tests. It provides specialized provisioners for containerized databases, a manager for WebDriver browser containers, and an orchestrator for deploying multi-container applications via Docker Compose. The project ensures reproducible data states through database schema initialization and provides integration with JUnit to manage the lifecycle of external services. It supports automated browser testing by launching Selenium containers with the ability to re

Jeesite is a full-stack low-code development framework designed for building enterprise administrative portals using Spring Boot, MyBatis, and Vue. It functions as a comprehensive platform for creating administrative dashboards with integrated role-based access control and organizational data permission systems. The framework distinguishes itself through a combination of automated CRUD code generation and an integrated RAG platform that connects large language models to enterprise data via vector stores. It further incorporates a BPMN-based workflow engine to automate complex business process

Webiny 是一个 AI 可编程、云原生的无头内容管理系统（Headless CMS），专为企业级规模设计。它作为一个多租户内容平台和编排器，隔离数据、用户和权限，从而在单一部署中托管数千个独立租户。 该平台以其 AI 辅助工程能力而著称，提供协议服务器，为 AI 代理提供生成类型化代码、内容模型和 API 扩展所需的结构化上下文。它通过部署在 AWS 基础设施上的云原生架构实现差异化，使用基础设施即代码（IaC）来配置和修改云函数及存储桶。 该系统涵盖广泛的内容操作，包括数字资产管理、用于解耦前端的可视化页面构建，以及具有多步审批和定时发布功能的发布工作流编排。它还包括通过类型化脚本和生命周期钩子进行平台扩展的机制，并允许管理界面自定义和品牌化。 部署和环境设置通过命令行界面进行管理。

Mindoc is a self-hosted documentation portal and API documentation management system built as a Golang web application. It serves as a markdown documentation engine for authoring, organizing, and sharing technical interface documentation and database dictionaries. The system persists project data and user accounts using MySQL or SQLite databases. The platform distinguishes itself by integrating diagrams-as-code rendering via Mermaid syntax, allowing flowcharts, sequence diagrams, and Gantt charts to be generated directly from text. It supports a flexible content pipeline that combines markdow

Spin is a WebAssembly serverless framework and development toolchain for building and running portable microservices. It functions as an event-driven orchestrator and runtime that executes WebAssembly components, allowing developers to map HTTP requests, Redis messages, and cron schedules to specific modules. The project distinguishes itself by implementing a Wasm-based AI inference gateway, enabling components to perform model inference and generate text embeddings. It utilizes the WebAssembly Component Model and WASI for language-agnostic composition and portable host interfacing, while emp

GraphQL.NET 是一个用于在 C# 应用程序中构建和执行 GraphQL API 的服务端框架。它提供了一套全面的工具包，用于模式构建、分布式数据图的联合引擎，以及用于管理实时数据流的订阅处理器。 该项目的独特之处在于其灵活的模式构建器，支持程序化的代码优先定义和使用标准模式定义语言的声明式模式优先方法。它包括一个专门的联合引擎，用于将数据图拆分为子图并将其组合成统一的网关，以及一个专门设计用于通过批处理和缓存解决 N+1 查询问题的数据加载器实现。 该框架涵盖了广泛的操作功能，包括用于服务生命周期管理的依赖注入集成、用于字段解析拦截的中间件流水线，以及针对值类型优化以减少内存分配的执行流水线。它还提供用于查询复杂度分析、文档缓存和基于角色的访问控制的工具，以保护 API 端点。 对提前（AOT）模式编译的支持允许该框架在禁止动态代码生成的环境中执行。

Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in distributed storage such as HDFS and cloud storage services. It provides a familiar SQL interface for batch analytics and reporting, supported by a core set of components including the HiveServer2 Thrift service for remote query execution, the Hive Metastore Service for central metadata management, the Hive ACID Transaction Engine for concurrent read-write operations, and the Hive LLAP Interactive Engine for low-latency analytical processing. The WebHCat REST API offers an HTTP interfac

koa2-note 是一个专注于 Koa2 Web 服务器开发和 Node.js 异步编程的项目。它提供了一个使用异步中间件管道处理请求和响应周期的 Web 服务器和 API 构建框架。 该项目强调分层后端架构，将路由、业务服务和数据模型解耦。其特色在于集成了用于持久化用户会话和应用数据的关系型数据库，以及包含用于前端资源 JSX 转 JavaScript 编译的构建过程。 功能范围涵盖后端 API 设计（包括 RESTful 路由和请求数据解析）以及使用模板引擎的服务器端渲染。它还包括对使用多部分流解析的异步文件上传、基于 Cookie 的会话管理以及用于跨域请求的 JSONP 实现的支持。 该仓库作为一个教育资源，提供了学习 Koa 框架实现和服务器架构的结构化教程和示例。

OpenFGA is a fine-grained authorization server and policy decision point that implements relationship-based access control. It serves as a centralized authorization service for evaluating access requests and managing relationship tuples across distributed microservices and multi-tenant environments. The engine combines relationship graphs with attribute-based access control, using the Common Expression Language to evaluate dynamic runtime attributes and conditional access rules. It handles complex hierarchies and nested permissions by traversing chains of associations and parent-child links t

This project is a Next.js landing page template and React UI kit designed for showcasing software products and open source projects. It serves as a professional marketing website foundation and a Tailwind CSS website boilerplate for building modern web interfaces. The framework provides specialized layouts and components for open source project showcases, SaaS landing pages, and admin dashboards. It includes a collection of responsive components and styling utilities that allow for visual design customization of colors, fonts, and layouts. The capability surface covers a variety of UI elemen

ActiveAndroid is a persistence framework for managing local SQLite databases on Android. It provides an active record object-relational mapping system that binds database tables to classes, allowing for data persistence and retrieval without writing manual SQL. The project distinguishes itself through a dedicated schema migration tool that updates database structures using versioned scripts loaded from application assets. It also includes a framework for sharing database content between different Android applications via a standard URI-based content provider interface. The library covers bro

Pikachu 是一个 Web 安全培训平台和易受攻击的 Web 应用沙盒。它提供了一个容器化的实验环境，旨在练习渗透测试和识别常见的安全漏洞。 该项目作为 OWASP Top 10 练习实验室，提供了一套针对关键风险的模拟套件。它包括用于练习 SQL 注入、跨站脚本 (XSS)、远程代码执行和失效的访问控制等漏洞利用的具体场景。 该环境涵盖了广泛的安全测试模拟，包括目录遍历、服务端请求伪造 (SSRF)、不安全的文件上传和 XML 外部实体 (XXE) 攻击。它还具有一个管理后台，用于管理钓鱼模拟并监控捕获的会话负载。 整个平台通过容器化镜像部署，该镜像会自动初始化数据库模式并使用种子数据填充环境。

该项目是一个重构 Kata 集合和软件设计教育资源。它提供了一组故意混乱的代码库和多语言代码示例，旨在练习增量设计、遗留代码现代化和软件重构。 该集合作为测试驱动开发 (TDD) 的培训材料，专注于使用黄金主测试套件和批准测试，以在演进源代码的同时确保功能对等。它通过在几种不同的编程语言中实现相同的复杂业务规则，提供了一个通用的学习基准。 该系统涵盖了一系列功能，包括库存管理模拟，用户根据特定的老化规则更新商品质量和销售价值。它支持完整的工作流验证，包括生成覆盖率报告、执行单元测试和回归测试，以及使用 BDD 场景来验证系统行为。 通过重构研讨会和使用活动图来跟踪设计演进，提供教育支持。

msgspec is a high-performance data modeling, serialization, and schema validation toolkit for Python. It serves as a type-safe serialization framework that integrates schema enforcement and data parsing into a single pass, functioning as both a data serialization library and a schema validation system based on standard Python type annotations. The project distinguishes itself through high-performance structural primitives, including compilation-based routine generation and zero-copy buffer parsing. It optimizes memory usage via garbage collection-aware layouts and reduces processing overhead

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