Using sqlite3 with Ruby, is there a way to read each row as a hash instead of array?

Question

I am using sqlite3 as follows:

db = SQLite3::Database.open "data.db"

stm = db.prepare "SELECT * FROM COMPANIES"
rs = stm.execute

while (row = rs.next) do
    name = row[1]

that is, the row is an array instead of a hash. Is there a way to read it as a hash, so that

row[:name]
row[:address]

is the data. That's because in the future, if the table has a different order of columns, row[3] may become row[5], so row[:address] is much more definite.

Rather than use the SQLite gem, I'd recommend one of the ORMs that help insulate you from a DBM-specific language. SQLite is nice, but if your DB needs grow having to rewrite all your calls for a different DBM is a major pain. I like Sequel because it's very agnostic and very capable. sequel.jeremyevans.net/rdoc/files/doc/cheat_sheet_rdoc.html is a good overview. — the Tin Man
– the Tin Man, Commented Dec 9, 2019 at 7:33

Marek Lipka · Accepted Answer · 2019-12-09 06:59:59Z

5

There's results_as_hash setter to get this behavior:

db = SQLite3::Databse.open 'data.db'
db.results_as_hash = true
# ...

answered Dec 9, 2019 at 6:59

Marek Lipka

51.3k7 gold badges90 silver badges93 bronze badges

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

1 Comment

nonopolarity Over a year ago

works great. I suppose it has to be row["NAME"] and can't be made to row[:NAME]?

Collectives™ on Stack Overflow

Using sqlite3 with Ruby, is there a way to read each row as a hash instead of array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related