Json into mysql

Question

The aim is to save user entered JSON into a database. Now, before someone jumps at me, I know json, I know mysql and I know all the links inbetween.

The issue is: I need to safely store the ENTIRE JSON feed in a single cell in the table.

The background: this function will be a temp fix for a tool, that is needed asap but will require a lot of time. The temp fix will allow the system to go live with minimal code.

Users will create a GOOGLE maps style here ( http://gmaps-samples-v3.googlecode.com/svn/trunk/styledmaps/wizard/index.html)

and have the JSON made for them

[
  {
    "stylers": [
      { "visibility": "off" }
    ]
  },{
    "featureType": "water",
    "stylers": [
      { "visibility": "on" }
    ]
  },{
    "featureType": "transit.line",
    "elementType": "geometry.fill",
    "stylers": [
      { "visibility": "on" },
      { "hue": "#ff3300" },
      { "color": "#ff0000" },
      { "weight": 0.7 }
    ]
  },{
    "featureType": "transit.station.rail",
    "stylers": [
      { "visibility": "on" },
      { "color": "#0000ff" },
      { "weight": 4.6 }
    ]
  },{
  }
]

The site will then just call the JSON and apply it using jQuery later on. What would my ''best practice'' method be at doing this.

Aaron Saray · Accepted Answer · 2013-02-19 02:07:13Z

1

To answer your specific question, I would agree with the poster 'tom' that you should use a TEXT column.

However, I think for ease of use, you should also use prepared statements. If you create a prepared insert statement, you can then pass in the JSON directly. This will be the best representation in your database of the exact JSON (no annoying slashes) - AND be the safest. Please don't forget to do this step - its very important!

answered Feb 19, 2013 at 2:07

Aaron Saray

1,1776 silver badges19 bronze badges

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

Comments

tom · Accepted Answer · 2013-02-19 01:15:54Z

0

Since MySQL doesn't have a dedicated JSON column type, I would just store the JSON in an unbounded TEXT column. Just make sure you always check for valid JSON on write.

answered Feb 19, 2013 at 1:15

tom

19.2k4 gold badges39 silver badges36 bronze badges

Collectives™ on Stack Overflow

Json into mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related