Awesome GitHub RepositoriesPostgreSQL Protocol Compatibility

Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures. The system distinguishes itself through

Wekan هي أداة إدارة مشاريع Kanban مفتوحة المصدر ومستضافة ذاتياً تُستخدم لتنظيم سير العمل من خلال اللوحات والقوائم والبطاقات. إنه تطبيق ويب في الوقت الفعلي يسمح للفرق بإدارة المهام على بنية تحتية خاصة. تتميز المنصة بأدوات ترحيل بيانات واسعة، وتحديداً لاستيراد اللوحات والبطاقات من Trello. وهي تدعم تكامل الهوية على مستوى المؤسسة عبر LDAP وOpenID Connect وOAuth2، وتوفر خيارات تخزين مرنة بما في ذلك PostgreSQL كخلفية علائقية أساسية وتخزين سحابي قابل للتوصيل للمرفقات. يغطي النظام مجموعة واسعة من قدرات إدارة المهام، بما في ذلك تصورات مخطط Gantt، وتتبع الوقت، وتجميع المهام عبر اللوحات. يتضمن أدوات إدارية للتحكم في الوصول القائم على الأدوار، وجدولة النسخ الاحتياطي الآلي، وقابلية التوسع البرمجي من خلال REST API وwebhooks القائمة على الأحداث. التطبيق متاح للنشر عبر Docker ويدعم تكوينات متعددة المستأجرين.

This project is a MySQL database driver and client for Node.js. It provides a JavaScript implementation of the MySQL protocol to facilitate connecting to, querying, and managing data within MySQL databases. The driver includes a connection pool manager to maintain a cache of reusable database connections, reducing the overhead of frequent network handshakes. It also supports row-by-row result streaming to process large datasets without loading entire result sets into memory. Core capabilities cover SQL query execution, the management of database transactions, and the coordination of multiple

This project is a database driver and interface for the Go programming language, specifically designed for PostgreSQL. It provides a low-level library for executing SQL queries, managing transactions, and handling data persistence within Go applications. The driver distinguishes itself by implementing the native PostgreSQL binary wire protocol, which minimizes communication overhead and maximizes data transfer efficiency. It includes advanced connection pooling to maintain persistent database sessions and supports prepared statement caching to accelerate the execution of frequently repeated o

This project is a Node.js client for PostgreSQL databases, providing a protocol parser to translate raw binary streams into JavaScript objects. It serves as a driver for executing queries, managing data, and integrating Node.js applications with PostgreSQL backends. The library includes a connection pool manager to reduce network overhead by caching reusable connections and a result streamer that uses cursors to retrieve large datasets incrementally. It also functions as an event listener for subscribing to asynchronous server-side notifications to trigger real-time application events. Broad

pq is a PostgreSQL driver for Go that implements the standard database/sql interface. It serves as a connection library and protocol implementation that translates application data types into the binary and text formats required by PostgreSQL. The project provides specialized utilities for high-performance data ingestion using bulk data loading and a dedicated bulk data importer. It also features an implementation for listening to asynchronous server notifications and provides tools for connection load balancing across multiple hosts and ports. The driver covers a broad surface of database i

RisingWave is a cloud-native streaming database and real-time analytics engine that uses standard SQL to process continuous data streams. It functions as a streaming data lakehouse, combining the capabilities of a streaming SQL database with a platform that integrates streaming ingestion with open table formats. The system is distinguished by its use of the PostgreSQL wire protocol, allowing it to integrate with existing SQL tools and drivers. It employs a decoupled compute and storage architecture, persisting streaming state and materialized views in cloud object storage to enable independen

immudb is a tamperproof database that maintains an immutable record of entries using cryptographic commit logging. It ensures verifiable database integrity by utilizing Merkle trees to generate membership and consistency proofs that detect unauthorized data alterations. The system employs a multi-model storage engine that unifies key-value, document, and relational data structures within a single immutable backend. It provides compatibility with the PostgreSQL wire protocol, allowing it to integrate with standard SQL clients, ORMs, and database tools. The project covers broad capabilities in

asyncpg is an asynchronous database driver and binary protocol client for PostgreSQL. It provides a non-blocking interface for executing SQL statements, streaming result sets, and managing data transfer between an application and a PostgreSQL database. The driver implements the PostgreSQL binary protocol directly to facilitate efficient data transfer and type conversion. It includes a connection pool to maintain and reuse open database connections, reducing the latency associated with repeated handshakes. The project covers a broad range of database integration capabilities, including atomic

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

Materialize is a streaming SQL database that continuously ingests live data from sources such as Kafka, Redpanda, PostgreSQL, and MySQL, and incrementally maintains materialized views. It provides a PostgreSQL-compatible query engine that accepts standard SQL over the PostgreSQL wire protocol, enabling any existing SQL client or BI tool to query real-time data. The system also includes a Model Context Protocol (MCP) server that exposes live materialized view data to AI agents, providing fresh context without polling. Materialize distinguishes itself through its ability to offer configurable c

