{"id":168657,"date":"2023-01-17T08:42:13","date_gmt":"2023-01-17T08:42:13","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/sqlite-database-integration\/"},"modified":"2026-04-10T15:06:53","modified_gmt":"2026-04-10T15:06:53","slug":"sqlite-database-integration","status":"publish","type":"plugin","link":"https:\/\/ca.wordpress.org\/plugins\/sqlite-database-integration\/","author":5911429,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"2.2.23","stable_tag":"2.2.23","tested":"6.9.4","requires":"6.4","requires_php":"7.2","requires_plugins":null,"header_name":"SQLite Database Integration","header_author":"The WordPress Team","header_description":"SQLite database driver drop-in. (based on SQLite Integration by Kojima Toshiyasu)","assets_banners_color":"","last_updated":"2026-04-10 15:06:53","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"","rating":4.6,"author_block_rating":0,"active_installs":2000,"downloads":414241,"num_ratings":12,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","faq","changelog"],"tags":{"2.1.13":{"tag":"2.1.13","author":"aristath","date":"2024-08-02 09:58:45"},"2.1.14":{"tag":"2.1.14","author":"aristath","date":"2024-08-14 15:53:26"},"2.1.15":{"tag":"2.1.15","author":"aristath","date":"2024-09-04 10:18:39"},"2.1.16":{"tag":"2.1.16","author":"janjakes","date":"2025-01-08 11:37:51"},"2.2.0":{"tag":"2.2.0","author":"janjakes","date":"2025-06-02 10:33:16"},"2.2.1":{"tag":"2.2.1","author":"janjakes","date":"2025-06-02 10:52:54"},"2.2.10":{"tag":"2.2.10","author":"janjakes","date":"2025-09-19 07:22:07"},"2.2.11":{"tag":"2.2.11","author":"janjakes","date":"2025-10-02 12:33:03"},"2.2.12":{"tag":"2.2.12","author":"janjakes","date":"2025-10-10 11:19:22"},"2.2.13":{"tag":"2.2.13","author":"janjakes","date":"2025-10-22 15:48:46"},"2.2.14":{"tag":"2.2.14","author":"janjakes","date":"2025-11-06 16:38:14"},"2.2.15":{"tag":"2.2.15","author":"janjakes","date":"2025-11-28 09:21:52"},"2.2.16":{"tag":"2.2.16","author":"janjakes","date":"2026-01-15 16:05:17"},"2.2.17":{"tag":"2.2.17","author":"janjakes","date":"2026-02-02 09:04:55"},"2.2.18":{"tag":"2.2.18","author":"janjakes","date":"2026-03-06 15:47:13"},"2.2.19":{"tag":"2.2.19","author":"janjakes","date":"2026-03-19 15:32:33"},"2.2.2":{"tag":"2.2.2","author":"janjakes","date":"2025-06-06 13:18:16"},"2.2.20":{"tag":"2.2.20","author":"janjakes","date":"2026-03-25 20:58:37"},"2.2.21":{"tag":"2.2.21","author":"janjakes","date":"2026-04-03 13:06:09"},"2.2.22":{"tag":"2.2.22","author":"janjakes","date":"2026-04-03 14:26:17"},"2.2.23":{"tag":"2.2.23","author":"janjakes","date":"2026-04-10 15:06:53"},"2.2.3":{"tag":"2.2.3","author":"janjakes","date":"2025-07-04 11:34:22"},"2.2.4":{"tag":"2.2.4","author":"janjakes","date":"2025-07-25 16:51:43"},"2.2.5":{"tag":"2.2.5","author":"janjakes","date":"2025-07-31 09:22:39"},"2.2.6":{"tag":"2.2.6","author":"janjakes","date":"2025-08-06 12:16:34"},"2.2.7":{"tag":"2.2.7","author":"janjakes","date":"2025-09-11 19:12:48"},"2.2.8":{"tag":"2.2.8","author":"janjakes","date":"2025-09-12 05:58:14"},"2.2.9":{"tag":"2.2.9","author":"janjakes","date":"2025-09-12 09:41:20"}},"upgrade_notice":[],"ratings":{"1":1,"2":0,"3":0,"4":1,"5":10},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["2.1.13","2.1.14","2.1.15","2.1.16","2.2.0","2.2.1","2.2.10","2.2.11","2.2.12","2.2.13","2.2.14","2.2.15","2.2.16","2.2.17","2.2.18","2.2.19","2.2.2","2.2.20","2.2.21","2.2.22","2.2.23","2.2.3","2.2.4","2.2.5","2.2.6","2.2.7","2.2.8","2.2.9"],"block_files":[],"assets_screenshots":[],"screenshots":[],"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[153,247],"plugin_category":[54,59],"plugin_contributors":[78740,226274,182429,236628,77594,236629,221146],"plugin_business_model":[],"class_list":["post-168657","plugin","type-plugin","status-publish","hentry","plugin_tags-database","plugin_tags-performance","plugin_category-security-and-spam-protection","plugin_category-utilities-and-tools","plugin_contributors-aristath","plugin_contributors-berislavgrgicak","plugin_contributors-bpayton","plugin_contributors-janjakes","plugin_contributors-wordpressdotorg","plugin_contributors-zaerl","plugin_contributors-zieladam","plugin_committers-aristath","plugin_committers-berislavgrgicak","plugin_committers-bpayton","plugin_committers-githubsync","plugin_committers-janjakes","plugin_committers-wordpressdotorg","plugin_committers-zaerl","plugin_committers-zieladam"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/sqlite-database-integration.svg","icon_2x":false,"generated":true},"screenshots":[],"raw_content":"<!--section=description-->\n<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>\n\n<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\">GitHub<\/a>.<\/p>\n\n<!--section=faq-->\n<dl>\n<dt id=\"what%20is%20the%20purpose%20of%20this%20plugin%3F\"><h3>What is the purpose of this plugin?<\/h3><\/dt>\n<dd><p>The primary purpose of the SQLite plugin is to allow testing the use of an SQLite database, with the goal to eventually land in WordPress core.<\/p>\n\n<p>You can read the original proposal on the <a href=\"https:\/\/make.wordpress.org\/core\/2022\/09\/12\/lets-make-wordpress-officially-support-sqlite\/\">Make blog<\/a>, as well as the <a href=\"https:\/\/make.wordpress.org\/core\/2022\/12\/20\/help-us-test-the-sqlite-implementation\/\">call for testing<\/a> for more context and useful information.<\/p><\/dd>\n<dt id=\"can%20i%20use%20this%20plugin%20on%20my%20production%20site%3F\"><h3>Can I use this plugin on my production site?<\/h3><\/dt>\n<dd><p>Per the primary purpose of the plugin (see above), it can mostly be considered a beta testing plugin. To a degree, it should be okay to use it in production. However, as with every plugin, you are doing so at your own risk.<\/p><\/dd>\n<dt id=\"where%20can%20i%20submit%20my%20plugin%20feedback%3F\"><h3>Where can I submit my plugin feedback?<\/h3><\/dt>\n<dd><p>Feedback is encouraged and much appreciated, especially since this plugin is a future WordPress core feature. If you need help with troubleshooting or have a question, suggestions, or requests, you can <a href=\"https:\/\/github.com\/wordpress\/sqlite-database-integration\/issues\/new\">submit them as an issue in the SQLite GitHub repository<\/a>.<\/p><\/dd>\n<dt id=\"how%20can%20i%20contribute%20to%20the%20plugin%3F\"><h3>How can I contribute to the plugin?<\/h3><\/dt>\n<dd><p>Contributions are always welcome! Learn more about how to get involved in the <a href=\"https:\/\/make.wordpress.org\/performance\/handbook\/get-involved\/\">Core Performance Team Handbook<\/a>.<\/p><\/dd>\n<dt id=\"does%20this%20plugin%20change%20how%20wordpress%20queries%20are%20executed%3F\"><h3>Does this plugin change how WordPress queries are executed?<\/h3><\/dt>\n<dd><p>The plugin replaces the default MySQL-based database layer with an\nSQLite-backed implementation. Core WordPress code continues to use\nthe wpdb API, while queries are internally adapted to be compatible\nwith SQLite syntax and behavior.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>2.2.23<\/h4>\n\n<ul>\n<li>Add Query Monitor 4.0 support (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/357\">#357<\/a>)<\/li>\n<li>Translate MySQL CONVERT() expressions to SQLite (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/356\">#356<\/a>)<\/li>\n<\/ul>\n\n<h4>2.2.22<\/h4>\n\n<ul>\n<li>Support INSERT without INTO keyword (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/354\">#354<\/a>)<\/li>\n<li>Add tests for MySQL row-level locking clauses (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/342\">#342<\/a>)<\/li>\n<li>Improve automated deploy setup.<\/li>\n<\/ul>\n\n<h4>2.2.21<\/h4>\n\n<ul>\n<li>Monorepo setup + release automation (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/334\">#334<\/a>)<\/li>\n<li>Rework release workflow (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/350\">#350<\/a>)<\/li>\n<li>Fix incorrect PHP polyfill implementations (<a href=\"https:\/\/github.com\/WordPress\/sqlite-database-integration\/pull\/338\">#338<\/a>)<\/li>\n<\/ul>","raw_excerpt":"SQLite integration plugin by the WordPress Team.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/168657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"author":[{"embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/users\/5911429"}],"replies":[{"embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=168657"}],"wp:attachment":[{"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=168657"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=168657"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=168657"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=168657"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=168657"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/ca.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=168657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}