The Heap™ – Consultancy ©®

« first day (5151 days earlier) ← previous day next day → last day (13 days later) »

Josh Darnell

02:01

> How is it possible that running COUNT(*) in a separate query would take more than COUNT(*) OVER () which does the same?

Goodness.

5 hours later…

John K. N.

06:38

Wordle 1,332 5/6*

⬛⬛🟩⬛⬛
⬛⬛🟩⬛⬛
🟨⬛🟩⬛⬛
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

2 hours later…

Zikato

08:37

good morning

Wordle 1,332 5/6*

⬛⬛⬛⬛⬛
🟨⬛⬛⬛⬛
⬛🟩🟩🟩🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

1 hour later…

Charlieface

10:03

@JoshDarnell Where is that a quote from?

2 hours later…

Josh Darnell

11:53

@Charlieface It's from the GitHub issues you linked, a comment by Shay (although the asterisk got eaten by the markdown formatting on this side).

1 hour later…

Sean Gallardy

13:19

Bunch'a chatty Kathy's, I am going to assume the transcript starts here, thus I am all caught up without having to read the last installment of war and peace.

Paul White

It's been kinda slow really

Like Azure

Sean Gallardy

Molassas

Using that GP disk

At least the Iggles won

Paul White

Not hearing much from Kansas today

Not even chicken noises

Zikato

JEAGL please?

Paul White

@billinkc

Search the transcript for KFC

It's a long running gag

Paul White

13:42

Otherwise, it's just a Super Bowl reference

Sean Gallardy

Iggles = the way it sounds when people in Philly say Eagles, unlike the mayor of Philly who can't spell (Eagels) but I would expect no less for the mayor.

Zikato

I've completely missed it this time. Didn't get a lot of promotion

Sean Gallardy

@Zikato Local factors

Zikato

Probably

Paul White

I heard it was a bit one-sided

Josh Darnell

14:10

GitHub CoPilot is really on fire.

Paul White

😀

Zikato

@JoshDarnell Actively burning?

Charlieface

@JoshDarnell It was the Aussie version

Ute (vehicle)

A ute ( YOOT), originally an abbreviation for "utility" or "coupé utility", is a term used in Australia and New Zealand to describe vehicles with a tonneau behind the passenger compartment, that can be driven with a regular driver's licence. Traditionally, the term referred to vehicles built on passenger car chassis and with the cargo tray integrated with the passenger body (coupé utility vehicles). However, present-day usage of the term "ute" in Australia and New Zealand has expanded to include any vehicle with an open cargo area at the rear, which would be called a pickup truck in other countries...

Josh Darnell

@Zikato LOL exactly

Charlieface

@PaulWhite Sorry South Pacific version...

Josh Darnell

14:19

@Charlieface Wow

Charlieface

It's like America's pickups, just cooler

My Aussie friends tell me people get crazy souped up version of these for pretty cheap. They were selling the Holden VXR ute in the UK at one point (under the Vauxhall brand), it was half the price of anything with the same power.

Josh Darnell

I really dislike pickup trucks. It should be illegal to own / drive one unless you have a good reason to.

Good reasons are decided unilaterally by me personally.

Zikato

Only for farmers and pickup artists.

Josh Darnell

I am fair and impartial though, so no worries.

Charlieface

Americans seem to have a fetish for them especially out west. Where are you based?

Utes are cooler because they tend to be lower slung and more "car-feel" than pickups, also a lot more powerful usually.

Josh Darnell

14:29

@Charlieface East coast (Charlotte area in North Carolina).

@Charlieface Yeah, that would be a lot more manageable.

Charlieface

But I've never understood American cars: how does a 7.5l V10 engine only produce 350bhp? Where are the other 4 or 5 litres going?

Hannah Vernon

Wordle 1,332 4/6*

⬛⬛🟩⬛⬛
⬛⬛🟩⬛⬛
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

@PaulWhite ouch!

Josh Darnell

15:10

@PaulWhite Thanks for escaping my asterisks 😀

Erik Reasonable Rates Darling

15:24

brb reading the transcript to see if anyone checked in on me

Lamak

15:41

Wordle 1,332 4/6*

⬜⬜⬜⬜⬜
⬜🟩⬜🟨⬜
🟨🟩⬜⬜🟨
🟩🟩🟩🟩🟩

1 hour later…

Sean Gallardy

16:57

@JoshDarnell I'm right here

Josh Darnell

@SeanGallardy Sorry man :D

Sean Gallardy

Was that an impartial and fair sorry?:P

Josh Darnell

Obviously!

Feel free to submit your Good Reason for my review.

Sean Gallardy

I'll have BroPilot write up something noice

Did we solve all of EF's problems?

Maybe Paul can create Enterprise Faithwork and fix all the things

Sean Gallardy

18:08

Lead us not into bad T-SQL but deliver us from Entity Framework

2 hours later…

Josh Darnell

20:22

@ErikReasonableRatesDarling I left a comment on that GitHub issue. But the short answer is that nothing is really solved. Some of the defaults are better in EF Core (lazy loading is OFF by default, there is no fallback to client-side evaluation), but developers can easily change those / workaround them in equally obnoxious ways.

Erik Reasonable Rates Darling

i saw, apparently i'm subscribed to the issue or something

thanks

Josh Darnell

No problem!

Schema generation is better in some respects. In particular, foreign keys get indexed automatically by default. I thought that was a nice change they made.

And the batched inserts thing is cool too.

Erik Reasonable Rates Darling

it sounds like there might be some interest in a tool that does that sort of thing

but it doesn't sound like eej has one?

wow

WHILE @@TRANCOUNT > 0
BEGIN
    ROLLBACK TRANSACTION;
END;

that's... thoughtful

Josh Darnell

20:43

@ErikReasonableRatesDarling I guess not. For sure it would be helpful. I've never done one of those myself, but it would be fun to try.

In my COPIOUS free time.

This person has a tutorial with one rule check (about using runtime auto-migrations): alwaysdeveloping.net/p/analyzer-explained

Erik Reasonable Rates Darling

every so often i get interested enough in ef to want to learn where all these awful things come from so i can do some training around it

but it often feels a lot like i'd have to learn how to build a car just to teach someone how to drive around the block safely

Charlieface

@ErikReasonableRatesDarling where was that from, I couldn't find it in a Github search

Josh Darnell

@ErikReasonableRatesDarling For sure haha.

Charlieface

In my recent use of EF Core, which was a brownfield existing database, I basically used it as a glorified query generator. Every query had to go through checks to see what SQL it generated, and if necessary any optimizations/rewrite then got fed back into the C# code so that it could generate it differently.

hardly worth it, in hindsight

Sometimes I think all we really want is a way of generating dynamic SQL with some nice intellisense. jOOQ has the right idea, maybe we should make a C# version.

Sean Gallardy

21:02

JOOQ kidding!

Erik Reasonable Rates Darling

21:16

@Charlieface something i saw while looking at someone else's code

2 hours later…

Paul White

23:20

I suppose the WHILE should be an IF?

A good linter will pick that up

@JoshDarnell That's the spirit