2 comments on “Streaming data from PostgreSQL using Akka Streams and Slick in Play Framework”

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


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…

2 comments on “KnolX: Understanding Spark Structured Streaming”

KnolX: Understanding Spark Structured Streaming


Hello everyone, Knoldus organized a session on 05th January 2018. The topic was “Understanding Spark Structured Streaming”. Many people attended and enjoyed the session. In this blog post, I am going to share the slides & video of the session. Slides: Video: If…

1 comment on “Knolx: Getting started with Presto”

Knolx: Getting started with Presto


Hi all, Knoldus has organized a 1-hour session on 8th September 2017. The topic was “Getting started with Presto”. Many people have joined and enjoyed the session. I am going to share the slides here. Please let me know if you…

0 comments on “SQL made easy and secure with Slick”

SQL made easy and secure with Slick


Slick stands for Scala Language-Integrated Connection Kit. It is Functional Relational Mapping (FRM) library for Scala that makes it easy to work with relational databases. Slick can be considered as a replacement of writing SQL queries as Strings with a…

0 comments on “Connecting To Presto via JDBC”

Connecting To Presto via JDBC


Hi Guys, In this blog we'll be discussing about how to make a connection to presto server using JDBC, but before we get started let's discuss what Presto is. What is Presto ? So, Presto is an open source distributed…

13 comments on “Best Practices for Using Slick on Production”

Best Practices for Using Slick on Production


Slick is most popular library for relational database access in Scala ecosystem. When we are going to use Slick for production , then some questions arise  like where should the mapping tables be defined and how to join with other…

6 comments on “Using Spark DataFrames for Word Count”

Using Spark DataFrames for Word Count


As we all know that, DataFrame API was introduced in Spark 1.3.0, in March 2015. Its goal was to make distributed processing of "Big Data" more intuitive, by organizing distributed collection of data (known as RDD) into named columns. This enabled both, Engineers…

4 comments on “Easiest Way To Insert Scala Collection into PostgreSQL using Slick”

Easiest Way To Insert Scala Collection into PostgreSQL using Slick


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,…