CREATE VIEW NiceList AS
 SELECT * FROM Children
  WHERE behavior > 2000
   AND parent.income > 40000; 
CREATE VIEW NaughtyList AS
 SELECT * FROM Children
  WHERE behavior <= 2000; 

Looks nice, and I like the wallpaper.

I love pop_OS’s window mangement. And I see they have released 24_04 LTS, finally!

Is this the latest pop_os?

I would love to see the implementaion.

Could it be that it aims to be the same technology? E-Ink is a brand.

I tried Huginn first but I found the documentation better for n8n, and it was easier to use.

I like to be able to tailor my notifications to me needs.

I wanted to do the same for One Punch Man but ended writing a bash script for it instead. File access and variables was the biggest hurdle (but both are solvable).

Knowing if it is going to rain in the next hour is nice because I take the bike to work. I like to know which clothes to take with me.

Caddy can manage certs out of the box for you, you don’t even need to understand how it works. Just add a url to your Caddy file, make sure the domain points to your Caddy server, have port 80 and 443 open, and you are done.

I hate when I see a cool title and then it links to a video. I want text so that I can read what I find relevant. It is like looking up recipe, a lot of the time there is a wall of text about their childhood before the actual recipie.

Here is what I use it for:

• Download top voted pictures from CivitAI
• Pull weather data and get notified if it is going to rain
• Subscribe to events posted by the police (polling their API)
• Scrub lunch restaurants for todays menu
• Get notified when a streamer I follow on twitch starts streaming
• The same for YouTube but I haven’t finished this one yet.
• Webhook (combined when a one file web page) to note down every time my oldest kid has this strange coughing.
• Send me this week’s number (because some people use it and knowing that today is week 50 can be useful a few times a year).

I use ntfy for my notifications. I was also planning to monitor if I sold anything in Guild Wars 2 but I haven’t bothered setting up a table in a database to keep track of if I have seen the latest changes, otherwise I would get the same notification over and over.

I had a Raspberry Pi once and wanted to move file from the current folder to some other folder. I typed mv /* /path/to/folder/ and move everything in the root directory and down to this other folder.

EDIT: Meant to say that snapshots are cheap backups. I ended up reinstalled the OS.

Correct would have been dot slash: mv ./* /path/to/folder/

Which software do you use for backups?

Install Virtualbox (or some software to handle virtual machines).
Install Debian (or some other OS of your choice, I won’t judge if you prefer Windows).
Update your OS (apt update && apt upgrade -y on Debian).
Take a snapshot of your VM’s current state after updating. Saves a lot of time if you mess up or want a clean slate.

Now you decide on what you want. Do you want to install n8n or Node-RED for automation? Do you want to use Immich for pictures? Paperless to save papers in a digital format? Audiobookshelf to listen on your books or podcasts? Jellyfin to stream your media? Set up a Minecraft or Factorio server?

Once you have decided on what you want to do, try to do it in your virtual machine.
Once you understand how to set it up and configure it to your liking, decide on how you want to host it. I took an office computer, added a few HDDs and replaced the case with a bigger one and it’s now my home server, but any old laptop will do. Just make sure to take backups.

I used to have a Dell R710 and a virtual machine for each service I hosted, but I have moved to docker because it as simple as taking the often provided compose file, tweaking it a bit (where to store data etc) and running it with docker compose up -d.

Which language can nil an int?

Same here. I remember playing minecraft and wanted to install some mod on my server. There were instructions and I followed them. Problems? Search the web.

I also tried to run TeamSpeak on an RPI at some point, and that was when I learned about ARM.

You are welcome.

I used to support a few companies hosting their own email servers (I supported the mail server software). I will never host my own email, not unless I have a gateway between me and world, someone to configure the DNS and all that.

1. Figure out what you want to host.
2. Read up on what is required to host that.
3. Understand what is required to host that.
4. Skip step 3, wing it and search the internet as you go.

I second Debian because of the amount of information out there.