Skip to main content

Posts

Update Schema for Distributed Table in Citus/Partman

1. We need to consolidate with Partman Template 2. Remove old index and create new one
Recent posts

Pivot Query in Postgresql is much better than Pivot_Table in Pandas

Pivot Query in Postgresql select * from crosstab ( $$ SELECT anonymous_id, message_id , timestamp, key, value FROM pixels WHERE tenant_id = 2 AND pixels.timestamp >= '2019-10-19 10:41:03.254968' AND pixels.timestamp < '2019-10-20 10:41:03.254968' AND message_id = ANY(SELECT message_id FROM pixels WHERE tenant_id = 2 AND pixels.timestamp >= '2019-10-19 10:41:03.254968' AND pixels.timestamp < '2019-10-20 10:41:03.254968' AND key = 'event' AND value = 'init_banuba_success' ) AND (key = ANY(array['context.timezone','context.device.model','

DO KNOW vs DONT KNOW

== Jack of all trades, master of none == Sometime, we stop learning something and replicate what we know today for a very long time. By then, we classify ourselves as a worker rather than a professional person. After many failures, I recognized that what I DONT KNOW mostly affected consequence. The more we know what we DONT, the most likely we increase successful rate over time.

Non-Test vs Test Driven Developer in Golang

There's been a lot of debates on whether TDD is dead or not! I strongly believe that TDD is very essential in any serious Software Development endeavor, especially for any team which is currently embracing  MICRO-services architecture or might seek to transition to Micro-services later. TDD somewhat will drive you to work out better and better system design rather than just focus on increasing Code Coverage as a vanity metric. The more you aim to improve Testability and TDD compliance in every single piece of your software, the easier you can extend or modify any functionalities in your system. I'm gonna share some pieces of codes to help illustrate my points regarding how different they are in practiceLet's dive into those differences //Non-Test package client import ( "bitbucket.org/sakariai/sakari/proto" "go.elastic.co/apm/module/apmgrpc" "google.golang.org/grpc" ) type Volante struct { proto.VolanteClient conn