It’s like Forkable Medium + Jupyter and Colab + JS Playground with preinstall data libs + Github (and Team for paid version).

Image for post
Image for post
https://observablehq.com/@katopz/hello-bigquery-and-vega-lite-api

TLDR

Here’s example for fetch BigQuery COVID-19 public data and plot it with vega-lite in Observable, Enjoy!

To follow me on Observable you can use RSS/feed

Image for post
Image for post
RSS via feedly

More to come!

PS : I feel like medium is useless for me now, there’s more fun there ;)


It’s 2020 now, everything should be easier right? let’s try!

Prerequisites

This is fresh install, you can skip some if its already installed

# Install brew
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

# Optional ensure up to date
brew update && brew upgrade

# Install Git
brew install git

# Optional IDE VSCode
brew cask install visual-studio-code

2. Install dotnet with brew

brew cask install dotnet-sdk
Image for post
Image for post

3. Try examples (This take some time to pull)

git clone git@github.com:dotnet/samples.git
cd samples/core/getting-started/golden

4. Open vscode (optional)

See Visual Studio Code on macOS

code .

5. Create console app

dotnet run -p app/app.csproj
It was not possible to find any compatible framework version
The framework 'Microsoft.NETCore.App', version '2.2.0' was not found.
- The following frameworks were found:
3.1.3 at [/usr/local/share/dotnet/shared/Microsoft.NETCore.App] …


This should be easy task but there is not! It seem like Blender 2.81 not go easy with import texture for some reason.

Problem

Texture has been ignore for some reason, and googling about it didn’t seem to help that much.

Solution

  1. Change base color from color to use texture instead.
Image for post
Image for post

2. Just make sure you have texture image file for open.

Image for post
Image for post

3. Done!

Image for post
Image for post

Hope you guy save from COVID-19. I do stay save at home and hope i finish this game before “my death line” literally!.

Now it’s time for Prison Break! ;)


I want to create Fire effect for my game with threejs via React for my EdTech startup product which is a ML Game that will release pretty soon this year (so excite!)

Image for post
Image for post
Let it burn!

TLDR;

Problem

It’s outdated (2017) and not working.

Solution

Migrate to threejs 0.114.0 and also with React 16.13.0

Source

Until next time!


It’s working as expected at first export, but suddenly took me a day to resolve this! So I will log it down here just in case I forget the combination.

Image for post
Image for post
Give my day back!

Problem #1

You will have “cut off” animation issue if your animation is more than 250 frames (mine is 291)

Image for post
Image for post
end at 250!? where is my 291

Solution #1

  1. Go to Object Data Properties (as shown in bottom left of picture)
  2. Make it End at your animation keyframe length (mine is 291)
  3. At export option, click to expand Animation setting and uncheck “Always Sample Animations”

Problem #2

You can’t see keyframe

Image for post
Image for post
I don’t get this!

And when I try press “i” for menu then select “Visual LocRotScale”

Image for post
Image for post
I’m lost…

Solution #2

  1. Delete unused Rig. …


Finally I got some task for a Data Engineer sake, Yeah! I’ve to import a backup file from MSSQL Tape file format (which appear to be obsolete pretty soon LOL) to Dataprep as CSV.

Image for post
Image for post
Poor tape file ;p

I will follow below guide to achieve my task.

But I will summarize in my own version. Because it’s not working LOL

Prerequisites

  1. Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
  2. MSSQL Server : I will use it via Docker container
docker pull microsoft/mssql-server-linux
Image for post
Image for post
Waiting…,If stuck try other hotspot!

3. Homebrew (for install SQL Server Command Line Tools for…


Video paused. Continue watching? dialog is super annoying! Here’s how I get rid of it.

Image for post
Image for post
STOP ASKING!

TLDR

R

Yes!

How it work?

  1. Watch for dialog, If “Yes” exist just click it programmatically. — This approach won’t work when window is not focus due to a DOM event for rendered not trigger and also click action is not perform properly.
  2. Watch for paused event, then perform play programmatically. — This work all the time so we also have to watch a mouse movement event for “intended” pause otherwise it will play (only pause from Youtube will trigger not from human click)

You can copy and paste in your browser console and run it or download google chrome extension here (no spam I do use it too!) …


Let’s get Stellar public key suffix as we want with Golang!

Image for post
Image for post
XCAT for CAT coin

TLDR;

  1. Install Golang with Homebrew
# Set path
export GOPATH="${HOME}/.go"
export GOROOT="$(brew --prefix golang)/libexec"
export PATH="$PATH:${GOPATH}/bin:${GOROOT}/bin"
test -d "${GOPATH}" || mkdir "${GOPATH}"
test -d "${GOPATH}/src/github.com" || mkdir -p "${GOPATH}/src/github.com"
# No brew? try this
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
# Now we brew
brew install go

2. Get the source

go get -u github.com/octofoxio/stress

3. Find public key that end with “XLOL”

stress -p XLOL
Image for post
Image for post
LOL coin! LOL

Done!


I just got new toy! Let’s boot it up shall we?

Image for post
Image for post
NVIDIA Jetson Nano

Follow this guide…

Or follow me if you choose to install via macOS console.

  1. Write Image to the microSD Card (>32GB) with Jetson Nano Developer Kit SD Card Image
  2. Run below commands step by step,
    📌 First command will tell you the disk number is (for me is “3”) which will need for next step (see the red mark in picture below)
    📌 “jetson-nano-sd-r32.2–2019–07–16.zip” will need to change to match what version you downloaded.
    📌 The last one took me~30 minutes!
diskutil list external | fgrep '/dev/disk'diskutil partitionDisk /dev/disk3 1 GPT "Free Space" "%noformat%" 100%/usr/bin/unzip -p ~/Downloads/jetson-nano-sd-r32.2-2019-07-16.zip | sudo /bin/dd of=/dev/rdisk3 bs=1m
Image for post
Image for post
Beware the red, it’s should match your end.

3. Insert microSD to Jetson Nano, Plug HDMI (to Jetson and monitor of course!) and microUSB …wait for booting…that’s it!

Everything seem to be working just fine! Let’s have fun with it!

Image for post
Image for post
https://developer.nvidia.com/embedded/twodaystoademo#hello_ai_world

Be right back! Have fun!


I just realized that my Google Cloud Professional Data Engineer Certification has been verified on the Blockchain. I’m so curious how it work so let’s take a look!

Step for verify

  1. Here’s live credential link for my certification.
Image for post
Image for post
https://www.credential.net/jqi4vjgg?key=34f36b0fcb2304c8bf61af64a10fdb1ec6029fdbdddfcc4d3a9a64305d64b596

2. Let’s use above link as input.

Image for post
Image for post
https://verify.accredible.com/input?type=link

3. Then get verified result.

Image for post
Image for post
verified page

4. Let’s Download the proof file

https://gist.github.com/katopz/51dce40c88a15a2632175e2ee876489f

5. And upload the json proof file here

Image for post
Image for post
https://chainpoint.org/demo/

6. Cool it’s valid!

Image for post
Image for post

That’s from user perspective which is simply enough

Behind the scene

It seem like Google use https://www.accredible.com to take care of certification service.

Image for post
Image for post
https://www.accredible.com

And here’s how magic work, Accredible use Cainpoint for Blockchain Verification

Image for post
Image for post
https://chainpoint.org/

How it work?

  1. Chainpoint links a hash of your data to a blockchain and returns a timestamp proof. …

About

katopz

DLT & ML Debugger

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store