Oof, I never let the application alter the tables. Makes running some applications a giant pain, but DDL should be an administrative thing, not a runtime thing.
That's pretty neat. The ? (help) link and the speed up button overlap on my browser (firefox on android, url bar on the bottom). My email is in my profile, I can send a screenshot if you need it.
Doesn't postgres (rightly) have a cow if a process has a disorderly shutdown (at least while in a write transaction) because there's shared memory between the processes?
See if you can find a copy of 'How to keep your Volkswagen Alive' by John Muir and have a read through.
Find an older VW (or similar) and that's the basics and a bit more. Definitely replace the fuel lines on an old VW, but otherwise drive it and let it tell you what needs doing. IMHO, fuel injection is nicer than carburetion, but you some early injection systems have a bad reputation; Bosch L-jetronic seems pretty reasonable. Some people really like carbs though, so up to you.
Lots and lots of forums, some of them helpful even.
When it's an extra car that you have for fun, you don't have as much of the 'needs to work asap' stress and you can also get one that's more questionable cosmetically to save some money.
> it clearly doesn't have a CA number plate, but there was a big red "3" on a laminated card in the spare.. what is that?
That's a temporary operating permit, colloquially called a moving permit. I've not built a car, so I dunno what happens there... but I've gotten moving permits for cars that have expired registration and need an emissions test to get registered. Can't have wheels on the public road unless it's registered or you have a movimg permit.
Afaik, all of our states have a process to get a VIN for a car without one... although it's common to take a VIN from a similar donor vehicle because it's less effort and vehicle safety and emissions requirements are de facto tied to the model year on the title. Legally, they're tied to the year of manufacture --- emissions ties to the year of the engine, not sure about safety.
You see all sorts of shenanigans if you look though. VW ended sales of Beetles in the US by the early 80s but still manufactured and sold them in Mexico through the 90s... it was not uncommon to send your US titled beetle to Mexico for "repair" and get back something very different. Sometimes just an engine transplant, sometimes only some key component from the US vehicle like the frame or the floor pan would remain, sometimes just the VIN plate. Putting a newer engine legally triggers newer emissions standards, but if you don't tell anybody and nobody notices, you can get away with it for a long time.
Several years ago, I bought a new in box 1981 road bike. Story from the seller was an old chicago bike shop went out of business and there were some old bikes and parts in the back. The frame is big, I'm 6 foot and I barely fit. Probably they sold the bikes with regular size frames and put this in the back, and then styles changed and they forgot about it. The brake pads wore out super quick, but everything else worked fine. I went through the tubes too, but that happens. No big collectors, so the price was reasonable as a bike to use... more than a similar used bike, but much less than a similarly nice new bike.
My understanding (which could easily be wrong), is the big difference today is CXL which adds cache coherency on top of pci-e.
Without cache coherency, you have to be more careful about how you use the memory and the performance story is complex. Ram over CXL is going to have worse perf than ram on the cpu memory controller, but there shouldn't be any big gotchas.
I wonder if the board game materials have rules or guidance about where equipment goes? I dunno how close the computer games stick to the board game materials though.
> You never really could. Participating in public email exchange requires that the sender can resolve then "fully qualified" domain in your return address.
I thought you could send from <> for things that shouldn't bounce.
> Isn’t that already what DMARC does though? For DMARC to pass you need DKIM _or_ SPF alignment, not both.
GP wants require DKIM, so SPF alone is insufficient to send mail from their domains.
If everyone did dmarc, you could set SPF to -all. But there are servers that check SPF but not DMARC. You need to pass SPF for those, so you need a passable SPF... but then DMARC will pass with only SPF.
> the precedent set quite a while ago has stood so strongly.
I wasn't really around for it, but I appreciate the early penny pinchers that developed fake parity ram. The IBM PC required a parity bit per byte?, but you could add an xor chip to calculate it at read and save out on the expensive ram chip.
I wouldn't mind paying a little more for ECC, what with the extra chip and a little more circuitry, but desktop ECC often starts at 50% more, which I'm way too cheap to pay for.
I could see it being anticompetitive if it benefited Microsoft products.
Ex: if Microsoft buys out office competitors or webmail competitors to shut them down, because those customers are going to be likely to buy more Microsoft stuff.
Buying games studios could be anticompetitive if Microsoft were going to keep them alive and make their output platform exclusive (but iirc they made a commitment not to do that). It could be anticompetitive if they were going to kill them and funnel consumers into their games with continuing development... It could also be anticompetitive if Microsoft were going to give these studios some uberengine secret access to Xbox/Windows that allowed them to make the best games that outside studios couldn't come close to...
But what's happened is Microsoft is killing the studios; all at once is a surprise, but death within like 3-7 years could be predicted. Most of those people will pop up again at other studios or start new studios. Some of them will realized gamedev sucks and do something else. This is the lifecycle of studios purchased by corporate overlords. When key people make enough from the purchase to allow significant but not complete creative freedom, they often make some really good games at their next venture. Too little freedom -> pump out sequels or gacha games; too much freedom -> interesting games that don't end up being much fun.
I run my cheap hosting box with a cleartext boot setup that uses ssh to automatically grab the key for the real root from my home server (or an alternate at my MILs house). Using FreeBSD, but similar concepts.
A previous hoster once gave me someone else's drives without wiping them. I don't want random customers snooping around on my data if a similar mistake happens with my disks.
For home use, I run without disk encryption. If I ever need to do data recovery, it's not going to be possible with encrypted disks and one point of a centralized NAS is to have stable long term storage.
> We’ve accepted lack of ECC because Intel decided it would be a product line differentiator, and serious customers who didn’t want random crashes or to lose data would buy chips with ECC.
AMD has been allowing ECC on lots of regular hardware for a long time.
People don't tend to buy ECC for desktop use because it costs significantly more (used server ram is/was often cheap... but it often doesn't work in desktop boards), and the performance specs are poor.
My home servers are mostly retired desktops, so they get my old desktop ram and I don't want to pay premium prices for jedec speed ecc ram on my desktops, thanks.
Since DDR5 doesn't include reporting on bit errors (afaik), it likely means much fewer single bit errors, but most experienced errors will be multi-bit. Although, I dunno what proportion of bit errors is on the ram chips and what's on the bus... there's no protection from bus errors.
If there were reporting, you could replace chips with high error rates, but without reporting you'll keep running them until they fail enough to notice.
I built a browser based path MTU discovery test, http://pmtud.enslaves.us/