Ask HN: Should IDs be strings or numbers in your codebase?

2•viviansolide•1h ago

At work we're debating whether entity IDs should be typed as strings or numbers throughout our stack (API contracts, frontend, etc.).

Database auto-increments happen to be integers, but we never perform arithmetic on IDs – they're opaque identifiers.

My take: IDs are identifiers, not numbers. Typing them as strings makes this explici and makes migrating to UUIDs or other formats painless.

Am I missing a good reason to keep them as numbers?

Comments

jghn•1h ago

Unless you're doing math with them for some reason, they're strings.

Rotundo•59m ago

Consider storage requirements. Strings (ASCII? UTF-8?) are not as efficient as integers or UUIDs. You're not storing UUIDs as strings, are you? They are binary, only converted to the string expansion for display and/or export.

Cartly: An iOS Receipt Tracking Demo Built on Mnexium

Show HN: Memgraph-agent – NER+PageRank memory for AI agents, $0 LLM cost

Show HN: Know Your SMD Footprints

Microgpt Lab

On-Policy Prediction with Approximation

What Crystals Older Than the Sun Reveal About the Start of the Solar System

Show HN: 58% cost by replacing file reads with a dependency graph on AI Coding

What makes a game tick? Part 9 – Data Driven Multi-Threading Scheduler

Completing the formal proof of higher-dimensional sphere packing

Show HN: license checker for npm projects

Treasury terminates Anthropic AI use after Trump's order

Show HN: Gapless.js – gapless web audio playback

Go is the best language for agents

KGet 1.6.0

"Poisoned Wells," the largest study of website blocking in India to date

In The Pentagon Battle with Anthropic, We All Lose

"That Shape Had None" – A Horror of Substrate Independence (Short Fiction)

Anonymous Credentials: An Illustrated Primer

Show HN: Smart-commit-rs – A zero-dependency Git commit tool in Rust

Ask HN: Self Sustaining Codebases

Home of Astrophotography

Show HN: Ccbridge – A CLI to Orchestrate Claude Code and Codex

Show HN: War.direct – Real-time conflict intelligence dashboard for the Iran war

Show HN: Self-hosted AI agent observability (OTel, Grafana, bash hooks)

New Best Friend Is a Chatbot

OpenAI Just Got Anthropic's Pentagon Deal

Patience Toys

My weird ADHD to-do app, Do-dono

Show HN: Independent monitoring of AI API reliability

Rig for Turbulence