A new experimental Database pane is now live on playground.wordpress.net, featuring:
- One-click Adminer access
- One-click phpMyAdmin access
- Quick access to the SQLite database file
Following the recent additions of the File Browser and the Blueprint Editor, it is now possible to browse and modify the Playground SQLite database even with tools designed to be used with MySQLMySQL MySQL is a relational database management system. A database is a structured collection of data where content, configuration and other options are stored. https://www.mysql.com/..
See it in action:
Or head to playground.wordpress.net and try it live.
If you experience any issues, please report them. This feature is under active development, and your feedback is valuable for future improvements.
State of MySQL-on-SQLite emulation
This new functionality showcases the capabilities of the new SQLite driver and offers a glimpse of what’s ahead. MySQL database administration tools often rely on advanced MySQL schema introspection capabilities, uncommon MySQL statements, and complex query patterns. While you may still encounter some issues and unsupported features, this early experimental integration with MySQL tooling is already very useful, and the compatibility will continue to improve.
Looking ahead, work is already underway on implementing the MySQL binary protocol, which will allow you to use tools that expect a MySQL server to be present. As the development continues, support for MySQL tooling will make its way into the Playground CLICLI Command Line Interface. Terminal (Bash) in Mac, Command Prompt in Windows, or WP-CLI for WordPress., and ultimately, these efforts will allow most MySQL-based applications and tools to run seamlessly on an SQLite database.