there is one big question in my mind why do developer plugin use post meta for saving data on database ? why don't use separate tables ? i know that if you lot of data you will save data on seprate tables and data related post better save on wp_postmeta What other reasons are there to store or not store data in post meta?
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in WORDPRESS
- How to add the dynamic new rows from my registration form in my database?
- Wordpress Site - pages have low text-HTML ratio
- wordpress delete unwanted location
- How to create a facet for WP gridbuilder that displays both parent and child custom fields?
- How to change woocomerce or full wordpress currency with value from USD to AUD
- error 500 on IIS FastCGI but no clue despite multiple error loggings activated
- Caching private wordpress rest endpoints
- How do i get my close button to work on a popup?
- SQL query to get student enrolled in this month in a course - Moodle
- What wordpress plugin prevent sharing of contact information amongst users?
- Password protected or private URL one-time viewable video access
- Download button not working in wordpress website. How can solve it?
- WP toolkit problem after deleting wordpress site manually
- TypeError: Failed to execute 'arrayBuffer' on 'Blob': Illegal invocation - Insert blob into database
- New Order Email Details Missing // Woocommerce / Woocommerce Bookings
Related Questions in PLUGINS
- Chrome/Firefox plug-in for automatically opening the dev tools and executing code in the console
- Creating a modal window in product edit page in Shopware6 and saving data to custom table(repository) from a form within the modal window
- Swiper.js moves slides outside of viewport/page
- Responsive Lightbox & Gallery issue
- Unity - How to add C++ file directly to be used as a Plug-in
- Can not switch camera while recording with camera plugin, setDescription working but preview doesn't change
- can anyone help me for NSIS Script I have a case where I need to check cases can be 3.3 3.42 23.5 23.56w 3.467 999.999 999.99a but not 1.b or 8..a
- How can I know if a vscode intelliSense suggestion is visible?
- Loader / Spinner infinite | Filter Everything Pro
- HTML Not Rendering and Displaying as Plain Text on Frontend with Ninja Forms in WordPress
- I want to run my own interface that I coded with Python in RoboDK
- How to redirect uploads from customers to go into specific folder?
- TestNG update related issue
- Co Author Plus: Need to add co authors names with link
- JS-issue "undefined query" when trying to create chrome-plugin
Related Questions in POST-META
- hide admin bar according to a post metadata
- Query wp_postmeta table to return post_id rows with LIKE condition on one meta_value and order by another meta_value
- wordpress $query->set to sort archive product pages, by *manipulated* ACF meta key value
- Is there a way to update post meta schema after meta fields have been saved for a wordpress post
- WordPress postmeta table size, why base 64 encoded images removal from db didn't decrease the size?
- Display custom post meta using a shortocde on WordPress
- Post meta vs separate database tables
- Wordpress - save frontend submission form field as custom field
- Orphaned Postmeta Records in WordPress
- INNER JOIN and multi-row data in SQL, wp_postmeta table
- wordpress phpadmin SQL database query to get results in columns
- I can't update post meta for WordPress
- Send post_meta to email wordpress
- How to get the number of visits to an article in 24 hours?
- Issue with WooCommerce too big database size especially post_meta
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Ahh, why indeed? WordPress's meta tables can be slow to query and confusing to use. The string-only meta values present real problems when you use them to store numbers or datestamps, for just one example of how confusing they are.
They do permit developers to extend WordPress's data model to handle many imaginable applications, without extra tables (or worse, custom columns added to the users or posts tables). If it weren't for this extensibility I suspect nobody would have heard of WordPress in 2022.
But here's the thing. Most people who own sites or develop plugins (or themes) for the WordPress.org software ecosystem aren't proficient with designing or developing for SQL tables. It's easier for many to rely on the meta table instead.
Some plugins (Yoast, Relevanssi, WooCommerce for example) have their own tables, and your plugin can have them too if you need them.
If you will publish a plugin like that you must include code to create your tables when your user first activate your plugin, and drop them when she deletes your plugin. And you need to test those cases carefully, lest you leave junk behind in your users' databases.
You must be careful to use the right $wpdb->prefix for your table names (or your plugin will collapse in a heap of digital rubble on multisite installations). To avoid SQL injection attacks you must use $wpdb->prepare(). And there are other things to keep in mind. Study up on the $wpdb class.