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
14744349
Releases
46
Current Version
0.18.0
Released
2015-01-05 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
15857504
Releases
66
Current Version
0.3.18
Released
2015-02-17 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
14094478
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
9
Forks
5
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
6099861
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
38
Forks
14
Development activity
Inactive
Last commit
2015-01-05 19:07:09 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
2861176
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
715061
Releases
12
Current Version
5.1.35
Released
2015-04-15 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
493733
Releases
14
Current Version
9.4.1200
Released
2015-02-16 00:00:00 UTC
First Release
2007-11-05 06:00:00 UTC
Depends on following gems
Depending Gems
7

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 Oracle8i, Oracle9i, Oracle10g, Oracle11g and Oracle Instant Client.

Rubygem ruby-oci8

Total Downloads
399524
Releases
23
Current Version
2.1.8
Released
2015-04-04 00:00:00 UTC
First Release
2008-06-28 18:00:00 UTC

Github kubo/ruby-oci8

Watchers
64
Forks
24
Development activity
Less active
Last commit
2015-04-04 13:14:26 UTC
First commit
Top contributors
Contributors
3
Issues

ruby-mysql

This is MySQL connector. pure Ruby version

Rubygem ruby-mysql

Total Downloads
154302
Releases
14
Current Version
2.9.13
Released
2014-11-16 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
77936
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
168
Forks
24
Development activity
Inactive
Last commit
2014-12-29 21:16:14 UTC

postgres-pr

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

Rubygem postgres-pr

Total Downloads
142687
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

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
96861
Releases
38
Current Version
2.5.26
Released
2015-04-09 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
16
Forks
11
Development activity
Less active
Last commit
2015-04-09 18:18:27 UTC
First commit
Top contributors
Contributors
4
Issues

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
18858
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
63
Forks
15
Development activity
Less active
Last commit
2015-03-31 11:07:28 UTC
First commit
Top contributors
Contributors
5
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
3328
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
1
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.