I'm working on a web app, and it part of it, there is a very simple database-driven file/document manager. As a file manager, there is the possibility of sub-folders. So in the DB, I have the ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...

Schema design, indexes, queries, configs, I/O... what could go wrong? Follow these 10 essential tips to keep your MySQL servers humming. MySQL is the world’s most widely used open source database, and ...

The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan Harkins offers some insights into when — and why — you might choose one over the other.

Which makes for a better primary key: natural data points or meaningless values? Database developers have strong opinions on this facet of primary key design. This article settles the debate once and ...