Add SQLite and PostgreSQL support

[discobot]

---

Read-only archive: Issues · ClassicPress/ClassicPress · GitHub

Author: stefanos82

Vote count: 16

Status: open

Tags:

• request-add-feature

---

Comments

I want to have SQLite as my default database for 2 second initial setup. I have people that want the simplest website possible and most of the times I use a static website generator to do my job.

Why not use SQLite instead and if the website gains traffic, to be able to switch to a different database?

~ posted by stefanos82

Plugin compatibility is going to be a huge issue here. There are probably also a lot of queries within core itself that would not work in other DBs.

~ posted by James Nylen

Yes, I think that is not easy at all.
As written there Using Alternative Databases « WordPress Codex there is a plugin for postregresql PostgreSQL for WordPress (PG4WP) – WordPress plugin | WordPress.org but is very old with no updates.
Add support can be very dramatic for backwards but if we find someone that analysis how works we can see in case.

~ posted by Daniele Scasciafratte

SQlite doesn’t play nice with concurrent PHP write access. However, I’d love to have SQLite support.

~ posted by Peter Molnar

I think the proposal ages ago was a database abstraction layer so plugins don’t know what database is actually being used.

~ posted by David Shanske

I’m using GitHub - aaemnnosttv/wp-sqlite-db: A single file drop-in for using a SQLite database with WordPress. Based on the original SQLite Integration plugin. as a drop-in replacement for a blog and works wonders. I have reported though some weird issues with WooCommerce and as soon as we fix those, I will be using it exclusively for small to nearly medium websites.

About concurrency, there’s pragma WAL support and solves that issue for you.

SQLite works just fine for the average website.

Imagine, Pieter Levels use it for remoteok.io and some other websites of his, so…yeah, it can work without a sweat if used properly.

~ posted by stefanos82

[james]

I propose to close this petition. WP and CP are fundamentally MySQL-based software. wp-sqlite-db exists to try to make it work with SQLite but it is a tremendous hack with numerous issues. I’m not aware of any other attempts to change out the database at the moment, but it’s a task that’s pretty firmly out of scope for ClassicPress core.