Insights and perspectives to keep you updated.

Google Apps Script: Read Google Document as Template

Reading Time: < 1 minute DocsList services provides access to the document list This services provides access to the document list and the files and folders in the document list. we can create files, folders, and subfolders that appear in the document list. Here, we are going to read a Google Document as a template by Google Apps Script. Step 1: Create a Document: Create a document and write some Continue Reading

An alternate way to implement JOINs in MongoDB [Update]

Reading Time: 2 minutes I have updated this blog . As last description was creating some misunderstanding and lot of confusion . In one of my project , there was a requirement to generate report in .csv format from MongoDB without using any reporting tool and any language . I had to use only MongoDB query . In that report , I had to use multiple collection . Since Continue Reading

Play Framework 2.0: Generate TinyUrl With API

Reading Time: 2 minutes The Google URL Shortener at is a service that takes long URLs and squeezes them into fewer characters to make a link that is easier to share, tweet, or email. Steps to integrate with : Step #1 : Register App with Google Register your App with Google through the API Console.  When you create your application, you register it with Google. Google then provides information Continue Reading

Filter Query Results With Objectify

Reading Time: < 1 minute Objectify is a Java data access API specifically designed for the Google App Engine datastore. It is an easy way to use Google Datastore. In this blog we are going to filter a single attribute for multiple values. Now lets start with creating an entity. The first step is to define your entity class. Here is an example of employee. public class Employee { @Id Continue Reading

Google Apps Script : Connectivity with Google Cloud SQL Database that lives in Google’s cloud

Reading Time: 2 minutes Google Cloud SQL is a MySQL database that lives in Google’s cloud. It has all the capabilities and functionality of MySQL. Google Cloud SQL is easy to use, doesn’t require any software installation or maintenance and is ideal for small to medium-sized applications. Google Cloud SQL allows you to create, configure, and use relational databases that live in Google’s cloud. It is a fully-managed service Continue Reading

ATDD, ScalaTest, Cucumber and respecting DRY

Reading Time: 3 minutes In our last post we looked at how it was easy to use ScalaTest for doing acceptance testing. In a post prior to that, we had looked at doing the same with Cucumber. We had also concluded that though acceptance tests could be written in the way described however, there was an issue. Writing the feature files with individual features having multiple scenarios which would Continue Reading

Play Framework 2.0: Connectivity with MySQL in Scala

Reading Time: < 1 minute Welcome to another week of KnolX sessions .The emphasis in this session is on How to connect a Play Application with Mysql as database in Scala.Play includes a simple data access layer called Anorm that uses plain SQL to interact with the database and provides an API to parse and transform the resulting datasets. Entire code can be found here:

Google Apps Script: Create user interface using HTML/ CSS/ JavaSript

Reading Time: 5 minutes The Html Service in Google Apps Script provides ability to create and serve HTML output from a script. Scripts that create user interfaces with the Html Service can contain HTML, JavaScript, and CSS. Our scripts can display the user interface in the following three ways: As a stand-alone web app Embedded in a Site Directly from a Spreadsheet In this blog, we are going to Continue Reading

Akka Futures: Using For Comprehensions

Reading Time: 3 minutes In my previous post I discussed about composing Futures. I also discussed that Futures are monadic and they can be composed using map or flatmap. Since, for comprehension is just a sugar on top we can use it as well. Lets understand their usage in a bit more detail than my previous post. Using the same example of direct use of Futures and using a Continue Reading

Multi Project Builds with SBT 0.12 for Scala Project

Reading Time: 3 minutes In my last post Create Scala Project with SBT. We had seen how it was easy with SBT to create a Scala project. In this post,we will learn multi Project Builds with SBT for Scala project. It can be useful to keep multiple related projects in a single build. If they depend on one another and you tend to modify them together. Each sub-project in Continue Reading

PhoneGap : To build cross-platform mobile apps using HTML5, Javascript and CSS.

Reading Time: 3 minutes PhoneGap is an open source framework for quickly building cross-platform mobile apps using HTML5, Javascript and CSS. Building applications for each device–iPhone, Android, Windows Mobile and more–requires different frameworks and languages. PhoneGap solves this by using standards-based web technologies to bridge web applications and mobile devices. Since PhoneGap apps are standards compliant, they’re future-proofed to work with browsers as they evolve. The PhoneGap code was Continue Reading

ElasticSearch: How to index data in bulk in elasticsearch with scala using java Bulk API.

Reading Time: 2 minutes Elasticsearch is an open-source, restful, distributed, search engine built on top of apache-lucene.In this post, we will learn to use elasticsearch java api in Scala to index data using BulkRequest. we will begin with adding dependency of elasticsearch in the project. At the time 0.19.8 was the latest. The artifact is available on typesafe repository. Here is the snippet in build.sbt file. name := “ElasticSearchBulkproject” Continue Reading