Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
@Lahsen2016 Naming conventions actually suggest using underscores in table and column names. But i am still using camel case wherever and whenever i can...i just like it
-
I prefer underscore because when you use camelcase for things like acronyms or contain capitals it gets iffy... e.g clientIPAdress is stupid... clientIpAdress reads better but you lose the meaning behind I.P. = internet protocol
-
I consider each table as an entity, so each column is a property, and I dont use underscore to name class' properties in my system... so PascalCase is my choice.
(c# guy) -
PostgreSql is case sensitive. But if you don't quote names, they are internally converted to lower case (therefore the query doesn't run, e.g. SELECT t1.firstName is not the same as SELECT t1."firstName"). I write queries to investigate data.
Feel my pain.
Related Rants
Stop camelCasing column names in databases! Underscore _ have been around for a while.
rant
dba
database
postgresql