Newly Rewritten WordPress SQLite Database Integration Plugin Needs Testing
WordPress contributors are making progress on officially supporting SQLite in core, a project that would benefit less complex sites (small to medium sites and blogs) that don’t necessarily require WordPress’ standard MySQL database. In a recent update, Yoast-sponsored core contributor Ari Stathopoulos said the SQLite Database Integration feature plugin has been rewritten, with the help of Automattic-sponsored core contributor Adam Zielinski, to be a more future-proof implementation. “The code has been completely rewritten to use an SQL Lexer and is now stable and able to handle all WordPress queries properly,” Stathopoulos said. “The SQL Lexer is part of the PHPMyAdmin/SQL-Parser project (licensed under the GPL 2.0) and it was adapted for WordPress, effectively implementing a MySQL to SQLite translation engine. This provides improved security, as well as compatibility.” Stathopoulos contends that the next step is to implement these changes in WordPress core “instead of using a plugin,” because in its current form it can only be tested on pre-existing websites that already have a MySQL database. “Using the featured plugin is a great way to allow users to test the implementation and iron out any issues etc,” he said. “However, long-term, it doesn’t make sense to use it as a plugin.” Stathopoulos created a draft Pull Request and…
…Full post on WP Tavern
Read Full
