Clone or copy a mysql database
Let's go straight into the subject matter. Here are the steps to create a copy of a existing database. 1. Open mysql CLI $ mysql -u root -p 2. List…
Menu
How to renew Ubuntu letsencrypt certificate
My server hosts multiple HTTPS web sites and recently I had an issue with my letsencrypt renew service. I verified that my renew cronwas still there available on my server and it…
Firebird: How to use internal functions
Sometimes the functions exposed by firebird are not enough to satisfy our needs. Luckily we can create our own internal functions. Let's say you want to cast a potential numeric…
TypeScript: Creating subset types from existing interfaces
Typescript allows us to create subsets of existing interfaces. Let's take an example: You have a function that return IUser IUser has many fields among them name and lastName.…
Create a nginx reverse proxy
Sometimes we have to set up nginx behind a proxy either because we can't have multiple public ports open, or because we have complex micro service apps powering our application…
How to install and control nginx service on MacOS
Install nginx brew install nginx Update nginx conf nano /usr/local/etc/nginx/nginx.conf Service control commands // Start nginx nginx // Test nginx conf nginx -t // Expected test result output nginx: the…
Ubuntu Setup
Install Ubuntu GUI* *Graphical User Interface Setup droplet $ sudo apt-get update For XFCE4 GUI (Preferred in my case) $ sudo apt install xfce4 xfce4-goodies For Ubuntu Desktop GUID $…
Fixing GradleVersion for class: JetGradlePlugin
Recently I came across this message while opening an android project. After some searches I found that this was being caused by an incompatible gradle version. So, here's what I…
Fixing “This iPhone {{iPhoneVersion}}- is running iOS {{version}}, which may not be supported by this version of Xcode”
This is something that affects many iOS developers and it's caused by missing device support files for your iOS device, mostly because you updated your phone to a more iOS recent…
How much does it cost to power your eletronic device?
If you are reading this article that's because you want a quick answer. Let's go straight to it. How much as Kw/h costs in your region? Power is priced in…