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 es una plataforma integral de orquestación de infraestructura de bases de datos diseñada para automatizar el ciclo de vida completo de clústeres de PostgreSQL de alta disponibilidad. Funciona como un framework de infraestructura como código que gestiona la coordinación de clústeres, el aprovisionamiento de nodos y el descubrimiento de servicios a través de playbooks idempotentes. Al integrar mecanismos de consenso distribuido, la plataforma garantiza la conmutación por error automatizada y la aplicación de estado consistente en diversos entornos, incluyendo infraestructura bare metal y virtualizada. La plataforma se distingue por un sólido conjunto de capacidades operativas que se extienden más allá de la gestión estándar de bases de datos. Cuenta con una tubería de observabilidad integrada que agrega métricas, registros y trazas en paneles centralizados para la monitorización del rendimiento en tiempo real y el análisis de diagnóstico. Además, proporciona un framework de migración que emula protocolos de cable propietarios y sintaxis SQL, permitiendo la integración de cargas de trabajo de bases de datos empresariales heredadas en entornos relacionales modernos. El sistema cubre una amplia superficie funcional, incluyendo gestión avanzada de almacenamiento con clonación de copia en escritura para un despliegue rápido, y orquestación de múltiples bases de datos que coordina motores relacionales con almacenamiento en caché y almacenamiento de objetos. También incorpora endurecimiento de seguridad, copia de seguridad y recuperación automatizadas, y enrutamiento de tráfico a través de proxies en capas para desacoplar las conexiones de los clientes de la topología del clúster subyacente. El proyecto se distribuye como un modelo de espejo de paquetes autónomo, lo que permite un despliegue y una gestión de dependencias consistentes en entornos seguros o aislados.

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

Este proyecto es un operador de Kubernetes diseñado para desplegar y gestionar clusters de bases de datos PostgreSQL de producción utilizando configuraciones declarativas. Funciona como un controlador que sincroniza el estado real de los clusters de bases de datos con un estado deseado, proporcionando un sistema para la orquestación de alta disponibilidad, respaldo y recuperación automatizados, y administración de bases de datos en contenedores. El operador se distingue por una suite integral de protección de datos que admite recuperación en un punto en el tiempo, respaldos en modo múltiple a almacenamiento de objetos en la nube y clonación de clusters. Asegura la disponibilidad continua utilizando consenso distribuido para la conmutación por error (failover) automatizada y admite una gestión de tráfico sofisticada a través de un pooler de conexiones integrado. El proyecto cubre una amplia gama de capacidades operativas, incluyendo replicación síncrona y asíncrona, recolección de telemetría a través de un stack de monitoreo dedicado y gestión de identidad segura con rotación automática de certificados TLS. También proporciona herramientas para la expansión de volúmenes de almacenamiento, actualizaciones del motor de base de datos e integración de varias extensiones de base de datos. El controlador se instala en un cluster utilizando manifiestos personalizables para permitir la orquestación declarativa del entorno de base de datos.

sqlean es una colección de librerías de extensión para SQLite implementadas como librerías compartidas basadas en C. Proporciona un conjunto de funciones escalares y de tabla adicionales que amplían las capacidades nativas del motor de base de datos SQLite. El proyecto proporciona conjuntos de herramientas especializados para criptografía, matemáticas avanzadas, redes y acceso al sistema de archivos. Estos incluyen hashing y codificación binaria, análisis estadístico, validación de direcciones IP y la capacidad de mapear archivos CSV o rutas del sistema de archivos como tablas virtuales. La librería también incluye herramientas integrales de procesamiento de texto como expresiones regulares, coincidencia difusa (fuzzy matching) y manipulación de cadenas consciente de Unicode. Las capacidades adicionales cubren la gestión de fecha y hora de alta precisión y la generación de identificadores únicos.

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