@dan@upvote.au avatar

dan

@dan@upvote.au

Aussie living in the San Francisco Bay Area.
Coding since 1998.
.NET Foundation member. C# fan
d.sb
Mastodon: @dan

This profile is from a federated server and may be incomplete. Browse more on the original instance.

dan,
@dan@upvote.au avatar

Raindrop doesn’t seem to be self-hosted? This is the selfhosted community…

dan,
@dan@upvote.au avatar

Authentik is pretty good. Authelia is good too, and lighter weight.

You can combine Authelia with LLDAP to get a web UI for user management and LDAP for apps that don’t support OpenID Connect (like Home Assistant).

dan,
@dan@upvote.au avatar

Aww, nice gift!

I’m using a workstation board in my server. Asus Pro WS W680M-ACE SE along with a Core i5-13500. Intel support ECC for consumer CPUs but only when using workstation motherboards :/. The IPMI on this board works well though.

dan,
@dan@upvote.au avatar

Why does Timeshift only support btrfs? Is it just a lack of developers? LVM supports snapshots too, even if you’re just using ext4. ZFS supports snapshots too.

dan,
@dan@upvote.au avatar

Wow this article perfectly captures the early 2000s experience of trying to teach parents how to use the internet. Internet access wasn’t very widespread in Australia yet, and my parents weren’t really interested in it and thought it was too difficult to use.

dan, (edited )
@dan@upvote.au avatar

Try MySQL instead of MariaDB. They have some performance tweaks in version 10 that aren’t present in MariaDB.

Also, tune your MySQL (or MariaDB) server. Make sure all tables use InnoDB. Enable the slow query log and analyze slow queries (there may be missing indices). If there’s a lot of unique queries, increase the query cache size.

The easy approach is to run MySQLTuner after the MySQL or MariaDB server has been up for at least a week, and go through its suggestions.

There shouldn’t be a significant difference in performance between PostgreSQL and MySQL/MariaDB if both have been optimized. Out-of-the-box config isn’t ideal for a production system.

dan, (edited )
@dan@upvote.au avatar

Debian => stale packages (Really solid distro though but dated version of Gnome)

Did you try using the testing or unstable versions of Debian? Testing is still more stable than some other distros. Packages need to be in unstable with no major bug reports for 10 days before they migrate to testing.

dan,
@dan@upvote.au avatar

Yeah people like to hate on Red Hat, but Linux development would be significantly slower without them.

dan,
@dan@upvote.au avatar

Do people actually use LXD in production? All hosting services I’ve seen use LXC and not LXD for containers, as do UIs like Proxmox and Unraid, and you don’t have to use Snap for LXC.

dan, (edited )
@dan@upvote.au avatar

It’s funny because the first time I read it, I thought it was serious and was just written by a tech-illiterate parent. Saying that Comet Cursor and Bonzi Buddy are hacker software kinda gives away that it’s just satire though.

oh I guess that’s also something that younger people may not know about… In the late 1990s / early 2000s, it wasn’t uncommon for people to install spyware to get things like custom mouse cursors, emoticons, and purple gorillas that help you navigate the web.

dan,
@dan@upvote.au avatar

Across all devs that fill out the Stack Overflow survey: survey.stackoverflow.co/2023/-most-popula…

dan,
@dan@upvote.au avatar

Anywhere that COBOL can be replaced with something more modern, it’s already underw

Rewrites are extremely risky though, and some companies don’t want to risk it. That COBOL code probably has 40 years worth of bug fixes and patches for every possible edge/corner case. A rewrite essentially restarts everything from scratch.

Do you know of a decent sized company that successfully migrated away from COBOL? I’d be interested in reading a whitepaper about how they did it, if such a thing exists.

dan,
@dan@upvote.au avatar

There is a disproportionately large number of furries working as network admins though. Whenever you use the internet, there’s a good chance that your data is transiting via a network administered by furries.

dan, (edited )
@dan@upvote.au avatar

I wish people wouldn’t downvote comments like this. The downvote button isn’t an “I disagree with you” button and downvoting people just because you disagree with their opinion is silly.

dan, (edited )
@dan@upvote.au avatar

We wouldn’t have Safari (Webkit) or Chrome (Blink) today if it weren’t for Konqueror and KHTML! Webkit is a fork of KHTML, and Blink is a fork of Webkit.

