When developing for WordPress and WooCommerce, it’s important to consider the nature and permanence of your data. This will help you decide the best way to store it. Here’s a quick primer:
If the data may not always be present (i.e., it expires), use a transient. Transients are a simple and standardized way of storing cached data in the database temporarily by giving it a custom name and a timeframe after which it will expire and be deleted.
If the data is persistent but not always present, consider using the WP Cache. The WP Cache functions allow you to cache data that is computationally expensive to regenerate, such as complex query results.
If the data is persistent and always present, consider the wp_options table. The Options API is a simple and standardized way of storing data in the wp_options table in the WordPress database.
If the data type is an entity with n units, consider a post type. Post types are “types” of content that are stored in the same way, but are easy to distinguish in the code and UI.
If the data is a means of sorting/categorizing an entity, consider a taxonomy. Taxonomies are a way of grouping things together.
Logs should be written to a file using the WC_Logger class. This is a simple and standardized way of recording events and errors for debugging purposes.
Remember, the best method of data storage depends on the nature of the data and how it will be used in your application.
Last updated: January 25, 2024