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 ...

Linux isn't nearly as hard as you think it is. In fact, Linux has become one of the easiest desktop and server operating systems on the planet. How is that possible? For one thing, modern Linux ...

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins PostgreSQL is an open-source, object-relational (also called ...

The command line isn't just for wise Linux beards. It's actually an awesome tool with almost limitless functionality. Here's a primer on how it works, and how you can do almost anything with it. Note: ...

This select set of Linux commands can help you master the command line and speed up your use of the operating system. When coming up to speed as a Linux user, it helps to have a cheat sheet that can ...

Linux is one of the popular operating systems and has seen wide adoption across the globe. It is an open-source, Unix-based operating system with many distributions for computers, embedded systems, ...

Regular readers of this column won't be surprised to hear that I love both Ruby on Rails and PostgreSQL. Rails has been my primary server-side Web development framework for about eight years, and it ...