TwitterFacebook

Art Of Code

Software and Data Science

blog, automation, software, scripting

Automating Video editing with programming knowledge

Many video editing tasks can be repetitive when applied frequently across different videos. In this blog post, we'll explore how to enhance videos by adding opacity transitions using Python and OpenCV.
Christian Páez
Christian Páez
2 min read
sql, hackerrank, writeups

HackerRank SQL preparation; Revising the Select Query II(MySQL)

Query the NAME field for American cities in the CITY table with populations larger than 120,000. The CountryCode for America is USA
Christian Páez
Christian Páez
1 min read
writeups, sql, hackerrank

HackerRank SQL Preparation: Revising the Select Query I(MySQL)

Query all columns for American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.
Christian Páez
Christian Páez
1 min read
sql, cheatsheet

The Ultimate SQL SELECT Cheat Sheet

SQL, with its vast array of commands and clauses, can be daunting to remember every detail. Here I will share a useful cheat sheet to write the most common SELECT queries.
Christian Páez
Christian Páez
3 min read
ctf, overthewire, bandit, writeups

Bandit Level 23 → Level 24

Welcome back, in this level we will learn some basics of privilege escalation by abusing cron jobs.
Christian Páez
Christian Páez
1 min read
ctf, overthewire, bandit, writeups

Bandit Level 22 → Level 23

In this level, we'll navigate through the uses of cron jobs and bash scripting to find hidden files on a linux system.
Christian Páez
Christian Páez
1 min read
ctf, overthewire, bandit, writeups

Bandit Level 21 → Level 22

Welcome back, to the Bandit challenges! In this level, we'll learn to exploit cron jobs and bashscript files.
Christian Páez
Christian Páez
1 min read
ctf, bandit, overthewire, writeups

Bandit Level 20 → Level 21

Welcome back tothe OverTheWire Bandit challenges. In this level, we encounter a scenario involving networking and data transfer.
Christian Páez
Christian Páez
1 min read
ctf, bandit, overthewire, writeups

Bandit Level 19→ Level 20

Greetings, Welcome back to the OverTheWire Bandit challenges. In this level, we are presented with a custom binary that has to be exploited to get secret information.
Christian Páez
Christian Páez
1 min read
ctf, writeups, overthewire, bandit

Bandit Level 18→ Level 19

In this level, we'll learn about SSH connections, command execution, and file retrieval.
Christian Páez
Christian Páez
1 min read
bandit, overthewire, ctf, writeups

Bandit Level 17 → Level 18

Greetings, Welcome back to the OverTheWire Bandit challenges. In this level, we're learning more about secure shell (SSH) and cryptographic keys.
Christian Páez
Christian Páez
1 min read
bandit, ctf, overthewire, writeups

Bandit Level 16→ Level 17

In this level of the OverTheWire Bandit challenges, we'll learn how to scan for open ports and establish an SSL connection to retrieve the flag for the next level.
Christian Páez
Christian Páez
1 min read