Issue storing arrays in SQLite using JavaScript

Question

I've been using Cordova and the storage adapter for SQLite. When I store objects using JSON.stringify and the retrieve them they work. I also have several fields that are arrays, but when I store them they are just stored comma-delimited. If there is only one item in the array then it's just stored as a single string.

Initial Array:

["test1", "test2", "test3"]

Stored As:

test1, test2, test3

I could just split those specific fields when I retrieve them from the database, but still wondering if there is a better way to store them. Is there a elegant way to store an array and retrieve it in SQLite using JavaScript?

Anand Jha · Accepted Answer · 2013-08-03 05:28:00Z

1

I don't see any problem ,you can access initial array after parsing (JSON.parse(yourStringifiedArrayString)).

  var yourarr=["test1", "test2", "test3"];
  var afterStringify = JSON.stringify(yourarr);
  console.log('After Stringify:'+afterStringify);
  var prevArr=JSON.parse(afterStringify);
  console.log('After Parsing:'+prevArr);
  //now access your array
   alert(prevArr[1]);//will show test2

Check Fiddle

edited Aug 3, 2013 at 5:28

answered Aug 3, 2013 at 5:22

Anand Jha

10.8k6 gold badges28 silver badges29 bronze badges

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

3 Comments

Joshua Over a year ago

I guess you're right. It looks stringifying and parsing arrays works too, even if they aren't JSON. I'd imagine using split would be less expensive on the processor though?

Anand Jha Over a year ago

I don't think split would be less expensive. if you are agree with my answer then you should accept it.

Joshua Over a year ago

I just switched all of my splits to use the json functions and it seems to be working.

alQemist · Accepted Answer · 2013-08-02 14:12:26Z

0

I don't see a problem with saving an array as a delimited string - It works fine for me. Just need to recreate the array using split() method when you retrieve it from SQLite.

answered Aug 2, 2013 at 14:12

alQemist

3704 silver badges14 bronze badges

1 Comment

Joshua Over a year ago

Yes, I know it's something I can work around, though I have a lot of tables and fields. It just feels like a lot of extra logic to check for those fields and then split them before returning the results.

Collectives™ on Stack Overflow

Issue storing arrays in SQLite using JavaScript

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related