dan, (edited )
@dan@upvote.au avatar

It can really slow things down if your views start calling other views in since they’re not actually tables

They can be in some cases! There’s a type of view called an “indexed” or “materialized” view where the view data is stored on disk like a regular table. It’s automatically recomputed whenever the source tables change. Doesn’t work well for tables that are very frequently updated, though.

Having said that, if you’re doing a lot of data aggregation (especially if it’s a sproc that runs daily), you’d probably want to set up a separate OLAP database so that large analytical queries don’t slow down transactional queries. With open-source technologies, this is usually using Hive and Presto or Spark combined with Apache Airflow.

Also, if you have data that’s usually aggregated by column, then a column-based database like Clickhouse is usually way faster than a regular row-based database. These store data per-column rather than per-row, so aggregating one column across millions or even billions of rows (eg average page load time for all hits ever recorded) is fast.

dan,
@dan@upvote.au avatar

It’s a pretty simple Visual Basic 6 app so I’d be surprised if it didn’t work using WINE.

dan,
@dan@upvote.au avatar

I’m pretty familiar with Linux server management, but haven’t ran Linux on the desktop in a very long time (I still remember the days of XFree86, which was the predecessor to X.org). If I install a mainstream desktop distro today (Ubuntu, Mint, whatever is popular now), does it come with X11 or Wayland out-of-the-box?

dan, (edited )
@dan@upvote.au avatar

security updates I would be getting for free on Debian.

Debian contrib doesn’t get official security updates, the same as Ubuntu universe. www.debian.org/security/faq#contrib

In both Debian and Ubuntu, only the main repo gets official security updates for free. Ubuntu has a paid option for universe whereas Debian doesn’t have that option and relies on the package maintainer to provide any updates.

I’d still recommend Debian over Ubuntu though, for various reasons.

dan, (edited )
@dan@upvote.au avatar

Trac

That’s a name I haven’t heard in a looong time. I used to use a pre-1.0 version before GitHub became popular.

dan,
@dan@upvote.au avatar

What does being federated mean in this case? Git is already distributed. Is it just for discovery, or do you mean for things like issues and discussions?

dan, (edited )
@dan@upvote.au avatar

Or, asked another way, does systemd load the Linux kernel, and if not, what does?

Immediately after the BIOS/POST, the first thing that starts is the boot loader. This is usually a piece of software called GRUB. There’s a part of GRUB in the Master Boot Record on the drive, that the loads the rest of GRUB from /boot. /boot has to be a basic partition so that the MBR code can mount it, so for example if you use something a bit fancier (like LVM) then you’ll usually have a separate small ext2 or FAT partition just for /boot.

GRUB shows a list of available kernels, and other operating systems (if any are installed), based on a config in /boot.

Once you select a kernel to boot (or wait a few seconds for it to automatically choose the default option), it starts loading the kernel. There is a small disk image called the “initial ramdisk” in /boot, usually with a name like initrd or initramfs. This is a small ramdisk that contains all the drivers needed to mount your root partition - for example, drive drivers (NVMe, SATA, etc), file system drivers (ext4, ZFS, XFS, etc), LVM, RAID drivers if needed, and so on. If the root disk is on an NFS network share (not as common any more, but still doable), it also needs to contain network drivers for your network card. It also contains a few basic utilities, usually provided by BusyBox.

Some Linux distros (such as Debian) build a custom initramfs, whereas others (like Fedora) have a generic one containing all possible drivers.

The initial ramdisk then mounts the root partition and hands control over to the Linux kernel, which starts actually booting the OS. The very first process the kernel starts running is the init process, which these days is usually systemd but can be a different one like sysvinit or runit.

Hope that helps :)

dan, (edited )
@dan@upvote.au avatar

Create a separate partition for /home so you can change distro without having to backup and restore the files in your home directory. Just be sure to NOT format that partition in the installer for your new distro. Take a backup anyways.

dan,
@dan@upvote.au avatar

Upgrading/tinkering doesn’t void your warranty. Explicitly.

This is generally true with everything in the USA (covered by the Magnuson-Moss Warranty Act) even though companies are sketchy about it and try to convince people that it’ll void their warranty. The manufacturer has to prove that your upgraded part was the direct cause of the issue you’re trying to claim under warranty.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • localhost
  • All magazines
  • Loading…
    Loading the web debug toolbar…
    Attempt #