Using ruby with databases, but without rails

Question

I've some huge text files to process and make sense out of the data. Part of the task is to save this data into a database. I want to use Ruby, with postgres or mysql, postgres being the first choice. What libraries should I include? There is no model, its going to be plain SQL statements. How to do this without rails?

Alison R. · Accepted Answer · 2013-06-05 15:07:31Z

4

For PostgreSQL, you want ruby-pg. It supplies your basic database connection with the ability to query it. The documentation is sparse, but there are plenty of code samples in the source tree. Here's a fairly straightforward one:

https://bitbucket.org/ged/ruby-pg/src/e4465a9779faed39825213d140df6b1531bb1e68/spec/pg/result_spec.rb?at=default

Edit: The MySQL site lists a few options for connecting to MySQL.

http://dev.mysql.com/downloads/ruby.html

edited Jun 5, 2013 at 15:07

answered Feb 11, 2010 at 4:36

Alison R.

4,3041 gold badge30 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JohnMerlino Over a year ago

The link is dead, do you have an alternative?

Alison R. Over a year ago

@JohnMerlino They appear to have changed their tests around. But I updated the link to a comparable example.

Farrel · Accepted Answer · 2010-02-11 09:21:30Z

4

Sequel - sequel.rubyforge.org - is great as well. Using the core library (not the Sequel::Model ORM) you can write SQL like queries/statements using Ruby syntax.

answered Feb 11, 2010 at 9:21

Farrel

2,38118 silver badges14 bronze badges

Comments

Peter · Accepted Answer · 2010-02-11 04:28:17Z

0

You're after ActiveRecord, which supplies the database connectivity. A quick google search suggested this might be a good place to start.

answered Feb 11, 2010 at 4:28

Peter

133k53 gold badges184 silver badges214 bronze badges

3 Comments

user61734 Over a year ago

Nope, I dont want to use ORM (activerecord is ORM, right?) I want to write my own SQL statements, like the way we do with mysql_query, mysql_connect etc in PHP.

Alison R. Over a year ago

Yes, ActiveRecord is an ORM, and is overkill for executing plain SQL statements.

ADAM Over a year ago

still and orm but its light and faaast datamapper.org/getting-started.html - datamapper. its also easy to use outside rails

daino3 · Accepted Answer · 2017-05-26 03:04:06Z

0

for mysql, check out the mysql2 gem

#>> gem install mysql2
require 'mysql2'

client = Mysql2::Client.new(:host => "localhost", :username => "root")

answered May 26, 2017 at 3:04

daino3

4,58640 silver badges49 bronze badges

Collectives™ on Stack Overflow

Using ruby with databases, but without rails

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related