Why WordPress choose data serialization over json_encode?

I think, not 100% sure that this was the real reason the WP developers took this approach, but common sense tells me that serialize preserves the variable types and have a mini built in error detection, and json stores only string values { key : value }, so when you go back to PHP you will have to guess the format, or make a parser for it. This will force you to have two different ways to handle your data: previous, to storing the data as json and after decoding the json it will come back as a totally different object.

This is the main reason the difference in size, PHP is storing not only an array; it is storing how many elements were in the array when it was serialized, their types, and their values.

You are not storing only key value pairs on the database but you may also be storing an object with different variable types.

Related Posts:

  1. Dealing with Many Meta Values, 30+
  2. What is the most secure way to store post meta data in WP?
  3. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  4. Meta query interfering with orderby relevance
  5. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  6. How to solve slow WordPress site caused by attachment_metadata
  7. Delete all post meta except featured image
  8. Is it possible to store visitors IPs in wp_postmeta table?
  9. Multiple postmeta with same name for one post in wp_postmeta table
  10. Delete all post meta except featured image Using SQL
  11. One post carries 30 postmeta values, is this too much?
  12. delete post meta from db, even if does not exist?
  13. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  14. Storing data for a wordpress plugin
  15. Where does the actual data stored by add_post_meta
  16. Structure of postmeta meta_value for woocommerce product download
  17. Routine to convert custom post meta from old to new value
  18. Saving zero as meta value
  19. Uknown meta entries in wp_postmeta
  20. Does post_meta data need to be unserialzed?
  21. Link image with data from the wpdb
  22. Custom Post Type not showing anything added by code anymore?
  23. Compare User meta_value with Product meta_value
  24. How to save EXIF metadata in WordPress database?
  25. _wp_attachment_metadata is not being added to database when PDF files uploaded
  26. “BS_” rows in postmeta table
  27. Migrating meta_key and meta_value from old theme to new one
  28. Database structure for thousands of posts
  29. How much post meta data is too much?
  30. How do i get value from wp_postmeta?
  31. Recommended Post Structure for DB Storage
  32. SQL query : Select a thumbnail for a media
  33. Importing 10 Years of Media into the WP Database
  34. Importing Data from a Non-WordPress database, into WP
  35. 2 WordPress sites with 2 databases but sharing the same users
  36. Insert Query not working in the form
  37. How to get nav_menu_item_id and slug from wp database
  38. connecting to DB from custom php file
  39. Is there a way to execute a php script outside WordPress?
  40. Make changes of wp-db.php file persistent against updates
  41. How can I restrict php mail() to only send me one email after a db error
  42. Importer fails to import every post
  43. Change the default data installed when setting up WordPress
  44. Remove “%” from strings in serialized arrays in wp_postmeta
  45. How to delete post comments from the database via SQL statement?
  46. Clear Terms from Taxonomy for Specific Post IDs?
  47. Why does changing Database Table Prefixes result in loss of content?
  48. Buddypress avatar image in database [closed]
  49. WordPress security [closed]
  50. How to split the WordPress database?
  51. $wpdb->get_var – What value is returned when zero records are found?
  52. SymmetricDS in dev + prod workflow?
  53. Fixing YARPP plugin FULLTEXT MySQL indexing
  54. What is wrong here? Issue with post_id and meta_value
  55. Advantages of dbDelta
  56. Only allow user to access a link once a year, based on their joining date
  57. Error establishing a database connection in wordpress site , website not opening
  58. Counting post and changing roles in mysql database. Query not code
  59. wpdb Insert unknown post data dynamic foreach loop
  60. How do I use a database in a custom theme?
  61. Deleting empty meta key values
  62. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  63. WP 5.5, child themes, customizer and a weird cache issue
  64. How do you enable scripts on a WordPress installation in Softaculous?
  65. How to rerieve comments and their replies from DB
  66. Inserting data with Geometry field
  67. I Want a More Concice Form of Data than an Array
  68. Export only a part of the database for migration
  69. Why am I being prompted to reinstall wordpress?
  70. What’s the easiest way to connect external database and display data on wordpress?
  71. Duplicate database to roll back theme & content changes
  72. database error WordPress move from one hosting to other
  73. Select data from foreach loop and send it to wordpress database
  74. mySQL database size large, but tables size less
  75. Error establishing database connection error during first WordPress run
  76. Same DB for live and dev versions
  77. update multiple user meta field based on another meta field
  78. After renaming MySQL database, I can no longer access my Blog page
  79. execute custom function on database connection error
  80. Call to a member function insert()
  81. Create a new table on the database and save parameters from a contact form
  82. version control for wordpress? (wordpress folder and database at same time)
  83. not saving post in wp_post wordpress database table
  84. How to add data from wordpress tables to new database tables you have created
  85. Mysterious template change after database import/export
  86. Creating Tables in WordPress Database
  87. Calling update_user_meta inside of another function doesn’t work
  88. Install WordPress with SQL database
  89. How to back-up a database on IIS
  90. Creating Job Tickets
  91. $wpdb->prepare returns empty array
  92. Best db table structure for users with many records
  93. Where are database files of a WordPress website?
  94. WP_Query by meta key not returning any posts
  95. Uploaded images not displaying full size preview or inserting into posts
  96. Many images in wp-content/uploads folder that are not in Media Library
  97. Order of search results based off of a backend custom field and also in alpha order
  98. How to find fresh (last modified) and sql backup?
  99. Understanding Redundant postmeta Tables in WordPress Database
  100. Database table prefix different between wp-config.php and in database

Leave a Comment