Awesome GitHub RepositoriesDatabase Extensions

Dokploy is a self-hosted platform-as-a-service designed to simplify the deployment and management of containerized applications and databases. It provides a centralized control plane that decouples administrative management from application workloads, allowing users to oversee infrastructure across multiple server nodes through a unified web interface or a command-line tool. The platform distinguishes itself through an extensive library of pre-configured application templates, enabling the rapid deployment of databases, identity providers, and various productivity or development tools. It sup

SurrealDB is a multi-model database engine designed to store and query document, graph, relational, and vector data within a single ACID-compliant platform. It functions as an AI-native data store, integrating vector search, graph traversal, and machine learning model execution directly into its query layer. By providing a unified declarative query language, the platform eliminates the need for external middleware to synchronize data across different storage models. The platform distinguishes itself through its ability to manage agent memory and complex workflows natively. It allows developer

SQLModel is a type-safe object-relational mapping library for Python that integrates database schema definitions with data validation logic. By combining these two roles into a single class, it allows developers to manage relational data structures and enforce data integrity for web APIs simultaneously. The framework is built to support asynchronous database operations, enabling high-performance applications to execute queries and transactions without blocking the main execution thread. The library distinguishes itself by leveraging Python type hints to provide IDE autocompletion and compile-

rqlite is a distributed relational database that replicates SQLite data across a cluster using the Raft consensus algorithm. It functions as a fault-tolerant storage system that provides high availability and a web API for executing SQL queries and managing relational data without requiring native database drivers. The system distinguishes itself by using an HTTP SQL interface to expose database operations and cluster management. It features a real-time change data capture stream that pushes database mutations to external HTTP endpoints via webhooks and supports the scaling of read throughput

LibSQL is a high-performance, distributed SQL database engine that extends SQLite to support remote network access, edge computing, and real-time synchronization. It functions as an embedded database library that integrates directly into application processes while providing the infrastructure to maintain consistency across multiple geographic regions. The platform distinguishes itself by enabling database interaction over standard HTTP protocols, allowing applications to query remote data sources in serverless and edge environments without requiring local filesystem access. It includes nativ

Pglite is a client-side relational database engine that runs a full-featured PostgreSQL instance directly within browser and Node.js environments. By leveraging WebAssembly, it provides a persistent SQL storage solution that enables complex data management and querying without requiring an external database server. The project distinguishes itself through a reactive SQL data layer that automatically synchronizes user interface components with live query results. It manages database operations using worker threads to prevent main-thread blocking and coordinates access across multiple browser t

Encore is a distributed systems framework designed to unify backend development, infrastructure provisioning, and observability. It functions as an infrastructure-as-code platform that allows developers to define cloud resources, databases, and messaging topics directly within their application code. By analyzing these declarations at compile-time, the system automatically manages the deployment of cloud resources and security policies, ensuring parity between local development and production environments. The platform distinguishes itself through its integrated development experience, which

PostgresApp is a native macOS application that provides a graphical interface for installing and managing PostgreSQL database servers locally. It serves as a local server manager, allowing users to start, stop, and configure database server states without using the command line. The application supports running multiple different versions of the database server simultaneously on a single machine, enabling multi-version compatibility testing and migrations through isolated environments. It also includes a bundle of pre-installed extensions for geospatial processing and vector search, removing

Realtime is a real-time data distribution and synchronization engine that enables applications to stream database changes and coordinate state between clients. It functions as a synchronization layer that monitors database write-ahead logs to provide change data capture and pushes updates to authorized clients via WebSockets. The project features a real-time presence server for tracking the online status of active users and a broadcast service for sending ephemeral messages without database persistence. It organizes communication through channel-based message routing and uses a structured JSO

Pigsty is a comprehensive database infrastructure orchestration platform designed to automate the full lifecycle of high-availability PostgreSQL clusters. It functions as an infrastructure-as-code framework that manages cluster coordination, node provisioning, and service discovery through idempotent playbooks. By integrating distributed consensus mechanisms, the platform ensures automated failover and consistent state enforcement across diverse environments, including bare metal and virtualized infrastructure. The platform distinguishes itself through a robust suite of operational capabiliti

