The process of determining a good naming scheme for your database is more complicated than one might initially think. Take the idea of UPPERCASE vs. lowercase vs. MiXedCaSe table names. Most people will focus on the visual aspect of naming things, but it’s important to understand that SQL standard defines behavior related to case folding, and that many databases implement this differently; for example if you install MySQL on windows, you get a different default behavior than on unix, not to mention there are configuration options that change behavior too; all of which can actually increase the complexity and the amount of code when dealing with your database. In this talk we’ll discuss examples like this and make sure people see all sides of each situation. Areas we’ll touch on include:
We’ll discuss pros and cons of each topic, as well as how different databases implementations will affect the choices you make. We’ll also discuss techniques for enforcing these rules without causing major pain to your fellow developers.
Robert Treat works as a database architect at OmniTI and has been working with open source for over a decade. A veteran industry speaker at conferences worldwide, Robert is also co-author of the book Beginning PHP and PostgreSQL 8, and has been recognized as a major contributor to the PostgreSQL project for his work over the years.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the OSCON Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required)
View a complete list of OSCON contacts