Getting a remote PostgreSQL database backup via SSH tunnel

In this article I’m writing a way to retrieve a backup of a PostgreSQL database in a remote server when you have access to the server machine via SSH. This would come handy when you can’t directly connect to the database server from your local machine. For example, in a situation where the PostgreSQL server only listens to localhost for connections or there is firewall preventing you from accessing the database port on the server machine....

February 13, 2021 · Sinaru Gunawardena

An intro to Debugging

In this article I’ve gathered my thoughts to help developers to get better in debugging especially if they find debugging really hard. The article also lists a set of tools which will help them to debug efficiently and to improve their skills. Hopefully you will find some value in this article, if you are also looking for debugging advice. ...

July 20, 2020 · Sinaru Gunawardena

Sometimes you have to look back when debugging

Last week has been a firefighting week at work (i.e. debugging and troubleshooting). I’m writing this article to share my experience with debugging a system configuration at work. In the end of article, I have placed some lessons learned points so hopefully someone can learn from it to improve their career. ...

September 15, 2018 · Sinaru Gunawardena

Setting up xdebug with phpstorm

This guide provide a step by step details on how to set up phpstorm IDE to work with xdebug. Installing on Ubuntu In software search for xdebug and install. Add to the following xdebug settings to php.ini file Installing on Windows XAMPP First download xdebug and copy it into the extension folder. Copy the full path the extension. Add the following xdebug settings to php.ini file. php.ini file Install easiest xdebug for Firefox and specify the remote IDE key for Firefox...

December 30, 2014