GreptimeDB is a distributed, open-source time-series database built for unified observability. It stores and queries metrics, logs, and traces together in a single columnar engine, supporting both SQL and PromQL for analysis. The database is designed as a Kubernetes-native operator with a decoupled compute and storage architecture, enabling horizontal scaling and multi-region deployment. What distinguishes GreptimeDB is its role as a multi-protocol ingestion gateway, accepting data through OpenTelemetry, Prometheus Remote Write, InfluxDB, Loki, Elasticsearch, Kafka, and MQTT protocols without

Cortex is an open-source, horizontally scalable metrics platform that ingests, stores, and queries Prometheus-compatible time-series data with multi-tenant isolation. It accepts metrics via Prometheus remote write and OpenTelemetry, executes PromQL queries against both recent and historical data, and provides a Prometheus-compatible alerting and recording rule engine with an integrated Alertmanager. The system is built as a set of independently scalable microservices that use hash-ring-based sharding, gossip-based cluster membership, and tenant-aware object storage to distribute workloads acro

Ory Keto is an open-source authorization server that implements Google Zanzibar’s relationship-based access control model. It stores every access relationship as a tuple in a SQL database and exposes a declarative TypeScript-like namespace language for defining object types, relations, and permissions. The service provides bidirectional permission resolution, configurable consistency levels for checks, and dual gRPC and REST APIs for broad integration. Keto extends the Zanzibar model with edge enforcement of access policies, structured compliance auditing of permission decisions, and infrastr

YDB هي قاعدة بيانات SQL موزعة ومحرك تحليلي مصمم لقابلية التوسع الأفقي والاتساق القوي. تعمل كنظام متعدد النماذج يدعم أحمال العمل المعاملاتية والتحليلية من خلال معمارية موزعة توفر معاملات ACID قابلة للتسلسل. يتميز النظام بتوافقه الواسع مع البروتوكولات، حيث ينفذ بروتوكول PostgreSQL لبرامج تشغيل SQL القياسية وبروتوكول Kafka للمراسلة والبث. كما يعمل كقاعدة بيانات متجهة، حيث يدعم فهارس المتجهات وعمليات البحث عن أقرب جار تقريبي للبحث الدلالي والتضمينات. تدير المنصة البيانات باستخدام نموذج تخزين هجين مع تنسيقات موجهة للصفوف وموجهة للأعمدة، باستخدام تنفيذ الاستعلام المتجه لتحليلات على نطاق البيتابايت. يشمل سطحها التشغيلي بث تغيير البيانات (CDC)، وطوابير ثابتة مرة واحدة بالضبط، وتوافر عالي متعدد المناطق. يتم دعم النشر وإدارة دورة الحياة من خلال مشغل Kubernetes وتوفير البنية التحتية ككود.

pgx هو إطار عمل ومجموعة أدوات لتطوير إضافات PostgreSQL عالية الأداء باستخدام لغة البرمجة Rust. يوفر غلاف API منخفض المستوى للتفاعل مع سياقات ذاكرة قاعدة البيانات الداخلية، وأنظمة التسجيل، وواجهات برمجة تطبيقات التنفيذ الأساسية، مما يتيح تنفيذ وظائف ومنطق قاعدة بيانات مخصص مباشرة داخل محرك قاعدة البيانات. يتميز المشروع بأداة بناء مخصصة وواجهة سطر أوامر تدير دورة حياة تطوير الإضافات، بدءاً من تهيئة البيئة وحتى حزم الملفات الثنائية. يتضمن أداة تعيين الأنواع (type mapper) التي تترجم هياكل اللغة إلى أنواع مركبة في قاعدة البيانات وتنشئ تعريفات مخطط SQL المقابلة تلقائياً. يغطي إطار العمل مساحة واسعة من القدرات بما في ذلك تعيين الوظائف المعرفة من قبل المستخدم، وتكامل البروتوكول الثنائي، ودعم استهداف إصدارات متعددة لضمان التوافق عبر إصدارات قاعدة البيانات المختلفة. كما يوفر أغلفة متخصصة لإدارة الذاكرة للتعامل مع المؤشرات ومنع التسريبات داخل بيئة قاعدة البيانات.

TablePlus is a SQL database management GUI and professional administration tool designed for managing relational and NoSQL databases. It functions as a native SQL query client and relational data browser, providing a graphical interface for database administration, schema management, and data exploration. The project distinguishes itself through a staged-change commit system that buffers GUI-driven modifications locally for review before they are applied to the server. It also features a native-protocol connection layer for low-latency communication and secure connectivity via SSH tunneling.

Npgsql is a .NET data provider and client library that enables applications to connect, execute queries, and manage data within PostgreSQL databases. It functions as a connection manager and translation layer between the application and the database server. The project features a connection manager capable of multi-host connectivity, providing load balancing and automatic failover across multiple servers. It includes specialized support for high-volume data import and export through bulk data operations and a mapping system that translates complex database types, such as arrays and JSON, into