WordPress.org

Ari Stathopoulos

Adam Zieliński

zaerl

Jan Jakeš

Bero

Brandon Payton

The SQLite plugin is a community, feature plugin. The intent is to allow testing an SQLite integration with WordPress and gather feedback, with the goal of eventually landing it in WordPress core.
This feature plugin includes code from the PHPMyAdmin project (specifically parts of the PHPMyAdmin/sql-parser library), licensed under the GPL v2 or later. More info on the PHPMyAdmin/sql-parser library can be found on <a href="https://github.com/phpmyadmin/sql-parser" rel="nofollow ugc">GitHub</a>.

SQLite Database Integration



Installed version 2.0



Activated



Message: "All checks completed successfully, your site can use an SQLite database. You can proceed with the installation."



Screen with text and button. Ok, I can go back by just deactivating this plugin! Great!



Clicked button "Install SQLite database"



"PDO Driver for SQLite is missing" alone on an blank page, wheverer I go



Stuck. My somewhat "well crafted" and sophisticated testing site gone away, it seemed. 




Why could this plugin not check the availability of this driver before presenting a clickable button, or even proceeding?



Since I'm knowledgable enough to delete the ´wp-content/db.php´ file I was soon back to start, so I don't need help.



Others, if less knowledable in WP, should be warned and stay away until proper tests can be made before proceeding. On screen instructions on how to manually disable it in an emergency should also be given.


Possibly worst UX trap I have ever seen


I used it to spin up a test site in CI, it's just elegant and brings WP closer to Static when we need it. There's a place for SQLite simplicity in some WP workflows. Loved it!


Excellent!


Thank you dev team for providing this plugin !


Great Plugin! Makes WP so fast!


Ok, so in terms of doing what it says in the tin, for me it looks great. I've set up 20 - 30 instances, it runs my core plugins and has a footprint of ~ 105M when running with a default setup. Seems to be at least as fast as the MySQL instances sat next to them.



Here's the problem tho'. It would seem I can't actually convert any existing sites over to run on these instances without a lot of manual work. (I say this after reading the experiences of some others who claim to have tried).



Are there any relatively automatic tools and/or documentation that I might have missed when it comes to migrating a MySQL instance over to SqLite (and back, in the event of a problem), or at least a Roadmap of if / when such tools or plugins might become available?



A roadmap or estimation might at least (if it's a long way away) prompt someone to get on and do it?


Great, seems only one step away ...

SQLite integration plugin by the WordPress Team.

Mr Pete

The (mu-compatible) WP Tuner plugin for WordPress is a powerful and easy to use way to answer many hard questions about why your blog is slow or cranky. What’s causing the slowdown? Is it a plugin? Is it your host?
Used with a bit of common sense, this powerful plugin will help blog administrators as well as software developers improve their WordPress blog performance.
Perfect for WordPress site administrators, plugin and theme designers, developers
Fully translatable.
<h3>Advanced Use</h3>
Here are more advanced ways to make use of WP Tuner. Please <a href="http://blogs.icta.net/plugins/wptuner" title="(Visit the WP Tuner home page)" rel="nofollow ugc">share your questions and/or stories</a> examples to share with others!
1) Hook any WordPress action
In wptuner.php, you will find a default set of action hooks. You can add as many hooks as you like for other actions. They look like this (just change “admin_footer” to the name of the action you want to measure):
<pre><code>add_action('admin_footer', 'wpTuneFilterTime' );
</code></pre>
Each hook adds a line to the WP Tuner performance analysis table, when that action is triggered.
2) Time anything at all in WordPress
WP Tuner contains a function that causes performance analysis for any section of WordPress code. Just use 
 wpTuneMarkTime(‘My Marker string’);
…at the beginning of the code you want analyzed. Add another marker at the end if needed.
For example, suppose you want to know how much time is spent loading each of the plugins you have enabled. Here’s how to do it, by adding two simple lines to wp-settings.php:
<pre><code>if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Load Plugins'); // ** Add THIS line **

if ( get_option('active_plugins') ) {
 $current_plugins = get_option('active_plugins');
 if ( is_array($current_plugins) ) {
 foreach ($current_plugins as $plugin) {
 if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Plugin: '.$plugin); // ** Add THIS line **
 if ( '' != $plugin && 0 == validate_file($plugin) && file_exists(WP_PLUGIN_DIR . '/' . $plugin) )
 include_once(WP_PLUGIN_DIR . '/' . $plugin);
 }
 }
}<h3>Credits</h3>
</code></pre>
Many thanks to the WP Tuner translation team!
Русский: <a href="http://lecactus.ru" rel="nofollow ugc">Кактусу</a> (updated through WP Tuner 0.9.3)
<h3>Readme Validator</h3>
This readme was validated using: 
<a href="https://wordpress.org/extend/plugins/about/validator/" rel="ugc">https://wordpress.org/extend/plugins/about/validator/</a>

WP Tuner

Easily, powerfully, discover why your blog or plugin is slow or cranky. Comprehensive time and database access analyzer. WPmu. multi-lingual.

SQLite Database Integration vs WP Tuner