upsert

Upsert library

A Ruby library that enables efficient upsert operations on relational databases using stored procedures or native SQL features.

Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.

GitHub

652 stars
10 watching
77 forks
Language: Ruby
last commit: almost 4 years ago
Linked from 1 awesome list


Backlinks from these awesome lists:

Related projects:

Repository Description Stars
seamusabshere/remote_table A Ruby library that reads and parses various file formats, including XLSX, XLS, ODS, CSV, TSV, and Google Docs, returning tabular data as arrays or hashes. 226
grempe/tss-rb A Ruby implementation of Threshold Secret Sharing as defined in the IETF Internet-Draft draft-mcgrew-tss-03.txt 23
weshatheleopard/rubyxl A Ruby library for reading and modifying spreadsheet files in the Open XML format 1,276
rom-rb/rom-yesql A Ruby adapter for an in-memory SQL database engine with a simple query language inspired by Clojure's Yesql. 32
alexgutteridge/rsruby A Ruby bridge to the R statistical programming environment 332
seamusabshere/data_miner Automates data import from various file formats into Active Record models 302
ronin-rb/ronin-db A common Ruby library for managing and querying security data across multiple databases 14
jeremyevans/ruby-pledge A Ruby interface to OpenBSD's pledge(2) and unveil(2) system calls for process restriction and file system access control 26
moonstorm/fastcrud A fast and strongly typed .NET ORM library for interacting with various relational databases. 506
dannnylo/rtesseract A Ruby library providing an interface to the Tesseract OCR system. 828
theseus-rs/rsql A command-line interface for interacting with various relational databases 127
tumblr/jetpants Automates complex MySQL database tasks and provides a Ruby library for building custom migration scripts 1,136
rails-sqlserver/tiny_tds A Ruby gem providing a simple and fast interface to Microsoft SQL Server databases 606
blastrain/octillery A Go package for sharding databases in a flexible and declarative way, supporting various OR mapping libraries and raw SQL. 194
soveran/ohm A Ruby library for storing objects in a Redis key-value database 1,398