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.

As a leader in the mobility energy sector in Europe, the TSG Group has established itself as a beacon of sustainability through innovative solutions. While many previously knew them by the name Tokheim as manufacturers of fuel dispensing technologies and gas service stations, they decided to make a change and expand their focus following the sale of a portion of their business to an American enterprise.

We are excited to announce that Imperva is the newest addition to the EDB GlobalConnect Technology Partner Program. Through our partnership with Imperva we are enabling customers to use Imperva Data Security Fabric (DSF) to protect their EDB Postgres Advanced Server and PostgreSQL database instances.

We at EDB are excited to introduce Chemaxon, a leader in the field of Cheminformatics, as the newest addition to the EDB GlobalConnect Technology Partner Program. Through our partnership, we are enabling our customers to use the Chemaxon JChem PostgreSQL Cartridge with EDB Postgres Advanced Server and PostgreSQL.

Now is your chance to dive deeper into Postgres. Secure your spot at our best Postgres Vision yet and get ready to learn how you can make the move and evolve your enterprise. Plus, keep an eye on our social media for the latest information.

In this part of our migration from Oracle to PostgreSQL series we’ll be taking a look at the START WITH/CONNECT BY construct.