myfamilyweb

Greg Schaub

<p>Built from the ground up based upon the latest technology and designed to support WordPress’ vision for the platform’s<br />
future,  <strong>Dynamic Tables</strong> is a new WordPress block plugin to create and manage information that is best organized<br />
as a table. The block is designed to be easily configured and highly responsive.</p>
<p>Dynamic Tables was created on a solid technical framework with the objective of delivering a complete end-to-end<br />
block solution for creating beautiful tables that are easy to maintain.  Additionally, this framework will provide a<br />
springboard to rapidly build upon this foundation to provide additional features.  Some capabilities on the<br />
roadmap include:<br />
* Support for templates and cloning.  Note that this support is <strong>not currently available</strong>. It is the first roadmap item.<br />
* Support for front end interactivity to sort and filter tables<br />
* Integrating Dynamic Tables with WordPress search<br />
* Allowing for specific content types and formats for all rows in a column (e.g, images, links, buttons, numeric formats, etc.) without the need to format each cell<br />
* Importing and exporting table data in common formats (e.g., csv, xlsx)<br />
* Enhanced responsive formatting for mobile devices<br />
* Front end editing</p>
<p>This is just a sample of the roadmap, some of which will be included in this free community edition while others will be available in a future premium version of Dynamic Tables.</p>
<h3>Formatting Features</h3>
<ul>
<li>Column & Row Actions
<ul>
<li>“Show table borders” creates a spreadsheet metaphore for intuitive column and row formatting. Toggle the boarders off when formats are set</li>
<li>Menu options to add or delete columns and rows</li>
<li>Fine grain control of column widths including support for:</li>
<li>Proportional or fix widths</li>
<li>Minimum and maximum widths so that text wraps appropriately, automatically adjusting row height</li>
<li>Supports both fixed (e.g., pixel) and inferred (e.g., character) sizing units</li>
</ul>
</li>
<li>Header
<ul>
<li>Optionally allow the first row to be a header</li>
<li>Optionally freeze headers with a vertical scrollbar</li>
<li>Support styling for the header row including borders and text alignment independently from table body rows</li>
</ul>
</li>
<li>Body Rows
<ul>
<li>Optionally display table grid licenses</li>
<li>Optionally display banded rows with styling for the band and text color</li>
<li>Allow for a horizontal scroll if table contents exceed the page width</li>
<li>Support styling for all body rows including borders and text alignment</li>
</ul>
</li>
<li>All color styling comes pre-loaded with the current theme colors with support for custom colors as well</li>
<li>Optionally display or hide table title</li>
</ul>
<h3>Love You Inner Geek!</h3>
<p>This information will be appealing to our techie friends, soothing their passion for embracing the technology.  Dynamic Blocks has an<br />
architecture that is somewhat unique to the world of Gutenberg development in that the table definition and content are stored in<br />
custom WordPress database tables because we didn’t believe it structurally lent itself well to the Post data metaphore.  These are<br />
the primary building blocks:<br />
* Table data and definitions are abstracted through a block entity types<br />
* Entities natively call RESTful api’s<br />
* There is an underlying WordPress REST API service that supports the loading and saving of table data<br />
* The service interacts with a highly abstracted SQL layer which leverages WordPress WPDB<br />
* The tables themselves leverage the newer CSS grid framework<br />
  * Much of the flexibility is derived from grid functinality that has been incorporated into mainstream web browsers as recently as 2024<br />
  * This framework provides responsiveness that doesn’t “break” table structure.  Misalighed rows and columns, unexpected wrapping, and otherwise indecipherable tables have been beaten down.<br />
* The API architecture can theoretically support data stored in external files or web services. We’re considering these capabilities in our roadmap.</p>


Dynamic Tables

Create highly responsive custom table blocks that are easily configured.

Lester Chan

<p>Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.</p>
<h3>General Usage</h3>
<ol>
<li>Activate <code>WP-DBManager</code> Plugin</li>
<li>The script will automatically create a folder called <code>backup-db</code> in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable</li>
<li>Open <code>Folder: wp-content/backup-db</code></li>
<li>If you are on Apache, move the <code>htaccess.txt</code> file from <code>Folder: wp-content/plugins/wp-dbmanager</code> to <code>Folder: wp-content/backup-db/.htaccess</code> if it is not there already</li>
<li>If you are on IIS, move the <code>Web.config.txt</code> file from <code>Folder: wp-content/plugins/wp-dbmanager</code> to <code>Folder: wp-content/backup-db/Web.config</code> if it is not there already</li>
<li>Move <code>index.php</code> file from <code>Folder: wp-content/plugins/wp-dbmanager</code> to <code>Folder: wp-content/backup-db/index.php</code> if it is not there already</li>
<li>Go to <code>WP-Admin -> Database -> DB Options</code> to configure the database options</li>
</ol>
<h3>Build Status</h3>
<p><a href="https://travis-ci.org/lesterchan/wp-dbmanager" rel="nofollow ugc"></a></p>
<h3>Development</h3>
<ul>
<li><a href="https://github.com/lesterchan/wp-dbmanager" title="https://github.com/lesterchan/wp-dbmanager" rel="nofollow ugc">https://github.com/lesterchan/wp-dbmanager</a></li>
</ul>
<h3>Translations</h3>
<ul>
<li><a href="http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/" title="http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/" rel="nofollow ugc">http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/</a></li>
</ul>
<h3>Credits</h3>
<ul>
<li>Plugin icon by <a href="http://www.freepik.com" rel="nofollow ugc">Freepik</a> from <a href="http://www.flaticon.com" rel="nofollow ugc">Flaticon</a></li>
</ul>
<h3>Donations</h3>
<ul>
<li>I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.</li>
</ul>
<h3>Disclaimer</h3>
<ul>
<li>Note that this plugin passes your datababase password via –password in the command line of mysqldump. This is convenient but as a trade off, it is insecure.</li>
<li>On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: <a href="http://dev.mysql.com/doc/refman/5.5/en/password-security-user.html" rel="nofollow ugc">End-User Guidelines for Password Security</a></li>
<li>If this is a concern to you, I recommend another database backup plugin called <a href="https://wordpress.org/plugins/wp-db-backup/" rel="ugc">WP-DB-Backup</a></li>
<li>To know about the difference between WP-DBManager and WP-DB-backup, checkout <strong>What is the difference between WP-DBManager and WP-DB-Backup?</strong> in the <a href="https://wordpress.org/plugins/wp-dbmanager/faq/" rel="ugc">FAQ section</a>.</li>
</ul>


Dynamic Tables vs WP-DBManager