Database security is the single biggest concern with today's Web-based applications. Without control, you risk exposing sensitive information about your company or, worse yet, your valuable customers. In this article, learn about security measures you can…

Users are central to any web application, and when you have users you usually need accounts, and when you have accounts you need password verification and cookies. Almost every web framework in any language has something for storing and comparing passwords…

Basic proficiency with PostgreSQL is one of the highest-leverage skills an engineer can have. Even a cursory understanding of its internals…

For many years MySQL and PostgreSQL were competing databases, which addressed slightly different audiences. Here's why you always should go for PostgreSQL!

Five years ago I wrote a post that got some good attention on why you should use Postgres. Almost a year later I added a bunch of things I missed. Many of those items bear repeating, and I’ll recap a few of those in the latter half of this post. But in the…

Your database knows which queries are running. It also has a pretty good idea of which indexes are best for a given query. And since…

Making sure columns contain what they ought