You can tell a lot about someone's experience in a field by the questions they ask.
When somebody is obviously new to the topic, whatever it is, you can help...
Continue reading "Helpful help" »
Friday, August 28. 2009
Your Tools, Their Server
You've set up psql just how you like it. Your editor, also
customized, your prompt, and it's even a pretty advanced version of psql with
lots of goodies. You've got more tools than psql, and some of them might be
proprietary and/or GUI tools. Ah, the joy of customization!
Now, you need to talk to somebody else's database. You could spend time
either adjusting to using their setup or installing yours. This prospect
fills you with dread, and time is of the essence.
Continue reading "Your Tools, Their Server" »
customized, your prompt, and it's even a pretty advanced version of psql with
lots of goodies. You've got more tools than psql, and some of them might be
proprietary and/or GUI tools. Ah, the joy of customization!
Now, you need to talk to somebody else's database. You could spend time
either adjusting to using their setup or installing yours. This prospect
fills you with dread, and time is of the essence.
Continue reading "Your Tools, Their Server" »
Wednesday, August 26. 2009
Key Tree
Ever wondered what tables have foreign keys to a given table, and which ones to those, and so on?
Read on! Continue reading "Key Tree" »
Read on! Continue reading "Key Tree" »
Wednesday, August 19. 2009
Choose Your Primary Key Wisely
Reason why schema design is really, really important number 187:
SSN is not a fit candidate as a primary key in a "person" table. Why not?
This is why not.
Remember, kids,
Just Say No
to hasty schema design.
SSN is not a fit candidate as a primary key in a "person" table. Why not?
This is why not.
Remember, kids,
Just Say No
to hasty schema design.
Monday, August 17. 2009
VARCHAR(n) Considered Harmful
So you're designing a database, and you think to yourself, "Hey, I'll use
VARCHAR(n) for some of my constraints!" Now, you have two problems.
Continue reading "VARCHAR(n) Considered Harmful" »
VARCHAR(n) for some of my constraints!" Now, you have two problems.
Continue reading "VARCHAR(n) Considered Harmful" »
(Page 1 of 1, totaling 6 entries)
