Awesome GitHub RepositoriesPostgreSQL Integrations

Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.

Wekan 是一个开源、自托管的看板项目管理工具，用于通过看板、列表和卡片组织工作流。它是一个实时 Web 应用程序，允许团队在私有基础设施上管理任务。 该平台的特色在于其广泛的数据迁移工具，特别是用于从 Trello 导入看板和卡片。它支持通过 LDAP、OpenID Connect 和 OAuth2 进行企业级身份集成，并提供灵活的存储选项，包括作为主要关系后端的 PostgreSQL 和用于附件的可插拔云存储。 该系统涵盖了广泛的任务管理功能，包括甘特图可视化、时间跟踪和跨看板任务聚合。它包括用于基于角色的访问控制、自动化备份调度以及通过 REST API 和事件驱动 Webhook 进行编程扩展的管理工具。 该应用程序可通过 Docker 部署，并支持多租户配置。

The AWS Cloud Development Kit is an infrastructure-as-code framework that enables developers to define and provision cloud resources using familiar programming languages. By utilizing construct-based synthesis, it translates high-level, object-oriented code into declarative templates, allowing for the automated management of complex cloud environments through a centralized, code-driven control plane. The framework distinguishes itself through its ability to model infrastructure as a dependency-aware resource graph, ensuring that components are provisioned and updated in the correct order. It

Hydra is a network login password cracker and authentication tester designed to identify valid usernames and passwords through automated brute-force and dictionary attacks. It serves as a multi-protocol authentication tester capable of verifying credentials across a wide range of remote network services, including SSH, SMB, FTP, and various database listeners. The project is distinguished by its ability to execute parallelized password attacks against multiple servers and protocols simultaneously. It features a modular system for implementing diverse network authentication schemes, allowing f

This project is a curated directory of software, libraries, and resources designed to support the management, monitoring, and deployment of PostgreSQL database environments. It functions as a structured index of community-supported tools, providing a centralized location for users to discover utilities that enhance database functionality and reliability. The directory organizes disparate database solutions into a logical hierarchy, covering areas such as graphical interfaces, backup and recovery utilities, and performance monitoring platforms. By categorizing these resources, it assists in th

Canopy is the official Go implementation of a blockchain node that runs a recursive network architecture, enabling new blockchains to launch as dependent layers that can later graduate into fully independent security roots. The project provides a hybrid consensus mechanism that combines Byzantine fault-tolerant Proof-of-Stake with Verifiable-Delay Functions, delivering instant finality while protecting against long-range attacks through trustless chain age verification. Validators secure multiple chains simultaneously through restaking, where a single bonded stake serves as collateral across t

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

Nhost is an open-source backend as a service that provides a managed PostgreSQL database, authentication, and file storage accessible through a unified GraphQL API. It functions as a backend infrastructure orchestrator, enabling the deployment and management of full-stack environments using containerization and command-line automation. The platform distinguishes itself by automating the transformation of relational database tables into a secure GraphQL API and providing an integrated identity provider that supports passwords, magic links, and OAuth. It also includes a serverless function runt

This is a computer science flashcard web application designed for memorizing algorithms, data structures, and general technical concepts. It functions as a spaced repetition study tool that organizes academic materials by category and mastery level to track knowledge acquisition. The application is provided as a containerized educational tool, allowing for self-hosted deployment to ensure consistent execution across different systems. It includes a utility to export stored study sets and academic content into CSV files for use in external applications. The platform covers content management

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

Statping is a self-hosted uptime monitoring system and status page tool. It tracks application availability by sending periodic HTTP requests to target endpoints and records the resulting health status to determine if services are online. The system features a public-facing status dashboard that renders real-time availability and operational health for end users. It utilizes a plugin-based notification system to dispatch multi-channel alerts via email, webhooks, or custom providers when services experience downtime. The project includes a Prometheus-compatible metrics exporter for external p

SpiceDB is a distributed permission store and relationship-based access control system. It provides a scalable database for storing and querying fine-grained authorization relationships, implementing a consistency model inspired by Google Zanzibar to manage access rights across large-scale applications. The system uses a dedicated schema language to define the rules and logic governing how relationships translate into permissions independently of application code. It functions as a pluggable authorization engine that persists relationship tuples in external relational databases such as Postgr

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

Django Oscar is a domain-driven e-commerce framework built on Django for constructing custom online stores. It provides a purpose-built admin dashboard for managing e-commerce operations including products, orders, customers, and promotions, replacing the default Django admin interface. The framework includes a flexible promotions engine for creating multi-buy, bundle, and percentage discounts with custom conditions and benefits, along with a configurable order status and transition system that supports split payments, multi-batch shipping, and deferred payment capture. The framework is desig

This project is a reference implementation of a production-ready backend API built with Rust and the Actix-Web framework. It serves as a codebase demonstrating the development of a newsletter subscription service, encompassing the management of subscriber sign-ups, email confirmations, and campaign delivery. The project highlights a layered architecture that separates concerns into handler, service, and repository layers. It utilizes an actor-based concurrency model for handling HTTP requests and employs trait-based abstractions to decouple business logic from external dependencies, such as e

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

csvkit is a composable Unix-style command-line toolkit for converting, filtering, and analyzing CSV files directly from the terminal. It provides a suite of focused single-purpose commands that can be combined via pipes to build complex data processing workflows, with a modular architecture that includes a column-type inference engine for automatically detecting data types and a streaming-pipeline design for efficient handling of tabular data. The toolkit distinguishes itself through its SQL-engine abstraction layer, which allows users to run SQL queries directly against CSV files without req

Reth is a modular, high-performance Ethereum execution layer client written in Rust. It serves as a full Ethereum node that syncs, validates, and serves blockchain data, functioning as an archive node implementation, a high-throughput RPC node server, and a snapshot sync tool. The project is built around a modular component architecture that allows assembling custom node behavior by swapping independent Rust crates for consensus, execution, mempool, and networking. The client distinguishes itself through a staged sync pipeline that downloads headers and bodies online before processing the res

ihp 是一个为 PostgreSQL 设计的类型安全 Web 框架和全栈应用编排器。它作为一个服务端渲染框架和类型安全 ORM，能自动从 SQL 模式生成记录类型，以确保编译时的查询验证。 该平台的特色在于在编译时验证路由、数据库查询和模板，以防止运行时崩溃。它使用 WebSocket 实现实时 Web 界面以进行即时数据同步，并采用服务器驱动的超媒体进行部分 DOM 修补。 该框架涵盖了广泛的集成功能，包括支持 Passkey 和 OAuth 的用户身份管理、具有自动迁移功能的完整数据存储层，以及具有类型安全 HTML 模板的综合 UI 渲染系统。它还提供了用于 JSON API 开发、异步后台任务执行以及支付网关金融集成的内置工具。 生产环境通过声明式 NixOS 部署进行管理，以实现可复现的基础设施。

Dialogic is a dialogue editor and runtime system for the Godot engine that provides a complete framework for creating branching conversations with characters, animations, and state management. At its core, it functions as a branching narrative editor with visual and text-based timeline authoring, a character animation manager that handles portraits and scene positioning, a localization tool that exports timelines to CSV for translation, and an interactive framework that manages player choices, text reveals, voice lines, and dynamic text effects within conversations. What distinguishes this sy