Hopefully, in time, people will learn that articles about LLM-generated stuff are as interesting as articles about what autocomplete suggestions vscode gives for specific half-written lines of code

Leverage whatsapp and hang good old posters around the neighborhood?

https://github.com/TecharoHQ/anubis

…and that’s why you need 16GB and a decent CPU to navigate the web

https://selfh.st/apps/?alternative=IFTTT

Did you ask an AI to do the list for you? (no need to answer)

Intriguing.

What’s the mechanism for dealing with spammers?

In lemmy there’s a clear escalation path that will lead to either the spammer’s instance dealing with the issue or the instance itself being de-federated.

How would that work in a p2p system?

Each user having to individually block every spammer will work as well as it did for email back in the day.

It’s optimized for making money

Look at restic and/or borg first. Iff you have specific needs that they don’t address, then look at other things (including reviewing your requirements: chances are you are doing something wrong in that case).

It straight made up a powershell module, and method call. Completely made up, non existent.

It was just imagining the best way to accomplish the task: instead of complaining, you should have just asked it to give you the source code of that new module.

Your lack of faith in AI is hindering your coding ability.

(do I need to add the /s? no, right?)

the translations on the database are for entities on the db

Oh, then you could consider having one extra table per entity (one-to-many) with the translatable stuff:

create table some_entity (
    id .. primary key,
    -- fields for attributes that are not translated
    price ..,
    created_on ..,
    deleted_on ..,
    ..
);
create table some_entity_i18n(
    id .. primary key,
    some_entity_id .. foreign key references some_entity(id),
    locale ..,
    -- one field per translatable attribute
    title ..,
    description ..,
    ..
);

IMHO putting everything in one big table will only complicate things in the long run.

INSERT INTO TextContent (OriginalText, OriginalLanguage)
VALUES ("Ciao", "it");

Shouldn’t that be TextContent(TextContentId, OriginalText)? Something like

(then you should make the id a primary key, index originaltext and make the id in the other table a foreign key)

I could drop TextContent too, and just have a Translations table with TextContentId

Sure, but the you would have to reference the text via TextContentId in your code, which would be very annoying.

Instead you could have a function, say t("Ciao") that kinda runs something like (of course loading all the translations in ram at startup and referencing that would be better than running a query for each and every string).

select t.translation
  from textcontent tc
       join translations t on t.textcontentid = tc.textcontentid
 where tc.originaltext = ?
   and t.language = ?

The function could also return the originaltext and log an error message if a translation is not found.

BTW 1: most frameworks/languages have i18n facilities/libraries - you may investigate one and use it instead of rolling your own.

BTW 2: why would you put the translations in a database? what’s the advantage compared to files?

If it’s for backup, zfs and btrfs can send incremental diffs quite efficiently (but of course you’ll have to use those on both ends).

Otherwise, both NFS and SMB are certainly viable.

I tried both but TBH I ended up just using SSHFS because I don’t care about becoming and NFS/SMB admin.

NFS and SMB are easy enough to setup, but then when you try to do user-level authentication… they aren’t as easy anymore.

Since I’m already managing SSH keys all over my machines, I feel like SSHFS makes much more sense for me.

AFAIU bluehost does not support the acme protocol, so you’ll either have to manage your certificate manually or (recommended!) move to a different dns registrar.

If you are wondering which provider you should switch to, basically all the serious ones will work… IDK if this is relevant for nginx, but here’s a list of the supported ones for the client I use https://go-acme.github.io/lego/dns/

If you are unsure and want to experiment before touching your current setup, you could register a new cheap domain (less than 1$, see https://tld-list.com/), use it for your tests, and then not renew it.

https://en.wikipedia.org/wiki/Knapsack_problem ?

Not sure if others already said this (I seem to see mostly comments explaining how to do it, but didn’t read them all), but, while it’s certainly feasible, you may not want to do that.

A router is the cornerstone of your network (if it goes down, so does the network) and if you are a self-hoster you’ll probably fiddle endlessly with your home server, and of course break it from time to time… the two things just don’t go well together.

Personally, I’d recommend getting some second-hand router appliance that can run openwrt and use that (make sure to check the flashing procedure before deciding what to buy - some are easier than others). Or you could get a dedicated x86 machine… probably overkill though.

Seems fun :)

Beware that the check passport screen and the one before it may make it look like a papers please clone (which it definitely seems not to be after looking/reading further) - maybe move them further down in presentation order?

deleted by creator

deleted by creator

For those kind of issues I’d recommend snapshots instead of backups