Wysmedia.com

As we know, Hibernate Query Language or using GORM are not enough, for example if we want to create complex queries or using native sql functions ie. date() function in MySQL. That’s why we need to use Groovy SQL to achive that.

Read the rest of this entry »

Here is a little tips to let grails create using innodb engine on mysql, everytime grails create a domain/table.

1
2
3
4
5
6
7

 dataSource {
      pooled = true
      driverClassName = "com.mysql.jdbc.Driver"
      username = "wysmedia"
      password = "password"
      dialect = org.hibernate.dialect.MySQLInnoDBDialect
 }

dialect = org.hibernate.dialect.MySQLInnoDBDialect that’s the main idea to set mysql using innodb. With InnoDB you can use service transaction or database transaction

Liquibase is the powerful database migration that available for free. For long time I am envy of rails database migration system. It is nice and have rich features.

Few weeks ago, I found that Grails has Liquibase plugin (there are 2, liquibase and autobase). I tried both plugins and autobase won my heart because the simplicity they offer (not using XML is the biggest advantages, for me at least). Liquibase however build as stand alone java application that you can run with any operating system that support java.

Here I will show you how to configure and using Liquibase on command line, so you can apply whether you are using php, python, or others programming language/framework

Read the rest of this entry »