calling-async-from-sync-csharp.mdCalling async code from sync code in C#: deadlocks, the thread pool and the right approachHow 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..NET
#dotnet #csharp #async
7 min
August 2026 · 5 posts
how-this-site-works.mdHow this site worksWhy I put my CV inside an IDE and a real SQLite database, and how the SQL console below is kept safe..NET
#dotnet #sqlite #security
1 min
sqlite-insert-performance-ios.mdFast and safe bulk inserts in SQLite: transactions, WAL and iOSWhy SQLite bulk inserts are slow by default, the three techniques that fix it, what synchronous=OFF and journal_mode=MEMORY really risk, why WAL with synchronous=NORMAL is a safer default, and how it all applies to Core Data, SwiftData and .NET.iOSDatabases
#sqlite #ios #dotnet #performance
8 min
transient-scoped-singleton-captive-dependency.mdService lifetimes in ASP.NET Core: transient, scoped, singleton and the captive dependency trapWhat transient, scoped and singleton really mean, how a scoped DbContext gets trapped in a singleton, how scope validation catches it, and how to handle background services, thread safety, keyed services (.NET 8) and HttpClient lifetimes..NET
#dotnet #aspnet-core #dependency-injection
6 min
ef-core-bulk-insert-update-delete.mdBulk inserts, updates and deletes in EF Core: from SaveChanges batching to SqlBulkCopyHow EF Core's batched SaveChanges differs from the EF6-era approach, how ExecuteUpdate/ExecuteDelete work and where they bite, EF Core 10's conditional setters, SqlQuery for unmapped types, and when to switch to SqlBulkCopy or PostgreSQL COPY..NET
#dotnet #efcore #performance
7 min
openai-api-token-counting-conversation-state.mdToken counting, conversation state and 429 errors in the OpenAI Responses APIHow the OpenAI API has changed, how to count input tokens before a request, three ways to keep conversation state (manual replay, previous_response_id, Conversations API), and how to tell quota errors from rate limits on a 429, with Python and C# examples.AI
#openai #ai #python #dotnet
7 min
tekinali.db · read-only · ● connected
SQLite 3.53.3 · 8 tables, 2 views.
Click a table on the left, pick a query below or write your own. Help: \?