Storing a javascript array that contains objects in a MYSQL database?

Question

So in javascript I have an array that looks about like this:

[{x1:0,x2:2000,y:300},{x1:50,x2:250,y:500}]

And I would like to store it in a single field in my database. I thought about either somehow making it a string and then saving it as text, but I don't really know a very efficient and "smart" way to do that. I also heard of the VARBINARY field type, but I have no idea how to write and object/array into one of those and how to read it out...

What I would really most prefer would be if it would automatically be read as an array. My MYSQL-plugin(or however that is called in js) returns my queries as arrays of objects like well:

[{id:0,bla:"text"},{id:0,bla:"text"}]

For a query in a table with the collumns id and bla.

Well say my array is stored in bla, I would like the object I get to look exactly like this right when it is returned(however if that is not possible I am fine with an alternative solution).

[{id:0,bla:[{x1:0,x2:2000,y:300},{x1:50,x2:250,y:500}]},{id:0,bla:[{x1:0,x2:2000,y:300},{x1:50,x2:250,y:500}]}]

So basically I would get an array containing two objects, which each have the properties bla and id, where bla is an array of objects with the properties x1,x2 and y.

It depends on what you want to do with the value in the database. If you don't want to query that field, you can just convert the array to JSON and store it as text. If you want to make queries on the data though, create a proper fields in the table. — Felix Kling
– Felix Kling, Commented May 10, 2012 at 18:19
Why don't you look into web storage, without DB. relationalcloud.com/index.php?title=Database_as_a_Service — Eric Hodonsky
– Eric Hodonsky, Commented May 10, 2012 at 18:30

Elliot Bonneville · Accepted Answer · 2012-05-10 18:27:03Z

22

somehow making it a string and then saving it as text, but I don't really know a very efficient and "smart" way to do that.

Save the string as JSON, like this:

var myArr = [{x1:0,x2:2000,y:300},{x1:50,x2:250,y:500}];
myArrString = JSON.stringify(myArr);

Later, when you get the JSON string back from MySQL, you can turn it back into an array with JSON.parse(), like this:

var myArr = JSON.parse(myArrString)

And yes, if you're wondering, JSON functionality has been added to Javascript's standard codebase: that's how popular it is.

answered May 10, 2012 at 18:27

Elliot Bonneville

53.6k23 gold badges101 silver badges125 bronze badges

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

4 Comments

Wingblade Over a year ago

Had never looked into this JSON much before, but it seems interesting so I guess I could give it a try...

Elliot Bonneville Over a year ago

It's so simple, I've already told you all you need to know. :)

Wingblade Over a year ago

That's really everything? So JSON only has the two functions JSON.stringify() and JSON.parse()? Nice and simple, just how I like it.

Elliot Bonneville Over a year ago

Yep, that's it. Incredibly simple, but incredibly useful. You can also define your own packing and unpacking procedures for complicated objects that don't want to pack nicely, but for simple stuff like you're doing here, stringify and parse should work nicely.

Collectives™ on Stack Overflow

Storing a javascript array that contains objects in a MYSQL database?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related