MySQL vs. JSON – Why? [closed]

by

To be really blunt about, MySQL is a database while JSON is not, so the correct answer is MySQL, without hesitation. JSON is just a language, and barely even that. JSON was never designed to handle anything like concurrent connections or any sort of data manipulation, since its own function is to represent data, not to manage it.

So go with MySQL for storing the data. Then you should use some programming language to read that database, and send that information as JSON, rather than actually storing anything in JSON.

If you store the data in files, whether in JSON format or anything else, you will have all sorts of problems that people have stopped worrying about since databases started being used for the same thing. Size limitations, locks, name it. It’s good enough when you have one user, but the moment you add more of them, you’ll start solving so many problems that you would probably end up by writing an entire database engine just to handle the files for you, while all along you could have simply used an actual database.

More Related Contents:

  1. How to search JSON data in MySQL?
  2. How to convert result table to JSON array in MySQL
  3. Storing Data in MySQL as JSON
  4. How do I generate nested json objects using mysql native json functions?
  5. MySQL JSON: How to find object from key value
  6. Using MySQL JSON field to join on a table
  7. How can write queries in MySQL that can parse JSON data in a column?
  8. Convert JSON array in MySQL to rows
  9. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  10. How to retrieve JSON data from MySQL?
  11. How to update JSON data type column in MySQL 5.7.10?
  12. How to create and insert a JSON object using MySQL queries?
  13. MySQL search json value by key in array
  14. 1052: Column ‘id’ in field list is ambiguous
  15. Codeigniter – multiple database connections
  16. How to add levenshtein function in mysql?
  17. Is the primary key automatically indexed in MySQL?
  18. Is there ANY_VALUE capability for mysql 5.6?
  19. Cumulative sum over a set of rows in mysql
  20. No connection could be made because the target machine actively refused it (PHP / WAMP)
  21. MySQL SELECT DISTINCT multiple columns
  22. How to connect to a MySQL Data Source in Visual Studio
  23. DOs and DONTs for Indexes [closed]
  24. How to insert images from database?
  25. MySQL – ORDER BY values within IN()
  26. How do I rename a MySQL database (change schema name)?
  27. Returning records from the last 3 months only in MySQL
  28. Which ORM should I use for Node.js and MySQL? [closed]
  29. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  30. Count duplicates records in Mysql table?

Leave a Comment