Storing Data in MySQL as JSON

by

Everybody commenting seems to be coming at this from the wrong angle, it is fine to store JSON code via PHP in a relational DB and it will in fact be faster to load and display complex data like this, however you will have design considerations such as searching, indexing etc.

The best way of doing this is to use hybrid data, for example if you need to search based upon datetime MySQL (performance tuned) is going to be a lot faster than PHP and for something like searching distance of venues MySQL should also be a lot faster (notice searching not accessing). Data you do not need to search on can then be stored in JSON, BLOB or any other format you really deem necessary.

Data you need to access is very easily stored as JSON for example a basic per-case invoice system. They do not benefit very much at all from RDBMS, and could be stored in JSON just by json_encoding($_POST[‘entires’]) if you have the correct HTML form structure.

I am glad you are happy using MongoDB and I hope that it continues to serve you well, but don’t think that MySQL is always going to be off your radar, as your app increases in complexity you may well end up needing an RDBMS for some functionality and features (even if it is just for retiring archived data or business reporting)

More Related Contents:

  1. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  2. Which DB technology is sued to solve the following search issue? [closed]
  3. MyISAM versus InnoDB [closed]
  4. Compare two MySQL databases [closed]
  5. How should I resolve –secure-file-priv in MySQL?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Storing JSON in database vs. having a new column for each key
  11. How do I restore a dump file from mysqldump?
  12. What’s the difference between MyISAM and InnoDB? [duplicate]
  13. Maximum length for MySQL type text
  14. What effects does using a binary collation have?
  15. MySQL SELECT increment counter
  16. Hyphens in column names in MySQL DB
  17. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  18. Error renaming a column in MySQL
  19. Modeling Product Variants
  20. Mysql database sync between two databases
  21. Check for x consecutive days – given timestamps in database
  22. What’s the best database structure to keep multilingual data? [duplicate]
  23. Does mysql have the equivalent of Oracle’s “analytic functions”?
  24. How do I show the schema of a table in a MySQL database?
  25. Remove special characters from a database field
  26. Using reserved words in column names
  27. How big can a MySQL database get before performance starts to degrade
  28. What is the difference between SQL and MySQL? [closed]
  29. mysql Failed to read auto-increment value from storage engine
  30. How to store data with dynamic number of attributes in a database

Leave a Comment