Haroon's PlanetPostgreSQL Archives - 2ndQuadrant

Smart R2DBC Repositories for PostgreSQL Databases

September 29, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

Continuing on from the Reactive Spring Boot application development blogs we authored and provided samples for in the last two blogs (part 1 and part 2), we will now move on and discuss how to design and deploy “intelligent” repositories for R2DBC project for PostgreSQL. The purpose of this post is to show you an […]

Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 2

August 26, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

Continuing the discussion from Part 1, Java applications provide a modular interface to the PostgreSQL databases, regardless of how you access them; via a JDBC or R2DBC. R2DBC repositories provide a rapid prototyping support for development, since they are lightweight and provide just-enough wrapper to perform database queries. When you mix the R2DBC with PostgreSQL’s […]

Building Reactive PostgreSQL Repositories for Spring Boot Applications – Part 1

August 21, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

Overview 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 […]

Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA

July 20, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

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 […]

Bulk transactions with RESTful CRUD API using PostgreSQL and Spring Boot

June 30, 2020/0 Comments/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

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 […]

RESTful CRUD API using PostgreSQL and Spring Boot – Part 2

June 16, 2020/4 Comments/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

Overview This article is an extended version atop of the previous article which was a kickstart for building an application using Spring Boot and PostgreSQL. There is no internal feature supported by Java which offers mapping between class objects and database tables; therefore, we use Object Relational Model (ORM). JPA is an abstraction above JDBC […]

RESTful CRUD API using PostgreSQL and Spring Boot – Part one

June 8, 2020/1 Comment/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

Overview Spring Boot is a framework that is used to build stand-alone Java applications following the Spring framework but with less hassle and minimal configuration. Learning by practical examples is always great; therefore, this article will walk you through the creation of a RESTful CRUD (create-read-update-delete) application using Spring Boot and its connectivity with PostgreSQL. […]

PostgreSQL: Regular expressions and pattern matching

July 31, 2019/1 Comment/in Haroon's PlanetPostgreSQL /by Muhammad Haroon

A regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular expressions (BREs and EREs) SIMILAR TO operator added in SQL:1999 SQL LIKE operator There are some more advanced techniques for advanced pattern matching requirements but those will very likely […]

PostgreSQL for IoT Data Retention and Archiving

September 11, 2018/1 Comment/in Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad Haroon

We do understand that IoT revolution is resulting in enormous amounts of data. With brisk data growth where data is mostly time series append-only, relational databases and DBAs have a rather tough task to store, maintain, archive and in some cases get rid of the old data in an efficient manner. In my previous posts, […]

PostgreSQL and IoT Data Localization, Integration, and Write Scalability

August 16, 2018/0 Comments/in Haroon's PlanetPostgreSQL, Internet of Things /by Muhammad Haroon

In my previous post we looked at various partitioning techniques in PostgreSQL for efficient IoT data management using IoT Solution. We do understand that the basic objective behind time based partitions is to achieve better performance, especially in IoT environments, where active data is usually the most recent data. New data is usually append only […]

2ndQuadrant is now part of EDB