WordPress.org

Ari Stathopoulos

Adam Zieliński

Bero

Brandon Payton

Jan Jakeš

zaerl

<p>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.</p>
<p>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>.</p>


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.

Frank Bueltge

Inpsyde GmbH

<p>List query-actions only for admins; for debug purposes. See all queries on the frontend of the blog and find the slowest part.</p>
<h4>New release, new Plugin</h4>
<p>Please use the plugin <a href="https://wordpress.org/extend/plugins/debug-objects/" rel="ugc">Debug Objects</a>, provides more information and a cleaner query view as this older plugin.<br />
The new solution list also the plugin and core queries in different views.</p>
<p>Since version 1.0.0 the plugin disable the MySQL query cache for the current connected session. That will show you the real execution time for a query. To disable this behavior set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<p>The plugin is perfect for WordPress developers, plugin and theme developers and site administrators who are trying to find out why the blog is too slow.</p>
<h4>Params</h4>
<p>The plugin has since version 1.0.0 a constant to disable the mySQL Session cache. On defoult is the value on true and the cache is off for an better analyse! For change this, set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<h4>Example</h4>
<p>This is a example for evaluation.</p>
<pre><code># Time: 0.00198888778687
Query: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
Call from: require, require_once, require_once, require_once, is_blog_installed, wp_load_alloptions
# Time: 0.000695943832397
Query: UPDATE 'wp_options' SET 'option_value' = 'a:3:{i:0;b:0;s:25:\"adminimize/adminimize.php\";a:2:{i:0;O:10:\"adminimize\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:12:\"on_deinstall\";}s:31:\"debug_queries/debug_queries.php\";a:2:{i:0;O:12:\"DebugQueries\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:10:\"deactivate\";}}' WHERE 'option_name' = 'uninstall_plugins'
Call from: require, require_once, require_once, require_once, include_once, adminimize->adminimize, register_uninstall_hook, update_option

. . .

Total query time: 0.0155501365662 for 23 queries.
Total num_query time: 0.392 for 23 num_queries.
</code></pre>
<h4>Acknowledgements</h4>
<p>Thanks to Joost de Valk on <a href="http://yoast.com/" title="yoast.com" rel="nofollow ugc">yoast.com</a> for small modifed on the plugin for some extra info.</p>
<h4>Licence</h4>
<p>Good news, this plugin is free for everyone! Since it’s released under the GPL, you can use it free of charge on your personal or commercial blog. But if you enjoy this plugin, you can thank me and leave a <a href="http://bueltge.de/wunschliste/" title="Wishliste and Donate" rel="nofollow ugc">small donation</a> for the time I’ve spent writing and supporting this plugin. And I really don’t want to know how many hours of my life this plugin has already eaten 😉</p>


Debug Queries

List query-actions only for admins; for debug purposes

SQLite Database Integration vs Debug Queries