I've been playing around with converting a website's database from MariaDB to SQLite. SQLite is consistently 100 - 200ms faster when performing search queries on a table with ~100,000 rows using DataTables and PHP. There doesn't appear to be any noticeable speed difference querying individual rows. Also, I'm not sure if I'm being a bit heavy handed with it, but I've managed to corrupt the SQLite db numerous times, which is concerning.

datatables mariadb php sqlite

Roughly 2 weeks ago, I changed my GNOME desktop to use Dark Style so that I could test some prefers-color-scheme CSS styles. I've not changed it back since.

gnome linux

Converting a website's back-end to use SQLite, it's currently using MariaDB. I'm interested to see if there will be any performance improvements. The largest table has ~250k rows, so it's not big data, but it's also not insignificant.

mariadb sqlite

Just upgraded to Nextcloud Hub 9 (30.0.1) from 29.0.8. The upgrade was super quick and everything seems to working just fine.

nextcloud

Giving Vivaldi a try on iOS. The built in ad blocker is nice. Settings synced from desktop, including custom search engines, which is also nice. I can’t seem to set a custom new tab page, but the customisable start page is ok.

ios vivaldi

Maybe I'm doing it wrong, but it is far easier to set a custom new tab page and create a custom search engine in Firefox on iOS than it is in Firefox on my Linux desktop. This does not seem right.

fedora firefox ios linux

I’ve had a really great experience at OggCamp this weekend. Lots of fantastic talks and people. It’s been good to catch-up with some old friends, and make some new ones. Big thanks to the sponsors, organisers and crew.

oggcamp oggcamp2024

OggCamp lightening talks covered ADHD, HTML text adventures, public speaking, parenting and building B2B SAS products, a Library in a container (Manchester Library of Things), and infosec karaoke 🤣

Lightening talk karaoke.

oggcamp

Philip Newborough and a donkey enjoying a beer.

About

My name is and I’m a full stack web developer living and working in Lincoln, England. This website (philipnewborough.co.uk) serves as my personal homepage. When I’m not working with tech, I love to ride bicycles with my wife and friends.

An IndieWeb Webring 🕸💍