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.
651 stars
10 watching
77 forks
Language: Ruby
last commit: over 5 years agoLinked from 1 awesome list
markets/awesome-rubyRelated 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 | A Ruby library that automates the process of importing various file formats into ActiveRecord 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. | 838 |
 theseus-rs/rsql | A command-line interface for interacting with various relational databases | 135 |
 tumblr/jetpants | Automates complex MySQL database tasks and provides a Ruby library for building custom migration scripts | 1,135 |
 rails-sqlserver/tiny_tds | A Ruby gem providing an interface to Microsoft SQL Server using FreeTDS and DB-Library. | 608 |
 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,397 |