25 repository-uri
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.
This project is a relational database cheat sheet and SQL reference guide. It provides a collection of syntax examples and query documentation for managing relational databases using structured query language. The tool is implemented as a static site with client-side searchable documentation, allowing for immediate filtering of technical content through a browser-based index. The reference covers relational database management, including data retrieval, database schema management, and record maintenance. It also includes guidance on relational data manipulation through table joins and the g
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.
Acest proiect este un strat de acces la date SQL și un generator de schemă care permite citirea și scrierea înregistrărilor în baze de date relaționale prin tratarea tabelelor ca structuri de date simple. Funcționează ca un generator automat de schemă care creează tabele și coloane de bază de date din mers, pe baza structurii datelor primite. Instrumentul oferă un încărcător în masă de înaltă performanță care importă seturi mari de date folosind tranzacții atomice grupate pentru a asigura consistența datelor. Include, de asemenea, un mecanism de upsert al înregistrărilor care determină dacă să actualizeze un rând existent sau să insereze unul nou pe baza identificatorilor unici. Sistemul acoperă gestionarea dinamică a schemei, inclusiv rezoluția implicită a coloanelor și furnizarea tabelelor. Oferă, de asemenea, o interfață de interogare bazată pe colecții pentru preluarea înregistrărilor sau extragerea valorilor unice fără a scrie interogări manuale.
Checks for existing records using unique identifiers to determine whether to update a row or insert a new one.
Goravel este un scaffold de dezvoltare complet și un framework pentru construirea de aplicații web, API-uri REST și servicii gRPC folosind limbajul de programare Go. Implementează o arhitectură model-view-controller și oferă un set de instrumente cuprinzător pentru servere și clienți de tip remote procedure call (RPC) de înaltă performanță. Framework-ul se distinge prin ecosistemul său integrat extins, care include un ORM (object-relational mapper) fluent pentru gestionarea bazelor de date și un toolkit CLI dedicat pentru automatizarea administrativă și scaffolding-ul proiectelor. Dispune de o abstractizare a serviciilor bazată pe drivere, care permite dezvoltatorilor să schimbe backend-urile de stocare, cache și sesiune fără a altera logica aplicației. Platforma acoperă o suprafață largă de capabilități pentru aplicații, inclusiv procesarea asincronă a sarcinilor cu cozi distribuite, gestionarea securizată a identității prin autentificare bazată pe token-uri și un strat robust de securitate cu criptare și control al accesului. Oferă, de asemenea, instrumente pentru localizarea conținutului, randarea de template-uri și o infrastructură de testare automatizată cu dependency mocking.
Implements standard create, update, and delete operations for model instances, including high-performance bulk insertions.
Dhall este un limbaj de configurare type-safe conceput pentru a crea fișiere de configurare programabile care sunt garantate să se termine. Este un limbaj non-Turing-complete care utilizează un sistem de tipuri strict pentru a asigura corectitudinea și a preveni buclele infinite în timpul evaluării. Proiectul funcționează ca un motor de configurare determinist și instrument de marshalling, convertind expresiile programabile în formate statice precum JSON, YAML și Bash. Se distinge printr-un accent pe securitate și integritate, utilizând hashing semantic pentru a fixa importurile la distanță și impunând politici de origine pentru a preveni exfiltrarea datelor. Capabilitățile sale acoperă o suprafață largă de gestionare a configurației, inclusiv utilizarea funcțiilor polimorfice, a tipurilor union și a completării înregistrărilor pentru a reduce redundanța. Oferă instrumente pentru validarea schemelor, rezolvarea expresiilor la distanță și o implementare Language Server Protocol pentru integrarea în editor. Limbajul oferă o interfață de linie de comandă și un REPL pentru evaluarea expresiilor și verificarea egalității.
Modify specific values deep within a record structure without redefining the entire object.
Flask-SQLAlchemy is a toolkit that integrates the SQLAlchemy relational database toolkit with the Flask web framework. It enables relational data modeling by defining database table structures as Python classes and manages the persistence and retrieval of database records within a web application. The project binds database session lifecycles to the active application request context to ensure automatic connection cleanup. It provides specialized utilities for web data access, including query result pagination and a mechanism to automatically trigger 404 Not Found responses when a requested d
Performs create, update, and delete operations on model objects and persists changes through a session.