Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

WordPress Core to start using SQLite

make.wordpress.org

Post reply on HN
Print view View original

51–60 of 71 posts

Re: WordPress Core to start using SQLite

#51

Post by lolinder »

tedivm wrote: post #23

> They suggest that if the plugin grows to a million plus installations, then it would support the desire for SQLite to be introduced in WordPress core. As of publishing this article, the plugin had 30 installations. This is a poison pill suggestion. I would absolutely switch to SQLite for my blog, but I'm not going to make that commitment using a plugin for something as important and central as the database layer. I…

What is this quote from? I can't find it in TFA.

Edit: It looks like at some point the article was changed to point to the official WordPress site, I think this was the original link:

https://blogiestools.com/wordpress-sqlite-database/

Re: WordPress Core to start using SQLite

#52

Post by gerdesj »

tedivm wrote: post #46
gerdesj wrote: post #45

Earlier quoted context omitted.

If a service provider doesn't provide a service you require, then find another provider! With a bit of effort you can run WP on say a RPi or an Odroid. Use a free dynamic DNS service to get it out there. A couple of NAT port forwards on your router. Lets Encrypt gets you a free SSL cert. A bit of research into web servers gets you an A+ score at SSL labs and a frisson of security! WP has some app firewall style addon…

I'm running Home Assistant on an odroid, and it's using an SQLite database. It's really nice not having to manage a database service, although I'll probably end up piping the data to influxdb anyways.

Crack on mate. We have a huge amount of choice these days. I too am a massive HA fan - I manage six of them - one at home, one in the office and four at customer sites.

My rule one is that any important HA related stuff needs to be local and also fail safe. So my Reolink cameras never access the internet at large. I use PoE switches and a UPS for them. My doorbell is PoE powered too and also UPS backed. It has a wired chime too, so even if HA is dead it will still ring something.

I run HA on a Thinkcentre which is a bit of a gas guzzler but as you say, an Odroid is fine too.

Re: WordPress Core to start using SQLite

#53

Post by samsolomon »

partiallypro wrote: post #30

I'm happy with any new Wordpress advancement, the only one I still struggle with is Gutenberg which still after however many years of being default leaves a lot to be desired.

Initially I felt the same way about Gutenberg, but it’s starting to grow on me. There’s a setting that understands markdown—so it’s easy to copy over posts from Obsidian when they are close to being ready. Plus the layout does just about everything I want with photos and video. I’m content with it.

Re: WordPress Core to start using SQLite

#54

Post by pixl97 »

ItsABytecode wrote: post #12
CodeCompost wrote: post #10

> And if your hosting server does not support SQLite ... I thought SQLite was file based. What's there to support?

They’re probably thinking of shared hosting environments that don’t have the SQLite library for PHP installed. That seems like a concern you could raise about any database connector, though

It would be pretty hard to find one without the mysql connector

Re: WordPress Core to start using SQLite

#55

Post by pixl97 »

gerdesj wrote: post #45
CodeCompost wrote: post #10

> And if your hosting server does not support SQLite ... I thought SQLite was file based. What's there to support?

If a service provider doesn't provide a service you require, then find another provider! With a bit of effort you can run WP on say a RPi or an Odroid. Use a free dynamic DNS service to get it out there. A couple of NAT port forwards on your router. Lets Encrypt gets you a free SSL cert. A bit of research into web servers gets you an A+ score at SSL labs and a frisson of security! WP has some app firewall style addon…

>The internet allows anyone to communicate with anyone,

Before the days cgnat and country wide firewalls

Re: WordPress Core to start using SQLite

#56

Post by h0l0cube »

clintonb wrote: post #26
h0l0cube wrote: post #9

Speaking 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

- https://roots.io/bedrock/ - https://roots.io/trellis/

Do these tools work well when people are editing content and config from the site vs developers adding features/content by version control? It's this tension that has caused me some grief when working on legacy Wordpress sites

Re: WordPress Core to start using SQLite

#57

Post by h0l0cube »

simonw wrote: post #18
h0l0cube wrote: post #9

Speaking 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

My personal blog runs on Django + PostgreSQL, and I got fed up of not having a version history of changes I made to my content there. I solved that by setting up a GitHub repo that mirrors the content from my database to flat files a few times a day and commits any changes. It's worked out really well so far. It wasn't much trouble to setup and it's now been running for nearly three years, capturing 1400+ changes. I'…

A version history sounds great, but it's not really the problem I'm talking about.

I'm adding features and content to legacy Wordpress websites where the clients are liable to change config and add and alter content themselves via the admin portal. There seems no easy way to automate deployment from local development into production without accidentally erasing someone's changes, and to keep up to date with production without losing your own work.

It seems like a tricky problem to solve, and maybe a bespoke version control system might be required (e.g., throw CRDTs at the problem?), but essentially I should be able to diff and merge between my local work and the production version while clients are making their own edits.

Re: WordPress Core to start using SQLite

#58

Post by thrownaway561 »

i remember a long time ago we used 3dcart as our ecommerce platform which used MSAccess as the database backend. I laughed my ass off at the time, but came to realize that 99% of their customer were like us... maybe did 5K a month in sales so not a huge amount of traffic so why pay for the license and cost of SQL Server. This is actually a really good move for WP as it will free up alot of resources on the server and simply deployments and migrations.

Re: WordPress Core to start using SQLite

#60

Post by tedivm »

gerdesj wrote: post #52
tedivm wrote: post #46

Earlier quoted context omitted.

I'm running Home Assistant on an odroid, and it's using an SQLite database. It's really nice not having to manage a database service, although I'll probably end up piping the data to influxdb anyways.

Crack on mate. We have a huge amount of choice these days. I too am a massive HA fan - I manage six of them - one at home, one in the office and four at customer sites. My rule one is that any important HA related stuff needs to be local and also fail safe. So my Reolink cameras never access the internet at large. I use PoE switches and a UPS for them. My doorbell is PoE powered too and also UPS backed. It has a wire…

I've got a battery pack for my odroid system, and the whole thing is completely local with the exception of pulling weather data in. My next plan is to build out a voice system around it- there are a lot of great options for this now too.
Post reply on HN