25 repositorios
Methods for modifying existing database rows using key-value pairs or maps.
Distinct from Database Record Management: Distinct from general record management: focuses specifically on the update operation logic rather than lifecycle management.
Explore 25 awesome GitHub repositories matching data & databases · Record Updates. Refine with filters or upvote what's useful.
ip2region is an offline IP geolocation library and framework designed to resolve IPv4 and IPv6 addresses to city-level regional information using local binary data files. It functions as a binary IP database compiler and a cross-language search client, allowing for regional lookups without relying on external APIs. The project distinguishes itself through a specialized binary format that supports high-performance query optimization. It employs adjacent-segment IP merging and deduplicated region storage to minimize the database footprint, while utilizing memory-mapped file caching and vector-i
Allows modification of raw regional records via manual entry or batch imports before binary compilation.
This project is an educational framework designed to teach the fundamentals of building core distributed systems and web services from scratch in Go. It provides a collection of modular implementations that demonstrate how to construct essential infrastructure components, including web servers, remote procedure call systems, distributed caches, and database abstraction layers. The framework distinguishes itself by focusing on the internal mechanics of these systems rather than providing a high-level abstraction for production use. It covers the implementation of complex architectural patterns
The framework updates existing rows in a database table by accepting either a map or a list of key-value pairs to define the new data.
Lombok is a Java annotation processor and boilerplate reduction library designed to automatically generate repetitive source code. It intercepts the compilation process to inject methods and fields directly into Java classes, acting as a source code generator that eliminates the need to manually write common class patterns. The project distinguishes itself through deep integration with the Java compiler and various integrated development environments. It provides IDE plugins that allow editors to recognize and navigate generated methods, preventing false compilation errors and maintaining syn
Generates methods that return a modified copy of an object to support immutable data patterns.
dbt-core is a command-line framework for transforming data within a warehouse using modular SQL and version control. It functions as a data transformation engine that enables users to define data structures and business logic through declarative configuration files, which the system then compiles into executable code. By managing complex data dependencies through a directed acyclic graph, it ensures that transformation tasks execute in the correct order while maintaining a manifest-driven state to track lineage and execution history. The project distinguishes itself through an adapter-based d
Updates existing rows in the warehouse based on a unique identifier instead of appending duplicates when new data arrives.
Reason is a strongly typed functional language and multi-target compiler designed to produce either JavaScript for web environments or native machine code for operating systems. It serves as an OCaml-compatible language that shares an abstract syntax tree with OCaml, providing a practical syntax for the OCaml ecosystem. The project functions as a type-safe frontend language, incorporating JSX support to build user interfaces through structural elements that translate into type-safe function calls. It enables deep integration with the JavaScript ecosystem, allowing the use of existing librarie
Supports immutable record updates by creating new copies of data with modified fields.
deepstream.io is an open-source realtime server that synchronizes JSON records, events, and remote procedure calls across clients and backend services. It functions as a realtime data sync server, event pub/sub server, record database server, and RPC server, all within a single platform. The server authenticates and authorizes every message using multiple strategies including JWT, HTTP, and file-based credentials, with a declarative permission language controlling access to records, events, and RPCs at a granular level. The platform distinguishes itself through its combination of realtime dat
Retrieves current record values without subscribing to future updates.
Supports immutable field setting that returns a new record copy.
InvenTree is an open-source inventory management platform built on Django, designed for tracking parts, stock levels, and supply chain operations through a web interface and REST API. The system uses barcodes—including QR codes, 1D barcodes, and Data Matrix codes—as primary identifiers for scanning, linking, and triggering inventory actions, and extends core functionality through a Python plugin framework supporting custom actions, UI panels, barcode handlers, and scheduled tasks. The platform distinguishes itself through a comprehensive plugin-based extensibility system that allows custom in
Updates existing database records by matching imported CSV rows using unique identifiers.
Masuit.Tools is a comprehensive static utility library for .NET and ASP.NET Core development. It provides a broad collection of reusable helper methods and infrastructure components that cover common programming tasks without requiring dependency injection or instance management. The library is organized as flat utility classes, making its functionality directly accessible from anywhere in a project. The toolkit distinguishes itself through a wide range of integrated capabilities that go beyond typical utility libraries. It includes a multithreaded range-request file downloader with pause and
Provides an upsert utility for inserting or updating database records based on a key expression.
Pinot is a distributed, columnar analytical database designed for high-concurrency, low-latency query processing. It functions as a real-time OLAP datastore, enabling interactive, user-facing analytics by ingesting and querying massive datasets from both streaming and batch sources. The system architecture relies on a centralized controller for cluster coordination and a distributed segment-based storage model to ensure horizontal scalability. The platform distinguishes itself through a hybrid ingestion pipeline that unifies real-time event streams and historical batch data into a single quer
Updates existing records based on primary keys using full replacement or partial column-level modifications.
CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools
Provides a model method to modify rows by primary key using an associative array of data.
pg is a PostgreSQL object-relational mapper (ORM) for Go that maps Go structs to database tables and provides a fluent query builder for constructing SQL statements programmatically. At its core, it automatically generates CREATE TABLE statements from Go struct definitions using struct tags and naming conventions, and builds queries through method chaining with placeholder-based parameter binding to prevent SQL injection. The library distinguishes itself through relation-aware join generation that automatically constructs JOIN clauses for has-one, has-many, many-to-many, and polymorphic assoc
Updates several structs in a single query using a VALUES list matched by primary key.
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
Provides methods for inserting and updating database records through model instances.
Este proyecto es una hoja de trucos de bases de datos relacionales y una guía de referencia de SQL. Proporciona una colección de ejemplos de sintaxis y documentación de consultas para gestionar bases de datos relacionales utilizando lenguaje de consulta estructurado. La herramienta está implementada como un sitio estático con documentación buscable en el lado del cliente, lo que permite el filtrado inmediato de contenido técnico a través de un índice basado en navegador. La referencia cubre la gestión de bases de datos relacionales, incluyendo la recuperación de datos, la gestión de esquemas de bases de datos y el mantenimiento de registros. También incluye orientación sobre la manipulación de datos relacionales mediante uniones de tablas (joins) y la generación de informes agregados.
Offers syntax examples for inserting, modifying, and removing records from database tables.
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
Provides a full localization pipeline that maps dialogue text to CSV files using Godot's locale system.
This project is an open-source 3D kart racing game and engine. It functions as a multi-mode competitive racer and customizable racing simulator featuring physics-based driving and vehicle collisions across diverse environments. The software includes tools for designing custom karts, authoring racing challenges, and creating 3D tracks. It supports a variety of competition styles beyond traditional racing, including soccer matches and scavenger hunts, and features a tactical combat powerup system and multiple kart classes with distinct performance attributes. The engine provides capabilities f
Maps in-game text identifiers to translated strings from external language files based on the selected locale.
Este proyecto es una capa de acceso a datos SQL y generador de esquemas que permite leer y escribir registros en bases de datos relacionales tratando las tablas como estructuras de datos simples. Funciona como un generador de esquemas automático que crea tablas y columnas de base de datos sobre la marcha según la estructura de los datos entrantes. La herramienta proporciona un cargador masivo de alto rendimiento que importa grandes conjuntos de datos utilizando transacciones atómicas agrupadas para asegurar la consistencia de los datos. También incluye un mecanismo de upsert de registros que determina si actualizar una fila existente o insertar una nueva según identificadores únicos. El sistema cubre la gestión dinámica de esquemas, incluyendo la resolución implícita de columnas y el aprovisionamiento de tablas. Además, proporciona una interfaz de consulta basada en colecciones para recuperar registros o extraer valores únicos sin escribir consultas manuales.
Checks for existing records using unique identifiers to determine whether to update a row or insert a new one.
Goravel es un scaffold de desarrollo y framework completo para construir aplicaciones web, APIs REST y servicios gRPC utilizando el lenguaje de programación Go. Implementa una arquitectura modelo-vista-controlador y proporciona un kit de herramientas integral para servidores y clientes de llamadas a procedimientos remotos de alto rendimiento. El framework se distingue por su extenso ecosistema integrado, que incluye un mapeador objeto-relacional fluido para la gestión de bases de datos y un kit de herramientas de interfaz de línea de comandos dedicado para la automatización administrativa y el scaffolding de proyectos. Cuenta con una abstracción de servicios basada en controladores que permite a los desarrolladores intercambiar backends de almacenamiento, caché y sesiones sin alterar la lógica de la aplicación. La plataforma cubre una amplia superficie de capacidades de aplicación, incluyendo el procesamiento de tareas asíncronas con colas distribuidas, gestión de identidad segura mediante autenticación basada en tokens y una capa de seguridad robusta con cifrado y control de acceso. También proporciona herramientas para la localización de contenido, renderizado de plantillas e infraestructura de pruebas automatizada con mocking de dependencias.
Implements standard create, update, and delete operations for model instances, including high-performance bulk insertions.
Dhall es un lenguaje de configuración con tipado fuerte diseñado para crear archivos de configuración programables que garantizan su terminación. Es un lenguaje no completo según Turing que utiliza un sistema de tipos estricto para asegurar la corrección y prevenir bucles infinitos durante la evaluación. El proyecto funciona como un motor de configuración determinista y herramienta de marshalling, convirtiendo expresiones programables en formatos estáticos como JSON, YAML y Bash. Se distingue por su enfoque en la seguridad e integridad, utilizando hashing semántico para fijar importaciones remotas y aplicando políticas de origen para prevenir la exfiltración de datos. Sus capacidades cubren una amplia superficie de gestión de configuración, incluyendo el uso de funciones polimórficas, tipos de unión y completado de registros para reducir la redundancia. Proporciona herramientas para la validación de esquemas, resolución de expresiones remotas y una implementación del Language Server Protocol para la integración con editores. El lenguaje proporciona una interfaz de línea de comandos y un REPL para evaluar expresiones y verificar la igualdad.
Modify specific values deep within a record structure without redefining the entire object.
Flask-SQLAlchemy es un kit de herramientas que integra el kit de herramientas de base de datos relacional SQLAlchemy con el framework web Flask. Permite el modelado de datos relacionales definiendo estructuras de tablas de base de datos como clases de Python y gestiona la persistencia y recuperación de registros de base de datos dentro de una aplicación web. El proyecto vincula los ciclos de vida de la sesión de base de datos al contexto de solicitud de la aplicación activa para garantizar la limpieza automática de la conexión. Proporciona utilidades especializadas para el acceso a datos web, incluyendo paginación de resultados de consultas y un mecanismo para activar automáticamente respuestas 404 Not Found cuando falta un registro de base de datos solicitado. La extensión cubre una amplia gama de capacidades de gestión de bases de datos, incluyendo mapeo de modelos declarativos, reflexión de esquemas y la generación de estructuras de tablas físicas. Admite la gestión avanzada de conexiones a través de enrutamiento de consultas multi-bind y proporciona herramientas de observabilidad para auditar el rendimiento de las consultas SQL y el tiempo de ejecución.
Performs create, update, and delete operations on model objects and persists changes through a session.