Quick bits and pieces that could save you a lifetime!

Enter passphrase for key '/Users/.../.ssh/id_rsa' SOLVED

November 05, 2019

Add the identity without using Keychain: Add the identity using Keychain:

Removing node_modules in all packages in lerna

May 07, 2019

Lerna lets you run commands and scripts in all packages, and it's sometimes necessary to perform scripts that remove certain files such as node_modules or .lock files. Use lerna exec: Using you…

Excluding node_modules in TSLint

March 18, 2019

Personally I think TSLint shouldn't look at anything inside of node_modules by default, however this is not the case out-of-the-box. For some libraries this can cause an issue, for instance when using…

Update OR Create function for Sequelize

March 18, 2019

A lot of times when creating records in a database, we'd like to know whether the record already existed, or at least partially did, and now we can add some more attributes to it. This is when a…

Pain-Free PostgreSQL Setup in Docker

February 22, 2019

Docker is cool! When using official Docker images, you can instantly have services up and running. A service that I use very often is PostgreSQL. It is a very powerful flavour of SQL, and thanks to…

Securely store credentials safely in iOS

February 20, 2019

If you're building an app chances are it requires some sort of authentication. Typically you would perform network calls an pass in a token that you've stored after login and it persists through the…

Get the number of rows in a table in SQL

February 20, 2019

Regardless of the flavour, SQL databases come with many useful aggregate functions that can come in handy and save many lines of code in your queries. One of these functions is the function. Here's…

Search by