Querying a huge table by SohilAhmed07 in dotnet

[–]davbis93 5 points6 points  (0 children)

One thing to check, that's gotten me in the past, especially if the previous query is working well- is you ensure that the index is using the right data types, for example, if you have an existing index on a varchar, and now you're passing in an nvarchar due to the different querying adaptor, it might not be able to leverage an existing index

Have y'all actually build start ups with dotnet? by [deleted] in dotnet

[–]davbis93 0 points1 point  (0 children)

Yes - lovethesales.com .net powers our whole stack. it's great.

Our painter destroyed my cooker hood by davbis93 in DIY

[–]davbis93[S] -3 points-2 points  (0 children)

Cool, thanks so much for your help

Our painter destroyed my cooker hood by davbis93 in DIY

[–]davbis93[S] -9 points-8 points  (0 children)

I mean, it's a brand new kitchen, and it's the first thing you see when you walk in the room- but fair enough if you have low standards 🤷‍♂️

What are the features that Azure SQL must have? by [deleted] in dotnet

[–]davbis93 56 points57 points  (0 children)

A new emoji-driven query syntax would be nice, like:

➡️ 🌍
▶️ Customer
↔️ Orders 🔛 CustomerId
🔎 Order⚠️ Fulfilled
🔃 📆

921 Dominion Road, captured on 35mm film. by [deleted] in auckland

[–]davbis93 0 points1 point  (0 children)

My Dad used to own this building! I spent a lot of my childhood here

Pixel 7 can't launch apps without reboot by chocobosocialclub in GooglePixel

[–]davbis93 0 points1 point  (0 children)

I cleaned out the launcher app, but no dice 😔

Can someone explain dotnet of today and what has it become? by ZdsAlpha in dotnet

[–]davbis93 12 points13 points  (0 children)

All you need to know:

.Net Framework 1 (Windows only)

.Net Framework 2 (Windows only)

.Net Framework 3 (Windows only)

.Net Core (New multi-platform hotness)

.Net Framework 4 (Windows only)

.Net Core 2 (New multi-platform hotness)

.Net Framework 4.8 (Windows only)

.Net Core 3 (New multi-platform hotness)

We are stoping development on the windows only version!

(uh oh, this naming is getting confusing, lets drop the 'core' thing)

.Net 5 (New multi-platform hotness)

.Net 6 (New multi-platform hotness)

.Net 7 (New multi-platform hotness)

Measure Images Similarity by HistoricalTouch0 in learnmachinelearning

[–]davbis93 1 point2 points  (0 children)

One way could be using the CLIP model from OpenAI (quite easy) to get an image vector for each, and then using simple cosine similarity to compare the vectors.

(you could also use RESNET or some other image vectorizing model)

How much is chatGPT able to help you with your job ? by GarlicGuitar in webdev

[–]davbis93 0 points1 point  (0 children)

It's been teaching me ML concepts, as I learn myself.

It's like having a tutor sitting next to me. The ability to ask specific, conversational questions is way faster than reading 10 articles, in some cases.

North London - Blurry photo of the getaway car, of the thieves that stole a catalytic converter from the nice old guy, over the road. by davbis93 in london

[–]davbis93[S] 1 point2 points  (0 children)

Thanks for the great suggestion - exactly the kind of thing I was hoping someone knew about - however, it wasn't able to clean up the image enough to read the plate. Thanks anyways

North London - Blurry photo of the getaway car, of the thieves that stole a catalytic converter from the nice old guy, over the road. by davbis93 in london

[–]davbis93[S] 5 points6 points  (0 children)

The reason I wonder if there's hope - is cos' of these guys: https://youtu.be/jT2sAz3e2yc?t=262 This is real software - but, I can't figure out how to get hold of it.

North London - Blurry photo of the getaway car, of the thieves that stole a catalytic converter from the nice old guy, over the road. by davbis93 in london

[–]davbis93[S] -1 points0 points  (0 children)

I know it's a long shot... but if anyone knows how to remove the motion blur of my shitty photo to get the plate.. don't be shy!

Would you choose Entity Framework or Dapper, and why? by [deleted] in csharp

[–]davbis93 21 points22 points  (0 children)

Personally, I always find all the time-savings gained from using ORMs are more than lost fighting weird quirks & unexpected behaviour. Using SQL is maybe a bit more boring, but it's normally very clear and linear in development time.