hlcsoftware

<ul>
<li>SQL Window plugin is a powerfull tool to inspect your wordpress database easy and fast.</li>
<li>It should be used by <strong>administrators and developers</strong>.</li>
<li>It creates two private pages in your pages section, one for running the sql commands and the other is for getting the data results.</li>
<li>Simple in use with the ability to display any sql command errors.</li>
</ul>
<h3>Arbitrary section</h3>
<ul>
<li>*** This plugin should be used only from administrators ***</li>
</ul>


HLC_sql_window

SQL Window plugin is a really helpfull tool for Administrators and developers. Can execute database commands and return results in a new page.

it2911

<p>TiDB is a high-performance database that is compatible with the MySQL protocol. Since MySQL has deprecated the SQL_CALC_FOUND_ROWS function, TiDB also has no intention of offering the SQL_CALC_FOUND_ROWS function. This leads to an error in WordPress when using TiDB, indicating that SQL_CALC_FOUND_ROWS is not supported, and submissions cannot be displayed correctly.</p>
<p>WordPress is also currently working on this issue, but it seems that more time is needed. #47280 Remove usage of deprecated MySQL SQL_CALC_FOUND_ROWS from WP_Query</p>
<p>This plugin solves the issue of TiDB not providing the SQL_CALC_FOUND_ROWS function. Once this plugin is activated, parts of WP_Query that use SQL_CALC_FOUND_ROWS will be replaced with the COUNT(*) function.</p>
<p>This plugin is entirely based on the method mentioned by @akramipro in the article, and this solution works perfectly and addresses the issue. I’ve turned this method into a plugin so that those using TiDB can easily resolve this problem. Many thanks to @akramipro for the excellent work, and I hope the official WordPress team can address this issue sooner.</p>
<h3>Contribute</h3>
<p>Contribute to this plugin on <a href="https://github.com/pingcap/wordpress-tidb-plugin" rel="nofollow ugc">github.com/pingcap/wordpress-tidb-plugin</a></p>


TiDB Compatibility


This plugin is a must-have if you are running TiDB as the database instead of MySQL/MariaDB.


Must have for TiDB users

This plugin is an official tool provided by PingCAP, designed to solve compatibility issues between TiDB and WordPress.

HLC_sql_window vs TiDB Compatibility