Awesome GitHub RepositoriesDatabase Connectivity Interfaces

Apache Spark is a unified distributed data processing engine designed for large-scale data analysis and computation graphs. It functions as a distributed machine learning framework, a graph processing system, a real-time stream processor, and a SQL analytics engine. The system enables the execution of distributed SQL querying, large-scale graph analysis, and real-time stream analytics across clusters of machines. It also provides a scalable environment for implementing machine learning algorithms and predictive model development on massive datasets. The engine incorporates relational query e

Perfect is a server-side Swift framework designed for building high-performance web applications, REST APIs, and backend services. It provides an asynchronous HTTP server that handles web traffic through an event loop, alongside a web template engine for generating dynamic HTML pages. The project includes a WebSocket communication library for implementing bidirectional, real-time data exchange between clients and servers. It also provides a database connector to establish connections and exchange data between Swift applications and external database stores. The framework's capabilities cover

FerretDB is an open-source database emulator and protocol translator that mimics a MongoDB environment to support existing drivers and client tools on a relational backend. It functions as a stateless database proxy that converts binary wire protocol messages into SQL statements, allowing a relational engine to handle document-oriented requests. The project serves as a migration tool for moving applications from MongoDB to PostgreSQL without rewriting queries or changing client drivers. It achieves this by using PostgreSQL as a document store, storing and querying BSON documents through a tra

go-cloud 是一个云无关的工具包，提供用于与常见云服务交互的可移植 Go 接口。它通过将业务逻辑与特定的提供商 API 实现解耦，实现了多云应用程序开发。 该项目利用基于驱动程序的系统将通用接口调用映射到特定供应商的请求。这允许应用程序在不同的云后端（如 Blob 存储、关系型数据库和异步发布-订阅消息）之间切换，而无需更改核心应用程序代码。 除了存储和消息传递，该工具包还包含一个管理器，用于在运行时跟踪和更新动态配置变量，而无需重启进程。它还为分布式追踪、请求日志记录和健康检查提供了标准化的可观测性层。

Flyway is a database schema versioning tool and SQL migration orchestrator. It applies version-controlled schema changes to relational databases using SQL scripts and Java Database Connectivity to ensure environments remain consistent and reproducible. The tool tracks applied migration scripts in a dedicated metadata table to determine which updates require execution. It supports the synchronization of schema versions across multiple different database engines and provides integration for build systems and application frameworks to automate updates during software release processes. Capabili

POCO is a comprehensive C++ application framework that provides a cross-platform set of libraries for building network-centric applications. It offers a unified abstraction layer that wraps platform-specific APIs, enabling the same code to run across desktop, server, mobile, IoT, and embedded systems. The framework is organized into modular libraries that can be compiled and linked selectively, allowing developers to include only the components their application needs. The framework distinguishes itself through its broad coverage of application infrastructure needs, including threading and sy

Steampipe is a cloud infrastructure query engine and API-to-SQL mapper that translates REST and GraphQL API responses into relational rows and columns. It allows for the retrieval and joining of real-time data from multiple cloud service providers using a relational database interface. The project functions as a PostgreSQL foreign data wrapper and an SQLite API extension, mapping external API endpoints to virtual tables. This enables the use of standard SQL to query live cloud services and aggregate data from different providers and service accounts into a single unified dataset. The system

pywin32 是一系列 Python 扩展，作为原生 Windows API 的封装器，能够调用操作系统函数来管理底层系统资源和硬件。它提供了一个用于与组件对象模型（COM）对象交互以自动化原生桌面应用的核心库、一个用于构建原生 Windows GUI 应用的框架，以及一个用于将 Python 脚本注册并作为后台系统服务运行的接口。 该项目的独特之处在于提供了与 Windows 环境的深度集成，包括将 Python 代码绑定到原生事件循环以处理系统通知的能力，以及将内部逻辑作为 ISAPI 扩展暴露以处理 Web 请求的能力。 该库更广泛的功能涵盖通过标准化 Windows 数据提供程序接口进行的数据库连接、系统事件日志的管理，以及将交互式解释环境集成到外部软件中。 该项目以针对多种处理器架构（包括 ARM64）的平台特定二进制 wheel 包形式分发。

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

Dev-Cpp is a comprehensive development suite that serves as a C++ integrated development environment, a cross-platform application builder, and a visual UI designer. It provides a toolchain for writing, compiling, and debugging native C++ applications on Windows, while offering a framework to create native binaries for desktop, mobile, and IoT devices from a single codebase. The project distinguishes itself by integrating an embedded SQL database engine and a REST API development platform directly into the workflow. It includes an AI-assisted coding tool that leverages large language models t