One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in ...

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

After his introductory series, Tom Fenton deploys a database on Docker and integrates it with other apps deployed from other Docker images. In my Introduction to Docker series, I covered the basics of ...

At my day job, we use MySQL and the excellent querious client to connect to it. I'm starting a side project using Postgresql, and I'm looking for a similar tool. I don't want anything too heavyweight, ...

Google today announced the launch of AlloyDB, a new fully managed PostgreSQL-compatible database service that the company claims to be twice as fast for transactional workloads as AWS’s comparable ...

PostgreSQL continues to improve in ways that meet the needs of even the most complex, mission-critical use cases. It also presents certain challenges. The database market continues to be splintered ...

Tom demos table joins, shell scripts for repetitive tasks and using "exec" to run commands inside a container from the host system. In my previous article on running applications on Docker, I deployed ...

PostgreSQL was built to handle a wide range of use cases, but flexibility also has a flip side. Make sure you’re not making these all-too-common design, configuration, tuning, and other mistakes. A ...