How to store a simple string array in SQLite 3?

Question

I want to do some testing...

If there is an array, array = [a, b, c, d], I want to save it in my database (SQLite 3) and call the elements when a user types 'array' in the input area.

I'm using cloud9 for testing! In 'migrates' folder, there is a file that has this code.

class CreateFans < ActiveRecord::Migration
  def change
    create_table :fans do |t|
      t.string :content


      t.timestamps null: false
    end
  end
end

I know I have to use this page for defining variable names of database data. but where should I put on my 'array' data?

The conclusion is...

I want to know how to save and recall an array in my database!

possible duplicate of newbie: append serialized integers into database column and retrieve them back — Beartech
– Beartech, Commented Aug 25, 2015 at 18:03

Saloaty · Accepted Answer · 2015-09-01 15:35:09Z

1

You could convert the array into a string to store it in the database. When you pull it from the database, convert it back into an array.

myModel.myDbObject = array.join("")

Then when pulling from the database...

array[] = myModel.myDbObject.split("")

That's essentially what I had to do for one of my Ruby on Rails applications.

Or for array elements longer than just one letter

myModel.myDbObject = array.join(",")

Pulling from database

array[] = myModel.myDbObject = array.split(",")

edited Sep 1, 2015 at 15:35

answered Aug 25, 2015 at 17:45

Saloaty

265 bronze badges

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

Collectives™ on Stack Overflow

How to store a simple string array in SQLite 3?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related