For more than a decade, the U.S. Navy has selected EDB to deliver the capabilities that push PostgreSQL further. We support several U.S. Navy missions, including Naval Surface Warfare Center (NSWC) programs, acoustics research, oceanographic data collection/processing, and global tactical command and control systems of record.

EDB supports Maryland’s Total Human services Integrated Network (MD THINK), building on PostgreSQL to help them do more and go faster in their cloud environment. MD THINK is an innovative, cloud-based platform that allows multiple state agencies to share and manage data in one convenient place. The State expects significant cost savings via the consolidation of application hosting and data center services.

In this talk from Postgres Vision 2020, Abhinav Sagar, Senior Database Consultant, and Premnath Jangam, Senior Database Administrator, from CSG International discuss the various methodologies, procedures, and techniques involved in successfully migrating data from Oracle and DB2 to PostgreSQL. Topics include steps to consider before and after migration, the time it takes to migrate, data compatibility, and much more.

Amidst database modernization and an increasing emphasis on customer-centricity, IKEA Retail Group made an important business decision to improve operations and cut downtime by moving to PostgreSQL.

Docker is quickly becoming the preferred method for deploying modern applications, but running a PostgreSQL cluster in containers is not yet prevalent. In this talk from Postgres Vision 2020, Jerry Eshbaugh, Sr. DevOps Team Leader, Federal Emergency Management Agency (FEMA), discusses the benefits and technical challenges around running PostgreSQL in production-from the first team to ever deploy containerized EDB in a mission critical production environment.

“We need to attain ZERO downtime and high performance in our application,” I was told during a conversation with a manager of a line of business during a conference last year. We hear this often from our customers, and we see it constantly in our conversations on forums. Most of the data center managers, sysadmins, and database administrators have heard this one from “The Business” on more than...

If you are building a Spring Boot application for your next project, you would also be preparing and planning for the PostgreSQL database to store the data generated by your customers. In some previous posts on the topic of RESTful services in Spring Boot, we discussed how we can use JPA to automatically create and automatically apply the schema to the PostgreSQL database.

Arrays are a powerful programming feature frequently used by developers, both in Java and in PL/pgSQL. Interfaces can potentially become tricky, however, when the two try and talk to each other. This section explores how you can write simple code that uses the java.sql.Array Interface to insert, retrieve, & update arrays in PostgreSQL.

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. We have covered this approach in part 2 for our series and have created a simple RESTful API that allows users to perform CRUD operations on a PostgreSQL database.

PostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re doing. This goes for hstore too, and the new jsonb type. These types are useful tools where they’re needed, but should not be your first choice when modelling your data in PostgreSQL, as it’ll make querying and manipulating it harder.