Good for you babes, but I wouldn’t trust you to wipe your arse if you can’t even keep data consistent
- 0 Posts
- 294 Comments
silasmariner@programming.devto
Leopards Ate My Face@lemmy.world•Punish the Democrats, she saysEnglish
42·14 days agoI misread the spine of a book when I was 10 and looking for my first username. George Eliot is fucking phenomenal though and no regregts.
silasmariner@programming.devto
Leopards Ate My Face@lemmy.world•Punish the Democrats, she saysEnglish
2217·15 days agoI tagged loads of accounts at the time, thinking they were just bots or plants, but a couple are still around and now I think maybe they’re just well-meaning morons who couldn’t quite figure out the implications…
Jesus fucking Christ man, not everyone’s use cases are your use cases. Get some real world experience. If you don’t know the kinda shit you have to actually do, it’s easy, but sometimes the show’s just gotta go on
deleted by creator
Lol what an absurd take. A transaction is a sequence of operations, not a single one, so even small tables can meet that threshold with enough query logic. I guess you’re unfamiliar with medium to large datasets, but it’s not uncommon to use the aggregate functions that SQL provides in real world situations, and on large tables that can easily reasonably exceed 1s. Toy my arse. Go play with yourself
Although this is no surprise tbh because apparently you don’t understand why transactions are even necessary. Benchmarks shmenchmarks. Whether it works is more important.
I do not apologise for the downvote because this is smug shit only a junior would say
But adding it to an 80ms operation is. If your operation is 0.5ms it’s either a read on a small table, or maybe a single write – transaction isolation wouldn’t even be relevant there. You’re right that I did mean consistency rather that integrity though, slip of the terminology, but not really worth quibbling over. The point I meant was that I like my data to make sense, a funny quirk of mine.
Well it depends how much data integrity is worth to you, and how your system works. Every write in postgres is already a transaction - when you can get away with simple crud stuff, often there’s nothing to do, you have transactionality already. Transaction isolation levels are where db operation costs might change under concurrent conflicting writes but you can tune that by ensuring single-writer-per-partition or whatever in your server logic and it might add a ms or two. OTOH if you have heavy contestation it can be much more expensive. The performance implications are complicated but can certainly kept to a fraction of overall cost depending on your workload!
Restarts in a server between dB updates that in a sane world would be txns I meant (e.g update A, crash so don’t update B). Anyway, in postgres they’re pretty cheap in the absence of actual conflict – more expensive if you have actual cinflicts, obvs.
Actually transactions can be a secomd-layer safety-net for single-responsibility writers to ensure rollback on eg restarts and consistency on loadbalancer redecisions without having much of an impact on performance, and data integrity is usually quite important.
silasmariner@programming.devto
Programmer Humor@programming.dev•might be a form of Jevons Paradox
1·1 month agoHave you tried disabling all local Trojans and seeing if that helps?
Is that Jen? It looks a lot like her but I suck at facial recognition
silasmariner@programming.devto
Science Memes@mander.xyz•Atmospheric Slapping TournamentEnglish
3·2 months agoI’d disagree with that argument and draw an analogy with the short reactive pathways triggered by e.g. that thing where you tap a knee with a hammer and it jerks; I don’t think the reaction loop there counts as a sense, and only when you add in the CNS and perception of it does it even connect to one. But it’s hardly a cut’n’dried argument and I’m sure there’s a lot left to plausibly disagree on here
silasmariner@programming.devto
Science Memes@mander.xyz•Atmospheric Slapping TournamentEnglish
3·2 months agoWhat’s a tree’s brain in this analogy?
silasmariner@programming.devto
Ask Lemmy@lemmy.world•What is your favorite quote, proverb, or piece of wisdom?
4·2 months agoWe must imagine Sisyphus as happy
I won’t break it down, plenty of people have done that already. It’s one of those sorta zen points that’s both almost trivial and very difficult to understand
silasmariner@programming.devto
Science Memes@mander.xyz•Lemmings, please give us your info dump.English
32·2 months agodeleted by creator
silasmariner@programming.devto
Ask Lemmy@lemmy.world•What's a piece of Media that is so underrated you must mention it?
6·2 months agoIf I had a mouse for every time I’d seen Pushing Daisies mentioned on Lemmy, I’d probably have like hundreds of mice, because I’ve seen it mentioned twice and those things breed. It was absolutely excellent though and I was so gutted it never got another series. Maybe it was hit by a writers strike? Can’t remember how long ago it came out now.
silasmariner@programming.devto
Technology@lemmy.world•New nickel-iron battery charges in seconds, survives 12,000 cyclesEnglish
2·2 months agoOk fair, sorry for being snappy, I think fusion is cool and probably pretty close these days and get a bit defensive when I feel I’m misrepresented.
silasmariner@programming.devto
Technology@lemmy.world•New nickel-iron battery charges in seconds, survives 12,000 cyclesEnglish
3·2 months agoWow, that’s not my attitude at all, I said ‘not there yet’, I’m sorry you can’t read bro
It’s weird though. One of the accounts I tagged has just become more and more reasonable and I feel like. Idk. They certainly weren’t all bad or deceptive people – and being mean to and about them won’t really help them figure it out … OTOH fuck ppl who do stupid shit because they’re too proud to accept inherent complicity in the evils of the lesser.