Eduardo Marcolino

<p>This ACF plugin makes it possible to store ACF data in structured database tables instead of WordPress core meta tables.</p>
<p>It uses ACF’s <code>acf/update_field_group</code> hook to create/update the database and then uses <code>acf/save_post</code> hook to store the data.</p>
<p>It was heavily inspired by Austin Ginder’s post <a href="https://anchor.host/acf-custom-fields-stored-in-custom-table/" rel="nofollow ugc">https://anchor.host/acf-custom-fields-stored-in-custom-table/</a>.</p>
<p>You can contribute to this plugin by submit PR/Issue in <a href="https://github.com/eduardo-marcolino/acf-fields-in-custom-table" rel="nofollow ugc">https://github.com/eduardo-marcolino/acf-fields-in-custom-table</a>.</p>
<h4>Supported Fields</h4>
<ul>
<li>Text</li>
<li>Text Area</li>
<li>Number</li>
<li>Range</li>
<li>Email</li>
<li>URL</li>
<li>Password</li>
<li>Image</li>
<li>File</li>
<li>Wysiwyg Editor</li>
<li>oEmbed</li>
<li>Select</li>
<li>Checkbox</li>
<li>Radio Button</li>
<li>Button Group</li>
<li>True / False</li>
<li>Date Picker</li>
<li>Date Time Picker</li>
<li>Time Picker</li>
<li>Color Picker</li>
<li>Link</li>
<li>Post Object</li>
<li>Page Link</li>
<li>Relationship</li>
<li>Taxonomy</li>
<li>User</li>
</ul>
<h4>Relational Fields</h4>
<p>This plugin supports the following relational field types: Post Object, Page Link, Relationship, Taxonomy and User.</p>
<p>It can store both single and multiple values based on the <code>multiple</code> option.</p>
<ul>
<li>If it’s a single value field, then the column type will be <code>bigint(20) unsigned</code></li>
<li>If it’s a multiple value field, then the column type will be longtext and the date will be stored in json format.</li>
</ul>
<p>You can query relational fields with multiple values using using MySQL’s function <a href="https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-contains" rel="nofollow ugc">JSON_CONTAINS</a>.<br />
Here is an example:</p>
<p>Table:</p>
<pre><code>+---------+-------------------+--------+
| post_id |       title       | stores |
+---------+-------------------+--------+
|       1 | Lord of the Flies | [1,2]  |
|       2 | The Island        | [2]    |
|       3 | 1984              | [3]    |
+---------+-------------------+--------+
</code></pre>
<p>Query:</p>
<pre><code>SELECT * FROM wp_acf_books WHERE JSON_CONTAINS(stores, 2, '$')
</code></pre>
<p>The query above will return “Lord of the Flies” and “The Island”.</p>
<h4>ACF Compatibility</h4>
<p>This plugin was tested with <em>ACF 5 FREE Version</em> .</p>


ACF: Fields in Custom Table

Stores ACF custom fields in a custom table instead of WordPress core meta tables.

StudioPress

WP Engine

Ryan Kienstra

rheinardkorf

Luke Carbis

stino11

<p>Genesis Custom Blocks provides WordPress developers with the tools they need to take control of the block-first reality of modern WordPress.</p>
<p>The WordPress block editor (AKA Gutenberg) opens up a whole new world for the way we build pages, posts, and websites with WordPress. Genesis Custom Blocks makes it easy to harness this and build custom blocks the way you want them to be built. Whether you want to implement a custom design, deliver unique functionality, or even remove your dependence on other plugins, Genesis Custom Blocks equips you with the tools you need to hit “Publish” sooner.</p>
<p><strong>Take control of design</strong> – Implement beautiful, custom designs with fine-tuned front-end templating control.</p>
<p><strong>Build unique functionality</strong> – Build blocks that function and behave exactly as you need.</p>
<p><strong>Extend & Integrate</strong> – Easily extend your custom blocks to integrate with third-party apps and plugins.</p>
<h3>Features</h3>
<h3>A Familiar Experience</h3>
<p>Work within the WordPress admin with an interface you already know.</p>
<h3>Block Fields</h3>
<p>Add from a growing list of available fields to your custom blocks.</p>
<h3>Simple Templating</h3>
<p>Let the plugin do the heavy lifting so you can use the built-in editor, or familiar WordPress development practices to build block templates.</p>
<h3>Developer Friendly Functions</h3>
<p>As an alternative to the built-in editor, there are simple functions, ready to render and work with the data stored through your custom block fields.</p>
<h3>Currently available block fields</h3>
<ul>
<li>Inner Blocks Field</li>
<li>File Field</li>
<li>Text Field</li>
<li>Image Field</li>
<li>URL Field</li>
<li>Toggle Field</li>
<li>Textarea Field</li>
<li>Select Field</li>
<li>Range Field</li>
<li>Radio Field</li>
<li>Number Field</li>
<li>Multi-select Field</li>
<li>Email Field</li>
<li>Color Field</li>
<li>Checkbox Field</li>
</ul>
<h3>Do more with Genesis Pro</h3>
<p>For those wanting to level-up with Genesis Custom Blocks, a Genesis Pro subscription brings some serious power-user features:</p>
<h3>Genesis Custom Blocks Pro Features</h3>
<ul>
<li>Repeater Field</li>
<li>Taxonomy Field</li>
<li>Post Field</li>
<li>User Field</li>
<li>Rich Text Field</li>
<li>Classic Text Field</li>
<li>Block Level Import/Export</li>
<li>24/7 Support</li>
</ul>
<p>Genesis Pro includes even more value for modern WordPress content creators, marketers, and developers. <a href="https://www.studiopress.com/genesis-pro/" rel="nofollow ugc">Learn more about Genesis Pro here</a>.</p>
<h3>Developer docs you can rely on.</h3>
<p>Developer tools are only as good as their docs. That’s why we take them seriously. Here are a few links to get you started:</p>
<ul>
<li><a href="https://developer.wpengine.com/genesis-custom-blocks/get-started/" rel="nofollow ugc">Getting Started</a></li>
<li><a href="https://developer.wpengine.com/genesis-custom-blocks/faqs/" rel="nofollow ugc">FAQs</a></li>
<li><a href="https://developer.wpengine.com/genesis-custom-blocks/fields/" rel="nofollow ugc">Block Fields</a></li>
<li><a href="https://developer.wpengine.com/genesis-custom-blocks/functions/" rel="nofollow ugc">PHP Functions</a></li>
</ul>
<h3>Links</h3>
<ul>
<li><a href="https://wordpress.org/plugins/genesis-custom-blocks" rel="ugc">WordPress.org</a></li>
<li><a href="https://github.com/studiopress/genesis-custom-blocks" rel="nofollow ugc">GitHub</a></li>
<li><a href="https://developer.wpengine.com/genesis-custom-blocks" rel="nofollow ugc">Documentation</a></li>
</ul>


Genesis Custom Blocks

This plugin makes it very easy to create custom blocks for use in WordPress themes. Thanks for the free plugin. 

ACF: Fields in Custom Table vs Genesis Custom Blocks