The Joy of Hex

Drunken Monkey Coding Style with a hint of Carlin humor

Deleting keys with wildcards in Redis

Sep 28, 2016 - 2 minute read - RedisLuaPHP

So, for you who don’t know Redis is an open source (BSD licensed), in-memory data structure store, used as database, cache and message broker Or to put it simply, it is a Key/Value Store and so much more You have different data structures, that are efficient and great and all, that are at the end of the day identified by their keys, and this is where my problem begins. I have some 100k+ hashes in redis with keys in the form of yer:key:harry:xxxyyzz.

Adding GitHub token to Travis CI configuration

Jun 7, 2016 - 5 minute read - CITravisCIGitHub

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.

Connecting JetBrains DataGrip to Redshift

May 14, 2016 - 3 minute read - DatabasesToolsDataGrip

Last few weeks I have been working with DataGrip, a latest offering from JetBrains that is marketed as “Your Swiss Army Knife for Databases and SQL” and in my use case it most certainly turned to be true. I needed to connect to Amazon Redshift, for those of you who do not know, Redshift is what happened when Amazon took a PostgreSQL 8.0.2 and mutated it into “Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools”, yet it does not support indexes afaik, and has a rather lengthy list of unsupported functions etc.

Introducing ERDammer

May 9, 2016 - 3 minute read - DatabasesDiagramsGraphs

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.

MySql default timezone

Apr 30, 2016 - 5 minute read - MySql

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.

MySql database statistics

Apr 19, 2016 - 4 minute read - MySql

One of the projects we are involved with has a data store in RDS, recently I had to figure out the size of the tables and one of the databases. As RDS does not report this diectly, I had to dig through some internet to get my answers, and this post is the result, having all the queries in one place, so next time I need it, I can find it with ease.