Organising and completing posts (mark as read and hide)

I’m not entirely sure this is the right place for this question, but I can’t say I know of a better place. 🙂

Your rough proposal is a valid way of building said system, but I would argue that you’re losing all of the advantages of using WordPress with the stated method. By creating a new table you have to build all of the “extras” around it. All of the special methods for finding the data you want, or accessing the relationships you need. WordPress already has a table meant for this type of data, it’s called usermeta (generally prefixed to be wp_usermeta, or in code $wpdb->usermeta).

It’s structured in such a way as to be open to just about any type of content with WP_Query having special filters (meta_query) for handling the sorting of the data and with the WP_User having methods (get_user_meta()) to access the DB data without having to write any SQL.

Related Posts:

  1. Getting wrong relationship value in $args in wp_Query?
  2. Using AND and bracket grouping in SQL not working
  3. Should I use wpdb prepare?
  4. Does using set_transient() function can lead to MySQL problems?
  5. How to make WordPress plugin check for database changes and then do something?
  6. How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
  7. How is the data stored in the database?
  8. Retrieving custom fields with $wpdb->get_results
  9. Display only certain posts based on visitor’s country?
  10. Really simple query giving error in SQL syntax
  11. How to add SQL file with PHP to WordPress database [closed]
  12. How can I free up the memory used by update_post_meta?
  13. Passing array of strings to a SQL statement in a WordPress plugin
  14. Activation hook not creating table
  15. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  16. How to edit mySQL wp_posts table from plugin php?
  17. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  18. $wpdb -> Batch insert from XML File?
  19. query users by role
  20. WordPress database error for query INSERT INTO
  21. How to connect to AWS RDS external database (not for the core WordPress db)
  22. SQL query for custom taxonomy slugs
  23. How to add user details to different tables immediately after user registration
  24. mysql_real_escape_string() vs. esc_sql() in WordPress
  25. How to get all queries’s results after they have executed?
  26. $wpdb->prepare with LIKE and sprintf
  27. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  28. How to optimize multiple insert into wordpress database
  29. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  30. How can I programmatically change a MySql variable (foreign_keys_check)?
  31. Auto-complete or auto-suggest from stored data in database
  32. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  33. wpdb->get_var always returning 0
  34. $wpdb->prepare is not working like mysql_real_escape_string
  35. Brainstorm – Slow Query from Plugin Need to Speed It Up
  36. Create an user on external database
  37. What could cause a WP Option to get truncated?
  38. WordPress database error: [Query was empty] – using $wpdb->prepare()
  39. Foreign wp_users ID in custom plugin DB table?
  40. How to Get Last ID?
  41. How to store sensitive user data (passwords)
  42. Insert, update or remove data from database (usermeta)
  43. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  44. Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
  45. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  46. Is it possible to replace MySQL with JSON files for WordPress
  47. WordPress doesn’t create table on plugin activation
  48. WordPress delete mysql rows with string
  49. pull data from wordpress database
  50. Plugin MySQL SELECT custom data and filter on user meta
  51. sql query not working in wp plugin
  52. $wpdb Mysql trigger problem
  53. Custom MySQL query to pull out Advanced Custom Fields?
  54. I can’t write in my DB using $wpdb->insert
  55. How to filter get_adjacent_post()?
  56. $wpdb how can i save my postmeta table before querying it
  57. How to add chunk of php, html, and sql code to variable an append to $content
  58. Nothing happens on WordPress Update command
  59. Get all the related data from WordPress DB
  60. select rows based on exact time (hours, minutes and seconds)
  61. How to properly prepare a column name if passed to a stored procedure?
  62. Get thumbnails with array sizes parameter
  63. How remove trashed WooCommerce orders from wc_get_orders() result?
  64. Adding custom stylesheet into header.php using a plugin
  65. How to properly package a block plugin
  66. Why would someone use function_exists(‘add_action’) in a plugin?
  67. Setting global block attribute value
  68. Developing the save function in Gutenberg blocks
  69. Plugin custom post template; without overriding all posts
  70. Full documentation about $args for register_rest_route?
  71. How to create post favorite function without plugins
  72. WordPress Gutenberg InnerBlocks renderAppender not showing with template
  73. Mock a dependency of a WP_REST_Controller class
  74. Creating an installation zip file
  75. How to use nonce
  76. Remove All Taxonomies from Post On Update
  77. update_callback is not working in register_rest_field
  78. how to insert missing tags into the posts through mySQL?
  79. Run uninstall.php if a checkbox is checked from settings page
  80. WP Still Generating 150×150 Thumbnail Size Even After Un-Setting Small Size in Functions.php
  81. How to create ShortCode
  82. Where to use nonce
  83. Plugin index page code executes multiple times
  84. How to call code when adding WooCommerce menu items via woocommerce_account_menu_items
  85. Is it possible to load the css just on my plugin admin page?
  86. Duplicate shipping method logic to another shipping method [closed]
  87. How do I validate extra pin field on my WordPress login form page?
  88. REST Endpoint API 404
  89. add_action pre_term_description vs. pre_category_description
  90. How to check whether checkbox is checked in WordPress customizer
  91. How to create a wordpress widget that dynamically changes according to the page
  92. How to disable a jQuery plugin on WordPress plugin page
  93. jquery in wordpress plugin with depdendency
  94. Problem with autoloader and namespaces
  95. DB Query not working in Plugin
  96. Non editable custom taxonomy
  97. How to Get Rid of Unwanted Backslashes in WordPress Form Input inside admin menu option
  98. Gutenberg – is it ok to load dependencies multiple times?
  99. Show Mysql table elements as pages in WordPress
  100. Is it possible to use WP-CLI in a plugin (or theme)?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)