lbbedendo

#Installing GraalVM with SDKMAN (https://sdkman.io/)
sdk install java 19.2.1-grl

#Installing build tools (C development environment)
sudo apt install build-essential libz-dev zlib1g-dev

#Configuring GraalVM environment variable
#1. Edit global environment file
sudo vim /etc/environment

lbbedendo

--Challenge: Get the last payment of customer with status = 'CO'

--DDL
CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
);
CREATE TABLE `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

lbbedendo

#Set vim as the default editor (don't forget to check if vim is installed)
git config --global core.editor "vim"

#Disable pager.branch configuration
git config --global pager.branch false

#Set user and email
git config --global user.name "John Doe"
git config --global user.email [email protected]

lbbedendo

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

lbbedendo

----------------------------------------------------------------------------------------------------------------------------------
Converting a series of jpeg images to a mp4 video:

ffmpeg.exe -f image2 -r 3 -i %06d.jpeg -r 15 -vcodec mpeg4 -s 352x240 Camera-0.avi

-f image2 => input format
-r 3 => input framerate
-i %06d.jpeg => input mask (files must be named sequencially, with 6 digits. Ex: "000000.jpeg", "000001.jpeg", "000002.jpeg", etc)
-vcodec mpeg4 => video output codec 
-s 352x240 => resolution