medoo framework in WP plugin

medoo and other similar libraries are generic, that is they are aimed at querying some database in general and the weight of figuring out necessary queries are on you as developer.

WP_Query and other WP APIs that perform requests to database are much more specific. They already contain much of that logic, which allows you to express what you need in API calls, rather than SQL query or abstraction close to it. Related code in core implements enormous amount of SQL query generation with literally years of logic and performance optimizations.

Overall for any WP development you have to use its APIs as much as possible, or you will have to waste incredible amount of time reinventing what they do.

Though bringing your own database abstraction can certainly be beneficial for some use cases. For example if you plan to develop extension which will add and interact with its own database tables, rather than native WP data structures.

Related Posts:

  1. WP JSON REST API (Ryan McCue) how to query posts with specific meta data with ‘AND’ relation?
  2. Creating two database tables via plugin
  3. Query Posts by Custom Field ‘Price’
  4. WP_query parameters for date range
  5. insert data in database table from plugin with WP3.1
  6. Thumb rating for wordpress – top user
  7. Comparisson between date() and a date from wp_postmeta
  8. Find out if request is for custom post type archive before query runs
  9. How to extract images of post and pages excluding header and logo image in wordpress?
  10. Fatal error: Uncaught Error: Call to undefined function get_userdata()
  11. Can I run multiple queries with $wpdb->prepare?
  12. How use %like% in sql statement wordpress
  13. WordPress logo upload option in theme panel
  14. Accessing GET variable named ‘error’
  15. WP_Query ordering numbers as letters
  16. FacetWP group listings by custom field [closed]
  17. How can i list random post from multiple category?
  18. how do i remove posts from a WP_Query so the pagination is right?
  19. Accessing post’s meta data based on user’s click of a post
  20. WooCommerce shop page orderby [closed]
  21. Get posts from WP_Query and format them on admin_head
  22. Not getting author rank when using return
  23. How to query the custom fields by language?
  24. How do I “get the next 10 posts after post_id == x”?
  25. switched from query_posts to WP_query, not working now?
  26. How to change this WP_Query to get all ProductIDs and not only specific one?
  27. How can I make 2 plugins that include different versions of a framework to both use the latest version?
  28. How to call WordPress function other files
  29. Insert content of a post into another
  30. WP_Query and NULL meta keys
  31. how to use in custom single.php template using php?
  32. WordPress page and plugin list using sql query
  33. Using AJAX to generate front end / viewer end pages
  34. WooCommerce search products between price range using WP_Query
  35. How to insert multiple postmeta values with one query?
  36. How to Loop Through all Posts and Count Attachments using Get Media Attachments
  37. How to get a list of bundled products using wp_query in woocommerce
  38. order posts by `meta_key`, Does not display posts that does not have `meta_key`
  39. WordPress Apply filter in plugin causes 500 internal error
  40. Meta query for comparing two dates
  41. Replacing global wp_query
  42. How to handle forms from sidebar widgets – Processing $_POST variables using get_field_name()
  43. Error in pdf generating plugin using FPDF
  44. Return multiple values ​in a shortcode attribute
  45. woocommerce search by sku and title ajax
  46. Loop returns the current page’s permalink and guid instead of the post in the loop
  47. Add user meta after a user has registered and logged In [closed]
  48. How to get CPT category checkbox list and show post of selected(multiply) checkboxes via ajax?
  49. BuddyPress activity on edit post for a CPT
  50. Pagination not working
  51. Custom Module, Extending WP with a Plugin?
  52. How to find the WordPress Nextgen galleries which are not used in WordPress posts?
  53. Adding CASE in WP_Query
  54. Searching a tab/space delimited text file based upon form criteria and returning a ‘record’ into a word press results page
  55. Woo-commerce Update price as a Bulk from My offline software export
  56. How to search post titles with whole words only, but not the exact word only?
  57. Trying to get property ‘ID’ of non-object in /wp-includes/class-wp-query.php on line 4044
  58. Use get_pages() before another plugin modifies it
  59. how to display recent post by category on home page
  60. How to Join wp_posts & wp_postmeta table using custom query
  61. What database state changes happen after a post is manually “updated” with no changes?
  62. any word search WordPress
  63. Warning: call_user_func_array() problem can anyone help with it?
  64. Fatal error: Uncaught Error: Cannot use object of type WP_Error as array in /../plugins/rm-payment.php
  65. How to get a specific string from a url
  66. WooCommerce Product Table – filter query on attributes
  67. Performance considerations – postmeta table versus new table for custom posts with foreign keys?
  68. How to pass multiple custom fields as shortcode’s parameters
  69. Is it possible to custom set query for a WordPress REST API response?
  70. Only return taxonomies that are linked to a category & product
  71. How to add specific posts to specific pages in WordPress?
  72. How to use information from the database in the front-end?
  73. User Following System
  74. How to fix slow comment query?
  75. Multiple Meta key in search
  76. Can I upload wordpress plugin made with framework
  77. History of page, interval of years
  78. How to insert variable which contain array value in wp_options table?
  79. Trending Tags based on post views
  80. Shortcode in a blog post, footer and related products stop working
  81. Plugin does not create a custom table upon activation
  82. How to delete only user meta value (not key) from usermeta table in wordpress?
  83. How can i see/log all requests coming from a registration form (not from the UI)?
  84. w3 total cache and post__not_in
  85. Action hook “wp_insert_post” works but not for last imported post
  86. Share common libraries across multiple themes/plugins
  87. WP_Query Date Filtering Inclusive Being Ignored
  88. Second foreach loop breaking (Posts2Posts)
  89. Advanced Custom Fields (ACF) Plugin – Random Image in Sidebar
  90. Ger posts from similar tags and categories
  91. WordPress filter function using query modifications
  92. WP-Snap too slow (caused by WP_Query?)
  93. WordPress Meta Query: Relation is not working correctly
  94. WordPress ultra slow if I click on posts?
  95. Insert data in custom table during new post creation
  96. Making a Custom Post Type Publish Loop
  97. Checking url from plugin [duplicate]
  98. I want to display data last 7 days with date wise in chartjs?
  99. Order custom post type by posts with most likes first
  100. Accessing Correct Database to Create REST API Endpoint