Software engineering topics I changed my mind on

Post by tonfreed » Mon, Jan 25, 2021, 4:41 AM UTC

BeetleB wrote: post #116

joseph_grobbles wrote: post #94

Earlier quoted context omitted.

"10 minutes" Are you the only one attending or something? Standups are initially scheduled for the start of the development day. But then people come in a little late, get that first minute call, have to attend to something that hiccupped, so soon enough the standup happens 30 minutes into the day, eventually an hour into the day. So if you did get there on time, now you just spin your wheel waiting, because first yo…

In the one job where standups went well, our limit was 15 minutes, for about 7 developers. > Standups are initially scheduled for the start of the development day. There's no reason it should. We did not have it at that time. If it's at a reasonable time (e.g. after all people have normally begun work), then have a low tolerance policy for those who come late. Sometimes our standups were about 5 minutes, because some…

Post by sobani » Mon, Jan 25, 2021, 10:37 AM UTC

piggubiggu wrote: post #474

xxs wrote: post #406

Earlier quoted context omitted.

>ACID transactions, validations & constraints There is no D from the ACID. For the D to happen, it takes transaction logs + write barrier (on the non-volatile memory). Doing Atomic, consistent and isolated is trivial in memory (esp. in GC setup), and a lot faster: no locks needed. Validations and constraints are simple if-statements, I'd never think of them as sql.

It sounds like you're talking about toy databases which don't run at a lot of TPS. Let me point out some features missing from your simple load a map in memory architecture. You also have to do backup and recovery. And for that, you need to write to disk, which becomes a big bottleneck since besides backup and checkpointing there is no other reason to ever write to disk. Then, you have to know that even in mem databa…

    result_address = first_free_address;
    first_free_address += requested_bytes;
    return result_address;

Post by kfir » Mon, Jan 25, 2021, 12:54 PM UTC

kfir wrote: post #512

maccard wrote: post #472

Earlier quoted context omitted.

People keep saying there are specific cases where NoSQL is better, but never what any of those cases are.

Here you go, this is from a system I helped building 10 years ago that is an eternity in tech - https://qconlondon.com/london-2010/qconlondon.com/dl/qcon-lo...

Post by CodeGlitch » Mon, Jan 25, 2021, 2:03 PM UTC

lillecarl wrote: post #465

mabbo wrote: post #456

Earlier quoted context omitted.

> If a good developer you know, recommends someone they worked with: It's almost an instant hire. But for the rest, yeah, it's incredibly tough. A talk I watched recently by Ijeoma Oluo made a point I had never considered before: statistically, most people refer friends, and most friends are of a similar background, race, culture, gender, etc. It's not intentional- people aren't going out of their way to only refer p…

What is the upside of a higly diversified worksforce? Where I work we're all white males age 20-60 except accounting, they're white females around age 30. What's bad about this? What value does it bring to diversify, what should we look for and why is it important? Or are we too small to need diversifying yet with only about 30 employees?

Post by Shorel » Mon, Jan 25, 2021, 3:26 PM UTC

orobinson wrote: post #316

Shorel wrote: post #257

Earlier quoted context omitted.

There are only two options for me: MySQL or Postgres. And using AWS generally means using Aurora. Then the choice is already made. Not hard at all. Yep, my work involves heavy use of SQL and I find it better than the NoSQL insanity.

Just curious, for what reasons would you choose MySQL over Postgres?