The ability to store abstract key-value pairs without modifying the database structure is the reason. Without that, WordPress loses much of its flexibility. I can’t speak for others, but the single largest reason why I develop atop WordPress is its flexible nature.
To quote one of your links above,
Usually the reasoning behind doing what you are doing is because the domains need to be “user definable”. If that is the case then even I am not going to push you towards creating tables on the fly…
While it’s true that it forces queries to be more complex, and a little slower, the benefits far outweigh the costs. But, hey, it’s all about what you’re doing. Don’t use a hammer to bang in a screw. If you still want to use WordPress, but need to run complex queries on steady, structured sets of data, check out Pods.
I hope this helps you out!
Related Posts:
- So much data in postmeta
- importing data from non-wordpress mysql db
- get_post_meta fields don’t show up on posts page
- Which is best in the following scenario : post_meta vs custom table vs parent/child posts
- ACF plugin and field update
- Query postmeta values, and return multiple post_titles for common meta value
- Site uses wpdb to fetch meta_keys but just displays first meta_key from a page (the post uses the same meta_key “filmmaker” more than once)
- Custom post meta field effect on the performance on the post
- Difference between meta keys with _ and without _ [duplicate]
- Orderby meta_value only returns posts that have existing meta_key
- How to enable revisions for post meta data?
- Best way to programmatically remove a category/term from a post
- When using add_post_meta and update_post_meta, is there any way to give the individual arrays keys?
- Storing meta fields multiple times OR once with multi dimensional array?
- Is there a hook / action that is triggered when adding or removing a post thumbnail?
- passing argument to get_template_part() or a better way to code
- Is it possible to store arrays in a custom field?
- Making a configurable field translatable
- Create meta boxes that don’t show in custom fields
- Copying Custom Meta Values from existing post to a duplicate post
- Move value of one custom field to another
- Order posts according to user defined order for meta values?
- Displaying posts with only upcoming dates according their custom field date value
- How to filter a dd/mm/yyyy date from a custom field in a query
- Custom fields: In what order are they saved into the DB?
- Get a post_id where meta_value equals something in a serialized meta_value field
- How to save a ToggleControl value in a meta field?
- MySQL query to set wp_postmeta using term_taxonomy_id value
- Custom User Profile Fields
- Custom Meta Box not Saving in Posts with Gutenberg Editor
- How can I sort homepage by a meta value?
- Get specific custom field keys from a post and put into an array
- How to wrap meta values seperated by comma in ? [closed]
- Bulk remove post meta
- How to create html block to display extra information on woocommerce single product page
- Create Multiple File Upload Metabox in WordPress
- filtering custom post types via meta data drop down
- Run a check for multiple meta key values
- If meta key exists in get posts function otherwise create it
- WordPress Rest API to call page data associate with custom meta
- How do I Implement Atomic Update of Post Metadata?
- Hide custom meta data if empty
- How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
- Why is my Custom Meta Box Field Inputs NOT saving?
- Get registered custom fields or post meta even if empty
- Pass current post title to a predefined link
- How to populate custom field dropdown box based on prior selection?
- How can you include custom post meta in search without calling each key?
- shortcode in a custom metabox
- Limit of char count in WP custom fields
- Can I access a post meta field before the loop?
- wrap text around custom fields array
- How can I modify RSS item titles to be either the title or a custom meta field?
- Avoiding ACF get_field and returning to core WordPress function
- Where does this field get its value?
- Problem with saving large amount of data in postmeta/usermeta
- How to get posts with a metadata numeric key greater than X?
- Get all the posts where meta field with multiple choice has several values checked
- Warn user that data may be lost for custom pages
- Move Title and the Content WYSIWYG editor position
- Build index page from custom fields
- How do i get the attached images with custom value checked?
- Update post meta custom field using block editor
- Diamond question mark in text after migrating content
- Get emails from users by custom field SQL
- Display posts with empty custom field
- Why am I getting a “Call to member function format() on a non-object” error?
- If metabox has content display content
- delete duplicate meta_value with same post_id
- How do I convert all custom_field php timestamps in the database to js timestamps?
- Modify custom field from front end
- Footnotes in custom fields
- Create a new custom field for all posts based on current custom field
- Display Meta Data with HTML?
- wordpress get_post_meta / the_meta to output custom field value
- Group Posts By Custom Meta Value: Date
- Meta field bulk editing no longer working in WP 6.0 [closed]
- update_post_meta not working well
- Set class if a meta value is set within post archive
- How to securely controlling data without keeping it in postmeta?
- How to add a post’s view count into the WordPress API response
- Adding Facebook’s image and meta description retrieval capabilities to a WordPress post
- Can’t set custom meta fields for a post
- Allow HTML in Custom Metabox area
- Custom field metabox not showing in back-end
- Show echo ready in single.php
- Save, update, get and sanitize post meta as HTML not plain
- Update custom table on metabox POST
- Saved Post Meta Array Returns as String
- Query Multiple meta
- Problem saving meta data
- When post is updated, custom metadata in text area field is overwritten
- change attachment custom field onChange event
- Media Attachment Custom Meta Fields not saving in Media Uploader when using jQuery UI Autocomplete
- When editing a post with a custom meta box the values aren’t displaying correctly
- add_post_meta insert null value into Database
- Make Custom Fields Public in JSON – API
- Retrieving custom field as shortcode
- Order by a meta field in query loop
- How to create a searchable database with a single-field search box at the front end? [closed]