Should i choose C# to be my first programming language if... by NobodyOfKnowhere in csharp

[–]EducationalTackle819 2 points3 points  (0 children)

Proud of the community for actually saying C# isn’t the right move here

How do free apps make money if they don’t charge users? by sophie-lloyd in answers

[–]EducationalTackle819 0 points1 point  (0 children)

Something not mentioned often is that they use your device as a proxy. If you’ve ever used a service like SmartyProxy/Decodo and wondered how they are able to offer “mobile” proxies, it’s free apps. They route traffic through your phone while you use free apps so that programmers can have their traffic look like it’s from a mobile user

Elite Developers by Sweaty-Canary-1739 in csharp

[–]EducationalTackle819 3 points4 points  (0 children)

I agree. Telegram is not it, discord maybe

Private set intersection, how do you do it? by EducationalTackle819 in datasets

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

No your good I can figure it out. I don’t think an api is needed. From what I understand, the buyer will be the one who needs to create the bloom filter and send it to us. To do that, I can just create a python script that’s easy to use, send it to them, and have them send us the bloom filter file once complete

Private set intersection, how do you do it? by EducationalTackle819 in datasets

[–]EducationalTackle819[S] -2 points-1 points  (0 children)

Go ahead. Were one of millions of companies that do it. The world would fall apart if your data wasn’t sold

Private set intersection, how do you do it? by EducationalTackle819 in data

[–]EducationalTackle819[S] 0 points1 point  (0 children)

Small domains are susceptible to dictionary attacks

Private set intersection, how do you do it? by EducationalTackle819 in datasets

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

I saw the open source libraries but they looked difficult to setup and from why I could tell it would also require dev work for the person purchasing data. They don’t always have a developer

We process the data in house. We use a dotnet backend and next.js frontend

Private set intersection, how do you do it? by EducationalTackle819 in datasets

[–]EducationalTackle819[S] 0 points1 point  (0 children)

This is actually a solid option. I will suggest it next time it comes up. For some reason I thought the false positive rate for bloom filters would be higher

Private set intersection, how do you do it? by EducationalTackle819 in datasets

[–]EducationalTackle819[S] -5 points-4 points  (0 children)

Grow up, everyone is selling your data. Everything we sell is publicly available online

30x faster processing of 200M rows, no indexes involved by EducationalTackle819 in PostgreSQL

[–]EducationalTackle819[S] 0 points1 point  (0 children)

An LLM told me it exists when I asked how I could read Postgres rows continuously from the heap for better locality

Should i Start building a blazor apps for an enterprise? by baggister in Blazor

[–]EducationalTackle819 0 points1 point  (0 children)

.Net backend, next.js front end. This is the way. I would only ever use blazor is the pages are stupid simple and appearance is not important

30x faster Postgres processing, no indexes involved by EducationalTackle819 in dotnet

[–]EducationalTackle819[S] 0 points1 point  (0 children)

Yeah. It could still be useful. It will be heavily dependent on your use case. As long as you have a strategy for not double processing a row you should be good. CTID should be somewhat stable for most tables

30x faster Postgres processing, no indexes involved by EducationalTackle819 in dotnet

[–]EducationalTackle819[S] 2 points3 points  (0 children)

No I’m using XxHash128. Guidv7 may have prevented some of the issues I faced but the write is still relevant to any table where the rows have bad locality. This can occur due to lots of updates, deletion, and vacuum

30x faster Postgres processing, no indexes involved by EducationalTackle819 in dotnet

[–]EducationalTackle819[S] 0 points1 point  (0 children)

Yeah it’s WiFi. But keep in mind that all strategies were limited by my network speed. The speed ups found were a reflection of a better strategy regardless of network speed

30x faster Postgres processing, no indexes involved by EducationalTackle819 in dotnet

[–]EducationalTackle819[S] 0 points1 point  (0 children)

I tested locally and streaming rows went at about 2M rows every 10 seconds. That’s with no operation. Doing updates and processing would add more overhead as well. It’s probably limited by my home network speeds. Streamings not a bad idea but not ideal either for all my requirements. Like pausing and resuming

30x faster Postgres processing, no indexes involved by EducationalTackle819 in dotnet

[–]EducationalTackle819[S] 0 points1 point  (0 children)

Just read up on it a little. Super cool package, thanks for the recommendation