I am waiting for sqlite support to be merged

Okay, understood. May be SteamOS was the incorrect wording. I meant the Linux Kernel, Arch, Proton. I am assuming most changes are related to hardware and software compatibility which should all be open source.

Yes, thats how Open Source works or they can keep paying Windows. Asus knows their hardware much better than Valve does and has a much bigger interest in a good user experience, but currently lacks the incentive, because Windows is a „good“ paid alternative. Honestly I don’t understand all the downvotes.

Valve shouldn’t give their blessing to SteamOS on the Ally. That should be Asus‘ job. However they could give Asus a cut on every game sold through their device on SteamOS (like a few percent). That would make it much more financially interesting for Asus and they might put an official team behind it, to support SteamOS.

Has anyone tried it? I am thinking about using it on some Raspberry Pi 5.

Yes, in the sense that you are responsible to update the Docker container and often this can lead to vulnerable containers. No, in the sense that it is much easier to scan for dependencies inside a Docker container and identify vulnerabilities. Also most containers are based on Linux distribution, so those distribute the security fixes for specific libraries. All you have to is update the base image.

Dependency-free doesnt mean they dont have dependencies. Its just that they bundle them all in the executable. When there is a security vulnerability in a library on your Linux system the vendor of your distribution (Canonical, Redhat, SUSE) takes care that it is fixed. All dependent software and libraries are then fixed as well. All I say? Not the ones which have been bundled in the executable. First they need to find out that you are affected and then the maintainer has to update the dependency manually. Often they can only do this after there has been a coordinated release of the fix by the major distributors, which can leave you vulnerable no matter how fast the maintainer is. This is the way it is in Windows. (This was a short summary)

Definitely Widelands! It captures the heart of settlers 2 while also extending it in ways that were really needed to make it even more enjoyable. Also with the right controller layout it plays very ergonomically. (Use a trigger to switch to map scrolling via the touchpads)

Are you just starting out? I got started with home labbing with a Raspberry Pi 2B (1GB RAM!) and an external HDD I had lying around. I host Yarr, Navidrome, backups and a dashboard app Ive written on there and I am quite satisfied. I would really recommend starting small with hardware you already have and then buy new hardware as you go along. I am also using Tailscale. With this you can get your initial setup up and running in a day and save money if it turns out home labbing isnt for you or you dont really need the hardware.

Very interesting! Could you provide some summary of what the trends are or may be visualize the results? I am new to this kind of data

There is plant-it written in Java and HortusFox written in PHP. Both using MySQL. Is there anything available which is written in Go or Rust and uses SQLite?

It is also very resource efficient. I am running it on a Raspberry Pi 2 and it works flawlessly.

• Use sqlite instead of Postgres, MariaDB
• Avoid enterprise software (Kubernetes, Elastic Search)
• Only use projects with efficient programming languages such as Go, Rust, etc.
• Try to run things bare metal
• Lookout for projects which name themself minimal or light-weight

I use a Raspberry Pi 2 to self host a Dashboard written in Rust (Axum), a RSS reader called yarr and a music streaming server Navidrome. The latter two are written in Go and very resource efficient. The electricity bill should be under a Euro a month (6.4W max power consumption).

Thanks, and good observations. Many countries (Germany and the Netherlands for example) have statistics for every mode of transportation, which as you said is way more informative. I just quickly grabbed the first statistic I could find for the EU to be honest :D

Here is the data for Germany: https://www.umweltbundesamt.de/daten/verkehr/fahrleistungen-verkehrsaufwand-modal-split#undefined

For the Netherlands they have the data split by county which is very interesting. In the bike capital Utrecht still 50% of all passenger kilometers belong to car travel. I cant find the government website right now.

This pattern is true and passenger kilometers represent it just fine. There is no need to use the how often you use the train metric. Note that my two examples were there to explain the metric, not actual factual examples.

As an actual example: I take my bike to work and dont own a car, so my modal split is mostly trains because of longer distance trips, but I use the bike far more often. Frequencies only make sense if each occurrence is very similar (in quantity). For example: How often does one eat meat? Each meal roughly contains the same amount of meat (may be factor two or three difference). Here frequencies make more sense as more detailed statistics dont actually give more insights.

Thanks for your comment. Not wrong in the sense that the data is wrong or faked, but that the metric is not useful. Especially when better metrics are readily available for that region. Can you name me one prediction or result which you can infer from the frequency of train travel other than „fun facts“? (I am actually really curious :) ). With the modal split you can for example calculate CO2 emissions or estimate needed capacity increases if you want to replace one mode with another and much more.

This is the wrong statistic! It doesnt matter how often you take the train, but how far you go. There is something called a passenger kilometer. Someone traveling one kilometer by train makes one passenger kilometer, 6 people on a train going 10 kilometers makes 60 passenger kilometers. The same can be done for other modes of transportation. The modal split (the right statistic) then shows how much each mode of transportation is actually used. Here you can find the statistic for each country of the EU: https://www.eea.europa.eu/data-and-maps/daviz/passenger-transport-modal-split-2#tab-chart_1

A few examples why modal split is better than frequencies:

• Environmentally CO2 is emitted per kilometer. Someone may bike a short distance everyday to work, but visits his parents who live far away every weekend by car.
• On the way to work someone could take the car and the train on the same commute.

The project controlled by only one entity can affect users in the future. Moving forward Hashicorp could do anything with the code or licensing and nobody could do anything about it. It is good that something is happening now, when there is still the chance to do it.

I‘ve recently started using Tailscale for my home setup and I really can‘t recommend it enough. In my opinion it takes a lot of the dangers regarding IT security out of self hosting. Depending on who you ask it is not true self hosting, but I couldn’t care less :)

With Tailscale you can create a VPN for your devices including your phone and even expose services to the outside world with SSL already setup (havent tried that out, yet)

They have guides/tutorials for a lot of stuff (web server, Minecraft).

Free software is not about free of charge, but about freedom. If you publish open source software under a license which allows commercial use or selling the software, you have given consent. If you don‘t like that, change the license. (Users will still be able to use the software for free if they choose to compile it themself, because the source code is available.

Redhat does exactly what you are describing: Packageing open source software into a paid Linux distribution and I would say they had an immense net positive effect on Linux doing this. I believe that this the point. Don‘t be an asshole. If you partly profit of someone else open source software, give them money, bug reports, bug fixes, recognition, etc. Be part of the community.