February 19th, 2021: What did you learn this week?

I used GitHub Actions for the first time - sooo easy and good! Why have I not used this before?!

I’ve played with ClickHouse — it’s a fast open-source analytical column-based database, and by fast I mean BLAZINGLY FAST. It’s also very developer-friendly: for example, It has something like REPL on its website that you can instantly try and use. And I actually wrote a guide about building an analytical dashboard with ClickHouse! Here it is:

Building ClickHouse Dashboard and crunching WallStreetBets data 💸🤑

Igor Lukanin ・ Feb 19 ・ 13 min read

#webdev #database #javascript #tutorial

I've been playing around with repl.it since I found out you can use it to deploy web servers. This means that is basically like a "full stack codepen".

I learned how to setup a tiny web server with 6 lines of code*.

(*) not counting the dependencies.

// index.js

const router = require('find-my-way')();
const static = require('serve-handler');

const assets = (req, res) => static(req, res, {'public': './public'});

router.on('GET', '/hello', () => 'Hello!');
router.on('GET', '/*', assets);

module.exports = (req, res) => router.lookup(req, res);

And 1 command.

node_modules/.bin/micro -l tcp://0.0.0.0:3000 index.js

Ok, technically you need to install things first. That'll be 2 commands.

npm install micro@9.3.4 serve-handler@6.1.3 find-my-way@4.0.0

There you have it a (useless) web server with a fully functional router and capable of handling static assets. Here's a more exciting example in repl.it: micro-quote-machine.

I'm slowly but surely getting my head around WebGL. I've been using 2d context for a while but needed to do some equirectangular projection maths, which was painful on the cpu, and foolishly thought, 'how hard can it be?'.

I had used location service in my own Android app using Java.
And I had completed 100 Problem solved in LeetCode and I'm really happy for that :)

I did my first Dockerfile 👌💪

I've converted existing VueJS SPA into Android apps with CapacitorJS. The guides was easy to follow and the application is working good. Just need to change the icons and enable camera for file upload.

How to create buffers and splits in Vim. I made some notes on my findings in my TIL repository here.

I learned how to do manage files with Flask and also how to use some JS APIs.

My two completed projects are:
code-crystals.tk
irisor.cf

Learning vuex and socket.io #todayilearn