✓ Build succeeded · 0 warning · 11 years of experience · 6 projects
Tekin Ali
Computer Engineer · .NET, iOS & NLP
I'm a computer engineer. For nearly 10 years, I have been developing highly concurrent backend systems using .NET, Redis, and Apache Kafka, alongside high-performance native iOS applications using Swift. I transform these infrastructures into smart systems capable of semantic text understanding through Natural Language Processing (NLP) integrations. While building new architectures is exciting, my favorite task remains the same: finding and accelerating that one slow query bogging down the system. Reducing execution times from seconds to milliseconds through advanced database design, Citus sharding, and pinpoint indexing optimizations on SQL Server and PostgreSQL is my core expertise.
Areas of expertise
- C#
- .NET Framework
- ASP.NET
- Entity Framework
- Swift
- SwiftUI
- UIKit
- SwiftData
- SQL Server
- PostgreSQL
- SQLite
- Sybase IQ
Latest posts
- Top-N per group in SQL: matching the query to your data A guide to selecting the first or top-N row per group in SQL Server, PostgreSQL, EF Core and Spark: how each pattern executes, why data distribution decides which one wins, which indexes they need, and how to verify the choice in the plan.
- Calling async code from sync code in C#: deadlocks, the thread pool and the right approach How blocking on a Task deadlocks UI apps and starves the thread pool in ASP.NET Core, what to do when blocking is unavoidable, where ConfigureAwait(false) and .NET 8's ConfigureAwaitOptions matter, and how hidden async void crashes processes.
- Concurrency-safe upserts in SQL Server, PostgreSQL and SQLite How upserts break under concurrency and how to write them safely: UPDLOCK and SERIALIZABLE or MERGE in SQL Server, ON CONFLICT, MERGE and RETURNING in PostgreSQL, native UPSERT in SQLite, and why INSERT OR REPLACE is not one.