Blog

Performing large WordPress migrations

#wordpress #aws

In 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 limitation to 512MB. To get rid of the 512MB Upload Limit for the All-in-One WP Migration Plugin, you can download an older version 6.77 that doesn’t have th... Read more

20 Apr 2020 - less than 1 minute read

Install Docker and docker-compose on Amazon Linux

#AWS #Docker

I 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 better, through a script in the user-data section of your launch template. Here’s the script you’ll need to install the latest version of Docker and do... Read more

20 Mar 2020 - less than 1 minute read

Rename a Postgresql database

#database #postgresql

Here’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 the database that you want to rename. Use the ALTER DATABASE statement to rename the database to the new one. Let’s take a look at an example of re... Read more

20 May 2019 - 1 minute read

How to duplicate a Postgresql database

#database #postgresql

If 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 the size of the database to copy, as this might be important for the rest of the process. SELECT pg_database.datname,pg_size_pretty(pg_database_size(... Read more

20 Apr 2019 - less than 1 minute read

Forcing ASMM component to shrink

#oracle #database

Here’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 is enabled, the internal tuning algorithm tries to determine an optimal size for the shared pool based on the workload. It usually converges on this va... Read more

20 Mar 2019 - 2 minute read

Convert FLAC to mp3 like a hacker

#system #linux

So 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, there’s always a way, and even better, a true hacker style way to achieve this! This procedure works for MacOS through Brew, but you should be able t... Read more

20 Feb 2019 - less than 1 minute read

How to conduct a job interview

#managment

Here 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 important). Then ask a bout the job offer and the company. What did you liked about the job offer? What do you know about our company? Past experi... Read more

20 Jan 2019 - 1 minute read

How to extract Oracle user DDL

#database #oracle

In 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 dump it into a SQL file to modify and replay. Here’s how to do it: set head off set pages 0 set long 9999999 spool user_script.sql SELECT DBMS_METADA... Read more

20 Feb 2018 - 1 minute read

Change default schema on Postgresql

#database #postgresql

In 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 search path: SHOW search_path; /* Result search_path ------------------ "$user", public */ Usually it defaults to the username and public. So when yo... Read more

20 Jan 2018 - less than 1 minute read

Rename all tables in a Postgresql schema

#database #postgresql

After 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 access it unless you specify the table name between quotes, like so. Select count(*) from schema."MY_TABLE_NAME"; Otherwise the table are not found, ... Read more

20 Dec 2017 - less than 1 minute read

Configure SSL Certificates on AWS EBS

#AWS #devops

Elastic 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 Let’s Encrypt Certificate Authority which provides free SSL certificates and is supported by a wide array of browsers. To generate the certificate, ... Read more

20 Nov 2017 - 2 minute read

Intro to Ecto

#elixir

Ecto is the specific component for interacting with databases in the Elixir language. It supports mosts used database systems, the default being PostgreSQL, but Oracle, MySQL, SQLite, and MongoDB are also available. I recently started to work on Elixir for some project and here’s a short syntax sum-up for using Ecto in your web apps. # Auto cre... Read more

20 Oct 2017 - 1 minute read