WordPress Core to start using SQLite
make.wordpress.org
WordPress Core to start using SQLite
1–10 of 71 posts
Re: WordPress Core to start using SQLite
#2Start supporting it natively without a plugin... but most users will still use WordPress with MySQL.
Re: WordPress Core to start using SQLite
#3wget /wp-content/database
Laughing deeply in my whole heart.
Also, can't wait to use it (drastically simplify hosting for certain usecases) - hope it will land soon!
Long live Wordpres
Re: WordPress Core to start using SQLite
#4Good for them! Perhaps this is an action item that came out of their WordPress Playground: A WordPress that runs entirely in the browser as discussed here:
Re: WordPress Core to start using SQLite
#5wget /wp-content/database Laughing deeply in my whole heart. Also, can't wait to use it (drastically simplify hosting for certain usecases) - hope it will land soon! Long live Wordpres
Really should be in a parent directory that will never be visible by anyone's browser.
Re: WordPress Core to start using SQLite
#6wget /wp-content/database Laughing deeply in my whole heart. Also, can't wait to use it (drastically simplify hosting for certain usecases) - hope it will land soon! Long live Wordpres
Before they added SQLite as WP plugin, I would use https://github.com/aaemnnosttv/wp-sqlite-db/ and I would use `define('DB_DIR', '/absolute/custom/path/to/directory/for/sqlite/database/file/');` to define the database location of my choice; I believe they would let users do the same with core support.
Re: WordPress Core to start using SQLite
#7This is great. Apps and frameworks should work with the lowest-common denominator of SQL. I get physically ill when I walk into yet another Rails shop to find that they have used every cool feature of Postgres and as a result, the CI must spin up a huge postgres instance and multiple plugins just to run a single unit test. Ugh.
Re: WordPress Core to start using SQLite
#8Waiting for obligatory comment of "WP sucks. Who still uses PHP in 2023"..
On a serious note, this is very interesting. SQLite is just awesome and this will be a welcome addition to the core.
Re: WordPress Core to start using SQLite
#9Speaking about WordPress, what does anyone do about diffable version control and automated deployment? From my naive perspective, it seems like an opaque database is just a bad idea
Re: WordPress Core to start using SQLite
#10> And if your hosting server does not support SQLite ...
I thought SQLite was file based. What's there to support?