Awesome GitHub RepositoriesUpdate Operations

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.

LiveKit is a comprehensive framework for building and orchestrating real-time, multimodal AI agents that interact with users through voice, video, and text. It provides a centralized, event-driven architecture to manage the entire lifecycle of automated participants, from initialization and session state management to graceful shutdown. By utilizing a selective forwarding unit, the platform efficiently routes media streams between participants and agents, ensuring low-latency communication and secure, token-based authentication for all connections. The platform distinguishes itself through it

BookStack is a self-hosted knowledge base platform designed for organizing, storing, and managing structured documentation. It utilizes a hierarchical content model that arranges information into nested trees of books, chapters, and pages, supported by a dedicated search index for rapid retrieval across the entire knowledge base. The platform distinguishes itself through deep integration with enterprise identity providers, allowing organizations to centralize authentication and access control via LDAP, SAML, or OIDC. It provides extensive administrative control over the content lifecycle, inc

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

This project is a framework for developing multimodal AI agents that function as programmable participants in real-time communication rooms. It enables the construction of agents that can see, hear, and speak by integrating speech-to-text, large language models, and text-to-speech pipelines to facilitate low-latency, natural conversations. The system is distinguished by its advanced orchestration of real-time media and conversational flow, including support for full-duplex speech, preemptive response generation, and sophisticated interruption management. It further differentiates itself throu

TubeArchivist is a self-hosted YouTube video archiving system and metadata indexer. It functions as a personal media library and download manager that allows users to create a searchable offline collection of videos, channels, and playlists. The system distinguishes itself by indexing subtitles, comments, and channel information for full-text search and retrieval. It features automated media synchronization to track subscriptions and playlists, ensuring new content is automatically queued and downloaded as it is published. The project provides a broad set of capabilities for digital asset ma

Mapper is a MyBatis-specific library that provides annotation-driven object-relational mapping, enabling single-table CRUD operations without writing SQL or XML. It uses Java reflection and field-level annotations to map entity fields to database columns, configure primary key generation strategies, and generate mapper interfaces and model classes from database schemas. The library distinguishes itself through several practical capabilities. It includes a safe operation guard that blocks delete and update calls lacking query conditions, preventing accidental full-table modifications. Its exam

Hazelcast is a distributed data platform that combines an in-memory data grid with a stream processing engine to support real-time analytics and event-driven applications. It functions as a partitioned, distributed key-value store that replicates data across cluster nodes to provide low-latency access and high availability. The platform also serves as a distributed SQL query engine, allowing users to execute standard SQL statements against both in-memory datasets and external data sources. What distinguishes Hazelcast is its use of a distributed consensus subsystem to maintain strongly consis

kube-state-metrics is a Kubernetes metrics exporter that generates Prometheus-compatible metrics from the current state of cluster objects such as pods, deployments, and nodes. It operates by watching the Kubernetes API server and transforming resource snapshots into metric families, which are then exposed over an HTTP endpoint in the Prometheus text-based exposition format for direct scraping. The project distinguishes itself through horizontal scaling capabilities, distributing metric collection across multiple instances using object UID hashing to reduce per-instance memory consumption. It

Apache Hive is a SQL-on-Hadoop data warehouse that enables querying and managing petabytes of data stored in distributed storage such as HDFS and cloud storage services. It provides a familiar SQL interface for batch analytics and reporting, supported by a core set of components including the HiveServer2 Thrift service for remote query execution, the Hive Metastore Service for central metadata management, the Hive ACID Transaction Engine for concurrent read-write operations, and the Hive LLAP Interactive Engine for low-latency analytical processing. The WebHCat REST API offers an HTTP interfac

SqlSugar is an object-relational mapping library for .NET that translates C# and VB objects into database queries and tables without requiring raw SQL. It is designed as a multi-database ORM supporting SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, ClickHouse, and other databases through a unified API, and it is compatible with .NET AOT compilation for native ahead-of-time deployment. The library distinguishes itself through high-speed bulk data operations that can insert or update millions of records in seconds using batch processing instead of row-by-row handling. It also provides multi-te

Naabu is a port scanner library and tool that probes hosts for open ports using SYN, CONNECT, and UDP methods to identify active services. It functions as a Go library for embedding port scanning into programs, and as a standalone tool that accepts targets as hostnames, IP addresses, CIDR ranges, or ASN numbers. The tool discovers live hosts before scanning, filters ports by range or top lists, and can integrate with Nmap for service version detection. The project distinguishes itself through its SYN-based port probing approach that sends TCP SYN packets and analyzes responses without complet

Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop. The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS

lakeFS ist ein Data-Lake-Versionierungssystem, das Git-ähnliche Branching- und Commit-Funktionen für große Datensätze in Objektspeichern bietet. Es fungiert als Versionskontrollschicht und ermöglicht die Erstellung unveränderlicher Snapshots, atomarer Commits und Zero-Copy-Branching, um isolierte Umgebungen für Datenexperimente zu schaffen, ohne physische Dateien zu duplizieren. Das System dient als S3-kompatibles Storage-Gateway und Iceberg-REST-Katalog, wodurch Standard-Cloud-Storage-Protokolle und kompatible Clients versionierte Tabellen verwalten können. Es fungiert als Data-Quality-Gatekeeper, indem es ein eventgesteuertes Hook-System nutzt, um Datensätze gegen Governance-Richtlinien zu validieren, bevor Änderungen in die Produktion gemergt werden. Die Plattform deckt umfassende Funktionen für Data-Governance ab, einschließlich Pull-Request-Kollaboration, rollenbasierter Zugriffskontrolle und Data-Lineage-Tracking. Sie bietet Integrationen für Workflow-Orchestrierung, Machine-Learning-Pipelines und verschiedene Big-Data-Compute-Engines und unterstützt Multi-Cloud-Storage-Konnektivität sowie Identitätssynchronisation via SSO und SCIM. Die Software kann mittels Binärdateien, Containern oder Helm-Charts für die Bereitstellung auf Kubernetes installiert werden.

