Some notes What is SQL database? What is NoSQL database? NoSQL types of databases (Document oriented, columnar, keyvalue and Graph) Relational Vs Document (NoSQL) key differences. Today, many people are...
“The cloud” feels like it’s been a thing for about, well, forever at this point. Yet, we see many customers who are just beginning to explore their options with the...
This article offers tips and shortcuts for performing useful tasks in Postgres. Whole-row references Comparing a selection of columns Hardcoded tables Custom config parameters Booleans can stand alone Convert column...
A typical database-oriented application setup only must work with single operation SQL or RESTful execution. Your customers might only be sending the INSERT or UPDATE queries one at a time...
The morning begins with a new email, with this subject line at the top of the inbox of you, the trusty DBA. The database isn’t down, though, otherwise you’d have...
Kubernetes (K8s) is increasingly gaining popularity. With the growing interest of containers/K8s, Postgres is also becoming a core technology that many developers/users want to deploy in the same environment. This...
Docker is an open source platform where we can create, deploy, and run applications by using containers. Docker is similar to virtual machines (VM), but in VM you need to...
In the days of cloud computing and agile development, it might seem that being a DBA is somewhat less appealing as a career choice. However, the role of DBA is...
On Thursday I wrote about the new MongoDB compatible DocumentDB from AWS and its potential impact on MongoDB going forward. Following up from that, a colleague pointed me to a...
There has been a lot of talk about database automation in the last six months and how, as if by magic, it will mean companies no longer have to worry...
