Title: SQLite Database Integration
Author: WordPress.org
Published: <strong>17 januari 2023</strong>
Last modified: 10 april 2026

---

Sök tillägg

![](https://s.w.org/plugins/geopattern-icon/sqlite-database-integration.svg)

# SQLite Database Integration

 Av [WordPress.org](https://profiles.wordpress.org/wordpressdotorg/)

[Ladda ner](https://downloads.wordpress.org/plugin/sqlite-database-integration.2.2.23.zip)

 * [Detaljer](https://sv.wordpress.org/plugins/sqlite-database-integration/#description)
 * [Recensioner](https://sv.wordpress.org/plugins/sqlite-database-integration/#reviews)
 * [Utveckling](https://sv.wordpress.org/plugins/sqlite-database-integration/#developers)

 [Support](https://wordpress.org/support/plugin/sqlite-database-integration/)

## Beskrivning

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.

This feature plugin includes code from the PHPMyAdmin project (specifically parts
of the PHPMyAdmin/sql-parser library), licensed under the GPL v2 or later. More 
info on the PHPMyAdmin/sql-parser library can be found on [GitHub](https://github.com/phpmyadmin/sql-parser).

## Vanliga frågor

### Vad är syftet med detta tillägg?

The primary purpose of the SQLite plugin is to allow testing the use of an SQLite
database, with the goal to eventually land in WordPress core.

You can read the original proposal on the [Make blog](https://make.wordpress.org/core/2022/09/12/lets-make-wordpress-officially-support-sqlite/),
as well as the [call for testing](https://make.wordpress.org/core/2022/12/20/help-us-test-the-sqlite-implementation/)
for more context and useful information.

### Går det att använda detta tillägg på min webbplats som är i produktion?

Per the primary purpose of the plugin (see above), it can mostly be considered a
beta testing plugin. To a degree, it should be okay to use it in production. However,
as with every plugin, you are doing so at your own risk.

### Var kan jag skicka in min återkoppling om tillägget?

Feedback is encouraged and much appreciated, especially since this plugin is a future
WordPress core feature. If you need help with troubleshooting or have a question,
suggestions, or requests, you can [submit them as an issue in the SQLite GitHub repository](https://github.com/wordpress/sqlite-database-integration/issues/new).

### Hur kan jag bidra till tillägget?

Contributions are always welcome! Learn more about how to get involved in the [Core Performance Team Handbook](https://make.wordpress.org/performance/handbook/get-involved/).

### Does this plugin change how WordPress queries are executed?

The plugin replaces the default MySQL-based database layer with an
 SQLite-backed
implementation. Core WordPress code continues to use the wpdb API, while queries
are internally adapted to be compatible with SQLite syntax and behavior.

## Recensioner

![](https://secure.gravatar.com/avatar/e1ea4633379bbc6b5bc9e3fa3aeb4da60ccff6557ad69d37e851647ed4735a10?
s=60&d=retro&r=g)

### 󠀁[Works great on my low-traffic site](https://wordpress.org/support/topic/works-great-on-my-low-traffic-site/)󠁿

 [openletter](https://profiles.wordpress.org/openletter/) 29 juni 2025

I have no other services requiring MySQL/MariaDB, so this option saves me some memory
and headache. Have been running for around one year and zero issues, but my site
is very simple.

![](https://secure.gravatar.com/avatar/1b0c704cb4942dbae9b171341ee95b3e2cb7cd2d6dc0bcdaa4dcee89f3fc0a8d?
s=60&d=retro&r=g)

### 󠀁[Util para crear sitios de desarrollo](https://wordpress.org/support/topic/util-para-crear-sitios-de-desarrollo/)󠁿

 [Alberto Prado](https://profiles.wordpress.org/alprado/) 29 juni 2025

SQlite debería de ser la opción por defecto para WordPress. Es mucho más simple 
de administrar que mySQL y puede funcionar igual de bien. Este plugin es indispensable
para crear un WordPress de desarrollo que solamente necesita PHP para iniciar el
servidor sin instalar XAMPP ni otro software.

![](https://secure.gravatar.com/avatar/ded41d1ff4a5d949ab95362f662e228df0c04f364ef3603dc304efc1c3372904?
s=60&d=retro&r=g)

### 󠀁[Great, seems only one step away …](https://wordpress.org/support/topic/great-seems-only-one-step-away/)󠁿

 [Gareth Bult](https://profiles.wordpress.org/madpenguin/) 3 december 2024

Ok, so in terms of doing what it says in the tin, for me it looks great. I’ve set
up 20 – 30 instances, it runs my core plugins and has a footprint of ~ 105M when
running with a default setup. Seems to be at least as fast as the MySQL instances
sat next to them. Here’s the problem tho’. It would seem I can’t actually convert
any existing sites over to run on these instances without a lot of manual work. (
I say this after reading the experiences of some others who claim to have tried).
Are there any relatively automatic tools and/or documentation that I might have 
missed when it comes to migrating a MySQL instance over to SqLite (and back, in 
the event of a problem), or at least a Roadmap of if / when such tools or plugins
might become available? A roadmap or estimation might at least (if it’s a long way
away) prompt someone to get on and do it?

![](https://secure.gravatar.com/avatar/9a38e5d4b02b4735c79831ec7d8e52ad04f20b2bc2bc3fc33593a60776bb1c11?
s=60&d=retro&r=g)

### 󠀁[First start](https://wordpress.org/support/topic/first-start-2/)󠁿

 [barbaroshh](https://profiles.wordpress.org/barbaroshh/) 26 november 2024 6 svar

I added this plugin. Wordpress warned me that it would be reinstalled. But now everything
is gone.) Will it come back, hopefully?

![](https://secure.gravatar.com/avatar/c6597faba22dfca2d73c37013974a0fa24b16556f91b1e1af6c0a9ed436d507e?
s=60&d=retro&r=g)

### 󠀁[Great Plugin! Makes WP so fast!](https://wordpress.org/support/topic/great-plugin-make-wp-so-fast/)󠁿

 [John Turner](https://profiles.wordpress.org/johnnytee/) 28 september 2024 1 svar

Thank you dev team for providing this plugin !

![](https://secure.gravatar.com/avatar/22dcf41213b58505959c76ae20650595fbd28c9653c683591c3c6f14d60f1aa5?
s=60&d=retro&r=g)

### 󠀁[Excellent!](https://wordpress.org/support/topic/excellent-13553/)󠁿

 [lucasbustamante](https://profiles.wordpress.org/lucasbustamante/) 26 augusti 2024
1 svar

I used it to spin up a test site in CI, it’s just elegant and brings WP closer to
Static when we need it. There’s a place for SQLite simplicity in some WP workflows.
Loved it!

 [ Läs alla 12 betyg ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/)

## Bidragsgivare och utvecklare

”SQLite Database Integration” är programvara med öppen källkod. Följande personer
har bidragit till detta tillägg.

Bidragande personer

 *   [ WordPress.org ](https://profiles.wordpress.org/wordpressdotorg/)
 *   [ Ari Stathopoulos ](https://profiles.wordpress.org/aristath/)
 *   [ Jan Jakeš ](https://profiles.wordpress.org/janjakes/)
 *   [ Adam Zieliński ](https://profiles.wordpress.org/zieladam/)
 *   [ Bero ](https://profiles.wordpress.org/berislavgrgicak/)
 *   [ Brandon Payton ](https://profiles.wordpress.org/bpayton/)
 *   [ zaerl ](https://profiles.wordpress.org/zaerl/)

”SQLite Database Integration” har översatts till 11 språk. Tack till [översättarna](https://translate.wordpress.org/projects/wp-plugins/sqlite-database-integration/contributors)
för deras bidrag.

[Översätt ”SQLite Database Integration” till ditt språk.](https://translate.wordpress.org/projects/wp-plugins/sqlite-database-integration)

### Intresserad av programutveckling?

[Läs programkoden](https://plugins.trac.wordpress.org/browser/sqlite-database-integration/),
kika på [SVN-filförvaret](https://plugins.svn.wordpress.org/sqlite-database-integration/)
eller prenumerera på [utvecklarloggen](https://plugins.trac.wordpress.org/log/sqlite-database-integration/)
via [RSS](https://plugins.trac.wordpress.org/log/sqlite-database-integration/?limit=100&mode=stop_on_copy&format=rss).

## Ändringslogg

#### 2.2.23

 * Add Query Monitor 4.0 support ([#357](https://github.com/WordPress/sqlite-database-integration/pull/357))
 * Translate MySQL CONVERT() expressions to SQLite ([#356](https://github.com/WordPress/sqlite-database-integration/pull/356))

#### 2.2.22

 * Support INSERT without INTO keyword ([#354](https://github.com/WordPress/sqlite-database-integration/pull/354))
 * Add tests for MySQL row-level locking clauses ([#342](https://github.com/WordPress/sqlite-database-integration/pull/342))
 * Improve automated deploy setup.

#### 2.2.21

 * Monorepo setup + release automation ([#334](https://github.com/WordPress/sqlite-database-integration/pull/334))
 * Rework release workflow ([#350](https://github.com/WordPress/sqlite-database-integration/pull/350))
 * Fix incorrect PHP polyfill implementations ([#338](https://github.com/WordPress/sqlite-database-integration/pull/338))

## Meta

 *  Version **2.2.23**
 *  Senast uppdaterat **3 dagar sedan**
 *  Aktiva installationer **2 000+**
 *  WordPress-version ** 6.4 eller senare **
 *  Testat upp till **6.9.4**
 *  PHP-version ** 7.2 eller senare **
 *  Språk
 * [Catalan](https://ca.wordpress.org/plugins/sqlite-database-integration/), [Chinese (Taiwan)](https://tw.wordpress.org/plugins/sqlite-database-integration/),
   [Czech](https://cs.wordpress.org/plugins/sqlite-database-integration/), [English (US)](https://wordpress.org/plugins/sqlite-database-integration/),
   [German](https://de.wordpress.org/plugins/sqlite-database-integration/), [Persian](https://fa.wordpress.org/plugins/sqlite-database-integration/),
   [Polish](https://pl.wordpress.org/plugins/sqlite-database-integration/), [Portuguese (Brazil)](https://br.wordpress.org/plugins/sqlite-database-integration/),
   [Russian](https://ru.wordpress.org/plugins/sqlite-database-integration/), [Spanish (Chile)](https://cl.wordpress.org/plugins/sqlite-database-integration/),
   [Spanish (Spain)](https://es.wordpress.org/plugins/sqlite-database-integration/)
   och [Swedish](https://sv.wordpress.org/plugins/sqlite-database-integration/).
 *  [Översätt till ditt språk](https://translate.wordpress.org/projects/wp-plugins/sqlite-database-integration)
 * Etiketter
 * [database](https://sv.wordpress.org/plugins/tags/database/)[performance](https://sv.wordpress.org/plugins/tags/performance/)
 *  [Avancerad vy](https://sv.wordpress.org/plugins/sqlite-database-integration/advanced/)

## Betyg

 4.6 av 5 stjärnor.

 *  [  10 5-stjärniga recensioner     ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/?filter=5)
 *  [  1 4-stjärnig recension     ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/?filter=4)
 *  [  0 3-stjärniga recensioner     ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/?filter=3)
 *  [  0 2-stjärniga recensioner     ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/?filter=2)
 *  [  1 1-stjärnig recension     ](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/#new-post)

[Se alla recensioner](https://wordpress.org/support/plugin/sqlite-database-integration/reviews/)

## Bidragande personer

 *   [ WordPress.org ](https://profiles.wordpress.org/wordpressdotorg/)
 *   [ Ari Stathopoulos ](https://profiles.wordpress.org/aristath/)
 *   [ Jan Jakeš ](https://profiles.wordpress.org/janjakes/)
 *   [ Adam Zieliński ](https://profiles.wordpress.org/zieladam/)
 *   [ Bero ](https://profiles.wordpress.org/berislavgrgicak/)
 *   [ Brandon Payton ](https://profiles.wordpress.org/bpayton/)
 *   [ zaerl ](https://profiles.wordpress.org/zaerl/)

## Support

Har du något att säga? Behöver du hjälp?

 [Visa supportforum](https://wordpress.org/support/plugin/sqlite-database-integration/)