Services

Go to Overview

 High performance systems Data strategy & Analytics Intelligence Driven Decisioning Platform strategy Blockchain Expert Services Academy, Audit & Consulting

Accelerators

Go to Overview

Platforms

KDP KDSP

Products

PremonR Studio9

TechHub

Akka Scala Rust Spark Functional Java Kafka Flink ML/AI DevOps Data Warehouse

Industries

Go to Overview

Travel

Retail Finance Healthcare Media and Publishing Consumer Internet Hi-tech & IOT

Insights

Go to Overview

 Case Studies Blogs Books community Resources OS contributions Webinars Knolx
CAREER
CONTACT US

postgreSQL

knoldus data-carbon

How To Create And Insert Data In Postgre Hstore

Studio-Scala, , , , , , , , , , ,

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

keycloak on kubernetes with postgres

How to deploy Keycloak with Postgres on GKE

Studio-DevOps, , ,

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

Let’s have a look at the PostgreSQL CRUD operation

Database, SQL, Studio-Scala, Tech Blogs, , ,

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

PostgreSQL OR APACHE CASSANDRA: WHICH ONE IS THE BETTER OPTION

Cassandra, Database, NoSql, SQL, Tech Blogs, , , , , , , , , , ,

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

keycloak

Migrate Keycloak H2 database to Postgres on Kubernetes

Studio-DevOps,

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

Incorporate Postgres with Rust

Database, Rust,

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

Streaming from Kafka to PostgreSQL through Spark Structured Streaming

Apache Kafka, Apache Spark, Studio-Scala, , , , ,

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

An Overview of the Stored Procedures in PostgreSQL

Database, ,

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

Streaming data from PostgreSQL using Akka Streams and Slick in Play Framework

Akka, Play Framework, Slick, SQL, Studio-Scala, , , , , ,

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

Neo4j Apoc : A Blessing For Developer

Studio-Scala, , , , , , ,

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

Easiest Way To Insert Scala Collection into PostgreSQL using Slick

SQL, Studio-Scala, , ,

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

Ready to gain a competitive advantage with Future Ready Emerging Technologies?

Let's Initiate a Partnership

OUR OFFERINGS

COMPANY

LEARN

CONNECT

Follow us Here:

Linkedin Youtube Twitter Facebook Slideshare Instagram
GPTW-footer-banner.png
clutch-global.png
ISO-27001-certification-small-1-1.png

Partners

knoldus-lightbend-white.png
knoldus-databricks-white-.png
knoldus-confluent-white.png
knoldus-docker-white.png
knoldus-hashiCorp-white.png
knoldus-ibm-white.png
knoldus-daml-white.png
knoldus-datastax-white.png
knoldus-kmine-white.png
knoldus-rust-foundation-white.png
knoldus-scala-white-1.png
knoldus-snowflake-white-1.png
Previous
Next
© 2022 Knoldus, Inc. All Rights Reserved.
Privacy Policy | Sitemap