CODEWITHSUNDEEP
sqlrubydatabasedatabase-connection
user61734
user61734

Reputation: 3013

Using ruby with databases, but without rails

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?

Upvotes: 6

Views: 13501

Answers (4)

daino3
daino3

Reputation: 4566

for mysql, check out the mysql2 gem

#>> gem install mysql2
require 'mysql2'

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

Upvotes: 0

Alison R.
Alison R.

Reputation: 4294

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

Upvotes: 4

Farrel
Farrel

Reputation: 2381

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.

Upvotes: 4

Peter
Peter

Reputation: 132227

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

Upvotes: 0

Related Questions