SQL Database Adapters

pg

Pg is the Ruby interface to the {PostgreSQL RDBMS}[http://www.postgresql.org/]. It works with {PostgreSQL 8.4 and later}[http://www.postgresql.org/support/versioning/]. A small example usage: #!/usr/bin/env ruby require 'pg' # Output a table of current connections to the DB conn = PG.connect( dbname: 'sales' ) conn.exec( "SELECT * FROM pg_stat_activity" ) do |result| puts " PID | User | Query" result.each do |row| puts " %7d | %-16s | %s " % row.values_at('procpid', 'usename', 'current_query') end end

Rubygem pg

Total Downloads
21390625
Releases
49
Current Version
0.18.4
Released
2015-11-13 00:00:00 UTC
First Release
2008-01-28 08:00:00 UTC

mysql2

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

Rubygem mysql2

Total Downloads
21008511
Releases
71
Current Version
0.4.1
Released
2015-09-16 00:00:00 UTC
First Release
2010-04-06 07:00:00 UTC

Github brianmario/mysql2

Watchers
1212
Forks
284
Development activity
Less active
Last commit
2014-12-20 05:09:44 UTC
Contributors
30
Issues

sqlite3

This module allows Ruby programs to interface with the SQLite3 database engine (http://www.sqlite.org). You must have the SQLite engine installed in order to build this module. Note that this module is only compatible with SQLite 3.6.16 or newer.

Rubygem sqlite3

Total Downloads
14694897
Releases
20
Current Version
1.3.10
Released
2014-10-31 00:00:00 UTC
First Release
2009-11-08 02:00:00 UTC

Github qoobaa/sqlite3

Watchers
11
Forks
6
Development activity
Inactive
Last commit
2010-05-08 21:16:25 UTC
Top contributors
Contributors
3
Issues

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.

Rubygem mysql

Total Downloads
6793101
Releases
8
Current Version
2.9.1
Released
2013-02-16 00:00:00 UTC
First Release
2004-10-20 04:00:00 UTC

Github luislavena/mysql-gem

Watchers
39
Forks
16
Development activity
Inactive
Last commit
2015-07-18 11:49:03 UTC
First commit
Top contributors
Contributors
5
Issues

sqlite3-ruby

This module allows Ruby programs to interface with the SQLite3 database engine (http://www.sqlite.org). You must have the SQLite engine installed in order to build this module. Note that this module is NOT compatible with SQLite 2.x.

Rubygem sqlite3-ruby

Total Downloads
2980051
Releases
19
Current Version
1.3.3
Released
2011-01-16 08:00:00 UTC
First Release
2004-12-21 05:00:00 UTC

Github luislavena/sqlite3-ruby

Watchers
144
Forks
64
Development activity
Less active
Last commit
2013-08-17 18:24:31 UTC

jdbc-mysql

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

Rubygem jdbc-mysql

Total Downloads
896558
Releases
15
Current Version
5.1.38
Released
2016-02-05 00:00:00 UTC
First Release
2007-11-05 06:00:00 UTC

Github jruby/activerecord-jdbc-adapter

Watchers
356
Forks
261
Development activity
Active
Last commit
2014-11-28 16:41:29 UTC

jdbc-postgres

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

Rubygem jdbc-postgres

Total Downloads
630722
Releases
16
Current Version
9.4.1206
Released
2016-02-05 00:00:00 UTC
First Release
2007-11-05 06:00:00 UTC

Github jruby/activerecord-jdbc-adapter

Watchers
356
Forks
261
Development activity
Active
Last commit
2014-11-28 16:41:29 UTC

ruby-oci8

ruby-oci8 is a ruby interface for Oracle using OCI8 API. It is available with Oracle 10g or later including Oracle Instant Client.

Rubygem ruby-oci8

Total Downloads
512931
Releases
27
Current Version
2.2.0
Released
2015-10-04 00:00:00 UTC
First Release
2008-06-28 18:00:00 UTC

Github kubo/ruby-oci8

Watchers
83
Forks
35
Development activity
Less active
Last commit
2016-01-29 11:41:23 UTC
First commit
Top contributors
Contributors
5
Issues

ruby-mysql

This is MySQL connector. pure Ruby version

Rubygem ruby-mysql

Total Downloads
188953
Releases
15
Current Version
2.9.14
Released
2015-12-30 00:00:00 UTC
First Release
2009-07-28 15:00:00 UTC
Depends on following gems
Depending Gems
3

Github tmtm/ruby-mysql

Watchers
109
Forks
28
Development activity
Inactive
Last commit
2014-11-16 04:28:11 UTC
Top contributors
Contributors
2
Issues

mysqlplus

Enhanced Ruby MySQL driver

Rubygem mysqlplus

Total Downloads
78194
Releases
2
Current Version
0.1.2
Released
2009-03-22 06:00:00 UTC
First Release
2009-03-22 07:00:00 UTC
Depends on following gems
Depending Gems
6

Github oldmoe/mysqlplus

Watchers
169
Forks
30
Development activity
Inactive
Last commit
2015-10-02 01:06:42 UTC

postgres-pr

A pure Ruby interface to the PostgreSQL (>= 7.4) database

Rubygem postgres-pr

Total Downloads
161517
Releases
20
Current Version
0.7.0
Released
2015-01-22 00:00:00 UTC
First Release
2004-11-18 05:00:00 UTC
Depends on following gems
Depending Gems
4

postgresql_cursor

PostgreSQL Cursor is an extension to the ActiveRecord PostgreSQLAdapter for very large result sets. It provides a cursor open/fetch/close interface to access data without loading all rows into memory, and instead loads the result rows in "chunks" (default of 1_000 rows), buffers them, and returns the rows one at a time.

Rubygem postgresql_cursor

Total Downloads
34279
Releases
9
Current Version
0.5.1
Released
2014-09-11 00:00:00 UTC
First Release
2010-05-17 04:00:00 UTC
Depends on following gems
Depending Gems
0

Github afair/postgresql_cursor

Watchers
97
Forks
20
Development activity
Inactive
Last commit
2015-05-20 16:42:16 UTC
First commit
Top contributors
Contributors
5
Issues

ibm_db

Rails Driver and Adapter for IBM Data Servers: {DB2 on Linux/Unix/Windows, DB2 on zOS, DB2 on i5/OS, Informix (IDS)}

Rubygem ibm_db

Total Downloads
132651
Releases
43
Current Version
3.0.0
Released
2015-09-30 00:00:00 UTC
First Release
2007-03-22 04:00:00 UTC
Depends on following gems
Depending Gems
0

Github ibmdb/ruby-ibmdb

Watchers
19
Forks
14
Development activity
Less active
Last commit
2016-01-06 16:26:26 UTC
First commit
Top contributors
Contributors
4
Issues

kbam

Simple gem that makes working with raw MySQL in Ruby efficient and fun! It's basically a query string builder (not an ORM!) that takes care of sanatization and sql chaining.

Rubygem kbam

Total Downloads
5143
Releases
7
Current Version
0.4.5
Released
2014-03-03 00:00:00 UTC
First Release
2013-09-21 00:00:00 UTC
Depends on following gems
Depending Gems
0

Github vilnius-leopold/kbam

Watchers
3
Forks
0
Development activity
Inactive
Last commit
2014-03-11 00:02:44 UTC
First commit
Top contributors
Contributors
0
Issues
×

In order to continue, you must be signed in using your Github account.

If you're signing in using this account for the first time Github will ask for your permission to give access to your public user data to the Ruby Toolbox.

Although the Github Authorization page does not mention it, the request includes read-only access to your verified email address (user:email OAuth scope). This is neccessary so there's a way to notify you about comments, information about your accepted project edits and the like. You can review your notification settings on your account page once you're signed in.