Learn the benefits of cloud databases, types of cloud environments, and how to select the right provider. Read the comprehensive guide.

Introduction Exploring the benefits of migrating databases from on-premises to cloud services Overview of legacy providers vs. cloud-based open source database management systems Highlighting the advantages of cloud computing for data centers and databases Why Would I Consider a Cloud Migration? Legacy providers like Oracle and Microsoft don’t offer the same level of innovation as cloud-based open...

Business transformation, the shift to digital and databases in the cloud are increasing demand for DBMS migrations. These migrations present challenges and traps for the unwary. Data and analytics leaders should ensure their organizations understand how to execute successful DBMS migrations. Knowledge is power, though, and in their recent report, Gartner researched and shared the best practices...

We at EDB are pleased to announce that we have completed validation testing of Nutanix AHV for it to now support the latest versions of EDB Postgres Advanced Server, versions 14 and 15. Nutanix AHV is the native Nutanix hypervisor that offers virtualization capabilities needed to deploy and manage enterprise applications.

We at EDB are pleased to announce Pure Storage, a provider of enterprise-grade, all-flash block, file, and object storage, as the newest member of the EDB GlobalConnect Technology Partner Program. Our certification of Pure Storage FlashArray provides customers with enterprise-grade flash storage arrays to help address their storage needs.

Starting v9.2, PostgreSQL is providing native data type support for JSON objects. Subsequent releases introduced JSONB (binary formatted JSON objects) and many data manipulation functions for JSONs, making it a very powerful tool for NoSQL operations.

Developing a frontend for a database can be a challenging task, especially when there are multiple runtimes / frameworks available for the language of your choice. We have been dealing with Java and the Spring Boot framework and have showcased how to develop RESTful APIs, how to manage migrations etc. We dealt with the “go-to” Java development practices, with a thread-per-connection model of web applications. Spring Boot Reactive is a new model of development your database-frontends that supports non-blocking operations.

Learn how to safely change the Postgres user password via PSQL.

In conjunction with EDB Postgres Vision 2023, we’re excited to announce a brand new program: the EDB Customer Excellence Awards. We’re privileged to work with many great brands that are using EDB solutions and tools to make a difference in their organizations.

Sometimes, PostgreSQL databases need to import large quantities of data in a single or a minimal number of steps. This is commonly known as bulk data import where the data source is typically one or more large files. This process can be sometimes unacceptably slow. In this article, we will cover some best practice tips for bulk importing data into PostgreSQL databases. However, there may be situations where none of these tips will be an efficient solution. We recommend readers consider the pros and cons of any method before applying it.