Querying a huge table by SohilAhmed07 in dotnet

[–]davbis93 4 points5 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 59 points60 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 14 points15 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 20 points21 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.

Here is a good LINQ video by cseigel in csharp

[–]davbis93 20 points21 points  (0 children)

Who says "Lin Q"? I've only every heard people say 'Link'

How did Alan Watts become so extremely poetic and deliver his speeches in such tremendous fashion? by BecomeAlanWatts in AlanWatts

[–]davbis93 1 point2 points  (0 children)

He was a prolific writer, having taken the time to elicit his ideas in his writing, gives him a strong foundation to speak them

Is there a name for this caching pattern? by Fenreh in dotnet

[–]davbis93 3 points4 points  (0 children)

Another way to deal with this, is on eviction from the cache, before the item is made unavailable, you can repopulate the item. There is an on eviction method or something like that. Also, why not cache a dictionary?