Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Ask HN: Db column naming: snake_case vs. CamelCase, what's the best convention?
2 points by jerawaj740 8 months ago | hide | past | favorite | 5 comments


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.


SHOUTY_CASE


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


It's camelCase, not CamelCase

I believe this is PascalCase




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: