In most cases, plug-ins modify options, metadata, or create new functionality from existing tables, usually post tables. Custom post types, custom taxonomies, image manipulation, gallery, shortcut code – none of them usually need their own database tables. Because the database architecture (database configuration) of WordPress is very suitable for development. The posts table can be used to store objects, and the posteta table can be used to store additional information about these objects. But in some cases, this can lead to trouble or waste. The
In today’s article, we will learn about the advantages and disadvantages of new database tables, how to determine the structure, and how to create tables in word press. Considerations for customizing tables? Whether a plug-in should use a custom table can be attributed to two factors: structure and data volume. Custom tables are required only when the data structure is fundamentally different from the standard post model and there are a large number of data structures. To prove my point, let’s consider a plug-in that uses Google Analytics to create and store weekly reports composed of multiple data elements. There are three ways to access: The
You can create a simple custom table and save the weekly analysis of the custom table in one row. The rows in the database include identifier, analysis date, number of Posts read, links clicked, countries \/ regions that provide the most visitors, etc. You can create post and post meta analysis custom post types and use them to save the ID and date of the analysis. You can then use the post method to save a single data point. Instead of using simple tile posts or custom tables, you can use individual options in the options table. This will be an array whose members will become separate week numbers. The
This is not really a big data set because it collects data every week. Of course, it would be convenient to have tables that fully meet our needs, but without us, is a table that is only used once a week worth polluting the beautiful WordPress database? In particular, I want to say no, because our data is very consistent with the key value method of post metatable. Selecting from histograms and simple arrays is not that simple. If our example only stores one year of historical data, array may be a completely effective method. Initially, it will include 52 easy to operate members. The
If we continue to collect data, we will consider the post and post meta methods, because we do not want to load and operate 260 member arrays after the fifth year. \
Post and post meta solutions will encounter the same problem. WordPress is well optimized, but in this scale, if there are some optimization errors, the website may be completely interrupted. Stored in the same table). The post metatable receives 5259480 rows per year because each analysis can contain more than 10 data points. This is where custom forms may apply. The table is populated with 500000 rows per year, but separated from other content. Data points can be added as columns (or dedicated MES)
Must be confirmed. This helps you determine when you need to change the database. Load the summary 8bcd636b36128992447bbad1508c43481. It is assumed that there are no changes in the database schema throughout the X release. In version 2.0, add columns. The working principle is as follows: Load summary 89d021b9bf28a83d3656d9597e7adccb adds a single column named blog\u ID to help you use the plug-in for multi site installation. As you can see, we have detected that the currently used database version is lower than the plug-in version. If yes, add columns using the same format only. The dbdelta() function handles all changes, so you just need to provide the appropriate database schema. Conclusion it is usually not necessary to create a unique table. However, the dbdelta feature allows you to create modular tables for flexible and easy maintenance. If you need a form, always be careful, because this is the only way to execute a custom form in a word press friendly way. If you know the plug-in for adding your own database tables, please help in the comments below. This will confirm that it is working properly! Tag: Developer
