{{Latest Articles}}

Build Nginx with PageSpeed, Brotli, OpenSSL from Source

  • Ivan Ivanov
  • Nginx
Build Nginx with PageSpeed, Brotli, OpenSSL from Source

PageSpeed is a set of modules for NGINX and Apache which optimize and measure page performance of websites. Optimization is done by minifying static assets such as CSS and JavaScript, which decreases page load time. PageSpeed Insights is a tool that measures your site’s performance, and makes [...]

Read More

PostgreSQL Fix Duplicates in Database

PostgreSQL Fix Duplicates in Database

This usually happens when bringing a Site from Dev to Live. There is a easy fix for this though that has never let me down.
EG: Duplicates are in Table articles. We access PostgreSQL DB with psql database_name than we execute below to get rid of the duplicates. 
DELETE FROM articles [...]

Read More

Let’s Encrypt & Nginx. How-to Install & Configure

  • Ivan Ivanov
  • Linux
Let’s Encrypt & Nginx. How-to Install & Configure

SSL is an acronym for Secure Sockets Layer, a global standard security technology adopted by Netscape in 1994. SSL is designed to establish encryption and identity assurance. It enables encrypted communication between a web server and a web browser. Now it’s important have websites secured by SSL [...]

Read More

Optimizing and Repairing MySQL Databases with mysqlcheck

  • Ivan Ivanov
  • MySQL
Optimizing and Repairing MySQL Databases with mysqlcheck

MySQL Tables can crash quite easily, especially when your server unexpectedly shuts down or crashed, or when you're forced to copy data around when it's still being accessed. Luckily, there's a simple command to automatically check, repair and optimize all tables in all databases when you're running [...]

Read More

Dump PostgreSQL without Owner & Privileges

Dump PostgreSQL without Owner & Privileges

If you ever wanted to dump your PostgreSQL Development Database without the Owner and the Privileges, then you just need to run the following command:
pg_dump database_name -O -x > output_file

Read More