talkingpumpkin

Not sure I'm getting the issue here (what does "join table" mean in the scope of JSON/XML?), but... doesn't how you lay out your data in JSON/XML file have zero impact in your application's queries? You won't be querying the JSON - you'll be loading data from it into memory and query the memory.

I last used it a good while ago (like, 10yrs?), so you'll have to verify how what I am about to say applies to current versions (it probably does).

Jasper is an old-school, enterprisey tool similar to Crystal Reports that attempts to give you a WYSIWYG editor for building your reports.

All in all, I'd say that it might be good if you have a reporting department full of people that only do reports and you don't want to train as programmers. If the ones doing the reports are gonna be actual programmers, they'll be much better off generating html/latex/whatever and converting that to pdf.

With the very limited number of drives one may use at home, just get the cheapest ones (*), use RAID and assume some drive may fail.

(*) whose performances meet your needs and from reputable enough sources

You can look at the backblaze stats if you like stats, but if you have ten drives 3% failure rate is exactly the same as 1% or .5% (they all just mean "use RAID and assume some drive may fail").

Also, IDK how good a reliabiliy predictor the manufacturer would be (as in every sector, reliabiliy varies from model to model), plus you would basically go by price even if you need a quantity of drives so great that stats make sense on them (wouldn't backblaze use 100% one manufacturer otherwise?)

IIUC you can flash LineageOS on the shield (if you try, let us know how it goes)

https://awesome-selfhosted.net/tags/personal-dashboards.html :)

Good catch on my megabit vs megabyte blunder!

One of the most exciting additions to the Raspberry Pi 5 feature set is the single-lane PCI Express 2.0 interface.

~~IIUC PCIe2.0x1 means 0.5GB/s, which is slower than USB 2 (I'm talking USB 2 specs - no idea how USB actually performs in PIs). I can't wait for people to buy that NVME hat and mount WD Blacks on that :)~~ READ BELOW

One thing you can try doing before throwing away the router (which is probably the exact same one your neighbor use) is checking the channel situation in your condo with an app like WiFiAnalyzer and also try moving the router around (some spots are better than others - and hi up is usually better)

That said, ISP routers are often terrible.

In your shoes, I'd put the money in a proper case (eg. fractal node 304/804) rather than an USB enclosure (no, you don't need hot-swap for a home server): besides the performance issues of USB (which may or may not be an actual issue depending on what you plan to do with the NAS), having a single box makes everything simpler.

For components to fill up the case, you can look at second-hand computers on ebay.

As for the OS, if you are not familiar with linux you may want to look at truenas scale (which is linux).

If you never built a PC, you'll have to do a lot of research not to buy incompatible components... otherwise you could rely on a friend/shop or stick to sinology and similar.

Well... if one must believe their own logo, (see https://sata-io.org/) "SATA" shoud actually be expanded to "Serial ATA" :)

Acronyms of acronyms may not be super-common, but they do exist: eg. Cisco has a network protocol they call "PVST", which means "Per-VLAN Spanning Tree", where "VLAN" is "Virtual Local Area Network" (or "Virtual LAN"; LAN is another of those acronyms that is mostly regarded as being its own word).

In open source, there's a long tradition of recursive acronyms: eg. "Linux" means "Linux is not Unix", which you can't be expanded (in finite time) according to your rule :)

I love you bot, but... PCIe is just "PCI express", NAS nowadays means more "home server" than network-attached storage, and no one even ever knew what SATA is supposed to expand to.

There are acronyms that are shortened versions of meaningful names and then there are acronyms that are actual meaningful names for which some meaningless (and quickly forgotten) expansion happens to exist.