Its because the comments he made are inconsistent with common conventions in data engineering.

1. It is very common not to deduplicate data and instead just append rows, The current value is the most recent and all the old ones are simply historical. That way you don't risk losing data and you have an entire history.
   • whilst you could do some trickery to deduplicate the data it does create more complexity. There's an old saying with ZFS: "Friends don't let friends dedupe" And it's much the same here.
   • compression is usually good enough. It will catch duplicated data and deal with it in a fairly efficient way, not as efficient as deduplication but it's probably fine and it's definitely a lot simpler
2. Claiming the government does not use SQL
   • It's possible they have rolled their own solution or they are using MongoDB Or something but this would be unlikely and wouldn't really refute the initial claim
   • I believe many other commenters noted that it probably is MySQL anyway.

Basically what he said is incoherent inconsistent with typical practices among data engineers to anybody who has worked with larger data.

In terms of using SQL, it's basically just a more reliable and better Excel that doesn't come with a default GUI.

If you need to store data, It's almost always best throw it into a SQLite database Because it keeps it structured. It's standardised and it can be used from any programming language.

However, many people use excel because they don't have experience with programming languages.

Get chatGpt to help you write a PyQT GUI for a SQLite database and I think you would develop a high level understanding for how the pieces fit together

Edit: @zalgotext made a good point.

The community could certainly be kinder.

Dial it back a bit. Many drug dealers are just trying to earn a living and many sell high quality safe products responsibly.

Most drug dealers I know have in fact never carried a whale carcass home.

IPSC is common around the world.

Yeah but wine helps lol

He wrote a kernel that is free, widely considered as secure and paves a way for secure computer interaction among the general public. A tremendous accomplishment.

He may be abrasive and unkind but the Linux kernel has been a real positive contribution to all.

The key is identifying how to use these tools and when.

Local models like Qwen are a good example of how these can be used, privately, to automate a bunch of repetitive non-determistic tasks. However, they can spot out some crap when used mindlessly.

They are great for skett hing out software ideas though, ie try a 20 prompts for 4 versions, get some ideas and then move over to implementation.

In most common law jurisdictions, the executive branch doesn't require even a victim, they merely need the elements of the criminal offence satisfied.

Not sure about the US, likely they need her to strengthen the case and won't bother without her witness testimony.

Whilst this is absolutely true, I think it's more constructive to focus on the failure in design that led to the confusion in the cockpit.

There is no doubt that children in the cockpit contributed to the incident, but that incident could have happened with some other distraction.

The failure for the aircraft to correctly notify the pilot of the change in autopilot configuration was clearly very dangerous.

I love this discussion because it's a complex issue.

I suppose I stand on the side that maybe she should have just delivered them. It's just words and individuals can throw garbage in the bin pretty easily. I sure as shit wouldn't want anybody filtering my mail.

OTOH, "got a job to do" is a weak justification for unethical behaviour.

Put me down 3:2 in favour of delivering the things I guess.

Some of these are going to be a bit of a challenge, but let's put down some keywords you can look into.

1. Airsonic or jellyfin in a docker container

   • I also recommend a container with lidarr etc. and a qbitorrent locked into a VPN
   • smart playlists may take some playing around with, however playlists are just a text file, so in a pinch a python script will do basic things.

2. This one's easy, I use rsync / unison with termux, there's also syncthing.

   • No clue with Apple. Jellyfin and airsonic stream well to it though

3. Nope, if this is a deal breaker, stop now. If your flexible however:

   • Excel: python, Jupyter, R and libre Office
     • Rmarkdown will produce reports
   • OneNote: Joplin, Obsidian, Dokuwiki, tiddlywiki etc (see r/pkms on Reddit)
   • Word: markdown with vim, vscode Emacs and then pandoc

4. Immich, shotwell, F-spot photoprism and I think there's another KDE tool that has AI

   • I'm very happy with immich, it does require docker, which is worth it imo.

5. Scanners do work, but I don't know how you'll connect it with Evernote.

I would like to think that these hotlines are helpful.

I have experience with somebody calling a sexual abuse hotline and being told to " Work less and go outside tomorrow".

This was a crisis situation and the advice was woefully inadequate and unhelpful.

Overall, I'm sure access to a hotline that is monitored with people who are experts at dealing with these situations is a good thing. I doubt they're funded very well though.

I agree.

It may undermine a person's self-image without indicating they think any differently about other people's sexual interests or perhaps even their own.

• The C Programming Language
• Principa Mathematica

I've always had an easier time jumping into an oop code base, then eg a lisp one.

I hear people when they say they don't want their data mixed in with their logic but The pressure to structure code Is very nice.

My favourite part of threaded platforms is the arbitrary and tangential discourse

Every OS just mentioned can be updated, no support needed? Just overlay the next kernel over the last and all these distros provide a pathway for that.

Moreover, Arch, Void, Gentoo etc are rolling, so no loss of support.

I figure a multi-million dollar company could do the equivalent of exactly that.

Yeah this hit me as well and it was very confusing until I found that lemmy.ml

I can't find it on the main branch so I didn't raise am issue

Self hosting is your pathway to a tech background.

University for comp sci, in my experience around the space, is a complete waste of time. Just a piece of paper that may or may not equip the recipient with some skills that may or may not be relevant.

It doesn't need CSAM in the dataset to generate images that would be considered CSAM.

I'm sure they take good effort to stay away from that stuff as it's bad for business.