Abdesol Builds
857 subscribers
123 photos
12 videos
96 links
.NET | Avalonia | Backend Dev | Chess Enthusiast

Portfolio https://abdesol.me

Reach me out at @abdesol
Download Telegram
btw, I see some of my favorite tech telegram channels have members only comments. I understand that it is to avoid spammers, etc..

but personally, as someone who doesn't like distractions and rarely join groups unless I will be interacting inside regularly, you took away my freedom to comment, give feedbacks etc... just emotes

๐Ÿซก on behalf of people like me, please allow non-group members to comment
๐Ÿ’ฏ11โค5
Forwarded from .Net Core Ethiopia
๐Ÿš€ Scaling .NET + PostgreSQL to 100M+ Events

Built an event analytics platform to explore real-world scaling challenges. Here's what I discovered:

๐Ÿ›  Stack:
โ€ข .NET Core console app with high-performance bulk insertion
โ€ข PostgreSQL with advanced partitioning + materialized views
โ€ข Docker for easy setup and testing

๐Ÿ’ก Key Learnings:
โ€ข PostgreSQL COPY is 10-100x faster than INSERT statements
โ€ข Performance cliff hits around 64M+ events
โ€ข Memory tuning critical: found 10GB shared_buffers sweet spot
โ€ข Materialized views essential at scale (1,900x improvement!)

๐Ÿ“Š C# Load Generator Features:
โ€ข Realistic data patterns (Pareto distribution, geo data)
โ€ข Configurable batch sizes (30K optimal for 100M+ scale)
โ€ข Parallel worker support
โ€ข Real-time progress tracking with Spectre.Console

๐ŸŽฏ Results:
โ€ข 100,365,001 events processed successfully
โ€ข Sub-millisecond dashboard queries
โ€ข 100+ concurrent users validated
โ€ข Complete monitoring and observability

๐Ÿ‘Œ for .NET developers working with large datasets or wanting to understand PostgreSQL scaling patterns.

GitHub: https://github.com/LeoulGirma/EventAnalytics-100M
Report : https://telegra.ph/The-100M-Row-Challenge-10-26

#dotnet #postgresql #performance #scaling #csharp
Please open Telegram to view this post
VIEW IN TELEGRAM
๐Ÿ”ฅ4
@software_guy, don't disable your channel comment section for non-members and I will say "I am here"
๐Ÿ’ฏ2๐Ÿ˜1
I joined with white cuz black is .... ๐Ÿ˜
๐Ÿ˜5
Forwarded from RaGoose
Current turn: Black

โฑ๏ธ Round 10: White can move immediately (no timer during round)

๐Ÿ“ฅ Captured:
โšช White: โ™Ÿโ™Ÿโ™Ÿ (3 pts)
โšซ Black: โ™žโ™Ÿ (4 pts)

๐Ÿ“œ Recent moves (19 total):
15. abdesol: c1 โ†’ d2
16. JONAZZ2: b4 โ†’ a5 captures โ™Ÿ
17. toneytor: g1 โ†’ f3
18. JONAZZ2: f5 โ†’ c2 captures โ™Ÿ
19. HasPluse: a6 โ†’ a7 captures โ™Ÿ
... (14 earlier moves)
the past two weeks, I have been working on this fun little side project: https://gitpersona.live

Give it your github username, and it will tell you the developer personality type it thinks you have (It is gonna roast you a bit tho )

Try it out and share the persona it gave you ๐Ÿ˜
๐Ÿ”ฅ9๐Ÿ˜ญ5โค3
Abdesol Builds
the past two weeks, I have been working on this fun little side project: https://gitpersona.live Give it your github username, and it will tell you the developer personality type it thinks you have (It is gonna roast you a bit tho ) Try it out and shareโ€ฆ
ik it is a bit slow.. github gives me max 5k request per hr limit. I can't finish it all first and make the other ppl who try it later wait an hr. Additionally, there is also the gemini api delays.

Appreciate any help around the github api limit ๐Ÿซก
Abdesol Builds pinned ยซthe past two weeks, I have been working on this fun little side project: https://gitpersona.live Give it your github username, and it will tell you the developer personality type it thinks you have (It is gonna roast you a bit tho ) Try it out and shareโ€ฆยป
I added a semaphore on top of the queue I had, forgetting that the queue was working as a semaphore with FIFO yesterday ๐Ÿ˜ฎโ€๐Ÿ’จ

I have fixed that.. hopefully the delays should be a bit lower
bear with me, github is rate limiting me ๐Ÿ˜”
Please open Telegram to view this post
VIEW IN TELEGRAM
I think it is better to teach a baby than to get LLMs be consistent with prediction ๐Ÿ˜ฎโ€๐Ÿ’จ I had to fix it multiple times to avoid biases.. I have done it again for one last time.. check out your profile again and see if it will give you a new persona

It was biasing towards Hacker and Tinkerer.. Haven't seen ppl having the juicy ones like Sentinel
โšก1โค1๐Ÿ˜1
The stack
Next.js + Tailwind + FastAPI + Postgres
Abdesol Builds
The stack Next.js + Tailwind + FastAPI + Postgres
No .NET.. ik, pls forgive me.. I just wanted to do something quick, and the crappy fastapi is enough for that.

.NET for production and stability ๐Ÿซก
๐Ÿ˜4๐Ÿ‘2
some of you got the "Unknown" or error type.. it was because of the gemini rate limiting. I think I had to make a way for ppl to provide their own github and gemini token.. but that would have made it a complicated UX

I have updated the gemini token to my other google accounts, hopefully it should work now
I am going to reveal just one or two personality types at a time which most ppl didn't get
Sentinel

the one I was hoping many ppl with very good public github activity would get
โšก1๐ŸŽ‰1