Category Archives: sql

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 … Continue reading

Posted in database, Scala, Security, Slick, sql, Tutorial | Tagged , , , , , | Leave a comment

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 … Continue reading

Posted in big data, database, Java, Scala, sql | Tagged | Leave a comment

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 … Continue reading

Posted in Best Practices, database, rdbms, Scala, scalatest, Slick, sql, tests | 13 Comments

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 … Continue reading

Posted in apache spark, big data, Scala, Spark, sql | Tagged , , , , | 5 Comments

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

Posted in Scala, sql | Tagged , , , | 4 Comments