Awesome GitHub RepositoriesDatabase Connection Configurations

dockerlabs is a collection of educational labs and technical tutorials designed to teach the fundamentals of containerization and microservice architecture. It provides instructional material and hands-on exercises covering image optimization, security training, infrastructure setup, and cluster orchestration. The project features specific courses and guides focused on reducing image size through multi-stage builds, securing workloads via vulnerability scanning and encrypted networks, and deploying multi-node clusters with high availability using Swarm orchestration. The materials cover a br

Fathom is a privacy-focused website analytics server written in Go. It monitors website traffic and page views without collecting personal data or using intrusive cookies, providing a self-hosted alternative for traffic monitoring. The system utilizes a Preact-based dashboard interface for visualizing traffic patterns and reports. Data is persisted in a SQL database analytics store, with support for MySQL, PostgreSQL, and SQLite. The project covers the collection of visitor data via lightweight tracking snippets and the management of that data through a pluggable storage layer. It includes m

Sui is a blockchain platform featuring an object-centric state model and resource-oriented smart contracts. It utilizes parallel transaction execution to increase network throughput and supports programmable transaction blocks that bundle multiple operations into single atomic units. The platform distinguishes itself with a capability-based access control system and zero-knowledge login mechanisms, enabling users to authenticate via identity providers without seed phrases. It also implements deterministic object addressing to allow predictable state lookups and supports the creation of soulbo

This project is a self-hosted community engine and forum software designed for hosting threaded discussions. It functions as a JSON API community platform, exposing all data and functionality through a standardized interface to support a single-page application architecture. The system is built to be a multi-language discussion board with integrated localization and language pack support. The platform is defined by a modular architecture that allows for extensive customization through an extension-based plugin system. This extensibility enables the modification of core behavior, the addition

Feast is an open-source feature store for machine learning that provides a central platform for defining, storing, and serving features across both training and inference workflows. It operates as a declarative system where feature definitions are written as code in Python files, synchronized to a central registry, and made available for low-latency online retrieval or point-in-time correct historical joins for training datasets. The project abstracts storage behind a pluggable architecture, allowing offline and online backends to be swapped without changing retrieval logic, and coordinates ma

SpaceBarChat is an open-source, self-hosted chat server that implements the Discord client-server protocol, allowing existing Discord clients and bots to connect without modification. It provides a complete communication platform for real-time messaging, voice, and video, all running on your own infrastructure with data stored in a PostgreSQL database that automatically synchronizes its schema with the application source code. The platform is built on a three-service architecture that separates API, Gateway, and CDN processes, communicating via Unix domain sockets or RabbitMQ for coordination

Boto is a Python SDK and API wrapper for Amazon Web Services. It serves as a programmatic interface for managing and automating cloud infrastructure, mapping cloud-side resources to native Python objects and methods. The library provides tools for the programmatic control and orchestration of compute, storage, networking, and database resources. It enables the automation of infrastructure deployments and the management of virtual servers, container services, and serverless functions. Capability areas include identity and access management, cloud monitoring and observability, and the administ

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

Studio 是一个容器化 SQL 数据库管理工具，提供了一个基于浏览器的图形界面，用于执行查询和管理各种 SQL 数据库。它由一个专门的查询编辑器和专为 Web 数据库管理设计的图形管理界面组成。 该项目具有一个高性能 SQL 查询编辑器，带有自动补全和函数提示，可同时运行多个数据库命令。它包括一个用于创建和修改表列的视觉模式编辑器，以及一个在提交到源之前暂存和预览更改的记录编辑器。 该平台涵盖数据库连接和配置文件同步、多方言 SQL 集成，以及用于向菜单、选项卡和侧边栏添加自定义逻辑的 UI 扩展框架。它利用桌面包装器来桥接在标准 Web 浏览器环境中受限的数据库驱动程序。 该应用程序打包为 Docker 镜像，以确保在不同托管平台上的部署一致性。

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 project is a Java-based e-commerce management system and educational project suite. It serves as a backend framework for building online shopping platforms, utilizing a model-view-controller architecture to decouple user interfaces from business logic and data models. The system implements a structured web application framework that integrates relational databases to track product inventories, user accounts, and customer purchase transactions. It features a layered architecture that separates presentation, business logic, and data access. The codebase covers several core capability area

Sqlpad 是一个基于 Web 的 SQL 客户端与多租户工作台，用于在多个关系型及分析型数据库中编写、执行和保存查询。它作为 ODBC 数据库管理器，使用户能够通过浏览器界面管理数据库连接并探索架构。 该平台作为一个协作环境脱颖而出，用户可以在此共享 SQL 文档并协调数据分析。它集成了通过 OpenID Connect、SAML、LDAP 和 OAuth 实现的身份联合认证，并提供了一个将查询结果渲染为图表与表格的可视化系统。 该系统涵盖了广泛的能力领域，包括用于限制数据库连接的基于角色的访问控制（RBAC）、用于多语句事务的状态化会话管理，以及用于增强安全性的运行时凭据替换。它还提供查询持久化与历史记录追踪，以管理已保存 SQL 语句的生命周期。

