In this blog post, I will show the usage of string_agg function in PostgreSQL with examples. As name suggests, string_agg is a string aggregate function which is used to concatenate values from multiple rows into one. Syntax Usage Lets first create a user table to show the usage. put some data into the table Below…
Spring team is developing spring native module which provides support for compiling Spring applications to native executables using the GraalVM native-image compiler. Native applications provide following advantages compared to JVM based applications Required software Setting up the project To create a project, go to https://start.spring.io and select following spring version and dependencies. Note 1) Spring Native 0.10.5 only supports Spring Boot…
In this blog post we will see various ways to store list of strings in single column in database using JPA. Storing list as comma separated strings Storing list in JSON format Storing list as array i) Storing List as comma separated strings The easiest way to store list of strings in a single database…