Latest Articles
Permanently authenticating with Git repositories
#AWS #DockerOn Linux you can use the ‘cache’ authentication helper that is bundled with Git 1.7.9 and higher. From the Git documentation: This command caches credentials in memory for use by future git progra... Read more
20 May 2020 - less than 1 minute readPerforming large WordPress migrations
#wordpress #awsIn order to perform a migration, for example from a new Wordpress instance to the production one, the best tool currently is All-in-One WP Migration Plugin. However, this plugin has a paid limitati... Read more
20 Apr 2020 - less than 1 minute readInstall Docker and docker-compose on Amazon Linux
#AWS #DockerI often have to deploy an AWS instance running on Amazon Linux and using it to deploy Docker containers. As Amazon Linux don’t come with Docker preinstalled, you have to do it manually. Or even be... Read more
20 Mar 2020 - less than 1 minute readRename a Postgresql database
#database #postgresqlHere’s the procedure to rename a PostgreSQL database: Disconnect from the database that you want to rename and connect to a different database. Check and terminate all active connections to t... Read more
20 May 2019 - 1 minute readHow to duplicate a Postgresql database
#database #postgresqlIf you need to duplicate an existing Postgresql database, and possibly transfer ownership of the database objects to a new user, here’s how to do that in a quick way: -- First, I recommand getting... Read more
20 Apr 2019 - less than 1 minute readForcing ASMM component to shrink
#oracle #databaseHere’s the way to force the shared pool to shrink dynamically. Documentation states that ASMM can only increase shared pool, and can’t shrink. When the automatic shared memory management feature i... Read more
20 Mar 2019 - 2 minute readConvert FLAC to mp3 like a hacker
#system #linuxSo you need to convert a bonch of FLAC files to mp3 and your best search engine only recommands you online file converters that nobody trusts ore require a paid subscription to work. Don’t worry, ... Read more
20 Feb 2019 - less than 1 minute readHow to conduct a job interview
#managmentHere are some tips for conducting job interviews that I gathered and compiled when I started recruiting. Introduction Introduce yourself (we often tend to overlook that one, but I think it’s impo... Read more
20 Jan 2019 - 1 minute readHow to extract Oracle user DDL
#database #oracleIn some cases, you need to duplicate an Oracle user, along with all it’s privileges. Doing this manually can be tedious. Hopefully, we can use the data dictionary to extract the data we need and du... Read more
20 Feb 2018 - 1 minute readChange default schema on Postgresql
#database #postgresqlIn PostgreSQL, users can have many namespaces to resolve objects names. These are called schemas like in Oracle, and can be altered through the search_path variable. Here’s how to check current sea... Read more
20 Jan 2018 - less than 1 minute readRename all tables in a Postgresql schema
#database #postgresqlAfter a conversion usually done through AWS Database Migration Service, you may have a Postgresql database converted with table names in uppercase. These tables needs renaming, because you can’t ac... Read more
20 Dec 2017 - less than 1 minute readConfigure SSL Certificates on AWS EBS
#AWS #devopsElastic Beanstalk is a fantastic way to deploy and manage web applications. Today, for most web apps, you’ll need SSL certificates to encrypt data between users and your server. For this, we’ll use... Read more
20 Nov 2017 - 2 minute read