[WordPress] 外掛分享: SQLite Database Integration

首頁外掛目錄 › SQLite Database Integration
4,000+
安裝啟用
★★★★
4.6/5 分(12 則評價)
7 天前
最後更新
問題解決
WordPress 6.4+ PHP 7.2+ v3.0.2 上架:2023-01-16

內容簡介

SQLite Database Integration 外掛讓 WordPress 能夠在 SQLite 環境中運行,取代預設的 MySQL 資料庫層,並提供兼容性與診斷功能,旨在收集反饋以促進未來的核心整合。

【主要功能】
• 無需資料庫伺服器,數據儲存在本地 SQLite 資料庫中
• 安裝過程檢查 PHP 擴展與寫入權限
• MySQL 語法解析與模擬層適配 SQLite
• 提供有用的診斷資訊,支援 Site Health 與 Query Monitor

外掛標籤

開發者團隊

⬇ 下載最新版 (v3.0.2) 或搜尋安裝

① 下載 ZIP → 後台「外掛 › 安裝外掛 › 上傳外掛」
② 後台搜尋「SQLite Database Integration」→ 直接安裝(推薦)
📦 歷史版本下載

原文外掛簡介

Run WordPress on SQLite.
The SQLite plugin is a community, feature plugin. The intent is to allow testing an SQLite integration with WordPress and gather feedback, with the goal of eventually landing it in WordPress core.
The plugin replaces the default MySQL database layer with an SQLite-backed implementation. WordPress continues to use its standard wpdb API while the plugin translates and emulates MySQL queries for SQLite.
What the plugin provides

No database server. Your site’s data is stored in a local SQLite database.
Guided setup. The installation screen checks for the required PHP extension, write access, and conflicting database drop-ins before enabling SQLite.
Purpose-built compatibility. A MySQL parser and emulation layer adapt MySQL syntax and behavior for SQLite.
Useful diagnostics. SQLite details appear in Site Health, and Query Monitor is supported.

Important: Enabling SQLite creates a separate, empty database; it does not migrate an existing site. If you enable it on a site that uses MySQL or MariaDB, WordPress will ask you to set up the site again. Disabling the plugin reconnects WordPress to the previous database with its data unchanged. Changes made while using SQLite are not transferred.
The plugin requires the PDO SQLite PHP extension and SQLite 3.37.0 or newer.

延伸相關外掛

文章
Filter
Mastodon