Skip to main content

Doughnut I/O

Search This Blog

... and it was delicious

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Can you interpret this?

Lifted from www.themetapicture.com.

Logged on Doughnut I/O. U.E. 1339997854.

Design Geeks' Maths

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Serious Development on Chromebook Part 1 of 2

It has been several years that Google has attempted all cloud connected device/OS fiasco called ChromeBook and Chrome OS. Naturally, Doughnut is curious if we can do serious development on one such device. First, definitions! When I say "development" it is not logging-in to either one of cloud9 (https://aws.amazon.com/cloud9/), codenvy (https://codenvy.com) or codeanywhere (https://codeanywhere.com) and write "hello world" to call it a day. My definition of "development" is full-fledge Java, python, JavaScript and bash development (p.s. these are the languages I am using 99.999% of the time these days). Yes, I know C/C++ but I'm no longer using them except for occasional nostalgia. Again, novelty languages such as Kotlin and typescripts are not going to test as, for the former, if Java is running, it's running and, for the latter, I assume it is part of JavaScript. Now, let's get started. First order of business is to get a Chromebook. Th

It's not Michael Jackson and this is not Thriller

I have noticed a few musicians through YouTube ( Megan Nicole , DeStorm and Lindsey Stirling ). They even had performed together in some of their videos. Now Lindsey Stirling has done it again. A violin piece probably inspired by Late Michael Jackson's Thriller. Yet, "It's not Michael Jackson and this is not Thriller." [Run DMC]. Logged on Doughnut I/O. U.E. 1354163169.

Postgres Gotchas - the "pg_dump" and the "null" Value Fiasco

PostgreSQL has been my staple since the year starting at U.E. 1262304000. Back then, the cutting edge version was 8.3.x. Today, it is 12.x.x. Whatever. I learnt multiple lessons. I really loved the jump from platform-specific installed client to the web-based client. There was hiccups but, nowadays, we even dockerize the pg_admin client. What a breakthrough. Long story short, I did the following: SELECT L.A, R.B FROM TABLE_A AS A LEFT JOIN TABLE_B AS B USING (KEY_1, KEY_2, KEY_3); -- note that KEY_3 is all null in both tables I ended up with R.B is always null ! How come !? The answer is the way postgres is handling null value. In short, null = null evaluates to false. Let's move on to lesson number 2. It is pg_dump ignores -n (or --schema) parameter for data. According to the RTFM , -n is to specify the schema. However, it works only for the DDL of the dumps. The data portion, when there are two tables with the same name, it dumps the

Powered by Blogger

Copyright (c) 2012. Doughnut I/O. All rights reserved