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

Question

leakycap · Accepted Answer

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.

tuatoru · Answer

SHOUTY_CASE

ompogUe · Answer

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.

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

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

snake_case because if your column ends up in a Postgres/MySQL environment your CamelCase will be become camelcaseAnd reading those becomes nightmaresIf you are just working in Javascript/Node.js, CamelCase is the preferred option.

SHOUTY_CASE

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.

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.

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.