grexican

<p>If you’ve ever needed your ACF choices to be dynamically generated by a SQL query, this plugin will help you get the job done.</p>
<p>You can mix and match static choices with dynamic, SQL-based choices by placing as many regular choices in the list as you’d like, followed by the special <code>%%QUERY%%</code> choice that will tell this plugin to load choices dynamically from the database.</p>
<p>An example on how to list users, setting the <code>id</code> as the value, would look like this:</p>
<pre><code>%%QUERY%% : SELECT user_nicename AS text, id AS value FROM wp_users
</code></pre>
<h3>Arbitrary section</h3>


ACF Dynamic Choices

Advanced Custom Fields plugin to allow for dynamic choices (through SQL queries)

Jordy Meow

<p>Database Cleaner is packed with features to handle big databases, built from years of experience with similar plugins. It works great with the latest WP and PHP versions and has an easy-to-use interface. For large tasks, it uses asynchronous requests to avoid errors and timeouts, ensuring smooth processing. Check it out at <a href="https://meowapps.com/database-cleaner/" rel="nofollow ugc">Database Cleaner</a>.</p>
<p><strong>IMPORTANT</strong>: Always back up your data before using this or any plugin! While Database Cleaner is reliable, it’s always best to be safe. Better safe than sorry! 🙂</p>
<h3>Features</h3>
<ul>
<li>Easy Mode & Expert Mode: Whether you’re a beginner or a pro, there’s a mode for you. Easy mode simplifies everything, while Expert mode gives you full control.</li>
<li>One-Click Cleaning: Save time with automatic cleaning. Just one click, and your database is tidy and optimized.</li>
<li>Smart Data Management: Understand how plugins or themes use your data. The Pro Version offers even deeper insights.</li>
<li>Detailed Statistics: Keep an eye on your database size with comprehensive stats and history tracking.</li>
<li>Effortless Data Browsing: Explore and categorize your data with ease. Find what you need without any hassle.</li>
<li>Big Database Handling: Perfect for large databases, it uses smooth, error-free asynchronous requests to manage heavy tasks.</li>
<li>In-Depth Analysis: Specialized tools to analyze and monitor your data across Post Types, Tables, Options, and Cron Jobs.</li>
</ul>
<h3>Why another Database Cleaner?</h3>
<p>While other database cleaners are available, my experience with them revealed areas for improvement, like outdated UIs, incomplete features, and limited data analysis capabilities. Most notably, they struggled with large databases. Motivated by these challenges, I developed my own solution. Now, I’m dedicated to refining it to suit all types of WordPress and databases, aiming to make it the best for everyone.</p>
<p>I’m open to feedback and would be thrilled to discuss how Database Cleaner can better meet your needs. Let’s chat and enhance this tool together!</p>


Database Cleaner


for now, I can tell It works better than any other database-optimizing plugin.


‌Best plugin for database cleaning


Now THIS guy really knows what he's doing. Fantastic UI for "Easy" and "Expert". As an expert I can easily delete loads of crud from the DB, and if I'm not sure I can even look at the value of a DB entry to find out more about it. Simply perfect. And that's all in the free version! I also recommend Jordy's companion plugin Media Cleaner highly - if you want to clean orphaned files in uploads you need the Pro version - I paid for it gladly.


Features you didn't dare dream of

Worth 5 stars without a doubt.  Efficient with an easy mode as well as an expert mode that gives you a lot of possibilities.

Haven't explored the hooks provided such as for example batch assigning unknown metas/options to plugins, but overall am happy with what I saw especially compared to other db clearner plugins out there which give you very basic cleaning functionality while all the real cleaning power site behind the paid version.

Lots of cleaning power


Your plugin is much too good, the interface is super well-thought-out. It's very easy to use, and allows going very far in cleaning up databases. Keep up the good work! You rock!


Deserves more installations

User-friendly tool to clean and optimize databases. Efficiently manages large databases, simplifying repair and ensuring peak performance.

ACF Dynamic Choices vs Database Cleaner