PageForge 1.3: Überprüfen Sie jeden Durchlauf, bevor er schreibt, aktualisierte Seiten, SpinTax und wiederaufnehmende Batches. Sehen Sie, was sich geändert hat
SQLite Database Integration icon
aktiv gepflegt Getestet mit WP 7.1 #22 in database

SQLite Database Integration

Run WordPress on SQLite.

Aktive Installationen5K+5K + Stufe
Downloads · 30d237.6K▲ +57.9% vs prev. 30d
Wertung4.6/512 Bewertungen
Gesundheits-Score82/100Ausgezeichnet
Downloads aller Zeiten1.1MSince Jan 2023
Unterstützung gelöst—Keine aktuellen Threads
erfordertWP 6.4PHP 7.2+
Downloads · 7d56.4K▲ +5.3% week over week
Unser Urteil

Sichere Auswahl

Yes — SQLite Database Integration is a safe, well-maintained plugin to use in 2026. It runs on 5K+ sites, is rated 4.6/5 and was last updated 2 weeks ago, and scores 82/100 on our health check.

  • Aktiv entwickelt — letztes Update vor 2 Wochen
  • Getestet mit dem neuesten WordPress (7.1)
  • Momentum – Downloads um 57,9% gegenüber den letzten 30 Tagen

Wie stapelt es sich?

Side-by-side bei Installationen, Updates, Bewertungen und Support

Tägliche Downloads

2.9K5.9K8.8KAug 22Oct 5Nov 19
Gestern8,843
Täglicher Durchschnitt (1 Jahr)2,411
Spitzentag11,732Oct 30, 2026
Letzte 12 Monate877.6K

Download-Spitzen folgen normalerweise einer neuen Version - jede Website, die automatisch aktualisiert wird, gilt als Download.

Ranglisten

Where SQLite Database Integration stands today

WordPress.org Ranglisten suchen

Live-Position in der Plugin-Suche, Top 100
StichwortPositionKonkurrierende PluginsKategorie
Datenbank #11 10,000 Beste Datenbank-Plugins →
SQLite #2 208 Best SQLite plugins →

Versionsübernahme

Anteil aktiver Sites pro Release.

  • 2.245.2%
  • 2.122.3%
  • 3.120.8%
  • 3.011.7%

Bewertungsaufschlüsselung

★★★★★★★★★★ 4.6 from 12 reviews

  • 5★83.3%
  • 4★8.3%
  • 3★0.00%
  • 2★0.00%
  • 1★8.3%

About SQLite Database Integration

From the official readme · v3.1.3

Beschreibung

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.

Änderungsprotokoll

Major release with an all-new SQLite driver. Requires SQLite 3.37.0 or newer. Back up your SQLite database before updating.

