Hacker News Reader

Comment by CodeCompost | Hacker News Reader

> 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

I think you can choose to enable or disable the SQLite driver when compiling php.

Not sure why any host would disable it, but I could see it happening.

A host might disable it if they also offer mysql/postgres services

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 addons and the web server eg apache or nginx have some useful addons and modules.

Self hosting isn't for everyone, obviously. You are not restricted in any geopolitical sense when choosing a provider. If say, you are living in the US, you can rent a VPS in say Germany and crack on.

You can also get quite a lot of Cloudflare for free, for example.

Its 2023 and the options for publishing on the internets are absolutely astonishing. I used to use telnet to get to a rather plain text thingie at CERN back in the day (1994ish). Obviously the estate has changed somewhat since the and we have to deal with some really nasty issues that the early web didn't have.

I argue that self publishing is the only way to go but please either get yourself clued up on the security aspects of IT or hire it in or ensure your external platform is segregated from your non platform stuff (that might be VLANs, for example).

We all have an intrinsic ability and I think an inalienable right to be able to communicate a message. Not all messages are welcome and that is where things get tricky. I think we also have a right to not receive messages that we might find offensive. There is no agreed approach to "offensive". There are several "societal norms" and the like but those change depending on say location or even current mindset.

The internet allows anyone to communicate with anyone, via social media and other madness! That means that a Masai warrior, wandering the veldt and looking for a lion to take on, his asegai trembling in his hand so he can advance to manhood and then his phone finds a base station and he might suddenly be chatting with a child from the Netherlands (they both subscribe to the same Facebook Barbie fan group)! That is obviously nonsense but the world is really, very, very connected these days.

Oh sorry, SQLite? I have no idea why WP hasn't supported it for years. It is quite literally the obvious first choice. How many bloggers do you know that are also closet DBA's?

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.

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.

>The internet allows anyone to communicate with anyone,

Before the days cgnat and country wide firewalls

Is shared hosting at all relevant these days? A VPS costs only a few dollars and gives you complete freedom.

Maybe something like Heroku?

Reply on news.ycombinator.com