Some time ago I came across a weird situation. I had a piece of PHP code which behaved really strange. Since the…
Sometimes I end up with a serialized JSON stored in a relational database (or in a CSV file). It often contains data structures that are not easy to map to a relational/flat structure and their structure is not fixed by any means. Ad hoc querying of this sort of data is…
A week or two ago I started playing with OpenRefine and its integration with Keboola Connection. Couple years ago I remember playing with Google Refine and hitting some memory limits pretty easily, so it was about time to check it again. OpenRefine engine would be a great fit into our…
We all know that floats are evil. Yet, there are moments in life when even something very well known can stab you in the back.
We run all our R scripts in Docker. The interface between an R script and our environment is simple…