Loro is a conflict-free replicated data type (CRDT) framework and collaborative state engine designed for building real-time collaborative applications. It provides a distributed data synchronizer that enables multiple users to edit shared documents and complex nested structures—such as maps, lists, trees, and counters—with automatic state convergence without requiring a central server. The project distinguishes itself through a versioned document store that supports branching, forking, and merging via a directed acyclic graph of causal operation history. It enables advanced version control c

ShareJS ist eine kollaborative Dokumentendatenbank und Synchronisations-Engine, die für die Verwaltung gemeinsam genutzter Zustände in Echtzeit konzipiert ist. Sie bietet eine Operational-Transform-Sync-Engine, um die gleichzeitige Bearbeitung von Klartext- und JSON-Daten zu ermöglichen, sowie eine RESTful-Synchronisations-API für die Verwaltung von Dokumentzuständen via HTTP. Das System verfügt über eine Offline-First-Datensynchronisationsschicht, die lokale Änderungen bei Verbindungsunterbrechung in eine Warteschlange stellt und Bearbeitungen bei Wiederherstellung der Verbindung automatisch überträgt. Es enthält zudem eine Middleware-Zugriffskontrollschicht, die Datenbankanfragen abfängt, um Sicherheitsrichtlinien durchzusetzen und Anfragen umzuschreiben. Die Plattform deckt ein breites Spektrum an Funktionen ab, einschließlich Live-Query-Abonnements, Echtzeit-Änderungsbenachrichtigungen und gleichzeitiger Inhaltssynchronisation. Diese Komponenten ermöglichen die Erstellung von Daten-Feeds, bei denen Clients sofort benachrichtigt werden, wenn Backend-Dokumente, die bestimmten Abfragen entsprechen, aktualisiert werden.

Querydsl ist ein Framework für die Konstruktion typsicherer Abfragen. Es verwendet eine Fluent-API und annotationsbasierte Codegenerierung, um Spiegelklassen aus Domänenmodellen zu erstellen, was eine Validierung von Datenbankabfragen zur Kompilierzeit ermöglicht und die Notwendigkeit manueller String-Verkettung beseitigt. Das Projekt bietet eine einheitliche Abfragesyntax, die in spezifische Dialekte für mehrere Backends übersetzt wird, einschließlich SQL, MongoDB, Lucene und JDO. Es unterstützt fortgeschrittene Abfragefunktionen wie Common Table Expressions, Window-Funktionen, geospatiale Operationen und komplexe verschachtelte Subqueries. Über den Datenabruf hinaus deckt das Framework die typsichere DML-Ausführung für Massenaktualisierungen und -löschungen sowie das Result-Mapping in Java-Beans, Konstruktoren oder Tupel ab. Es beinhaltet Unterstützung für In-Memory-Collection-Abfragen und integriert sich in das Spring-Framework für Transaktionsmanagement und Verbindungsverwaltung.

Bun ist ein typsicherer Object-Relational-Mapper für Go, der SQL-first-Abfragekonstruktion und Result-Mapping priorisiert. Er fungiert als programmierbarer SQL-Abfrage-Builder, Datenbank-Verbindungsmanager und Tool zur Abbildung von Datenbanktabellen auf Go-Structs. Das Projekt zeichnet sich durch ein Multi-Dialekt-SQL-Unterstützungssystem aus, das es einer einzigen Codebasis ermöglicht, über eine konsistente Schnittstelle mit verschiedenen Datenbank-Engines zu interagieren. Es enthält ein integriertes Datenbank-Observability-Tool für Abfrage-Interzeption, verteiltes Tracing und Logging sowie ein Schema-Migrations-Tool zur Versionierung struktureller Änderungen. Die Bibliothek deckt ein breites Spektrum an Datenoperationen ab, einschließlich Bulk-Verarbeitung, Upserts, Soft-Deletes und der Verwaltung relationaler Daten wie polymorpher Assoziationen. Sie bietet Funktionen für fortgeschrittene SQL-Analysen unter Verwendung von Common Table Expressions und Window-Funktionen, neben atomarem Transaktionsmanagement und Connection-Pooling. Das Schema-Management wird über eine Kommandozeilenschnittstelle zur Anwendung versionierter Migrationsskripte unterstützt.

Kimai is an open-source time tracking system that records employee working hours, manages absences, and generates professional invoices from recorded timesheets and expenses. It organizes all time records through a mandatory three-level hierarchy of customer, project, and activity, and supports project budget monitoring with configurable time and money limits. The application is extensible through a plugin system that allows adding custom features, invoice templates, reporting views, and dashboard widgets without modifying core files. It provides a RESTful JSON API for programmatic read and w

FreeSql is a .NET object-relational mapper and data access layer that translates object-oriented code into SQL for multiple relational database providers. It functions as a fluent SQL query builder and database schema synchronizer, allowing developers to align database table and index structures with entity class definitions. The framework is specifically optimized for .NET Native AOT to ensure reduced memory footprints and faster startup times. It includes a database traffic manager to distribute load through read-write splitting, dynamic table sharding, and tenant-based data isolation. Bro