sensei icon indicating copy to clipboard operation
sensei copied to clipboard

Published 20 hours ago • verified publisher icon Automattic

Update SQL: SQLite compatible queries

Open merkushin opened this issue 8 months ago • 0 comments

WordPress Playground (also used for the plugin preview on wordpress.org) and Studio use SQLite as the database that backs the website.

In Sensei, we have custom SQL queries that are incompatible with SQLite.

One feature that is incompatible with SQLite and is used in Sensei is SQL_CALC_FOUND_ROWS (it is used in Reports).

There could be other incompatible features.

We need to revise our custom SQL queries and make them compatible with SQLite.

merkushin avatar Mar 13 '25 05:03 merkushin