Author Archives: Aykut Akin

How to generate self-signed X.509 certificates for local development (Nginx)

This days, security and encryption is one of the most important topics and that’s why we need to have certain amount of knowledge about commonly used methods. TLS/SSL works by using a combination of a public certificate and a private … Continue reading

Posted in Linux | Tagged , , , , , , , , , | Leave a comment

Gpg – can’t connect to `/home/${USER)/.gnupg/S.gpg-agent’: No such file or directory

Recently, I got below error while I was trying to create new gpg key: can’t connect to `/home/aykut/.gnupg/S.gpg-agent’: No such file or directory gpg-agent[27029]: command get_passphrase failed: Operation cancelled gpg: cancelled by user gpg: Key generation canceled. One can think … Continue reading

Posted in Linux, Shell Script | Tagged , , , , , , , | Leave a comment

Oracle Null Safe Comparison (Spoiler alert: SYS_OP_MAP_NONNULL)

Even most experienced programmers are caught null comparison trap time to time. Let’s say we have two different customer tables and our business need is to find the customers that has the same first name, middle name and last name … Continue reading

Posted in Oracle | Tagged , , , , , , | Leave a comment

Git – Moving folders with history and all related branches

In my case, I had to move 2 different subfolders with their histories and all effected branches to the new bare repository. I had a folder structure like below: old repo |___ folder1 |___ folder2 |___ folder3 | |___ folder3_1 … Continue reading

Posted in Git | Tagged , , , , , | Leave a comment

Installation of Oracle SQL Developer to Ubuntu

First of all, you need to install Java in your environment. I will continue with the latest OpenJDK version currently available. Easiest method to install jdk is to write following commands to the terminal: And put below content inside of … Continue reading

Posted in Linux, Oracle, Shell Script | Tagged , , , , | Leave a comment

Getting result from database in shell script

In shell script, there is no standard way of connecting and retrieving result from database. But, for Oracle we can use SQLPlus to connect and run operations on database. I tried my codes on bash for this post and codes … Continue reading

Posted in Linux, Oracle, Shell Script | Tagged , , , , | Leave a comment

MySql UTF8 character set

MySQL database has two implementations for utf8 character set: utf8 (As of MySQL 4.1) utf8mb4 (As of MySQL 5.5) In this writing, I am going to explain the difference between these two character set and how you can store data … Continue reading

Posted in Java, MySql | Tagged , , , , , , , , , | Leave a comment