---
title: "Doogal Simpson (@doogal) | Hashnode"
description: "\"hey doogal, what is .... ?\". Read the latest articles by Doogal Simpson on Hashnode."
url: "https://hashnode.com/@doogal"
---

@doogal

# Doogal Simpson

@doogal · Joined December 2025

"hey doogal, what is .... ?"

### [Why SELECT Before INSERT Causes Duplicate Records](https://doogal.dev/why-select-before-insert-causes-duplicates?utm_source=hashnode&utm_medium=feed)

Checking records before an insert causes race conditions under load. Learn why row locks fail and how unique constraints reliably prevent duplicate records.

4 min read · [doogal.dev](https://doogal.dev/why-select-before-insert-causes-duplicates?utm_source=hashnode&utm_medium=feed)

[2d ago](https://hashnode.com/posts/why-select-before-insert-causes-duplicates/6afafa364a946c51216bc841)

### [The 7 Threads Running Inside Every Node.js Process](https://doogal.dev/why-an-empty-nodejs-process-runs-7-threads?utm_source=hashnode&utm_medium=feed)

Explore why an empty Node.js process launches 7 OS threads, what V8 does in the background, and how these threads differ from the libuv thread pool.

5 min read · [doogal.dev](https://doogal.dev/why-an-empty-nodejs-process-runs-7-threads?utm_source=hashnode&utm_medium=feed)

[5](https://hashnode.com/posts/why-an-empty-nodejs-process-runs-7-threads/6af6d73a41060513e7d11ea0) [5d ago](https://hashnode.com/posts/why-an-empty-nodejs-process-runs-7-threads/6af6d73a41060513e7d11ea0)

### [Why ASP.NET Core Accepts Expired JWTs (And How to Fix It)](https://doogal.dev/why-aspnet-core-accepts-expired-jwts?utm_source=hashnode&utm_medium=feed)

ASP.NET Core validates expired JWTs due to a default 5-minute clock skew. Learn why this happens, how frameworks compare, and how to set ClockSkew to zero.

4 min read · [doogal.dev](https://doogal.dev/why-aspnet-core-accepts-expired-jwts?utm_source=hashnode&utm_medium=feed)

[4](https://hashnode.com/posts/why-aspnet-core-accepts-expired-jwts/6af58b784b90906ebc6a38e2) [6d ago](https://hashnode.com/posts/why-aspnet-core-accepts-expired-jwts/6af58b784b90906ebc6a38e2)

### [A Day Isn't 24 Hours: Fixing Date Math & DST Bugs](https://doogal.dev/why-a-day-is-not-24-hours?utm_source=hashnode&utm_medium=feed)

A calendar day isn't always 24 hours. Learn why duration math breaks during Daylight Saving Time and how to write resilient calendar arithmetic in your code.

5 min read · [doogal.dev](https://doogal.dev/why-a-day-is-not-24-hours?utm_source=hashnode&utm_medium=feed)

[Nov 11](https://hashnode.com/posts/why-a-day-is-not-24-hours/6af43d852eb9c13dc84f3b03)

### [Why SQL UNIQUE Constraints Allow Duplicate NULLs](https://doogal.dev/why-sql-unique-constraints-allow-duplicate-nulls?utm_source=hashnode&utm_medium=feed)

Understand why SQL unique constraints permit duplicate NULLs, the impact on composite keys, and how to use NULLS NOT DISTINCT in PostgreSQL.

5 min read · [doogal.dev](https://doogal.dev/why-sql-unique-constraints-allow-duplicate-nulls?utm_source=hashnode&utm_medium=feed)

[3](https://hashnode.com/posts/why-sql-unique-constraints-allow-duplicate-nulls/6af34e6af60522234a475d0f) [Nov 10](https://hashnode.com/posts/why-sql-unique-constraints-allow-duplicate-nulls/6af34e6af60522234a475d0f)
