sqlite-database-integration
sqlite-database-integration copied to clipboard
WordPress
Feature Plugin to add SQLite support to WordPress. Under Development.
The CREATE TABLE LIKE syntax isn't supported at the moment.
Support for adjusting the autoincrement counter would be useful in Playground for resetting the default WordPress content. Right now you may get 3 or 4 or 5 pages by default,...
Hello maintainer 👋 This plug-in project is very good. Although SQLite is suitable for small websites, for small websites with intensive writing, perhaps turning on WAL can further improve the...
Version 2.1.9 I'm continuing to see these entries (and similar) appear in the PHP error log many times per minute while accessing the site. The `no such column: wp_options` seems...
Let's go through the MySQL documentation pages and make sure even the complex SELECT queries are supported by the SQLite integration plugin: * https://dev.mysql.com/doc/refman/8.0/en/select.html * https://dev.mysql.com/doc/refman/8.0/en/join.html * https://dev.mysql.com/doc/refman/8.0/en/union.html * https://dev.mysql.com/doc/refman/8.0/en/intersect.html...
There's a proposal to add a UNION query to WordPress core: https://core.trac.wordpress.org/ticket/61097. Also, a fair share of plugins use UNION queries: https://wpdirectory.net/search/01HWQ4DT6Y1QP8W0DJ8GMZJJZ6 The SQLite integration plugin should support those, too....
We noticed the following error: ``` Deprecated: addslashes(): Passing null to parameter #1 ($string) of type string is deprecated in sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php on line 107 ``` https://github.com/WordPress/sqlite-database-integration/blob/037f6efe3ac27e9cda668e6d13eb087ed5471bce/wp-includes/sqlite/class-wp-sqlite-db.php#L95-L108 I think that in...
Built based on the official image and integrated with the official SQLite plug-in. - https://github.com/soulteary/docker-sqlite-wordpress I hope it can help friends who want to use this solution.
LIMIT has been fixed for UPDATE with this PR https://github.com/WordPress/sqlite-database-integration/pull/93 but DELETE LIMIT is still unsupported.
In https://github.com/WordPress/sqlite-database-integration/pull/94 we added support for allowing columns to be updated to null even if they have NOT NULL in the column definition and don't have a DEFAULT value. This...