3.1.3

  • Fix BINARY and VARBINARY column defaults (#596)
  • Quote SQLite identifiers in LOCK TABLES, SHOW TABLES, and compound primary key indexes (#599)
  • Name lexer tokens after the MySQL grammar and default to MySQL 8.4.10 (#607)
  • Fix MySQL lexer correctness issues (#584)
  • Require MySQL proxy authentication and default to loopback (#540)
  • Speed up PHPUnit and avoid E2E setup timeouts (#579)
  • Fix reserved prefix checks for case variants and foreign keys (#580)

3.1.2

  • Allow configuring the SQLite busy timeout with SQLITE_BUSY_TIMEOUT (#558)
  • Keep the user transaction active after a failed statement (#536)
  • Support odd-length 0x hexadecimal literals (#573)
  • Fix rebuilds of legacy text and binary columns (#565)
  • Use '0' column defaults in non-strict INSERT statements (#569)
  • Roll back failed OPTIMIZE TABLE and REPAIR TABLE rebuilds (#567)
  • Remove the Rust parser extension (#566)
  • Preserve AUTO_INCREMENT counters when rebuilding tables (#561)
  • Fix ALTER TABLE ... ADD (...) for columns, indexes, and constraints (#557)
  • Fix ON UPDATE CURRENT_TIMESTAMP for explicit values and unchanged rows (#560)
  • Normalize zero defaults in date and time columns (#542)
  • Add support for ALTER COLUMN with SET DEFAULT and DROP DEFAULT (#555)

3.1.1

  • Support date arithmetic with INTERVAL operators (#539)
  • Fix ROLLBACK as the first transaction of a connection (#537)
  • Fix matching a foreign key reference to a unique key with a different case (#534)
  • Fix FOUND_ROWS() without SQL_CALC_FOUND_ROWS (#533)
  • Fix unique keys and foreign key restore without stringified fetches (#532)
  • Fix CREATE TEMPORARY TABLE IF NOT EXISTS and DROP TEMPORARY TABLE as the first temporary table (#524)
  • Fix a warning for a foreign key referencing a table with a shorter unique key (#523)
  • Fix temporary table lookup without stringified fetches and with a different case (#522)

3.1.0

SQLite Database Integration 3.1 is here! 🎉

This release improves database storage and configuration and fixes several MySQL compatibility issues.

Was ist neu

Version 3.1 improves how WordPress sites store, locate, and protect their SQLite databases. It also fixes SQL behavior and export compatibility:

  • Randomized database paths: The default database location is now a randomized directory under wp-content/database/, recorded in wp-content/database/db-path.php. (#502)
  • DB_PATH: Configure the database with one full-path constant, also available at runtime for integrations. (#512)
  • SQL compatibility: Fix IF() condition evaluation and make TRADITIONAL enable its component SQL modes. (#518, #509)
  • WordPress table collations: Default to utf8mb4_unicode_520_ci for new tables created with WordPress’s charset settings, improving exports to MariaDB. Existing tables keep their recorded collation. (#514)
  • Documentation: A new plugin README and expanded FAQ explain database storage and secure configuration. (#520)

For more information about database paths and secure configuration, read the database storage guide.

Upgrading to 3.1

Upgrading an existing SQLite site is straightforward:

  1. Back up your SQLite database.
  2. Update the plugin to version 3.1.

Existing .ht.sqlite and .ht.sqlite.php databases move to the randomized layout automatically unless a database file path is explicitly configured.

To properly secure the database, set DB_PATH in wp-config.php to an absolute file path outside the web root that your web server does not expose. Its directory must be writable by PHP. Changing DB_PATH does not move an existing database.

Breaking changes

Review these changes if you use custom database settings or integrations:

  • Database paths: Default database files now move to randomized paths under wp-content/database/. Explicitly configured file paths stay unchanged. Integrations, including backup and migration tools, must read DB_PATH after WordPress loads instead of assuming a fixed filename.
  • Legacy constants: DB_DIR and DB_FILE are now deprecated. They and the previously deprecated FQDB and FQDBDIR remain supported, but DB_PATH takes precedence. Conflicting values trigger warnings.
  • Absolute paths: Relative database file and directory paths are now rejected. :memory: remains available for in-memory databases.

Thank you

Thank you to everyone who contributed, tested, and helped update integrations.

Changes since 3.0.2: v3.0.2...v3.1.0

3.0.2

  • Fix schema reconstruction with native numeric results (#506)
  • Fix lexer edge cases and string handling (#505)
  • Preserve index prefix lengths and order in SHOW CREATE TABLE primary keys (#500)
  • Align savepoint handling with MySQL semantics (#496)

3.0.1

  • Mark the plugin as compatible with WordPress 7.1 (#497)
  • Fix fresh multisite database setup (#492)

Vollständiges Änderungsprotokoll auf WordPress.org →

Für Entwickler

Ist das dein Plugin? Zeigen Sie die Zahlen.

Fügen Sie Ihrer Website, Docs oder GitHub Readme ein Live-Badge hinzu. Es wird von selbst aktualisiert - kein Konto erforderlich.

Aktiv installiert Badge Bewertungsabzeichen Gesundheits-Score-Abzeichen

Best SQLite Database Integration alternatives

Alle Datenbank-Plugins →
Alternativen
Rang Plugin Aktive Installationen Wertung Aktualisierten Gesundheit
1 Suche Regex Suche Regex Search Regex fügt eine leistungsstarke Reihe von Such- und Ersetzungsfunktionen zu WordPress Posts, Seiten… Von John Godley 100K+ ★★★★★★★★★★ 4.7 (101) Vor 2 Monaten 84
2 WP-Sweep WP-Sweep Mit WP-Sweep können Sie nicht verwendete, verwaiste und doppelte Daten in Ihrem WordPress bereinigen. es ... Von Lester Chan 100K+ ★★★★★★★★★★ 4.7 (138) Vor 3 Monaten 91
3 Advanced Database Cleaner – Optimize & Clean Database to Speed Up Site Performance Erweiterter Datenbankreiniger Reinigen Sie die Datenbank durch Löschen verwaister Daten wie "Revisionen", "Abgelaufene Transienten"… von Younes JFR. 100K+ ★★★★★★★★★★ 4.9 (2K) Vor 3 Monaten 86
4 URLs für Live-Update URLs für Live-Update Ändern Sie die Domain auf Ihrer Website mit einem Klick. von Mat Lipe 90K+ ★★★★★★★★★★ 4.5 (59) Vor 3 Wochen 90
5 BackupWordPress BackupWordPress Einfache automatisierte Backups Ihrer WordPress-basierten Website. von Tom Willmot 80K+ ★★★★★★★★★★ 4.7 (1.4K) Vor 2 Wochen 80
6 Datenbanksicherung für WordPress Datenbanksicherung für WordPress Datenbanksicherung für WordPress ist Ihre One-Stop-Datenbanksicherungslösung für WordPress. von WP-Motor 60K+ ★★★★★★★★★★ 4.5 (66) vor 7 Monaten 61
7 Vsourz-Formulareinträge für Kontaktformular 7 Vsourz-Formulareinträge für Kontaktformular 7 Speichern Sie das Kontaktformular 7 in der Datenbank und verwalten Sie Einträge vom WordPress-Admin. Von Vsourz Digital 60K+ ★★★★★★★★★★ 4.5 (44) Vor 2 Wochen 78
8 Optimieren Sie die Datenbank nach dem Löschen von Revisionen Optimieren Sie die Datenbank nach dem Löschen von Revisionen Ein-Klick-Datenbankoptimierung mit präziser Revisionsbereinigung und flexibler Planung… von NerdPress 50K+ ★★★★★★★★★★ 4.7 (181) Vor 6 Monaten 69
9 WP-DBManager WP-DBManager Verwaltet Ihre WordPress-Datenbank. Von Lester Chan 50K+ ★★★★★★★★★★ 4.4 (95) Vor 3 Monaten 77
10 Wp phpMyAdmin Wp phpMyAdmin [✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 𝒫𝓊𝓋𝑜𝓍 ] phpMyAdmin - Datenbank-Browser & Manager (für MySQL & MariaDB) von Puvox Software 40K+ ★★★★★★★★★★ 4.6 (58) Vor 4 Wochen 89

Fragen und Antworten

SQLite Database Integration: quick answers

Gerade Antworten, gezogen von Live WordPress.org Daten.

Quelle: WordPress.org

Is SQLite Database Integration free?

Yes. SQLite Database Integration is free to download and use from the official WordPress.org plugin directory.

Is SQLite Database Integration safe to use in 2026?

Yes — SQLite Database Integration is a safe, well-maintained plugin to use in 2026. It runs on 5K+ sites, is rated 4.6/5 and was last updated 2 weeks ago, and scores 82/100 on our health check.

How many websites use SQLite Database Integration?

SQLite Database Integration is active on 5K+ WordPress websites and has been downloaded 1,141,786 times since it launched in January 2023. It was downloaded 237,620 times in the last 30 days.

Does SQLite Database Integration work with WordPress 7.1?

Yes. The developer has tested SQLite Database Integration up to WordPress 7.1.5, the latest release. It requires WordPress 6.4 or newer.

What PHP version does SQLite Database Integration need?

SQLite Database Integration requires PHP 7.2 or higher. Most hosts run PHP 8.x today, so it works on any modern WordPress hosting.

When was SQLite Database Integration last updated?

The latest version, 3.1.3, was released on November 3, 2026 (2 weeks ago).

Who makes SQLite Database Integration?

SQLite Database Integration is developed and maintained by WordPress.org.

What are the best alternatives to SQLite Database Integration?

The most popular alternatives to SQLite Database Integration are Search Regex (100K+ installs), WP-Sweep (100K+ installs) and Advanced Database Cleaner (100K+ installs).

Angetrieben von PageForge

Eine Vorlage und eine Tabelle. Eine echte Seite für jede Suche.

PageForge Verwandelt jede Zeile eines CSV in eine WordPress-Seite mit eigenem Titel, URL, SEO Felder und Schema entworfen. Kostenlos auf WordPress.org.

  • CSV und XLSX, plus Google Sheets auf Beruf und Unternehmen
  • seinen eigenen Titel, URL, SEO Felder und Schema für jede Seite
  • Arbeitet mit dem Blockeditor, Elementor, Divi und Avada
  • Kostenlos auf WordPress.org, keine Kreditkarte

↑↓ bewegen↵ öffnen