deployd 是一个实时 API 框架和 MongoDB 后端即服务 (BaaS)，允许创建在客户端和服务器之间同步数据和事件的网络化接口。它作为一个 JavaScript API 中间件，可以与 HTTP 服务器集成，以提供身份验证、请求拦截器和实时功能。 该项目具有一个自托管的 API 管理仪表板，用于通过 Web 界面配置资源设置、管理数据集合和监控服务器状态。它包括一个实时数据同步引擎，使用 Socket 将实时数据库更新推送到连接的客户端。 该系统涵盖了具有模式验证和递归查询的后端数据管理，以及跨无状态请求和持久连接跟踪会话的用户身份验证工作流。它还提供实时事件广播、通过模块扩展自定义 API 中间件以及管理访问控制的功能。 该项目包含一个用于引导新项目和运行开发服务器的 CLI。

Kimai is an open-source time tracking system that records employee working hours, manages absences, and generates professional invoices from recorded timesheets and expenses. It organizes all time records through a mandatory three-level hierarchy of customer, project, and activity, and supports project budget monitoring with configurable time and money limits. The application is extensible through a plugin system that allows adding custom features, invoice templates, reporting views, and dashboard widgets without modifying core files. It provides a RESTful JSON API for programmatic read and w

supabase-js 是一个全面的客户端库，旨在将前端应用程序与托管的后端即服务 (BaaS) 集成。它提供了一个统一的接口，用于与 PostgreSQL 数据库、身份管理系统、云对象存储和实时数据同步进行交互。 该库具有同构客户端设计，可在浏览器和服务器环境中运行。它通过类型安全的方法脱颖而出，利用 TypeScript 将数据库模式直接映射到客户端定义，并采用基于 PostgREST 的 API 将 JavaScript 调用转换为 RESTful 请求。 该客户端涵盖了广泛的功能，包括通过 OAuth、OIDC 和通行密钥 (passkeys) 进行用户身份验证，以及使用签名令牌进行会话管理。它通过 S3 兼容的存储接口管理大规模二进制数据，并通过基于 WebSocket 的订阅实现实时应用程序更新，以进行数据库更改和状态同步。其他功能包括无服务器边缘函数的调用以及使用向量嵌入执行相似性搜索。

Apostrophe is an open-source Node.js headless content management system that delivers structured content through REST APIs while providing a visual in-context page editor for live editing. It is built on a module-based plugin architecture that extends CMS functionality through reusable modules, each encapsulating logic, configuration, and templates. The system uses schema-driven content modeling to define data structures and validation rules through configurable schemas and custom field types, with all content stored as flexible JSON-like documents in MongoDB. The platform distinguishes itsel

vim-dadbod is a database interface for the Vim editor that allows for the execution of SQL and NoSQL queries. It functions as a connection manager and query runner, enabling users to interact with databases using connection URLs. The project acts as a bridge to native command-line interfaces, providing a wrapper to launch interactive database consoles. This integration allows users to run commands from the editor and view the results within a preview window. The system manages database connections through URL-based configurations and environment variables. It handles the execution of queries

Flask-SQLAlchemy 是一个将 SQLAlchemy 关系数据库工具包与 Flask Web 框架集成的工具包。它通过将数据库表结构定义为 Python 类来实现关系数据建模，并管理 Web 应用程序中数据库记录的持久化和检索。 该项目将数据库会话生命周期绑定到活动的应用程序请求上下文，以确保自动连接清理。它为 Web 数据访问提供了专门的实用程序，包括查询结果分页，以及在请求的数据库记录缺失时自动触发 404 Not Found 响应的机制。 该扩展涵盖了广泛的数据库管理功能，包括声明式模型映射、模式反射和物理表结构的生成。它通过多绑定查询路由支持高级连接管理，并提供用于审计 SQL 查询性能和执行时间的观测工具。

Mongoid 是一个 Ruby 的对象文档映射器（ODM），用于将 Ruby 对象转换为 MongoDB 文档。它充当文档数据库映射器和客户端库，为在 NoSQL 环境中管理数据持久化和检索提供了一种结构化方式。 该项目通过提供高级数据检索工具脱颖而出，包括用于语义相似度的向量搜索和用于关键词匹配的全文搜索。它通过客户端字段级加密、加密密钥轮换和 TLS 连接安全实现高安全性数据保护，以保护敏感信息。 广泛的功能包括通过回调钩子管理文档生命周期、将文档组织成层级树结构，以及使用聚合管道进行数据转换。它还处理数据库索引管理、用于集群流量的副本集路由，以及集成外部文件上传库。 该系统通过应用日志记录、数据库事件监控和文档历史跟踪提供可观测性工具。