百科.dev
全部条目在线工具AI 编程趋势榜开源项目技术资讯提交条目
登录
< 返回工具列表
S

sqlite-database-integration

> 编程语言
开源

将 SQLite 支持添加到 WordPress 的特性插件 。 正在开发中.

358 stars0 点赞2 次浏览
访问官网GitHub

工具介绍

将 SQLite 支持添加到 WordPress 的特性插件 。 正在开发中.

SQLite database integration

This project implements SQLite database support for MySQL-based projects.

It is a monorepo that includes the following components:

  • MySQL lexer — A fast MySQL lexer with multi-version support.
  • MySQL parser — An exhaustive MySQL parser with multi-version support.
  • MySQL on SQLite — A MySQL emulation layer on top of SQLite with a PDO-compatible API.
  • MySQL proxy — A MySQL binary protocol implementation to support MySQL-based projects beyond PHP.
  • WordPress plugin — A plugin that adds SQLite support to WordPress.
  • Test suites — A set of extensive test suites to cover MySQL syntax and functionality.

The monorepo packages are placed under the packages directory.

The WordPress plugin links the MySQL on SQLite package using a symlink. The build script replaces the symlink with a copy of the package for release.

The codebase is pure PHP with zero dependencies. It supports PHP 7.2 through 8.5, MySQL syntax from version 5.7 onward, and requires SQLite 3.37.0 or newer (with legacy mode down to 3.27.0).

Quick start

The codebase is written in PHP and Composer is used to manage the project. The following commands are useful for development and testing:

…

Optional: Native MySQL Parser Extension

The default code path is pure PHP. For environments that can load PHP extensions, the optional wp_mysql_parser extension accelerates the MySQL lexer/parser used by MySQL on SQLite.

  • Published WASM release list, manifest links, Playground links, and native extension overview
  • Build, load, and benchmark docs

Latest local measurement (Apple Silicon macOS, PHP 8.4.5 CLI, 2026-05-26): the native lexer path processed the MySQL test corpus at ~343k QPS versus ~72k QPS for pure PHP (~4.80x), and the native parser path processed it at ~108k QPS versus ~7k QPS for pure PHP (~15.45x).

Release workflow

Release is streamlined with a local preparation script and GitHub Actions:

  1. Run the release preparation script locally.

    bash
    composer run prepare-release 

    The script will:

    • Bump version numbers and generate a changelog from merged PRs.
    • Create a release/v branch with a preparation commit.
    • Push the branch and create a PR.
  2. Review the PR. Edit the changelog or push additional changes to the release branch.

  3. Mark as ready and merge the PR. The release-publish workflow will automatically:

    • Build the plugin ZIP.
    • Create and publish a GitHub release with the ZIP attached.
    • Deploy the release to WordPress.org.

Architecture

The project consists of multiple components providing different APIs that funnel into MySQL on SQLite to support diverse use cases both inside and outside the PHP ecosystem.

Component overview

The following diagrams show how different types of applications can be supported using components from this project:

…

Query processing pipeline

The following diagram illustrates how a MySQL query is processed and emulated:

                string        tokens         AST ╔═════════════╗ SQL
┌─────────────┐  │  ╔═══════╗  │  ╔════════╗  │  ║ Translation ║  │  ┌────────┐
│ MySQL query │──┴─→║ Lexer ║──┴─→║ Parser ║──┴─→║      &      ║──┴─→│ SQLite │
└─────────────┘     ╚═══════╝     ╚════════╝     ║  Emulation  ║     └────────┘
                                                 ╚═════════════╝

Issues· 0 开放

查看全部 Issues在 GitHub 打开

暂无开放 Issues,或尚未同步最近议题。

> 标签

PHP

暂无评论,来聊聊你的看法吧

> 工具信息

发布日期2026年8月1日
最后更新2026年9月17日
分类编程语言
定价开源

> 相关工具

T
TypeScript
JavaScript 的超集,为前端与全栈提供静态类型
P
Python
通用编程语言,广泛用于 Web、数据与 AI
G
Go
Google 推出的简洁高效系统语言