I think one thing I love about web development is that I'm always learning something new! Even with my database skills, just when I think I “know it all” (HA HA HA), I learn some new trick! This week, I had to write some scripts to move some data around […]
I've long and loud pronounced my love for PostgreSQL as a DBMS, but alas, it appears I can't actually pronounce it correctly. When I first started using it, I never saw a pronunciation guide for it, and it never really occurred to me to question it. It seemed obvious to […]
I work with both MySQL and PostgreSQL DBMS. Given the choice, I'll use PostgreSQL over MySQL 99% of the time. MySQL has its benefits, don't get my wrong, but overall I find PostgreSQL to be the more mature DBMS. One of my greatest annoyances with MySQL is that it does […]
I posted the other day about a fun bug with ColdFusion's query of a queries randomly deciding that a value was “like” NULL. Well, I also discovered that when you use LIKE in Query of a Query, the text comparison is case sensitive. This follows what some RDBMS, like PostgreSQL, […]
Why should a web developer care? A badly designed database is not only a pain to work with, but it can bog down your web server. In a worse case scenario, a bad database design can make your server grind to a halt! Although it may take an initial switch […]
A database is a collection of data organized in a way that makes searching and retrieval relatively easy and more efficient. Adding a database to a site can really help in terms of content management, site freshness, and making a site more “dynamic.” It can also make it much easier […]