Upsert
A Ruby library for fast, database-agnostic upsert operations on MySQL, PostgreSQL, and SQLite3 without ActiveRecord dependencies.
What is Upsert?
Upsert is a Ruby library that enables efficient upsert (insert or update) operations on relational databases like MySQL, PostgreSQL, and SQLite3. It solves the problem of handling duplicate records by providing a fast, database-agnostic method that avoids the performance overhead of ActiveRecord. The library transparently creates and reuses stored procedures or functions as needed, adapting to each database's capabilities.
Ruby developers working with relational databases who need high-performance upsert operations, especially those using raw database connections (e.g., Mysql2, PG) or avoiding ActiveRecord in data-intensive applications.
Developers choose Upsert for its significant speed advantages (70–90% faster than ActiveRecord), database portability, and lightweight design without ActiveRecord dependencies. It offers a consistent API across MySQL, PostgreSQL, and SQLite3, with automatic optimization for native database features like PostgreSQL's ON CONFLICT.
Overview
Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
Use Cases
Best For
- High-volume data import or synchronization tasks requiring upsert logic
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
