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
24969334
Releases
50
Current Version
0.19.0.pre20160409114042
Released
2016-04-09 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
23693960
Releases
74
Current Version
0.3.21
Released
2016-05-08 00:00:00 UTC
First Release
2010-04-06 07:00:00 UTC

Github brianmario/mysql2

Watchers
1446
Forks
331
Development activity
Less active
Last commit
2016-04-19 11:24:57 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
20067610
Releases
21
Current Version
1.3.11
Released
2015-10-10 00:00:00 UTC
First Release
2009-11-08 02:00:00 UTC

Github qoobaa/sqlite3

Watchers
12
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
7095390
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
40
Forks
15
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
3046921
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
968340
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
395
Forks
291
Development activity
Less active
Last commit
2016-04-29 18:50: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
687945
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
395
Forks
291
Development activity
Less active
Last commit
2016-04-29 18:50: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
570481
Releases
28
Current Version
2.2.2
Released
2016-04-24 00:00:00 UTC
First Release
2008-06-28 18:00:00 UTC

Github kubo/ruby-oci8

Watchers
86
Forks
35
Development activity
Less active
Last commit
2016-04-24 13:16:31 UTC
First commit
Top contributors
Contributors
5
Issues

ruby-mysql

This is MySQL connector. pure Ruby version

Rubygem ruby-mysql

Total Downloads
204242
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
1

Github tmtm/ruby-mysql

Watchers
117
Forks
34
Development activity
Inactive
Last commit
2016-04-05 13:51:47 UTC
Top contributors
Contributors
3
Issues

mysqlplus

Enhanced Ruby MySQL driver

Rubygem mysqlplus

Total Downloads
81324
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
31
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
173189
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
45262
Releases
10
Current Version
0.6.0
Released
2016-02-22 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
108
Forks
23
Development activity
Less active
Last commit
2016-04-27 19:04:30 UTC
First commit
Contributors
7
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
147114
Releases
45
Current Version
3.0.3
Released
2016-06-20 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
20
Forks
17
Development activity
Inactive
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
6030
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.