May 2019

Once we have automated a VPS server backup, it is unavoidable the fact that we will have to delete older files after a certain number of days. To avoid deleting them manually (which means connecting to the server, which can become tiresome), one line can be written in one of the scripts you use for the backup.

The line is actually a find command with some advanced options:

find /mnt/directory/ -type f -mtime +4 -exec rm — {} \;

Explanation

• /mnt/directory/ – is obviously the path to the directory where the older n days files will be searched (replace the path to… read more +

TeX is considered by some to be the best solution for gathering text containing mathematical formulas, especially in the form of LaTeX and other templates.

LaTeX Text is a document preparation system that allows you to issue data using the TeX programming language. Leslie Lamport created LaTeX in 1984 at SRI International and over time became the primary method for TeX programming. Due to the capacity to plan in detail any matter and the publication of materials (articles, books, treaties, pamphlets), LaTeX is generally used in academia by mathematicians, engineers, and so on, but also in the business due to… read more +

Standard Query Language (SQL) is at the base of any relational database, including DB2 from IBM, Oracle, SQL Server from Microsoft and the MySQL open source database.

Although in theory it has been standardized for 20 years, its implementations range from a relational database management system (RDBMS) to another, which is why some of the skills are not easily transferable from one case to another. SQL is used in data manipulation in relational databases. With this structured query language, you can do various things: inserting data, querying, updating, deleting, modifying, and creating schemas. SQL has its origins in the relational… read more +