Sequel is a relational database toolkit for Ruby that provides object-relational mapping, a fluent SQL query builder, and schema migration capabilities. It maps database tables to Ruby classes with support for associations, validations, lifecycle hooks, and eager loading, offering a comprehensive ORM layer for building data-centric applications. Sequel distinguishes itself through a plugin-based extension architecture that allows composable customization of models, databases, and datasets without relying on deep inheritance hierarchies. It includes a thread-safe connection pool with support f

pgrx is a framework for building and packaging custom PostgreSQL extensions using Rust. It serves as a foreign function interface bridge that maps Rust types and functions to the internal server programming interface of the database. The project provides a specialized toolchain for cross-compilation across different operating systems and target architectures using custom sysroots. It includes a schema generator that automatically translates high-level language structures into SQL definitions and binary protocol mappings. The framework manages memory safety by wrapping database memory context

Dieses Projekt ist ein Kubernetes-Operator, der für die Bereitstellung und Verwaltung von PostgreSQL-Datenbankclustern in der Produktion mittels deklarativer Konfigurationen entwickelt wurde. Er fungiert als Controller, der den tatsächlichen Zustand von Datenbankclustern mit einem gewünschten Zustand synchronisiert und ein System für Hochverfügbarkeits-Orchestrierung, automatisiertes Backup und Recovery sowie containerisierte Datenbankadministration bereitstellt. Der Operator zeichnet sich durch eine umfassende Datenschutz-Suite aus, die Point-in-Time-Recovery, Multi-Mode-Backups in Cloud-Objektspeicher und Cluster-Cloning unterstützt. Er stellt kontinuierliche Verfügbarkeit durch verteilten Konsens für automatisiertes Failover sicher und unterstützt ausgefeiltes Traffic-Management durch einen integrierten Connection-Pooler. Das Projekt deckt ein breites Spektrum an operativen Fähigkeiten ab, einschließlich synchroner und asynchroner Replikation, Telemetrie-Erfassung über einen dedizierten Monitoring-Stack und sicheres Identitätsmanagement mit automatisierter TLS-Zertifikatsrotation. Es bietet zudem Tools für die Erweiterung von Speichervolumes, Datenbank-Engine-Updates und die Integration verschiedener Datenbankerweiterungen. Der Controller wird mittels anpassbarer Manifeste in einem Cluster installiert, um die deklarative Orchestrierung der Datenbankumgebung zu ermöglichen.

sqlean ist eine Sammlung von SQLite-Erweiterungsbibliotheken, die als C-basierte Shared Libraries implementiert sind. Sie bietet eine Suite zusätzlicher skalarer und tabellenwertiger Funktionen, die die nativen Fähigkeiten der SQLite-Datenbank-Engine erweitern. Das Projekt bietet spezialisierte Toolsets für Kryptografie, fortgeschrittene Mathematik, Netzwerke und Dateisystemzugriff. Dazu gehören binäres Hashing und Encoding, statistische Analysen, IP-Adressvalidierung sowie die Möglichkeit, CSV-Dateien oder Dateisystempfade als virtuelle Tabellen abzubilden. Die Bibliothek enthält zudem umfassende Textverarbeitungstools wie reguläre Ausdrücke, Fuzzy-Matching und Unicode-bewusste String-Manipulation. Zusätzliche Funktionen decken hochpräzises Datums- und Zeitmanagement sowie die Generierung eindeutiger Identifikatoren ab.

Autobase is a self-hosted PostgreSQL database management platform and orchestrator designed to provide database-as-a-service capabilities. It automates the full lifecycle of PostgreSQL clusters, from initial provisioning and deployment to ongoing administration and decommissioning. The system distinguishes itself by treating database infrastructure as code, allowing clusters to be deployed and updated through version control and continuous integration pipelines. It provides both a centralized web console for visual management and programmatic interfaces for automating infrastructure orchestra

DDEV is a container-based local development environment and project manager designed to bootstrap consistent web development stacks. It orchestrates Docker containers to provide isolated Linux environments, integrating web servers, databases, and language runtimes. The project distinguishes itself by automating the complexities of local networking and security, featuring a local HTTPS proxy for SSL certificate automation and wildcard DNS for hostname management. It further enables collaboration by exposing local environments to the internet through tunneling for external project sharing. The