Challenges of managing PostgreSQL
PostgreSQL’s popularity is growing and we’ve got the numbers to prove it: this database is currently ranked #4 in popularity amongst hundreds of databases worldwide in the DB-Engines Ranking. Yaniv Yehuda, CTO at DBmaestro weighs in on the challenges of managing PostgreSQL and talks about the factors driving the increased interest in PostgreSQL.
PostgreSQL is becoming the preferred database for more and more enterprises and smaller organizations. It is currently ranked #4 in popularity amongst hundreds of databases worldwide according to the DB-Engines Ranking.
What is even more impressive, is its significant climbing trend in the market (mentions websites, searches, technical discussions, job offers, social networks etc.).
Factors driving the increased interest in PostgreSQL
There are several factors driving the increased interest in PostgreSQL. Many organizations are looking for open source alternatives beyond traditional vendors in the database arena, such as Oracle, Microsoft, and IBM to keep down the total cost of ownership.
PostgreSQL also has the advantage that it can store structured and unstructured data in a single product. Unstructured data, found in audio, video, emails and social media postings, can be used to improve customer service, discover new product requirements, and find ways to prevent a customer from churning in addition to countless other uses. By 2025, IDG projects that 80% of data will be unstructured.
PostgreSQL also has superior online transaction processing capabilities (OLTP) and can be configured for automatic failover and full redundancy, making it suitable for financial institutions and manufacturers. As a highly capable analytical database it can be integrated effectively with mathematical software, such as Matlab and R. Due to PostgreSQL’s replication capabilities, websites can easily be scaled out to as many database servers as you need.
DBmaestro chose to focus on PostgreSQL not just for its obvious popularity and market demand, but also for the challenges it presents to companies using it. Whereas traditional database vendors or 3rd party vendors complete the offering for missing or less than satisfactory supporting tools (just see the ecosystem around Oracle’s database), the PostgreSQL community does not have the luxury of a mature database ecosystem. In addition, PostgreSQL is often used in tandem with several different databases, such as Oracle or MongoDB, where each database requires specialized and somewhat expertise.
DevOps teams and database professionals in addition to management tools for PostgreSQL, also need to be able to manage multiple databases from multiple vendors without having to change existing processes. DBmaestro experience the demand for an overarching solution for CI/CD adoption across platforms and operating systems including Oracle, DB2, Microsoft SQL Server and PostgreSQL, enables organizations to meet the evolving database release automation needs of enterprises across databases for all types of data.