{"id":94018,"library":"upsert","title":"Upsert","description":"Makes it easy to upsert on MySQL, PostgreSQL, and SQLite3 by transparently creating merge functions or using INSERT OR IGNORE.","status":"active","version":"2.9.10","language":"ruby","source_language":null,"source_url":"https://github.com/seamusabshere/upsert","tags":["upsert","mysql","postgresql","sqlite3","database"],"install":[{"cmd":"gem install upsert","lang":"bash","label":"gem install"},{"cmd":"# Gemfile\ngem 'upsert', '~> 2.9.10'","lang":"ruby","label":"Gemfile"}],"dependencies":[],"imports":[{"symbol":"Upsert","correct":"require 'upsert'"}],"quickstart":{"code":"require 'upsert'\nUpsert.new(connection, :table).row({id: 1}, {name: 'Alice'})","lang":"ruby","description":"Insert or update a row in a database table"},"warnings":[],"env_vars":null,"search_vec":"'creat':14 'databas':26 'easi':4 'function':16 'ignor':21 'insert':19 'make':2 'merg':15 'mysql':8,23 'postgresql':9,24 'sqlite3':11,25 'transpar':13 'upsert':1,6,22 'use':18","created_at":"2026-06-19T09:59:42.608411+00:00","updated_at":"2026-06-19T09:59:42.608411+00:00","problems":[],"ecosystem":"rubygems","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/seamusabshere/upsert","github":"https://github.com/seamusabshere/upsert","docs":"http://www.rubydoc.info/gems/upsert/","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-19","next_check":"2026-12-16","install_tag":null}}