The Joy of Hex

Drunken Monkey Coding Style with a hint of Carlin humor

Mar 28, 2017 - 2 minute read - Docker Haskell ERD

Running ERD in docker

Recently we started developing a new system on a project, and I needed to create the Entity Relationship Diagram. This time I wanted something simple, where I could just type it out, and the utility would spit out the file in format I need.

After some search I found this interesting tool called ERD, it was written in Haskell, and it seemed to do just what I wanted.

Jun 7, 2016 - 5 minute read - CI TravisCI GitHub

Adding GitHub token to Travis CI configuration

We are using Travis CI for our projects, and as we are using PHP a lot, and as great as composer is, constantly pulling in the full source for dependencies it can become tedious when you are constantly building and running tests (yes yes, I know I can limit the branches which are run). Luckily for us, composer provides a nice --prefer-dist option that will download the distribution package/zip that can save you a lot of time.

May 9, 2016 - 3 minute read - Databases Diagrams Graphs

Introducing ERDammer

Lately I have been looking into tools that can help us generate Entity Relationship Diagrams from database schema of any RDBMS (provided there is a driver), and to create some kind of editable format that can be then integrated with rest of the documentation and transformed by Sphinx to html. Needles to say the options were sorely lacking, they either fell short of my requirements or they required java to be installed, or both. So in a moment of idleness, my mind decided to build a playground… Again.

Apr 30, 2016 - 5 minute read - MySql

MySql default timezone

So lately we have been hitting some interesting egde cases (at least to us) while using the MySql on RDS and in local when using the CONVERT_TZ functions. If we executed the following query on production database 1 mysql> SELECT DATE(CONVERT_TZ(FROM_UNIXTIME(1456479303), "+00:00", "America/New_York")); The result would be the desired date 1 2 3 4 5 6 +---------------------------------------------------------------------------+ | DATE(CONVERT_TZ(FROM_UNIXTIME(1456479303), "+00:00", "America/New_York")) | +---------------------------------------------------------------------------+ | 2016-02-26 | +---------------------------------------------------------------------------+ 1 row in set (0.