Reading Time: 3 minutes Hi folks in this blog, we perform CRUD(Create, Read, Update, Delete) operations using Scala, Play framework, and Postgres Slick Project Setup We must install the SBT command-line tool (at least JDK 8). This Project uses SBT version 1.6.2 to install Play Framework version 2.8.1 and the Postgres database. Now you need to download the hello word template in play scala. Run ‘ sbt new playframework/play-scala-seed.g8’ Continue Reading
Reading Time: 3 minutes Postgre without a doubt is one of the most popular databases in the market. The reason behind this is speed, security, and robustness. One of the reasons for its popularity is that it has many amazing features. In this blog, we are going to discuss one of its important features which is hstore. Here we will see how we can retrieve data from hstore column. Continue Reading
Reading Time: 2 minutes Postgre without a doubt is one of the most popular databases in the market. The reason behind this is PostgreSQL’s speed, security, and robustness. PostgreSQL isn’t just a relational database. PostgreSQL invented many post-relational concepts like in-database functions and user-defined datatypes. Other than that it has many amazing features like Hstore. Now, this blog is for you if you want to know about PostgreSQL Hstore. Continue Reading
Reading Time: 3 minutes In this blog, we will se how we can deploy Keycloak with Postgres database on kubernetes here, Postgres database is to persist keycloak data. Without Postgres Keycloak will use it’s internal embedded databse H2. Keycloak is an open-source Identity and Access management application. It can be used for authentication applications and it has many providers like google to provide sign-in from your google account. It Continue Reading
Reading Time: 4 minutes We are aware that PostgreSQL is one of the most popular and powerful databases in the market. Its amazing features and support from large developer communities always make a difference in the industry. Now, this blog is for you if you want to get familiar with the basic concepts of Postgre SQL. This blog will cover the basic CRUD operation (Create Read Update Delete) in Continue Reading
Reading Time: 3 minutes We are living in the 20th century the century of technologies. Because of this, we come across a lot of data in our daily life. So it is important for us to have a database that can help in maintaining a huge amount of data. Now we have many popular databases in the market like PostgreSQL, Cassandra, MySQL MongoDB, and many more. But the question Continue Reading
Reading Time: 4 minutes In this blog. We will discuss how we can migrate the Keycloak H2 database to Postgres on production or for the new server. Follow stepwise instructions to migrate the Keycloak H2 database to Postgres. Introduction – Migrate Keycloak Keycloak: is open source identity & access management software. It provides many services for authentication and security. H2 database: H2 database in-memory java-based relational database for keycloak. Continue Reading
Reading Time: 4 minutes PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. Hello, folks! your wait is over, we have come up with a new blog. In this blog, we will discuss how we can incorporate the Postgres database using Rust programming language with the help of a sample example. I Continue Reading
Reading Time: 3 minutes Hello everyone, in this blog we are going to learn how to do a structured streaming in spark with kafka and postgresql in our local system. We will be doing all this using scala so without any furthur pause, lets begin. Setting up the necessities first: Dependencies Set up the required dependencies for scala, spark, kafka and postgresql. 2. PostgreSQL setup Lets start fresh by Continue Reading
Reading Time: 4 minutes As you may know in all the versions up to PostgreSQL 10, it was not possible to create a procedure in PostgreSQL. In PostgreSQL11, PROCEDURE was added as a new schema object which is a similar object to FUNCTION, but without a return value. Over the years many people were anxious to have the functionality and it was finally added in PostgreSQL. Traditionally, PostgreSQL has provided all Continue Reading
Reading Time: 4 minutes In this blog post I’ll try to explain the process wherein you can stream data directly from PostgreSQL database using Scala Slick (which is Scala’s database access/query library) and Akka Streams (which is an implementation of Reactive Streams specification on top of Akka toolkit) in Play Framework. The process is going to be pretty straightforward in terms of implementation where data is read from one Continue Reading
Reading Time: 6 minutes Hello Folks, As we know about Neo4j, it pulls out developers life from the trouble and black & white screen of the databases. It doesn’t give freedom from the old databases also provides best support with it’s predefined procedures. As we know that in the Relational Database, Procedure provide advantages of better performance, scalability, productivity, ease of use and security and Neo4j also provides some Continue Reading
Reading Time: 2 minutes Few days ago, I had a scenario, in which I had to insert scala collection into postgreSQL using Slick. My postgreSQL table has some columns with data types such as Arrays, hstore etc.. I tried to do this using slick, but didn’t get success. After beating my head whole day, I found a solution. I found a slick extension slick-pg, which supports following postgreSQL types:- Continue Reading