A Sudoku Puzzle using Play! AngularJS and Bootstrap

by ⋅ Leave a Comment

I have been fascinated by the Sudoku puzzle. It has been my dream to build the sudoku puzzle all by myself. Learning Scala has helped me fulfill that easier.

I have used AngularJS to make it a single page application. Using Bootstrap from Twitter helped me make the page look prettier.

Then I used Heroku to deploy it in cloud. Here’s the link. Sudoku in Scala It may not be perfect, but I loved working on it. Learned a lot in the way.

I want to write how I developed this one day.

Using PostgreSQL with Play! framework

by ⋅ Leave a Comment

I am diving into Play! framework for Scala. While I’ve been working on MySQL all this time, I thought I’ll use a new database to learn Play! for Scala. Thats how I decided to use PostgreSQL. So, here’s how I got it setup.

1. Add Dependency project/Build.scala

val appDependencies = Seq(
      // Add your project dependencies here,
        "postgresql" % "postgresql" % "9.1-901-1.jdbc4"
    )

 2.  Configure database access in conf/application.conf

db.default.driver=org.postgresql.Driver
db.default.url="jdbc:postgresql://localhost:5432/YOUR_POST_GRE_SQL_DATABASE"
db.default.user=USERNAME
db.default.password=PASSWORD

3. Using evolutions

Evolutions help you propagate your schema changes easily to your database.  Its similar to migrations in Ruby on Rails. Each evolution script is a plain sql script. The file name goes as 1.sql, 2.sql and so on. Evolutions are placed under the  directoryconf/evolutions/<DATABASE_NAME>. Here is an example.

conf/evolutions/warehouse/1.sql

# --- !Ups

CREATE TABLE products (
	id serial primary key,
	name text,
	price float
);

# -- !Downs

DROP TABLE products;