MySQL

This is the MySQL API module for Ruby. It provides the same functions for Ruby programs that the MySQL C API provides for C programs. This package is offered as gem for easy installation using RubyGems. It wraps unmodified tmtm's mysql-ruby extension into a proper gem. Please note that tmtm (Tomita Mashahiro) has deprecated development of this extension and only update it for bug fixes.

A simple, fast Mysql library for Ruby, binding to libmysql

MySQL JDBC adapter for JRuby on Rails.

Install this gem `require 'jdbc/mysql'` and invoke `Jdbc::MySQL.load_driver` within JRuby to load the driver.

Enhanced Ruby MySQL driver

extension for mysql2 to add client-side variable binding, by adding method Mysql2::Client#xquery

Implements the DataObjects API for MySQL

Let ActiveRecord serialize and cast your UUIDs to and from binary columns in your database.

Mysql2 instrumentation for the OpenTelemetry framework

AR-JDBC is a database adapter for Rails' ActiveRecord component designed to be used with JRuby built upon Java's JDBC API for database access. Provides (ActiveRecord) built-in adapters: MySQL, PostgreSQL and SQLite3 as well as adapters for popular databases such as Oracle, SQLServer, DB2, FireBird and even Java (embed) databases: Derby, HSQLDB and H2. It allows to connect to virtually any JDBC-compliant database with your JRuby on Rails application.

An ActiveRecord adapter for MySQL, based on mysql gem.

MySQL DBI DBD, Leverages 'mysql' low-level driver

Request log analyzer's purpose is to find out how your web application is being used, how it performs and to focus your optimization efforts. This tool will parse all requests in the application's log file and aggregate the information. Once it is finished parsing the log file(s), it will show the requests that take op most server time using various metrics. It can also insert all parsed request information into a database so you can roll your own analysis. It supports Rails-, Merb- and Rack-based applications logs, Apache and Amazon S3 access logs and MySQL slow query logs out of the box, but file formats of other applications can easily be supported by supplying an easy to write log file format definition.

This is an ActiveRecord connection adapter for MySQL Spatial Extensions. It is based on the stock MySQL2 adapter, but provides built-in support for spatial columns. It uses the RGeo library to represent spatial data in Ruby.

MySQL Adapter for DataMapper

Rodauth is Ruby's most advanced authentication framework, designed to work in all rack applications. It's built using Roda and Sequel, but it can be used as middleware in front of web applications that use other web frameworks and database libraries. Rodauth aims to provide strong security for password storage by utilizing separate database accounts if possible on PostgreSQL, MySQL, and Microsoft SQL Server. Configuration is done via a DSL that makes it easy to override any part of the authentication process. Rodauth supports typical authentication features: such as login and logout, changing logins and passwords, and creating, verifying, unlocking, and resetting passwords for accounts. Rodauth also supports many advanced authentication features: * Secure password storage using security definer database functions * Multiple primary multifactor authentication methods (WebAuthn and TOTP), as well as backup multifactor authentication methods (SMS and recovery codes). * Passwordless authentication using email links and WebAuthn authenticators. * Both standard HTML form and JSON API support for all features.

Persistent event repository implementation for RubyEventStore based on ActiveRecord. Ships with database schema and migrations suitable for PostgreSQL, MySQL ans SQLite database engines. Includes repository implementation with linearized writes to achieve log-like properties of streams on top of SQL database engine.

Add binary (not string) UUIDs to ActiveRecord in MySQL

Make it easy to upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates merge functions for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.

The best Rails 6.0+ forums engine ever. Its goal is to be as simple and feature rich as possible. Thredded works with SQLite, MySQL (v5.6.4+), and PostgreSQL. See the demo at https://thredded.org/.

GeoRuby is intended as a holder for data returned from PostGIS and MySQL Spatial queries. The data model roughly follows the OGC "Simple Features for SQL" specification (see www.opengis.org/docs/99-049.pdf), although without any kind of advanced functionalities (such as geometric operators or reprojections)

Awesome patches backported for ActiveRecord MySQL adapters

Fluent input plugin for MySQL slow query log file.

mysql2 plugin supporting aurora failover.

A friendly MySQL-compatible library for Ruby, binding to libtrilogy

This plugin provides native MySQL instrumentation for monitoring and metrics collection, including: service health, database connectivity, `InnoDB` locks, replication status, metrics collection, and sending metrics to a MySQL database.

Add unsigned option to integer type for ActiveRecord's MySQL2 adapter

Set transaction isolation level in the ActiveRecord in a database agnostic way. Works with MySQL, PostgreSQL and SQLite as long as you are using new adapters mysql2, pg or sqlite3. Supports all ANSI SQL isolation levels: :serializable, :repeatable_read, :read_committed, :read_uncommitted.

MySQL adapter for thoughtbot/scenic

Retries database transaction on deadlock and transaction serialization errors. Supports MySQL, PostgreSQL and SQLite (as long as you are using new drivers mysql2, pg, sqlite3).

Official Ruby client library to consume Mysql

fluent plugin to insert mysql as json(single column) or insert statement

Provides automatic deadlock retry and logging functionality for ActiveRecord and MySQL

extracted code from mysql2

Provides enhancements to ActiveRecord to handle spatial datatypes in PostgreSQL and MySQL.

Selects records from a table.

MySQL 5.6 adds a `LOCK=NONE` option to make sure migrations are done with no locking. Let's use it.

Take a peek into the MySQL queries made during your application's requests.

It is the library to reconnect automatically when ActiveRecord is disconnected from MySQL.

Inserts or updates records to a table.

Gives you binaries like mysql2csv, mysql2json, and mysql2xml, and Ruby classes to match.

Library for parsing MySQL binary logs in Ruby

This is MySQL connector. pure Ruby version

Astrails-Safe is a simple tool to backup databases (MySQL and PostgreSQL), Subversion repositories (with svndump) and just files. Backups can be stored locally or remotely and can be enctypted. Remote storage is supported on Amazon S3, Rackspace Cloud Files, or just plain FTP/SFTP.

Persistent event repository implementation for RubyEventStore based on ActiveRecord. Ships with database schema and migrations suitable for PostgreSQL, MySQL ans SQLite database engines. Includes repository implementation with linearized writes to achieve log-like properties of streams on top of SQL database engine.

Take a peek into the MySQL queries made during your application's requests.

MySQL index hint support for ActiveRecord

MySQL slow query parser.

A small library that allows you to easily spin up new local mysql servers for testing purposes.

Shield sensitive data in Postgres and MySQL