I join you Arthur. That Hungarian notation is despicable (though I love 
listening to that language, it is different).
I don't find it necessary for a column name to tell me its type.  
But I do like the ability to have all database objects (table, column, trigger, 
index, fk, views, procedures, etc.) sortable and searchable. I use a prefix 
though. My prefix is a number for one reason: Ease of communication with stuff. 
A schema is assigned to a range of numbers. 
Sounds old fashioned? Cobolish? So? 
My 2c. David. 

----- Original Message -----
From: Arthur Fuller <fuller.art...@gmail.com>
To: Martin Gainty <mgai...@hotmail.com>
Cc: mysql@lists.mysql.com <mysql@lists.mysql.com>
Sent: Sun Aug 07 19:03:43 2011
Subject: Re: Hungarian Notation [Was Re: Too many aliases]

I despise this sort of notation, and have instead adopted what have
cheerfully named Hungarian Suffix notation, the reason being Signal-To-Noise
ratio. Instead of prefacing everything with some form of prefix, just do the
opposite:

Customer_tbl
Customer_Dead_boo
Customer_DOB_date
Customer_qs (that means Query Select)
Customer_qu (that means Query Update)
Customer_qd (that means Query Delete)
CustomerOrders_tbl
Customer_frm (a form that opens the Customer table; could involve subforms,
but in that case they are named Customer_Orders_fsub,
Customer_Payments_fsub, and so on.

Easy to read, obvious the intent, and easily sortable. Just my opinion.

Arthur

Reply via email to