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
9076567
Releases
39
Current Version
0.17.1
Released
2013-12-19 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
9989735
Releases
61
Current Version
0.2.22
Released
2014-01-23 00:00:00 UTC
First Release
2010-04-06 07:00:00 UTC

Github brianmario/mysql2

Watchers
1061
Forks
249
Development activity
Active
Last commit
2014-01-25 09:04:03 UTC
Contributors
55
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
9262458
Releases
19
Current Version
1.3.9
Released
2014-02-25 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
4889542
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
33
Forks
10
Development activity
Inactive
Last commit
2013-05-10 15:08:44 UTC
First commit
Top contributors
Contributors
4
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
2627539
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
487833
Releases
9
Current Version
5.1.30
Released
2014-04-14 00:00:00 UTC
First Release
2007-11-05 06:00:00 UTC

Github jruby/activerecord-jdbc-adapter

Watchers
306
Forks
234
Development activity
Active
Last commit
2014-01-10 11:52:57 UTC
Contributors
98
Issues
Wiki pages

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
292641
Releases
11
Current Version
9.3.1101
Released
2014-03-05 00:00:00 UTC
First Release
2007-11-05 06:00:00 UTC
Depends on following gems
Depending Gems
6

Github jruby/activerecord-jdbc-adapter

Watchers
306
Forks
234
Development activity
Active
Last commit
2014-01-10 11:52:57 UTC
Contributors
98
Issues
Wiki pages

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
307052
Releases
22
Current Version
2.1.7
Released
2014-02-02 00:00:00 UTC
First Release
2008-06-28 18:00:00 UTC

Github kubo/ruby-oci8

Watchers
47
Forks
19
Development activity
Less active
Last commit
2014-02-02 10:56:35 UTC
First commit
Top contributors
Contributors
3
Issues
Wiki pages

mysqlplus

Enhanced Ruby MySQL driver

Rubygem mysqlplus

Total Downloads
71622
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
5

Github oldmoe/mysqlplus

Watchers
162
Forks
20
Development activity
Inactive
Last commit
2012-07-25 22:31:38 UTC

ruby-mysql

This is MySQL connector. pure Ruby version

Rubygem ruby-mysql

Total Downloads
119520
Releases
13
Current Version
2.9.12
Released
2013-12-17 00:00:00 UTC
First Release
2009-07-28 15:00:00 UTC
Depends on following gems
Depending Gems
2

Github tmtm/ruby-mysql

Watchers
97
Forks
21
Development activity
Less active
Last commit
2013-12-17 09:25:31 UTC
Top contributors
Contributors
2
Issues
Wiki pages

postgres-pr

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

Rubygem postgres-pr

Total Downloads
122522
Releases
19
Current Version
0.6.3
Released
2009-12-14 23: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
67266
Releases
35
Current Version
2.5.17
Released
2014-03-06 00:00:00 UTC
First Release
2007-03-22 04:00:00 UTC
Depends on following gems
Depending Gems
0

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 10_000 rows), buffers them, and returns the rows one at a time.

Rubygem postgresql_cursor

Total Downloads
7173
Releases
6
Current Version
0.4.1
Released
2013-02-20 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
12
Forks
7
Development activity
Inactive
Last commit
2013-02-20 19:09:12 UTC
First commit
Top contributors
Contributors
1
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
1372
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
2
Forks
0
Development activity
Active
Last commit
2013-12-20 16:38:19 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.