News for hackers. Stuff that matters.
Re:WordPress testing official SQLite Support by upon_drumhead on Friday December 16, 2022 @05:23PM (#34021382)
Complexity? I have a small site that would run just fine with SQLite. I’d switch over in a heartbeat.
Re:WordPress testing official SQLite Support by pstuart on Friday December 16, 2022 @05:25PM (#34021412)
I'm curious as to how much of your site depends on WordPress, vs. just using a static site generator.
Re:WordPress testing official SQLite Support by kstrauser on Friday December 16, 2022 @06:46PM (#34022269)
I use Hugo, and I have a relatively ergonomic workflow set up where I use iA Writer to write posts on my iPad, then Working Copy to push them to a git repo. Then my server pulls that repo on a cron job, and builds and deploys it. It’s fine. It gets the job done.

But I confess that being able to post a new entry to an API and have it published instantly sure is attractive. If WordPress had a better security track record, I’d be tempted to switch to it. You don’t get much more secure than a bunch of static files served straight from disk, though.

Re:WordPress testing official SQLite Support by upon_drumhead on Friday December 16, 2022 @09:55PM (#34023914)
My mother in law is the one writing content for it. She knows Wordpress from working for other companies. In theory I could teach her something new, but why bother? She enjoys what she’s doing now. I don’t want to take away from that.
Re:WordPress testing official SQLite Support by pstuart on Saturday December 17, 2022 @08:53PM (#34034299)
That's understandable. My question wasn't meant as a challenge--I'm assuming that most sights could transition to a static site with judicious JS to lively up things.
Re:WordPress testing official SQLite Support by Dunedan on Saturday December 17, 2022 @04:45AM (#34026370)
One killer feature for me aside from usability for less-technical people are comments. While comments are not be necessary for certain types of websites, I consider them essential for anything you might call a blog.
Re:WordPress testing official SQLite Support by TrueSlacker0 on Friday December 16, 2022 @05:24PM (#34021407)
Complexity? MySQL 1 click installs on damn near every WordPress install. I fail to see how it is complex.
Re:WordPress testing official SQLite Support by LVB on Friday December 16, 2022 @05:41PM (#34021603)
Zero clicks is better. And less resource usage, which can help on really small instances with multiple applications.
Re:WordPress testing official SQLite Support by dharmab on Friday December 16, 2022 @05:26PM (#34021434)
Keeping it updated and backed up is complex. Sqlite can be embedded inside an application (easy updates) and the database backup is a single file.
Re:WordPress testing official SQLite Support by rchaud on Friday December 16, 2022 @05:43PM (#34021632)
Someone's never seen a WP white screen of death because of some esoteric MySQL error the average person will have no idea how to debug.