HNGlance

Top Best New Show

Ask HN: Db column naming: snake_case vs. CamelCase, what's the best convention?

https://news.ycombinator.com/item?id=45407552

by jerawaj740 • 10 months ago

2 5 10 months ago

NE

news.ycombinator.com

Related Stories

Loading related stories...

Comments

5

leakycap• 10 months ago

snake_case because if your column ends up in a Postgres/MySQL environment your CamelCase will be become camelcase

And reading those becomes nightmares

If you are just working in Javascript/Node.js, CamelCase is the preferred option.

catlover76• 10 months ago

It's camelCase, not CamelCase

I believe this is PascalCase

tuatoru• 10 months ago

SHOUTY_CASE

ompogUe2• 10 months ago

Snowflake forces this, so you would also never get CamelCase w/o always quoting the column name in your queries.

ompogUe2• 10 months ago

Depending upon how you organize the words within them (*_id, *_name, *_percent), snake case allows you to parse the column names dynamically for things like santization and formatting.

Source preview

news.ycombinator.com

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms