{{Latest Articles}}

PostgreSQL Fix Duplicates in Database

  • Ivan Ivanov
  • PostgreSQL
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

  • Ivan Ivanov
  • PostgreSQL
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

How to check Internet Speed via Terminal?

  • Ivan Ivanov
  • Linux
How to check Internet Speed via Terminal?

This is a short version (no root required) of speedtest-cli to output the Speedtest of your Server.
curl -s https://raw.githubusercontent.com/sivel/speedtest-cli/master/speedtest.py | python -
Output:
~$ curl -s https://raw.githubusercontent.com/sivel/speedtest-cli/master [...]

Read More