{%block content%}{%endblock content%}

@@ -82,7 +77,7 @@ - RSS + RSS
diff --git a/art/plt/index.html b/art/plt/index.html index 5b1c9e1..a283ffc 100644 --- a/art/plt/index.html +++ b/art/plt/index.html @@ -1,13 +1,13 @@ {%extends "base.html"%} {%block html_lang%}en{%endblock html_lang%} {%block head_title%}Index{%endblock head_title%} -{%block head_description%}My personal blog where I post about my thoughts, some how-to's, or general ranting.{%endblock head_description%} +{%block head_description%}My personal space where I post all my drawings, sketches and more art related stuff.{%endblock head_description%} {%block head_og%} - + {%endblock head_og%} @@ -15,7 +15,7 @@

Index -- {{config.title}}

- Welcome to my blog where I'll post whatever I please, ranging from rants to how-to's. Además, este pex va a estar en español e inglés porque quiero (no una mezcla en cada entrada, pero sí entradas completas en diferentes lenguajes). + Here is where I will post all of my drawings, sketches and more art related stuff. Right now this is managed similar to the blog, but more "gallery" oriented. The structure is kind of a 3-level zoom, where you see all the images in this index (or on a tag index), then you see the whole image in its separate link with additional information and then you can see the raw image itself.

diff --git a/art/plt/page.html b/art/plt/page.html index dbb2734..55a0c90 100644 --- a/art/plt/page.html +++ b/art/plt/page.html @@ -14,15 +14,19 @@ {%block content%}

+ +

+ + {{page.content}} + {%import "art_nav.html" as art_nav%} + {{art_nav.print(page, config)}} +

By {{page.author}}

Created: {{page.cdate}}

- {%if page.mdate is not none%} -

Modified: {{page.mdate}}

- {%endif%} +

By: {{page.author}}

Posted: {{page.cdate}}

{%import "tag_list.html" as tag_list%} {{tag_list.print(page.tags)}}

diff --git a/art/plt/page_list.html b/art/plt/page_list.html index bd1f678..8cdebd8 100644 --- a/art/plt/page_list.html +++ b/art/plt/page_list.html @@ -1,15 +1,22 @@ {%macro print(pages)%} -

Articles

+ {%for p in pages%} + {%if p.meta['tall'] is defined%} + {%if p.meta['wide'] is defined%} + {{art_entry.print(p, 'tall wide')}} {%else%} -

+ {{art_entry.print(p, 'tall')}} {%endif%} -

{{p.cdate_list}} - {{p.title}}

- {%endfor%} -

+ {%elif p.meta['wide'] is defined%} + {%if p.meta['tall'] is defined%} + {{art_entry.print(p, 'tall wide')}} + {%else%} + {{art_entry.print(p, 'tall')}} + {%endif%} + {%else%} + {{art_entry.print(p)}} + {%endif%} + {%endfor%} +

{%endmacro%} diff --git a/art/plt/rss.xml b/art/plt/rss.xml index 5ce541d..c119daf 100644 --- a/art/plt/rss.xml +++ b/art/plt/rss.xml @@ -7,9 +7,9 @@ {{config.title}} {{config.url}} - A personal weblog ranging from rants to how to's and other thoughts. + A personal collection of drawings, sketches and more art related stuff. en-us - Blog + Art Copyright 2021 David Luévano Alvarado david@luevano.xyz (David Luévano Alvarado) david@luevano.xyz (David Luévano Alvarado) @@ -19,7 +19,7 @@ https://validator.w3.org/feed/docs/rss2.html 30 - {{config.static_url}}/images/blog.png + {{config.static_url}}/images/a/default.png {{config.title}} {{config.url}} diff --git a/art/plt/tag.html b/art/plt/tag.html index d379590..f3d5999 100644 --- a/art/plt/tag.html +++ b/art/plt/tag.html @@ -1,18 +1,18 @@ {%extends "base.html"%} {%block html_lang%}en{%endblock html_lang%} -{%block head_title%}Posts filtered by {{tag[0]}}{%endblock head_title%} -{%block head_description%}Posts filtered by {{tag[0]}}{%endblock head_description%} +{%block head_title%}Art filtered by {{tag[0]}}{%endblock head_title%} +{%block head_description%}Art filtered by {{tag[0]}}{%endblock head_description%} {%block head_og%} - + - + {%endblock head_og%} {%block content%} -

Posts filtered by {{tag[0]}}

Art filtered by {{tag[0]}}

{%import "page_list.html" as page_list%} {{page_list.print(tag_pages)}} diff --git a/art/plt/tag_list.html b/art/plt/tag_list.html index 2dfb70c..b1d6f72 100644 --- a/art/plt/tag_list.html +++ b/art/plt/tag_list.html @@ -1,5 +1,5 @@ {%macro print(tags)%} -

Tags: {%for t in tags-%} {{t[0]}}{{", " if not loop.last else ""}} diff --git a/art/pyssgrc b/art/pyssgrc new file mode 100644 index 0000000..61d14d7 --- /dev/null +++ b/art/pyssgrc @@ -0,0 +1,10 @@ +SRC=src +DST=dst +PLT=plt +URL=https://art.luevano.xyz +STATIC_URL=https://static.luevano.xyz +DEFAULT_IMAGE_URL=/images/a/default.png +TITLE=Luévano's Art +DATE_FORMAT=%a, %b %d, %Y @ %H:%M %Z +LIST_DATE_FORMAT=%b %d +LIST_SEP_DATE_FORMAT=%B %Y diff --git a/art/src/.files b/art/src/.files new file mode 100644 index 0000000..1c79ca1 --- /dev/null +++ b/art/src/.files @@ -0,0 +1,7 @@ +a/test1.md 1622992153.6939147 0.0 digital,drawing,english +a/test3.md 1622992264.1187086 0.0 digital,drawing,spanish +a/test6.md 1622992329.1495857 0.0 digital,drawing,spanish +a/test5.md 1622992310.7793367 0.0 digital,drawing,spanish +a/test2.md 1622992244.2984438 0.0 digital,drawing,spanish +a/test4.md 1622992285.0989902 0.0 digital,drawing,spanish +a/elephant_octopus.md 1623005755.256314 0.0 black-white,digital,drawing,spanish diff --git a/art/src/a/elephant_octopus.md b/art/src/a/elephant_octopus.md new file mode 100644 index 0000000..4f632ff --- /dev/null +++ b/art/src/a/elephant_octopus.md @@ -0,0 +1,15 @@ +title: Elephant octopus +author: David Luévano +lang: es +image_url: images/a/elephant_octopus.png +summary: Dibujo en digital de una combinación de elefante y pulpo. +tags: drawing + digital + black-white + spanish + +El último dibujo que he hecho, justo para probar la tableta que me compré y de pasada usarlo para estrenar esta nueva sección de la página. + +Duré más de lo que hubiera querido y de hecho se nota que le fui bajando la calidad mientras más pasaba el tiempo, pero así nomás quedó. + +Como side note, debí haberlo *firmado*, pero la neta se me roló porque no estoy acostumbrado, así que ni pedo por el momento. diff --git a/blog/dst/a/linux_video_notes.html b/blog/dst/a/linux_video_notes.html deleted file mode 100644 index e495ed6..0000000 --- a/blog/dst/a/linux_video_notes.html +++ /dev/null @@ -1,199 +0,0 @@ - - - - - - - Linux tutorial video notes -- Luévano's Blog - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- - - -

- -

Linux tutorial video notes

- -

I was requested to make a summary of a video about basic Linux stuff (like the SQL tutorial video notes); this time, I did most of the notes depending on the topic since I’m familiar with most of the stuff presented in the video. The video in question is: The Complete Linux Course: Beginner to Power User!. Also, some notes were taken from Arch Linux Wiki since it’s got pretty decent documentation, and, of course, general googling.

(Basic) commands

A list of basic commands and small explanation (note that options are started with either - or --, depending on the program, but most of the time - is used for letter options and -- for word options, -l vs --list for example):

pwd: “print working directory”, full absolute path to the current directory.
cd: “change directory”, followed by the absolute or relative path of the directory to change to.
- Absolute path is started with /, while a relative path is started with ./ or just the name of the folder.
- Use .. (two dots) to go up one directory.
- An abbreviation of /home/username is ~ (tilde).
-
ls: “list” files and directories in current directory, or specify a directory from which to show the list after typing ls. Has many options, the most common ones being:
- l: use long listing format.
- r or reverse: reverse order while sorting.
- s: sort by file size, largest first.
- a or all: do not ignore entries starting with ..
-
mkdir: “make directory”, create a new directory with specified name.
touch: create new (empty) files.
cp: “copy” files or directories (using option r for recursive). Requires file/directory to copy and destination, separated by space.
mv: “move” files or directories, also requires file/directory to copy and destination, separated by space. This is also used to rename files/directories.
rm: “remove”, followed by a file to remove it.
rmdir: “remove empty directory”, followed by a directory to remove it. If the directory is not empty, use rm -r on the directory (“remove recursive”).
su: “switch user”, by default to root user, but another one can be specified.
sudo: “switch user, do”, similar to su, but only to execute a command as root or the specified user.
clear: clear the terminal window, a (common) keyboard shortcut is Ctrl + l.
find: search for files/directories matching a pattern or all contents of a directory (using .).
grep: comes from the ed command “g/re/p”, for searching plain-text for lines that match a regular expression (regex).
top: a task manager program, shows currently running commands and gives important info such as PID (process ID), user who is running that command, command name, cpu and ram usage, etc.. Some useful commands to manage programs running are:
- pgrep: get the PID of a running process, or a list in chronological order.
- kill or pkill: kill a running process either by PID or by name.
- killall: similar to pkill.
-
ssh: “secure shell” is a remote login client used to connect into a remote machine and executing commands remotely, basically taking control of the remote machine. Widely used when managing servers.
ftp or sftp: “(secure) file transfer protocol” used to transfer files from one machine to another one (usually a server). It’s recommended to use sftp instead of ftp because anyone can look through the packages if it’s not secured (encrypted).

And in general, to see the options supported by almost any command, use command -h or command --help, for a quick explanation. IMPORTANT: Most programs have man (manual) pages; to access them do man command, this is a very powerful tool to use.

Commands can be redirected to other commands (the output), which is powerful to create mini scripts or to achieve a goal in a single command. Most of the time the redirection can be done with the special characters >, < and most powerful, the | (pipe). Also, some commands accept an option to execute another command, but this depends on a command to command basis (exec option for find, for example).

Most terminal programs accept Ctrl-c or just q to exit the program.

File permissions and ownership

When listing files with ls -l, an output with file attributes (permissions) and ownership is shown, such as drwxr-xr-x 2 user group 4096 Jul 5 21:03 Desktop, where the first part are the attributes, and user and group the ownership info (all other info is irrelevant for now).

File attributes (drwxr-xr-x in the example above) are specified by 10 (sometimes 11) characters, and can be break into 4 parts (or 5):

The first character is just the file type, typically d for directories or just - for files. There is l too, which is for symlinks.
The next 3 characters represent the permissions that the owner has over the file.
Next 3 the permissions that the group has over the file.
Next 3 the permissions everyone else (others) have over the file.
An optional + character that specifies whether an alternate access method applies to the file. When the character is a space, there is no alterante access method.

Each of the three permission triads (rwx) can be:

- or r, for the first character, if the file can be read or directory’s content can be shown.
- or w, for the second character, if the file can be modified or the directory’s content can be modified (create new files or folders or rename existing files or folders).
- or x, for the third character, if the file can be executed or the directory can be accessed with cd. Other characters can be present, like s, S, t and T (for more: Arch Linux Wiki: File permissions and attributes).

To change attributes or ownership use chmod and chown, respectively.

Services

Special type of linux process (think of a program or set of programs that run in the background waiting to be used, or doing essential tasks). There are many ways to manage (start, stop, restart, enable, disable, etc.) services, the most common way (if using systemd) is to just use systemctl. Basic usage of systemctl is systemctl verb service, where verb could be start, enable, stop, disable, restart, etc. Also, to get a general system status run systemctl status or just systemctl for a list of running units (a unit is an instance of a service, or a mount point or even a device or a socket). For more: Arch Linux Wiki: systemd.

systemd also provides a way to do tasks based on a timer, where you can schedule from the second to the year. One could also use cron (using crontab with option e) to do this. These timers provide support for calendar time events, monotonic time events, and can be run asynchronously.

User and group management

Most mainstream linux distributions come with a Graphic User Interface (GUI) to manage users and groups on the system. For a Command-Line Interface (CLI) just use useradd (with passwd to create a password for a given user) and groupadd. Also, other useful commands are usermod, userdel, groups, gpasswd, groupdel and more, each used for a basic management of users/groups like modification, deletion, listing (of all existing users/groups), etc.. For more: Arch Linux Wiki: Users and groups.

Networking

Hosts file

Located at /etc/hosts, serves as a translator from hostname (web addresses or URLs) into IP addresses (think of DNS records), meaning that any URL can be overridden to make it point to whatever IP address it’s specified (only locally on the machine affected). The syntax of the file is pretty simple: first column for IP, second for hostname (URL) and third+ for aliases.

(Some) commands

These commands serve the sole purpose of showing information about the network and stuff related to it:

ping: gives information about latency to a given ip/domain.
ifconfig: gives similar information to ipconfig on windows, general info of physical network devices with their addresses and properties. An alternative could be ip addr, depending on the linux distribution being used and programs installed.
tcpdump: “transmission control protocol dump” gives information on all “packets” being sent and received through the network.
netstat: “network statistics” general statistics about network devices usage, display connections to the machine and more.
traceroute: shows the route that the packets go through (how the packets jump from one server to another one) when trying to access an IP (or, for example, a website).
nmap: “network mapper” explore network available hosts, opened ports, reverse DNS names, can guess the operating system of the device, it’s type, MAC address and more.

- -

By David Luévano

Created: Sun, Mar 14, 2021 @ 05:57 UTC

Modified: Fri, Jun 04, 2021 @ 07:59 UTC

Tags: -english, notes

- -

- - - - \ No newline at end of file diff --git a/blog/dst/a/shell_scripting_video_notes.html b/blog/dst/a/shell_scripting_video_notes.html deleted file mode 100644 index a2d0a47..0000000 --- a/blog/dst/a/shell_scripting_video_notes.html +++ /dev/null @@ -1,324 +0,0 @@ - - - - - - - Shell scripting tutorial video notes -- Luévano's Blog - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- - - -

- -

Shell scripting tutorial video notes

- -

Another summary, this time about shell scripting in general. And just like with the Linux notes, I also did most of the notes myself or with resources outside the video. The videos in question are: The Bad Tutorials (YT): Shell Scripting Tutorials and Automation with SCripting (YT): Complete Shell Scripting Tutorials. Also, some notes were taken from tutorialspoint: UNIX / LINUX Tutorial and general googling.

Basic concepts

A shell it’s an interface between the user and the kernel. While the kernel it’s the layer that interacts between the shell and the hardware. And you access the shell either via a terminal, or executing a shell script. Note that if you’re using a GUI environment, you need a terminal emulator to actually use a terminal (most Linux distros come with everything needed, so no need to worry).

When using a terminal a blank screen with some text and a cursor that shows you where to type will appear and depending on the shell being used (sh, dash, ksh, bash, zsh, fish, etc.) the prompt will be different. The most common one being of the form user@host:~$, which tells that the user is using host machine and the current working directory is ~ (can be /any/path/ too), and lastly, the $ shows the current privileges of the shell/user using the shell (a $ for normal user and # for root access).

To clear the screen use command clear or simply do Ctrl + l (most terminals let you do this) and to cancel or create a new prompt do Ctrl + c, this also cancels any running program that’s using the terminal (typing q when a program is running also stops the process, sometimes).

Also there are POSIX (portable operating system interface) compliant shells like sh, dash, ksh, etc., that have a standard syntax and are portable to any Unix system. Non POSIX compliant shells (or not necessary fully POSIX compliant) are bash, zsh, fish, etc., that provide a more modern syntax but lack speed on executing scripts.

Common commands/programs

A list of common commands or programs with a short description (for more, do man command or command -h or command --help):

man: an interface to the system reference manuals.
pwd: print name of current/working directory.
cd: change the working directory.
ls: list directory contents.
echo: display a line of text. Also, see escape sequences (Bash Prompt HOWTO: Chapter 2. Bash and Bash Prompts: 2.5. Bash Prompt Escape Sequences).
mkdir: make directories.
touch: change file timestamps (if no file exists, creates a new blank one).
cat: concatenate files and print on the standard output.
mv: move (rename) files.
rm: remove files or directories.
rmdir: remove empty directories.
cp: copy files and directories.
ln: make links between files (hard or soft, also known as symbolic).
umask: get or set the file mode creation mask.
chmod: change file mode bits (change file permissions).
chown: change file owner and group.
wc: print newline, word, and byte counts for each file.
file: determine file type.
sort: sort lines of text files.
cut: remove sections from each line of files.
dd: convert and copy a file (mostly used to make bootable USBs).
compress: compress data.
gzip, gunzip, zcat: compress or expand files.
uname: print system information.
cal: display a calendar.
date: print or set the system date and time.
read: read from standard input into shell variables (also used to read from a file).
tr: translate or delete characters.
readonly: set the readonly attribute for variables.
set: set or unset options and positional parameters.
unset: unset values and attributes of variables and functions.
expr: evaluate expressions.
tput, reset: initialize a terminal or query terminfo database (used for more complex terminal output).
grep, egrep, fgrep: print lines that match patterns (usually used to find text in a file or some text).
sleep: delay for a specified amount of time.
break: exit from for, while, or until loop.
continue: continue for, while, or until loop.
logname: print user’s login name.
write: send a message to another user.
mesg: display (or do not display) messages from other users.
return: return from a function or dot script.
exit: cause the sell to exit.

And some special “commands” or “operators” (for more: gnu: 3.6 Redirections):

| (pipe): used between two commands and the output from the command from the left serves as input to the command from the right.
>: redirects output to a file, overwriting the file (or creating a new file).
>>: redirects output to a file, appending to the file (or creating a new file).

Shell scripting

A shell script is nothing more but a file that contains commands in it; they’re executed in the same order they are present in the file. A shell script file is usually terminated with a .sh extension, independently of the shell being used, but it’s not 100% necessary as in Unix systems, an extension mean nothing, other than distinction (visually) between files. Then one can just have an extension-less file as a script. The script must have execution permissions (chmod +x file), unless shell script is executed in the terminal, where shell could be sh, bash, etc. Comments are created by prepending # to whatever the text should be a comment.

It’s common practice to have the first line as a she-bang (#!), which is just a comment telling the interpreter which shell to execute the script with (usable when having the script in your PATH so you only call the name of the script like any other command/program). A she-bang has the syntax #!/path/to/shell some_other_options, the most common she-bangs being: #!/bin/sh, #!/bin/bash, #!/usr/bin/python, etc.

Also, some people argue that you shouldn’t use absolute paths, since not all Unix operating systems have the same directory structure, or not all programs are going to be installed in the same folder. So a portable she-bang can be made by prepending /usr/bin/env and the specify the program to run, for example: #!/usr/bin/env bash.

Like always… the basic “Hello, world!” script:

#!/bin/sh
-echo "Hello, world!"
-

Three ways of executing this script (assuming the file name is hw):

Type in terminal sh hw.
Type in terminal ./hw. Requires the file to have execute permissions.
Type in terminal hw. Requires the file to have execute permissions. Requires the file to be in your PATH.

Variables

Variables are case sensitive, meaning that my_var and MY_VAR are different and a variable name can only contain letters and numbers (a-z, A-Z and 0-9) or the underscore character _. Can’t contain a space. Variables are called by prepending $ to the variable name.

Like in most programming languages, there are some reserved words like if, select, then, until, while, etc., that can’t be used as variables or as values of variables. For more: D.2 Index of Shell Reserved Words.

There is no need to specify a variable type. Anything surrounded by " will be treated as text. You can use booleans, numbers, text and arrays (the implementation of arrays depends on the shell being used). Make a variable readonly by calling readonly variable_name. Basic syntax:

Text variables: var="my var".
Numeric variables: var=123.
Boolean variables: var=true and var=false.
Arrays (assuming bash is the shell):
- var[0]=value1, var[...]=..., var[n]=valuen, etc.
- var=(value1 ... valuen)
- Access single values with ${var[index]} and all values with ${var[*]} or ${var[@]}.
-

There are special variables (for more. tutorialspoint: Unix / Linux - Special Variables):

$: represents the process ID number, or PID, of the current shell.
0: the filename of the current script.
n: where n can be any whole number, correspond to arguments passed to the script (command arg1 arg2 arg3 argn).
#: number of arguments supplied to the script.
*: all the arguments are double quoted.
@: all the arguments are individually double quoted.
?: exit status of the last command executed.
!: process number of the last background command.

When calling a script, you can pass optional (or required) positional arguments like: command arg1 arg2 arg3 argn.

Note that a variable can also take the output of another command, one common way to do this is using $(command) or `command`, for example: var="$(echo 'this is a command being executed inside the definition of a variable')" which, since the echo command is being run, var="this is a command being executed inside the definition of a variable", which doesn’t seem like much, but there could be any command inside $() or `command`. Note that this is not special to defining variables, could also be used as arguments of another command.

Internal Field Separator (IFS)

This is used by the shell to determine how to do word splitting (how to recognize word boundaries). The default value for IFS consists of whitespace characters (space, tab and newline). This value can ve overridden by setting the variable IFS to something like, for example, :.

Conditionals

Exit status

Any command being run has an exit status, either 0 or 1, if the command has been executed successfully or otherwise (an error), respectively.

`if` statement

Pretty similar to other programming languages, evaluates an expression to a true or false and executes code as specified. if statements can be nested, and follow normal rules of logical operations. Basic syntax is:

#!/bin/sh
-if expression
-then
-do_something
-elif another_expression
-then
-do_another_thing
-else
-do_something_else
-fi
-

The expression is usually wrapped around [] or [[]], the first being POSIX compliant and the second bash-specific (and other shells).

Also, some operators to compare things use == for “equals” and > for “greater than”, for example; while in a POSIX compliant shell, = for “equals” and -gt for “greater than” has to be used. For more operators: tutorialspoint: Unix / Linux - Shell Basic Operators (this also covers logical operators and file test operators).

Case statement

A common good alternative to multilevel if statements, enables you to match several values against one variable. Basic syntax is:

case $var in
-    pattern1)
-        do_something1
-        ;;
-    pattern2)
-        subpattern1)
-            do_subsomething1
-            ;;
-        subpattern2)
-            do_subsomething2
-            ;;
-        *)
-    pattern3|pattern4|...|patternN)
-        do_something3
-        ;;
-    patternM)
-        do_somethingM
-        ;;
-    *)
-        do_something_default
-        ;;
-esac
-

Where the * pattern is not necessary but serves the same purpose as a “default” case.

Loops

Loops enable execution of a set of commands repeatedly. Loops, naturally, can be nested. expression here (in the basic syntax examples) work the same as mentioned in the “if statement” section. For more: tutorialspoint: Unix / Linux - Shell Loop Types.

Loop control

Similar than other programming languages, there are loop controls to interrupt or continue a loop:

* `break` statement.
-* `continue` statement.
-

These statements accept an argument that specify from which loop to exit/continue.

`while` loop

Enables to execute a set of commands repeatedly until some condition occurs. Basic syntax:

#!/bin/sh
-while expression
-do
-    do_something
-done
-

`until` loop

Similar to the while loop, the difference is that the while loop is executed as long as a condition is true, but the until loop… until a condition is true. Basic syntax (similar to while loop):

#!/bin/sh
-until expression
-do
-    do_something
-done
-

`for` loop

Operates on lists of items. It repeats a set of commands for every item in a list. Basic syntax:

#!/bin/sh
-for var in word1 word2 ... wordN
-do
-    do_something_with_var
-done
-

Where var is the current value (word1, word2, etc.) in the loop and the expression after for can refer to an array, or the output of a command that outputs a list of things, etc.

`select` loop

Provides an easy way to create a numbered menu from which users can select options. Basic syntax (similar to for loop):

select var in word1 word2 ... wordN
-do
-    do_something_with_var
-done
-

Meta characters

Meta characters are used to execute several commands on a single line (depending on what it’s needed). The most used meta characters to accomplish this are semi-colon ;, double ampersand && and double “pipe” ||.

;: is used to finish one command (similar to some programming languages), after the command on the left of ; is finished (whatever the exit code is), the command on the right will be executed.
&&: similar to ;, but only if the command on the left exits with code 0 (success).
||: similar to &&, but for exit code 1(error).

Functions

Enable to break down the overall functionality of a script into smaller, logical subsections, which can then be called upon to perform their individual tasks when needed (like in any other programming language…). For more: tutorialspoint: Unix / Linux - Shell Functions. Basic syntax:

#!/bin/sh
-function_name () {
-    do_something
-}
-

Functions can also take arguments and can access their individual arguments (each function will have a different “storage” for their arguments). Functions can also be nested. Here exit will not only will finish the function code, but also the shell script that called it, instead use return plus an exit code to just exit the function.

- -

By David Luévano

Created: Sun, Mar 14, 2021 @ 05:57 UTC

Modified: Fri, Jun 04, 2021 @ 08:00 UTC

Tags: -english, notes

- -

- - - - \ No newline at end of file diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html deleted file mode 100644 index 69fb8e7..0000000 --- a/blog/dst/a/sql_video_notes.html +++ /dev/null @@ -1,261 +0,0 @@ - - - - - - - SQL tutorial video notes -- Luévano's Blog - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- - - -

- -

SQL tutorial video notes

- -

I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: SQL Tutorial - Full Database Course for Beginners, MySQL Tutorial for Beginners [Full Course] and Advanced SQL course | SQL tutorial advanced. Also, some notes were taken from w3schools.com’s SQL Tutorial and MySQL 8.0 Reference Manual.

What is a database (DB)?

Any collection of related information, such as a phone book, a shopping list, Facebook’s user base, etc.. It can be stored in different ways: on paper, on a computer, in your mind, etc..

Database Management Systems (DBMS)

A special software program that helps users create and maintain a database that makes it easy to manage large amounts of information, handles security, backups and can connect to programming languages for automation.

CRUD

The four main operations that a DBMS will do: create, read, update and delete.

Two types of databases

Relational (SQL)
- Organize data into one or more tables.
- Each table has columns and rows.
- A unique key identifies each row.
-
Non-relational (noSQL/not just SQL)
- Key-value stores.
- Documents (JSON, XML, etc).
- Graphs.
- Flexible tables.
-

Relational databases (RDB) (SQL)

When we want to create a RDB we need a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL) which is a standardized language for interacting with RDBMS and it’s used to perform CRUD operations (and other administrative tasks).

Non-relational databases (NRDB) (noSQL/not just SQL)

Anything that’s not relational, stores data in anything but static tables. Could be a document (JSON, XML, etc.), graph (relational nodes), key-value hash (strings, json, etc.), etc.

NRDB also require a Non-Relational Database Management System (NRDBMS) to maintain a database. But it doesn’t have a standardized language for performing CRUD and administrative operations like how RDB have.

Database queries

A DB query is a request that is made to the (R/NR)DBMS for a specific information. A google search is a query, for example.

Tables and keys

A table is composed of columns, rows and a primary key. The primary key is unique and identifies one specific row. Columns and rows are trivial, a column identifies a field and has a specific data type (name, email, birth) and a row identifies a table entry (person that contains a name, email and birth).

Also, there are foreign keys, it’s purpose is to relate to another database table; this foreign key is unique in it’s own table, but can be repeated where you use it as a foreign key.

It’s possible to use the same table keys as foreign keys to make relations inside the same table.

SQL basics

It’s actually a hybrid language, basically 4 types of languages in one:

Data Query Language (DQL)
- Used to query the database for information.
- Get information that is already stored there.
-
Data Definition Language (DDL)
- Used for defining database schemas.
-
Data Control Language (DCL)
- Used for controlling access to the data in the database.
- User and permissions management.
-
Data Manipulation Language (DML)
- Used for inserting, updating and deleting data from a database.
-

Queries

A set of instructions given to the RDBMS (written in SQL) that tell the RDBMS what information you want it to retrieve. Instead of getting the whole database, retrieve only a bit of information that you need.

Also, SQL keywords can be either lower or upper case, but it’s convention to use upper case. And queries are ended by a semi-colon.

Data types

Just some SQL data types (for more: MySQL 8.0 Reference Manual: Chapter 11 Data Types, the notation is DATATYPE(SIZE(,SIZE)):

INT: integer numbers.
DECIMAL(M,N): decimal numbers.
VARCHAR(N): string of text of length N.
BLOB: Binary Large Object, stores large data.
DATE: YYYY-MM-DD.
TIMESTAMP: YYYY-MM-DD HH:MM:SS.

Basic management of tables

To create a table, the basic syntax is CREATE TABLE tablename (column1 datatype constraint, column2 datatype constraint, ...), where a constraint could be (for more: MySQL 8.0 Reference Manual: 13.1.20 CREATE TABLE Statement):

NOT NULL: can’t have a NULL value.
UNIQUE: all values are unique.
PRIMARY KEY: uniquely identifies each row.
FOREIGN KEY: uniquely identifies a row in another table.
CHECK expresion: satisfy a special condition (expresion).
DEFAULT value: if no value is specified use value value.
INDEX: to create and retrieve data from the database very quickly.

Get the table structure with DESCRIBE tablename and delete it with DROP TABLE tablename. Add columns to the table with ALTER TABLE tablename ADD column DATATYPE(N,M), similar syntax to delete a specific column ALTER TABLE tablename DRORP COLUMN column.

Add entries to the table with INSERT INTO tablename VALUES(value1, value2, ...) where all the fields must be specified, or INSERT INTO tablename(column1, column2) VALUES(value1, value2) to just add some fields to the new entry. While at it, (all) the table content can be fetched with SELECT * FROM tablename.

Basic Updating of entries with UPDATE tablename SET expression1 WHERE expression2, where expression1 could be column = value2 and expression2 could be column = value1, meaning that the value of column will be changed from value1 to value2. Note that the expressions are not limited by column = value, and that the column has to be the same, it would be any expression. Also, this is really extensive as SET can set multiple variables and WHERE take more than one condition by chaining conditions with AND, OR and NOT keywords, for example.

ON DELETE statement

When an entry needs to be updated somehow based on a modification on a foreign key. If two tables are related to each other, if something is deleted on one end, update the other end in some way.

For example on creation of a table, on the specification of a foreign key: CREATE TABLE tablename (..., FOREIGN KEY(column) REFERENCES othertable(othertablecolumn) ON DELETE something). That something could be SET NULL, CASCADE, etc..

SELECT queries

Instead of doing SELECT * FROM tablename, which gets all the data from a table, more complex SELECT queries can be implemented, such as SELECT column FROM tablename to only get all data from one column of the table. Append LIMIT N to limit the query to N entries. Append WHERE condition to meet a custom condition.

Other statements that can be used in conjunction with SELECT are ORDER BY column ASC|DESC, SELECT DISTINCT, MIN(column), MAX(column), COUNT(column), AVG(column), SUM(column), LIKE and more. For more, visit MySQL 8.0 Reference Manual: 13.2.10 SELECT Statement.

MySQL uses regular expressions (regex) like pattern matching, some wildcards that can be used with the LIKE statement are:

%: zero or more characters.
_: a single character.
[]: any single character within the brackets.
^: any character not in the brackets.
-: a range of characters.

An extended regex can be used with the statement REGEX_LIKE(expression); REGEXP and RLIKE are synonyms for REGEX_LIKE. For more: MySQL 8.0 Reference Manual: 3.3.4.7 Pattern Matching.

Unions

A specialized SQL operator that is used to combine multiple SELECT statements into one. The basic syntax is SELECT ... UNION SELECT ..., where ... is a whole SELECT statement; there can be any amount of unions. There are some rules that apply when doing unions, such as having the same amount of columns on both statements and being of the same data type.

Joins

Used to combine rows from two or more tables based on a related column between them. Basic syntax is SELECT table1.column1, ..., table2.column1, ... FROM table(1|2) JOIN table(1|2) ON table1.common_column = table2.common_column, where the table specified in the FROM statement is called the “left” table, where the one in the JOIN statement is the “right” table. For more: MySQL 8.0 Reference Manual: 13.2.10.2 JOIN Clause.

There are different types of SQL JOINs:

(INNER) JOIN: returns records that have matching values in both tables.
LEFT (OUTER) JOIN: returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN: returns all records from the right table, and the matched records from the left table.
FULL (OUTER) JOIN: returns all records when there is a match in either left or right table.

INNER JOIN - LEFT JOIN - RIGHT JOIN - FULL OUTER JOIN

Nested queries

A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a SELECT query somewhere inside another one, for example SELECT ... IN (SELECT ...), where the nesting is occurring inside the parenthesis after the IN statement.

A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

Triggers

A block of SQL code that will define a certain action that will happen when a specific operation is performed on the database. It is recommended to change the DELIMITER temporarily from semi-colon to something else (since we need to use semi-colon to end the trigger) while the trigger is created. The basic syntax is CREATE TRIGGER trigername triggertime triggerevent ON tablename FOR EACH ROW triggerorder triggerbody. For more: MySQL 8.0 Reference Manual: 13.1.22 CREATE TRIGGER Statement and MySQL 8.0 Reference Manual: 25.3.1 Trigger Syntax and Examples.

Entity Relationship Diagrams (ERD)

When designing a database it’s important to define a database schema which is just a definition of all the different tables and their attributes that are going to live inside the database. So, basically, an ERD diagram is a diagram that consists of text, symbols and shapes that are combined to create a relationship model.

The diagram consists of:

Entity: a square with the name of the entity inside it.
Attributes: ovals with the name of the attributes inside it; an attribute defines specific pieces of information about an entity (columns).
Primary key: same as with attributes but with name underlined; the primary key uniquely identifies the entity.
Composite attribute: an attribute that consists on one or more (sub-)attributes.
Multi-valued attribute: oval with another oval inside it and the name of the attribute.
Derived attribute: dotted oval; this attribute can be derived from other attributes from the entity.
Relationship: a diamond with the relationship name in it, for the connections a single line (partial participation) or a doubled line (total participation); it denotes how two or more attributes are related to each other; all members must participate in the relationship.
Relationship attribute: denoted like a normal attribute, but it’s child of a relationship; it defines what attributes exists because of the relationship, it’s not stored in any of the entities related, but on the relationship object itself.
Relationship cardinality: denoted with a number on the line connecting the relationship to the entity; detones the number of instances of an entity from a relation that can be associated with the relation.
Weak entity: rectangle inside a rectangle with its name inside; it cannot be uniquely identified by its attributes alone.
Weak entity’s primary key: oval with its text underlined, but the line is dotted.
Identifying relationship: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.

ERD example taken from wikipedia

- -

By David Luévano

Created: Tue, Mar 02, 2021 @ 14:35 UTC

Modified: Sun, Jun 06, 2021 @ 03:41 UTC

Tags: -english, notes

- -

- - - - \ No newline at end of file diff --git a/blog/dst/index.html b/blog/dst/index.html index 9d127ed..c4b6a73 100644 --- a/blog/dst/index.html +++ b/blog/dst/index.html @@ -88,7 +88,7 @@

Tags: -english, notes, server, short, spanish, tools, tutorial, update

+english, server, short, spanish, tools, tutorial, update

@@ -103,9 +103,6 @@

Mar 21 - Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM

Mar 19 - Create a website with Nginx and Certbot

Mar 16 - Así es raza, el blog ya tiene timestamps

Mar 14 - Shell scripting tutorial video notes

Mar 14 - Linux tutorial video notes

Mar 02 - SQL tutorial video notes

February 2021

Feb 27 - This is the first blog post, just for testing purposes

diff --git a/blog/dst/rss.xml b/blog/dst/rss.xml index 31be916..3448fb7 100644 --- a/blog/dst/rss.xml +++ b/blog/dst/rss.xml @@ -13,9 +13,9 @@ Copyright 2021 David Luévano Alvarado david@luevano.xyz (David Luévano Alvarado) david@luevano.xyz (David Luévano Alvarado) - Sun, 06 Jun 2021 14:30:40 GMT - Sun, 06 Jun 2021 14:30:40 GMT - pyssg v0.5.5 + Sun, 06 Jun 2021 16:01:07 GMT + Sun, 06 Jun 2021 16:01:07 GMT + pyssg v0.5.6 https://validator.w3.org/feed/docs/rss2.html 30 @@ -683,448 +683,6 @@ systemctl restart nginx

Ya lo único que queda es cambiar un poco el formato del blog (y de la página en general), porque en un momento de desesperación puse todo el texto en justificado y pues no se ve chido siempre, entonces queda corregir eso. Y aunque me tomó más tiempo del que quisiera, así nomás quedó, diría un cierto personaje.

El ssg modificado está en mis dotfiles (o directamente aquí).

Por último, también quité las extensiones .html de las URLs, porque se veía bien pitero, pero igual los links con .html al final redirigen a su link sin .html, así que no hay rollo alguno.

]]> - - - Shell scripting tutorial video notes - https://blog.luevano.xyz/a/shell_scripting_video_notes.html - https://blog.luevano.xyz/a/shell_scripting_video_notes.html - Sun, 14 Mar 2021 05:57:34 GMT - English - Notes - Notes of videos about shell scripting, as requested by a mentor of mine. - Another summary, this time about shell scripting in general. And just like with the Linux notes, I also did most of the notes myself or with resources outside the video. The videos in question are: The Bad Tutorials (YT): Shell Scripting Tutorials and Automation with SCripting (YT): Complete Shell Scripting Tutorials. Also, some notes were taken from tutorialspoint: UNIX / LINUX Tutorial and general googling.

Basic concepts

Common commands/programs

A list of common commands or programs with a short description (for more, do man command or command -h or command --help):

man: an interface to the system reference manuals.
pwd: print name of current/working directory.
cd: change the working directory.
ls: list directory contents.
echo: display a line of text. Also, see escape sequences (Bash Prompt HOWTO: Chapter 2. Bash and Bash Prompts: 2.5. Bash Prompt Escape Sequences).
mkdir: make directories.
touch: change file timestamps (if no file exists, creates a new blank one).
cat: concatenate files and print on the standard output.
mv: move (rename) files.
rm: remove files or directories.
rmdir: remove empty directories.
cp: copy files and directories.
ln: make links between files (hard or soft, also known as symbolic).
umask: get or set the file mode creation mask.
chmod: change file mode bits (change file permissions).
chown: change file owner and group.
wc: print newline, word, and byte counts for each file.
file: determine file type.
sort: sort lines of text files.
cut: remove sections from each line of files.
dd: convert and copy a file (mostly used to make bootable USBs).
compress: compress data.
gzip, gunzip, zcat: compress or expand files.
uname: print system information.
cal: display a calendar.
date: print or set the system date and time.
read: read from standard input into shell variables (also used to read from a file).
tr: translate or delete characters.
readonly: set the readonly attribute for variables.
set: set or unset options and positional parameters.
unset: unset values and attributes of variables and functions.
expr: evaluate expressions.
tput, reset: initialize a terminal or query terminfo database (used for more complex terminal output).
grep, egrep, fgrep: print lines that match patterns (usually used to find text in a file or some text).
sleep: delay for a specified amount of time.
break: exit from for, while, or until loop.
continue: continue for, while, or until loop.
logname: print user’s login name.
write: send a message to another user.
mesg: display (or do not display) messages from other users.
return: return from a function or dot script.
exit: cause the sell to exit.

And some special “commands” or “operators” (for more: gnu: 3.6 Redirections):

| (pipe): used between two commands and the output from the command from the left serves as input to the command from the right.
>: redirects output to a file, overwriting the file (or creating a new file).
>>: redirects output to a file, appending to the file (or creating a new file).

Shell scripting

Like always… the basic “Hello, world!” script:

#!/bin/sh
-echo "Hello, world!"
-

Three ways of executing this script (assuming the file name is hw):

Type in terminal sh hw.
Type in terminal ./hw. Requires the file to have execute permissions.
Type in terminal hw. Requires the file to have execute permissions. Requires the file to be in your PATH.

Variables

Text variables: var="my var".
Numeric variables: var=123.
Boolean variables: var=true and var=false.
Arrays (assuming bash is the shell):
- var[0]=value1, var[...]=..., var[n]=valuen, etc.
- var=(value1 ... valuen)
- Access single values with ${var[index]} and all values with ${var[*]} or ${var[@]}.
-

There are special variables (for more. tutorialspoint: Unix / Linux - Special Variables):

$: represents the process ID number, or PID, of the current shell.
0: the filename of the current script.
n: where n can be any whole number, correspond to arguments passed to the script (command arg1 arg2 arg3 argn).
#: number of arguments supplied to the script.
*: all the arguments are double quoted.
@: all the arguments are individually double quoted.
?: exit status of the last command executed.
!: process number of the last background command.

When calling a script, you can pass optional (or required) positional arguments like: command arg1 arg2 arg3 argn.

Internal Field Separator (IFS)

Conditionals

Exit status

Any command being run has an exit status, either 0 or 1, if the command has been executed successfully or otherwise (an error), respectively.

`if` statement

#!/bin/sh
-if expression
-then
-do_something
-elif another_expression
-then
-do_another_thing
-else
-do_something_else
-fi
-

The expression is usually wrapped around [] or [[]], the first being POSIX compliant and the second bash-specific (and other shells).

Case statement

A common good alternative to multilevel if statements, enables you to match several values against one variable. Basic syntax is:

case $var in
-    pattern1)
-        do_something1
-        ;;
-    pattern2)
-        subpattern1)
-            do_subsomething1
-            ;;
-        subpattern2)
-            do_subsomething2
-            ;;
-        *)
-    pattern3|pattern4|...|patternN)
-        do_something3
-        ;;
-    patternM)
-        do_somethingM
-        ;;
-    *)
-        do_something_default
-        ;;
-esac
-

Where the * pattern is not necessary but serves the same purpose as a “default” case.

Loops

Loop control

Similar than other programming languages, there are loop controls to interrupt or continue a loop:

* `break` statement.
-* `continue` statement.
-

These statements accept an argument that specify from which loop to exit/continue.

`while` loop

Enables to execute a set of commands repeatedly until some condition occurs. Basic syntax:

#!/bin/sh
-while expression
-do
-    do_something
-done
-

`until` loop

#!/bin/sh
-until expression
-do
-    do_something
-done
-

`for` loop

Operates on lists of items. It repeats a set of commands for every item in a list. Basic syntax:

#!/bin/sh
-for var in word1 word2 ... wordN
-do
-    do_something_with_var
-done
-

Where var is the current value (word1, word2, etc.) in the loop and the expression after for can refer to an array, or the output of a command that outputs a list of things, etc.

`select` loop

Provides an easy way to create a numbered menu from which users can select options. Basic syntax (similar to for loop):

select var in word1 word2 ... wordN
-do
-    do_something_with_var
-done
-

Meta characters

;: is used to finish one command (similar to some programming languages), after the command on the left of ; is finished (whatever the exit code is), the command on the right will be executed.
&&: similar to ;, but only if the command on the left exits with code 0 (success).
||: similar to &&, but for exit code 1(error).

Functions

#!/bin/sh
-function_name () {
-    do_something
-}
-

]]> - - - Linux tutorial video notes - https://blog.luevano.xyz/a/linux_video_notes.html - https://blog.luevano.xyz/a/linux_video_notes.html - Sun, 14 Mar 2021 05:57:23 GMT - English - Notes - Notes of videos about basic Linux terms, usage and commands, as requested by a mentor of mine. - I was requested to make a summary of a video about basic Linux stuff (like the SQL tutorial video notes); this time, I did most of the notes depending on the topic since I’m familiar with most of the stuff presented in the video. The video in question is: The Complete Linux Course: Beginner to Power User!. Also, some notes were taken from Arch Linux Wiki since it’s got pretty decent documentation, and, of course, general googling.

(Basic) commands

pwd: “print working directory”, full absolute path to the current directory.
cd: “change directory”, followed by the absolute or relative path of the directory to change to.
- Absolute path is started with /, while a relative path is started with ./ or just the name of the folder.
- Use .. (two dots) to go up one directory.
- An abbreviation of /home/username is ~ (tilde).
-
ls: “list” files and directories in current directory, or specify a directory from which to show the list after typing ls. Has many options, the most common ones being:
- l: use long listing format.
- r or reverse: reverse order while sorting.
- s: sort by file size, largest first.
- a or all: do not ignore entries starting with ..
-
mkdir: “make directory”, create a new directory with specified name.
touch: create new (empty) files.
cp: “copy” files or directories (using option r for recursive). Requires file/directory to copy and destination, separated by space.
mv: “move” files or directories, also requires file/directory to copy and destination, separated by space. This is also used to rename files/directories.
rm: “remove”, followed by a file to remove it.
rmdir: “remove empty directory”, followed by a directory to remove it. If the directory is not empty, use rm -r on the directory (“remove recursive”).
su: “switch user”, by default to root user, but another one can be specified.
sudo: “switch user, do”, similar to su, but only to execute a command as root or the specified user.
clear: clear the terminal window, a (common) keyboard shortcut is Ctrl + l.
find: search for files/directories matching a pattern or all contents of a directory (using .).
grep: comes from the ed command “g/re/p”, for searching plain-text for lines that match a regular expression (regex).
top: a task manager program, shows currently running commands and gives important info such as PID (process ID), user who is running that command, command name, cpu and ram usage, etc.. Some useful commands to manage programs running are:
- pgrep: get the PID of a running process, or a list in chronological order.
- kill or pkill: kill a running process either by PID or by name.
- killall: similar to pkill.
-
ssh: “secure shell” is a remote login client used to connect into a remote machine and executing commands remotely, basically taking control of the remote machine. Widely used when managing servers.
ftp or sftp: “(secure) file transfer protocol” used to transfer files from one machine to another one (usually a server). It’s recommended to use sftp instead of ftp because anyone can look through the packages if it’s not secured (encrypted).

Most terminal programs accept Ctrl-c or just q to exit the program.

File permissions and ownership

File attributes (drwxr-xr-x in the example above) are specified by 10 (sometimes 11) characters, and can be break into 4 parts (or 5):

The first character is just the file type, typically d for directories or just - for files. There is l too, which is for symlinks.
The next 3 characters represent the permissions that the owner has over the file.
Next 3 the permissions that the group has over the file.
Next 3 the permissions everyone else (others) have over the file.
An optional + character that specifies whether an alternate access method applies to the file. When the character is a space, there is no alterante access method.

Each of the three permission triads (rwx) can be:

- or r, for the first character, if the file can be read or directory’s content can be shown.
- or w, for the second character, if the file can be modified or the directory’s content can be modified (create new files or folders or rename existing files or folders).
- or x, for the third character, if the file can be executed or the directory can be accessed with cd. Other characters can be present, like s, S, t and T (for more: Arch Linux Wiki: File permissions and attributes).

To change attributes or ownership use chmod and chown, respectively.

Services

User and group management

Networking

Hosts file

(Some) commands

These commands serve the sole purpose of showing information about the network and stuff related to it:

ping: gives information about latency to a given ip/domain.
ifconfig: gives similar information to ipconfig on windows, general info of physical network devices with their addresses and properties. An alternative could be ip addr, depending on the linux distribution being used and programs installed.
tcpdump: “transmission control protocol dump” gives information on all “packets” being sent and received through the network.
netstat: “network statistics” general statistics about network devices usage, display connections to the machine and more.
traceroute: shows the route that the packets go through (how the packets jump from one server to another one) when trying to access an IP (or, for example, a website).
nmap: “network mapper” explore network available hosts, opened ports, reverse DNS names, can guess the operating system of the device, it’s type, MAC address and more.

]]> - - - SQL tutorial video notes - https://blog.luevano.xyz/a/sql_video_notes.html - https://blog.luevano.xyz/a/sql_video_notes.html - Tue, 02 Mar 2021 14:35:11 GMT - English - Notes - Notes of videos about basic SQL syntax and usage, as requested by a mentor of mine. - I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: SQL Tutorial - Full Database Course for Beginners, MySQL Tutorial for Beginners [Full Course] and Advanced SQL course | SQL tutorial advanced. Also, some notes were taken from w3schools.com’s SQL Tutorial and MySQL 8.0 Reference Manual.

What is a database (DB)?

Any collection of related information, such as a phone book, a shopping list, Facebook’s user base, etc.. It can be stored in different ways: on paper, on a computer, in your mind, etc..

Database Management Systems (DBMS)

CRUD

The four main operations that a DBMS will do: create, read, update and delete.

Two types of databases

Relational (SQL)
- Organize data into one or more tables.
- Each table has columns and rows.
- A unique key identifies each row.
-
Non-relational (noSQL/not just SQL)
- Key-value stores.
- Documents (JSON, XML, etc).
- Graphs.
- Flexible tables.
-

Relational databases (RDB) (SQL)

Non-relational databases (NRDB) (noSQL/not just SQL)

Anything that’s not relational, stores data in anything but static tables. Could be a document (JSON, XML, etc.), graph (relational nodes), key-value hash (strings, json, etc.), etc.

Database queries

A DB query is a request that is made to the (R/NR)DBMS for a specific information. A google search is a query, for example.

Tables and keys

Also, there are foreign keys, it’s purpose is to relate to another database table; this foreign key is unique in it’s own table, but can be repeated where you use it as a foreign key.

It’s possible to use the same table keys as foreign keys to make relations inside the same table.

SQL basics

It’s actually a hybrid language, basically 4 types of languages in one:

Data Query Language (DQL)
- Used to query the database for information.
- Get information that is already stored there.
-
Data Definition Language (DDL)
- Used for defining database schemas.
-
Data Control Language (DCL)
- Used for controlling access to the data in the database.
- User and permissions management.
-
Data Manipulation Language (DML)
- Used for inserting, updating and deleting data from a database.
-

Queries

Also, SQL keywords can be either lower or upper case, but it’s convention to use upper case. And queries are ended by a semi-colon.

Data types

Just some SQL data types (for more: MySQL 8.0 Reference Manual: Chapter 11 Data Types, the notation is DATATYPE(SIZE(,SIZE)):

INT: integer numbers.
DECIMAL(M,N): decimal numbers.
VARCHAR(N): string of text of length N.
BLOB: Binary Large Object, stores large data.
DATE: YYYY-MM-DD.
TIMESTAMP: YYYY-MM-DD HH:MM:SS.

Basic management of tables

NOT NULL: can’t have a NULL value.
UNIQUE: all values are unique.
PRIMARY KEY: uniquely identifies each row.
FOREIGN KEY: uniquely identifies a row in another table.
CHECK expresion: satisfy a special condition (expresion).
DEFAULT value: if no value is specified use value value.
INDEX: to create and retrieve data from the database very quickly.

ON DELETE statement

When an entry needs to be updated somehow based on a modification on a foreign key. If two tables are related to each other, if something is deleted on one end, update the other end in some way.

SELECT queries

MySQL uses regular expressions (regex) like pattern matching, some wildcards that can be used with the LIKE statement are:

%: zero or more characters.
_: a single character.
[]: any single character within the brackets.
^: any character not in the brackets.
-: a range of characters.

An extended regex can be used with the statement REGEX_LIKE(expression); REGEXP and RLIKE are synonyms for REGEX_LIKE. For more: MySQL 8.0 Reference Manual: 3.3.4.7 Pattern Matching.

Unions

Joins

There are different types of SQL JOINs:

(INNER) JOIN: returns records that have matching values in both tables.
LEFT (OUTER) JOIN: returns all records from the left table, and the matched records from the right table.
RIGHT (OUTER) JOIN: returns all records from the right table, and the matched records from the left table.
FULL (OUTER) JOIN: returns all records when there is a match in either left or right table.

INNER JOIN - LEFT JOIN - RIGHT JOIN - FULL OUTER JOIN

Nested queries

A nesting isn’t constrained to the IN statement, it can appear anywhere, for example in a WHERE statement: SELECT ... WHERE something = (SELECT ...).

Triggers

Entity Relationship Diagrams (ERD)

The diagram consists of:

Entity: a square with the name of the entity inside it.
Attributes: ovals with the name of the attributes inside it; an attribute defines specific pieces of information about an entity (columns).
Primary key: same as with attributes but with name underlined; the primary key uniquely identifies the entity.
Composite attribute: an attribute that consists on one or more (sub-)attributes.
Multi-valued attribute: oval with another oval inside it and the name of the attribute.
Derived attribute: dotted oval; this attribute can be derived from other attributes from the entity.
Relationship: a diamond with the relationship name in it, for the connections a single line (partial participation) or a doubled line (total participation); it denotes how two or more attributes are related to each other; all members must participate in the relationship.
Relationship attribute: denoted like a normal attribute, but it’s child of a relationship; it defines what attributes exists because of the relationship, it’s not stored in any of the entities related, but on the relationship object itself.
Relationship cardinality: denoted with a number on the line connecting the relationship to the entity; detones the number of instances of an entity from a relation that can be associated with the relation.
Weak entity: rectangle inside a rectangle with its name inside; it cannot be uniquely identified by its attributes alone.
Weak entity’s primary key: oval with its text underlined, but the line is dotted.
Identifying relationship: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.

ERD example taken from wikipedia

]]> This is the first blog post, just for testing purposes diff --git a/blog/dst/sitemap.xml b/blog/dst/sitemap.xml index 4c43131..672e607 100644 --- a/blog/dst/sitemap.xml +++ b/blog/dst/sitemap.xml @@ -38,24 +38,6 @@ weekly 1.0 - - https://blog.luevano.xyz/a/shell_scripting_video_notes.html - 2021-06-04 - weekly - 1.0 - - - https://blog.luevano.xyz/a/linux_video_notes.html - 2021-06-04 - weekly - 1.0 - - - https://blog.luevano.xyz/a/sql_video_notes.html - 2021-06-06 - weekly - 1.0 - https://blog.luevano.xyz/a/first_blog_post.html 2021-05-17 @@ -69,12 +51,6 @@ daily 0.5 - - https://blog.luevano.xyz/tag/@notes.html - 2021-06-06 - daily - 0.5 - https://blog.luevano.xyz/tag/@server.html 2021-06-06 diff --git a/blog/dst/tag/@english.html b/blog/dst/tag/@english.html index 5c19054..5cfce87 100644 --- a/blog/dst/tag/@english.html +++ b/blog/dst/tag/@english.html @@ -86,9 +86,6 @@

Mar 21 - Create a git server and setup cgit web app (on Nginx)

Mar 21 - Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM

Mar 19 - Create a website with Nginx and Certbot

Mar 14 - Shell scripting tutorial video notes

Mar 14 - Linux tutorial video notes

Mar 02 - SQL tutorial video notes

February 2021

Feb 27 - This is the first blog post, just for testing purposes

diff --git a/blog/dst/tag/@notes.html b/blog/dst/tag/@notes.html deleted file mode 100644 index 79c9b73..0000000 --- a/blog/dst/tag/@notes.html +++ /dev/null @@ -1,120 +0,0 @@ - - - - - - - Posts filtered by notes -- Luévano's Blog - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- - - -

- -

Posts filtered by notes

- -

Articles

March 2021

Mar 14 - Shell scripting tutorial video notes
Mar 14 - Linux tutorial video notes
Mar 02 - SQL tutorial video notes

- - -

- - - - \ No newline at end of file diff --git a/blog/src/a/linux_video_notes.md b/blog/src/a/linux_video_notes.md deleted file mode 100644 index 8906304..0000000 --- a/blog/src/a/linux_video_notes.md +++ /dev/null @@ -1,93 +0,0 @@ -title: Linux tutorial video notes -author: David Luévano -lang: en -summary: Notes of videos about basic Linux terms, usage and commands, as requested by a mentor of mine. -tags: notes - english - -I was requested to make a summary of a video about basic Linux stuff (like the [SQL tutorial video notes](https://blog.luevano.xyz/a/sql_video_notes)); this time, I did most of the notes depending on the topic since I'm familiar with most of the stuff presented in the video. The video in question is: [The Complete Linux Course: Beginner to Power User!](https://www.youtube.com/watch?v=wBp0Rb-ZJak). Also, some notes were taken from [Arch Linux Wiki](https://wiki.archlinux.org/) since it's got pretty decent documentation, and, of course, general googling. - -## (Basic) commands - -A list of basic commands and small explanation (note that options are started with either `-` or `--`, depending on the program, but most of the time `-` is used for letter options and `--` for word options, `-l` vs `--list` for example): - -* `pwd`: "print working directory", full **absolute** path to the current directory. -* `cd`: "change directory", followed by the absolute or relative path of the directory to change to. - * Absolute path is started with `/`, while a relative path is started with `./` or just the name of the folder. - * Use `..` (two dots) to go up one directory. - * An abbreviation of `/home/username` is `~` (tilde). -* `ls`: "list" files and directories in current directory, or specify a directory from which to show the list after typing `ls`. Has many options, the most common ones being: - * `l`: use long listing format. - * `r` or `reverse`: reverse order while sorting. - * `s`: sort by file size, largest first. - * `a` or `all`: do not ignore entries starting with `.`. -* `mkdir`: "make directory", create a new directory with specified name. -* `touch`: create new (empty) files. -* `cp`: "copy" files or directories (using option `r` for recursive). Requires file/directory to copy and destination, separated by space. -* `mv`: "move" files or directories, also requires file/directory to copy and destination, separated by space. This is also used to **rename** files/directories. -* `rm`: "remove", followed by a file to remove it. -* `rmdir`: "remove empty directory", followed by a directory to remove it. If the directory is not empty, use `rm -r` on the directory ("remove recursive"). -* `su`: "switch user", by default to **root** user, but another one can be specified. -* `sudo`: "switch user, do", similar to `su`, but only to execute a command as **root** or the specified user. -* `clear`: clear the terminal window, a (common) keyboard shortcut is `Ctrl + l`. -* `find`: search for files/directories matching a pattern or all contents of a directory (using `.`). -* `grep`: comes from the `ed` command "g/re/p", for searching plain-text for lines that match a regular expression (regex). -* `top`: a task manager program, shows currently running commands and gives important info such as PID (process ID), user who is running that command, command name, cpu and ram usage, etc.. Some useful commands to manage programs running are: - * `pgrep`: get the PID of a running process, or a list in chronological order. - * `kill` or `pkill`: kill a running process either by PID or by name. - * `killall`: similar to `pkill`. -* `ssh`: "secure shell" is a remote login client used to connect into a remote machine and executing commands remotely, basically taking control of the remote machine. Widely used when managing servers. -* `ftp` or `sftp`: "(secure) file transfer protocol" used to transfer files from one machine to another one (usually a server). It's recommended to use `sftp` instead of `ftp` because anyone can look through the packages if it's not secured (encrypted). - -And in general, to see the options supported by almost any command, use `command -h` or `command --help`, for a quick explanation. **IMPORTANT**: Most programs have **man (manual) pages**; to access them do `man command`, this is a very powerful tool to use. - -Commands can be redirected to other commands (the output), which is powerful to create mini scripts or to achieve a goal in a single command. Most of the time the redirection can be done with the special characters `>`, `<` and most powerful, the `|` (pipe). Also, some commands accept an option to execute another command, but this depends on a command to command basis (`exec` option for `find`, for example). - -**Most terminal programs accept `Ctrl-c` or just `q` to exit the program.** - -## File permissions and ownership - -When listing files with `ls -l`, an output with file attributes (permissions) and ownership is shown, such as `drwxr-xr-x 2 user group 4096 Jul 5 21:03 Desktop`, where the first part are the attributes, and `user` and `group` the ownership info (all other info is irrelevant for now). - -File attributes (`drwxr-xr-x` in the example above) are specified by 10 (sometimes 11) characters, and can be break into 4 parts (or 5): - -* The first character is just the file type, typically `d` for directories or just `-` for files. There is `l` too, which is for **symlinks**. -* The next 3 characters represent the permissions that the **owner** has over the file. -* Next 3 the permissions that the **group** has over the file. -* Next 3 the permissions everyone else (**others**) have over the file. -* An optional `+` character that specifies whether an alternate access method applies to the file. When the character is a space, there is no alterante access method. - -Each of the three permission triads (`rwx`) can be: - -* `-` or `r`, for the first character, if the file can be **read** or directory's content can be shown. -* `-` or `w`, for the second character, if the file can be **modified** or the directory's content can be modified (create new files or folders or rename existing files or folders). -* `-` or `x`, for the third character, if the file can be **executed** or the directory can be **accessed** with `cd`. Other characters can be present, like `s`, `S`, `t` and `T` (for more: [Arch Linux Wiki: File permissions and attributes](https://wiki.archlinux.org/index.php/File_permissions_and_attributes)). - -To change attributes or ownership use `chmod` and `chown`, respectively. - -## Services - -Special type of linux process (think of a program or set of programs that run in the background waiting to be used, or doing essential tasks). There are many ways to manage (start, stop, restart, enable, disable, etc.) services, the most common way (if using `systemd`) is to just use `systemctl`. Basic usage of `systemctl` is `systemctl verb service`, where `verb` could be `start`, `enable`, `stop`, `disable`, `restart`, etc. Also, to get a general system status run `systemctl status` or just `systemctl` for a list of running **units** (a unit is an instance of a service, or a mount point or even a device or a socket). For more: [Arch Linux Wiki: systemd](https://wiki.archlinux.org/index.php/systemd). - -`systemd` also provides a way to do tasks based on a **timer**, where you can schedule from the second to the year. One could also use `cron` (using `crontab` with option `e`) to do this. These timers provide support for calendar time events, monotonic time events, and can be run asynchronously. - -## User and group management - -Most mainstream linux distributions come with a Graphic User Interface (GUI) to manage users and groups on the system. For a Command-Line Interface (CLI) just use `useradd` (with `passwd` to create a password for a given user) and `groupadd`. Also, other useful commands are `usermod`, `userdel`, `groups`, `gpasswd`, `groupdel` and more, each used for a basic management of users/groups like modification, deletion, listing (of all existing users/groups), etc.. For more: [Arch Linux Wiki: Users and groups](https://wiki.archlinux.org/index.php/users_and_groups). - -## Networking - -### Hosts file - -Located at `/etc/hosts`, serves as a translator from **hostname** (web addresses or URLs) into IP addresses (think of DNS records), meaning that any URL can be overridden to make it point to whatever IP address it's specified (only locally on the machine affected). The syntax of the file is pretty simple: first column for IP, second for hostname (URL) and third+ for aliases. - -### (Some) commands - -These commands serve the sole purpose of showing information about the network and stuff related to it: - -* `ping`: gives information about latency to a given ip/domain. -* `ifconfig`: gives similar information to `ipconfig` on windows, general info of physical network devices with their addresses and properties. An alternative could be `ip addr`, depending on the linux distribution being used and programs installed. -* `tcpdump`: "transmission control protocol dump" gives information on all "packets" being sent and received through the network. -* `netstat`: "network statistics" general statistics about network devices usage, display connections to the machine and more. -* `traceroute`: shows the route that the packets go through (how the packets jump from one server to another one) when trying to access an IP (or, for example, a website). -* `nmap`: "network mapper" explore network available hosts, opened ports, reverse DNS names, can guess the operating system of the device, it's type, MAC address and more. diff --git a/blog/src/a/shell_scripting_video_notes.md b/blog/src/a/shell_scripting_video_notes.md deleted file mode 100644 index 680663f..0000000 --- a/blog/src/a/shell_scripting_video_notes.md +++ /dev/null @@ -1,268 +0,0 @@ -title: Shell scripting tutorial video notes -author: David Luévano -lang: en -summary: Notes of videos about shell scripting, as requested by a mentor of mine. -tags: notes - english - -Another summary, this time about shell scripting in general. And just like with the [Linux notes](https://blog.luevano.xyz/a/linux_video_notes), I also did most of the notes myself or with resources outside the video. The videos in question are: [The Bad Tutorials (YT): Shell Scripting Tutorials](https://www.youtube.com/playlist?list=PL7B7FA4E693D8E790) and [Automation with SCripting (YT): Complete Shell Scripting Tutorials](https://www.youtube.com/playlist?list=PL2qzCKTbjutJRM7K_hhNyvf8sfGCLklXw). Also, some notes were taken from [tutorialspoint: UNIX / LINUX Tutorial](https://www.tutorialspoint.com/unix/index.htm) and general googling. - -## Basic concepts - -A **shell** it's an **interface** between the user and the **kernel**. While the kernel it's the layer that interacts between the shell and the **hardware**. And you access the shell either via a **terminal**, or executing a **shell script**. Note that if you're using a GUI environment, you need a **terminal emulator** to actually use a terminal (most Linux distros come with everything needed, so no need to worry). - -When using a terminal a blank screen with some text and a cursor that shows you where to type will appear and depending on the shell being used (`sh`, `dash`, `ksh`, `bash`, `zsh`, `fish`, etc.) the **prompt** will be different. The most common one being of the form `user@host:~$`, which tells that the `user` is using `host` machine and the current working directory is `~` (can be `/any/path/` too), and lastly, the `$` shows the current privileges of the shell/user using the shell (a `$` for normal user and `#` for root access). - -To clear the screen use command `clear` or simply do `Ctrl + l` (most terminals let you do this) and to cancel or create a new prompt do `Ctrl + c`, this also cancels any running program that's using the terminal (typing `q` when a program is running also stops the process, sometimes). - -Also there are **POSIX** (portable operating system interface) compliant shells like `sh`, `dash`, `ksh`, etc., that have a standard syntax and are portable to any Unix system. Non POSIX compliant shells (or not necessary fully POSIX compliant) are `bash`, `zsh`, `fish`, etc., that provide a more modern syntax but lack speed on executing scripts. - -### Common commands/programs - -A list of common commands or programs with a short description (for more, do `man command` or `command -h` or `command --help`): - -* **`man`: an interface to the system reference manuals.** -* `pwd`: print name of current/working directory. -* `cd`: change the working directory. -* `ls`: list directory contents. -* `echo`: display a line of text. Also, see **escape sequences** ([Bash Prompt HOWTO: Chapter 2. Bash and Bash Prompts: 2.5. Bash Prompt Escape Sequences](https://tldp.org/HOWTO/Bash-Prompt-HOWTO/bash-prompt-escape-sequences.html)). -* `mkdir`: make directories. -* `touch`: change file timestamps (if no file exists, creates a new blank one). -* `cat`: concatenate files and print on the standard output. -* `mv`: move (rename) files. -* `rm`: remove files or directories. -* `rmdir`: remove empty directories. -* `cp`: copy files and directories. -* `ln`: make links between files (hard or soft, also known as symbolic). -* `umask`: get or set the file mode creation mask. -* `chmod`: change file mode bits (change file permissions). -* `chown`: change file owner and group. -* `wc`: print newline, word, and byte counts for each file. -* `file`: determine file type. -* `sort`: sort lines of text files. -* `cut`: remove sections from each line of files. -* `dd`: convert and copy a file (mostly used to make bootable USBs). -* `compress`: compress data. -* `gzip`, `gunzip`, `zcat`: compress or expand files. -* `uname`: print system information. -* `cal`: display a calendar. -* `date`: print or set the system date and time. -* `read`: read from standard input into shell variables (also used to read from a file). -* `tr`: translate or delete characters. -* `readonly`: set the readonly attribute for variables. -* `set`: set or unset options and positional parameters. -* `unset`: unset values and attributes of variables and functions. -* `expr`: evaluate expressions. -* `tput`, `reset`: initialize a terminal or query terminfo database (used for more complex terminal output). -* `grep`, `egrep`, `fgrep`: print lines that match patterns (usually used to find text in a file or some text). -* `sleep`: delay for a specified amount of time. -* `break`: exit from for, while, or until loop. -* `continue`: continue for, while, or until loop. -* `logname`: print user's login name. -* `write`: send a message to another user. -* `mesg`: display (or do not display) messages from other users. -* `return`: return from a function or dot script. -* `exit`: cause the sell to exit. - -And some special "commands" or "operators" (for more: [gnu: 3.6 Redirections](https://www.gnu.org/software/bash/manual/html_node/Redirections.html)): - -* `|` (pipe): used between two commands and the output from the command from the left serves as input to the command from the right. -* `>`: redirects output to a file, overwriting the file (or creating a new file). -* `>>`: redirects output to a file, appending to the file (or creating a new file). - -## Shell scripting - -A shell script is nothing more but a file that contains commands in it; they're executed in the same order they are present in the file. A shell script file is usually terminated with a `.sh` extension, independently of the shell being used, but it's not 100% necessary as in Unix systems, an extension mean nothing, other than distinction (visually) between files. Then one can just have an extension-less file as a script. **The script must have execution permissions (`chmod +x file`)**, unless `shell script` is executed in the terminal, where `shell` could be `sh`, `bash`, etc. **Comments** are created by prepending `#` to whatever the text should be a comment. - -It's common practice to have the first line as a **she-bang** (`#!`), which is just a comment telling the interpreter which shell to execute the script with (usable when having the script in your **PATH** so you only call the name of the script like any other command/program). A she-bang has the syntax `#!/path/to/shell some_other_options`, the most common she-bangs being: `#!/bin/sh`, `#!/bin/bash`, `#!/usr/bin/python`, etc. - -Also, some people argue that you shouldn't use absolute paths, since not all Unix operating systems have the same directory structure, or not all programs are going to be installed in the same folder. So a portable she-bang can be made by prepending `/usr/bin/env` and the specify the program to run, for example: `#!/usr/bin/env bash`. - -Like always... the basic "Hello, world!" script: - -```sh -#!/bin/sh -echo "Hello, world!" -``` - -Three ways of executing this script (assuming the file name is `hw`): - -1. Type in terminal `sh hw`. -2. Type in terminal `./hw`. Requires the file to have execute permissions. -3. Type in terminal `hw`. Requires the file to have execute permissions. Requires the file to be in your PATH. - -### Variables - -Variables are case sensitive, meaning that `my_var` and `MY_VAR` are different and a variable name can only contain letters and numbers (`a-z`, `A-Z` and `0-9`) or the underscore character `_`. Can't contain a space. Variables are called by prepending `$` to the variable name. - -Like in most programming languages, there are some reserved words like `if`, `select`, `then`, `until`, `while`, etc., that can't be used as variables or as values of variables. For more: [D.2 Index of Shell Reserved Words](https://www.gnu.org/software/bash/manual/html_node/Reserved-Word-Index.html). - -There is no need to specify a variable type. Anything surrounded by `"` will be treated as text. You can use booleans, numbers, text and arrays (the implementation of arrays depends on the shell being used). Make a variable readonly by calling `readonly variable_name`. Basic syntax: - -* Text variables: `var="my var"`. -* Numeric variables: `var=123`. -* Boolean variables: `var=true` and `var=false`. -* Arrays (assuming `bash` is the shell): - * `var[0]=value1`, `var[...]=...`, `var[n]=valuen`, etc. - * `var=(value1 ... valuen)` - * Access single values with `${var[index]}` and all values with `${var[*]}` or `${var[@]}`. - -There are special variables (for more. [tutorialspoint: Unix / Linux - Special Variables](https://www.tutorialspoint.com/unix/unix-special-variables.htm)): - -* `$`: represents the process ID number, or PID, of the current shell. -* `0`: the filename of the current script. -* `n`: where `n` can be any whole number, correspond to arguments passed to the script (`command arg1 arg2 arg3 argn`). -* `#:` number of arguments supplied to the script. -* `*:` all the arguments are double quoted. -* `@:` all the arguments are individually double quoted. -* `?:` exit status of the last command executed. -* `!:` process number of the last background command. - -When calling a script, you can pass optional (or required) positional arguments like: `command arg1 arg2 arg3 argn`. - -Note that a variable can also take the output of another command, one common way to do this is using `$(command)` or `` `command` ``, for example: `var="$(echo 'this is a command being executed inside the definition of a variable')"` which, since the `echo` command is being run, `var="this is a command being executed inside the definition of a variable"`, which doesn't seem like much, but there could be any command inside `$()` or `` `command` ``. Note that this is not special to defining variables, could also be used as arguments of another command. - -#### Internal Field Separator (IFS) - -This is used by the shell to determine how to do word splitting (how to recognize word boundaries). The default value for `IFS` consists of whitespace characters (space, tab and newline). This value can ve overridden by setting the variable `IFS` to something like, for example, `:`. - -### Conditionals - -#### Exit status - -Any command being run has an exit status, either `0` or `1`, if the command has been executed successfully or otherwise (an error), respectively. - -#### `if` statement - -Pretty similar to other programming languages, evaluates an expression to a `true` or `false` and executes code as specified. `if` statements can be nested, and follow normal rules of logical operations. Basic syntax is: - -```sh -#!/bin/sh -if expression -then -do_something -elif another_expression -then -do_another_thing -else -do_something_else -fi -``` - -The expression is usually wrapped around `[]` or `[[]]`, the first being POSIX compliant and the second `bash`-specific (and other shells). - -Also, some **operators** to compare things use `==` for "equals" and `>` for "greater than", for example; while in a POSIX compliant shell, `=` for "equals" and `-gt` for "greater than" has to be used. For more operators: [tutorialspoint: Unix / Linux - Shell Basic Operators](https://www.tutorialspoint.com/unix/unix-basic-operators.htm) (this also covers **logical operators** and **file test operators**). - -### Case statement - -A common good alternative to multilevel `if` statements, enables you to match several values against one variable. Basic syntax is: - -```sh -case $var in - pattern1) - do_something1 - ;; - pattern2) - subpattern1) - do_subsomething1 - ;; - subpattern2) - do_subsomething2 - ;; - *) - pattern3|pattern4|...|patternN) - do_something3 - ;; - patternM) - do_somethingM - ;; - *) - do_something_default - ;; -esac -``` - -Where the `*` pattern is not necessary but serves the same purpose as a "default" case. - -### Loops - -Loops enable execution of a set of commands repeatedly. Loops, naturally, can be nested. `expression` here (in the basic syntax examples) work the same as mentioned in the "`if` statement" section. For more: [tutorialspoint: Unix / Linux - Shell Loop Types](https://www.tutorialspoint.com/unix/unix-shell-loops.htm). - -#### Loop control - -Similar than other programming languages, there are loop controls to interrupt or continue a loop: - - * `break` statement. - * `continue` statement. - -These statements accept an argument that specify from which loop to exit/continue. - -#### `while` loop - -Enables to execute a set of commands repeatedly until some condition occurs. Basic syntax: - -```sh -#!/bin/sh -while expression -do - do_something -done -``` - -#### `until` loop - -Similar to the `while` loop, the difference is that the `while` loop is executed as long as a condition is true, but the `until` loop... until a condition is true. Basic syntax (similar to `while` loop): - -```sh -#!/bin/sh -until expression -do - do_something -done -``` - -#### `for` loop - -Operates on lists of items. It repeats a set of commands for every item in a list. Basic syntax: - -```sh -#!/bin/sh -for var in word1 word2 ... wordN -do - do_something_with_var -done -``` - -Where `var` is the current value (`word1`, `word2`, etc.) in the loop and the expression after `for` can refer to an array, or the output of a command that outputs a list of things, etc. - -#### `select` loop - -Provides an easy way to create a numbered menu from which users can select options. Basic syntax (similar to `for` loop): - -```sh -select var in word1 word2 ... wordN -do - do_something_with_var -done -``` - -### Meta characters - -Meta characters are used to execute several commands on a single line (depending on what it's needed). The most used meta characters to accomplish this are semi-colon `;`, double ampersand `&&` and double "pipe" `||`. - -* `;`: is used to finish one command (similar to some programming languages), after the command on the left of `;` is finished (whatever the exit code is), the command on the right will be executed. -* `&&`: similar to `;`, but only if the command on the left exits with code `0` (success). -* `||`: similar to `&&`, but for exit code `1`(error). - -### Functions - -Enable to break down the overall functionality of a script into smaller, logical subsections, which can then be called upon to perform their individual tasks when needed (like in any other programming language...). For more: [tutorialspoint: Unix / Linux - Shell Functions](https://www.tutorialspoint.com/unix/unix-shell-functions.htm). Basic syntax: - -```sh -#!/bin/sh -function_name () { - do_something -} -``` - -Functions can also take arguments and can access their individual arguments (each function will have a different "storage" for their arguments). Functions can also be nested. Here `exit` will not only will finish the function code, but also the shell script that called it, instead use `return` plus an exit code to just exit the function. diff --git a/blog/src/a/sql_video_notes.md b/blog/src/a/sql_video_notes.md deleted file mode 100644 index ff20f26..0000000 --- a/blog/src/a/sql_video_notes.md +++ /dev/null @@ -1,179 +0,0 @@ -title: SQL tutorial video notes -author: David Luévano -lang: en -summary: Notes of videos about basic SQL syntax and usage, as requested by a mentor of mine. -tags: notes - english - -I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: [SQL Tutorial - Full Database Course for Beginners](https://www.youtube.com/watch?v=HXV3zeQKqGY), [MySQL Tutorial for Beginners [Full Course]](https://www.youtube.com/watch?v=7S_tz1z_5bA) and [Advanced SQL course | SQL tutorial advanced](https://www.youtube.com/watch?v=2Fn0WAyZV0E). Also, some notes were taken from [w3schools.com's SQL Tutorial](https://www.w3schools.com/sql/) and [MySQL 8.0 Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/). - -## What is a database (DB)? - -Any collection of related information, such as a phone book, a shopping list, Facebook's user base, etc.. It can be stored in different ways: on paper, on a computer, in your mind, etc.. - -### Database Management Systems (DBMS) - -A special software program that helps users create and maintain a database that makes it easy to manage large amounts of information, handles security, backups and can connect to programming languages for automation. - -### CRUD - -The four main operations that a DBMS will do: create, read, update and delete. - -### Two types of databases - -* Relational (SQL) - * Organize data into one or more tables. - * Each table has columns and rows. - * A unique key identifies each row. -* Non-relational (noSQL/not just SQL) - * Key-value stores. - * Documents (JSON, XML, etc). - * Graphs. - * Flexible tables. - -#### Relational databases (RDB) (SQL) - -When we want to create a RDB we need a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL) which is a standardized language for interacting with RDBMS and it's used to perform CRUD operations (and other administrative tasks). - -#### Non-relational databases (NRDB) (noSQL/not just SQL) - -Anything that's not relational, stores data in anything but static tables. Could be a document (JSON, XML, etc.), graph (relational nodes), key-value hash (strings, json, etc.), etc. - -NRDB also require a Non-Relational Database Management System (NRDBMS) to maintain a database. But it doesn't have a standardized language for performing CRUD and administrative operations like how RDB have. - -### Database queries - -A DB query is a request that is made to the (R/NR)DBMS for a specific information. A google search is a query, for example. - -## Tables and keys - -A table is composed of columns, rows and a primary key. The primary key is unique and identifies one specific row. Columns and rows are trivial, a column identifies a field and has a specific data type (name, email, birth) and a row identifies a table entry (person that contains a name, email and birth). - -Also, there are foreign keys, it's purpose is to relate to another database table; this foreign key is unique in it's own table, but can be repeated where you use it as a foreign key. - -It's possible to use the same table keys as foreign keys to make relations inside the same table. - -## SQL basics - -It's actually a hybrid language, basically 4 types of languages in one: - -* Data Query Language (DQL) - * Used to query the database for information. - * Get information that is already stored there. -* Data Definition Language (DDL) - * Used for defining database schemas. -* Data Control Language (DCL) - * Used for controlling access to the data in the database. - * User and permissions management. -* Data Manipulation Language (DML) - * Used for inserting, updating and deleting data from a database. - -### Queries - -A set of instructions given to the RDBMS (written in SQL) that tell the RDBMS what information you want it to retrieve. Instead of getting the whole database, retrieve only a bit of information that you need. - -Also, SQL keywords can be either lower or upper case, but it's **convention to use upper case**. And **queries are ended by a semi-colon**. - -#### Data types - -Just some SQL data types (for more: [MySQL 8.0 Reference Manual: Chapter 11 Data Types](https://dev.mysql.com/doc/refman/8.0/en/data-types.html), the notation is `DATATYPE(SIZE(,SIZE))`: - -* `INT`: integer numbers. -* `DECIMAL(M,N)`: decimal numbers. -* `VARCHAR(N)`: string of text of length N. -* `BLOB`: Binary Large Object, stores large data. -* `DATE`: YYYY-MM-DD. -* `TIMESTAMP`: YYYY-MM-DD HH:MM:SS. - -#### Basic management of tables - -To **create a table**, the basic syntax is `CREATE TABLE tablename (column1 datatype constraint, column2 datatype constraint, ...)`, where a constraint could be (for more: [MySQL 8.0 Reference Manual: 13.1.20 CREATE TABLE Statement](https://dev.mysql.com/doc/refman/8.0/en/create-table.html)): - -* `NOT NULL`: can't have a `NULL` value. -* `UNIQUE`: all values are unique. -* `PRIMARY KEY`: uniquely identifies each row. -* `FOREIGN KEY`: uniquely identifies a row in another table. -* `CHECK expresion`: satisfy a special condition (`expresion`). -* `DEFAULT value`: if no value is specified use value `value`. -* `INDEX`: to create and retrieve data from the database very quickly. - -Get the **table structure** with `DESCRIBE tablename` and delete it with `DROP TABLE tablename`. **Add columns** to the table with `ALTER TABLE tablename ADD column DATATYPE(N,M)`, similar syntax to **delete a specific column** `ALTER TABLE tablename DRORP COLUMN column`. - -**Add entries** to the table with `INSERT INTO tablename VALUES(value1, value2, ...)` where all the fields must be specified, or `INSERT INTO tablename(column1, column2) VALUES(value1, value2)` to just add some fields to the new entry. While at it, (all) the table content can be fetched with `SELECT * FROM tablename`. - -Basic **Updating of entries** with `UPDATE tablename SET expression1 WHERE expression2`, where `expression1` could be `column = value2` and `expression2` could be `column = value1`, meaning that the value of `column` will be changed from `value1` to `value2`. Note that the expressions are not limited by `column = value`, and that the `column` has to be the same, it would be any expression. Also, this is really extensive as `SET` can set multiple variables and `WHERE` take more than one condition by chaining conditions with `AND`, `OR` and `NOT` keywords, for example. - -##### ON DELETE statement - -When an entry needs to be updated somehow based on a modification on a foreign key. If two tables are related to each other, if something is deleted on one end, update the other end in some way. - -For example on creation of a table, on the specification of a foreign key: `CREATE TABLE tablename (..., FOREIGN KEY(column) REFERENCES othertable(othertablecolumn) ON DELETE something)`. That something could be `SET NULL`, `CASCADE`, etc.. - -#### SELECT queries - -Instead of doing `SELECT * FROM tablename`, which gets all the data from a table, more complex `SELECT` queries can be implemented, such as `SELECT column FROM tablename` to only get all data from one column of the table. Append `LIMIT N` to limit the query to `N` entries. Append `WHERE condition` to meet a custom condition. - -Other statements that can be used in conjunction with `SELECT` are `ORDER BY column ASC|DESC`, `SELECT DISTINCT`, `MIN(column)`, `MAX(column)`, `COUNT(column)`, `AVG(column)`, `SUM(column)`, `LIKE` and more. For more, visit [MySQL 8.0 Reference Manual: 13.2.10 SELECT Statement](https://dev.mysql.com/doc/refman/8.0/en/select.html). - -MySQL uses regular expressions (regex) like pattern matching, some wildcards that can be used with the `LIKE` statement are: - -* `%`: zero or more characters. -* `_`: a single character. -* `[]`: any single character within the brackets. -* `^`: any character not in the brackets. -* `-`: a range of characters. - -An extended regex can be used with the statement `REGEX_LIKE(expression)`; `REGEXP` and `RLIKE` are synonyms for `REGEX_LIKE`. For more: [MySQL 8.0 Reference Manual: 3.3.4.7 Pattern Matching](https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html). - -#### Unions - -A specialized SQL operator that is used to combine multiple `SELECT` statements into one. The basic syntax is `SELECT ... UNION SELECT ...`, where `...` is a whole `SELECT` statement; there can be any amount of unions. There are some rules that apply when doing unions, such as having the same amount of columns on both statements and being of the same data type. - -#### Joins - -Used to combine rows from two or more tables based on a related column between them. Basic syntax is `SELECT table1.column1, ..., table2.column1, ... FROM table(1|2) JOIN table(1|2) ON table1.common_column = table2.common_column`, where the table specified in the `FROM` statement is called the "left" table, where the one in the `JOIN` statement is the "right" table. For more: [MySQL 8.0 Reference Manual: 13.2.10.2 JOIN Clause](https://dev.mysql.com/doc/refman/8.0/en/join.html). - -There are different types of SQL JOINs: - -* `(INNER) JOIN`: returns records that have matching values in both tables. -* `LEFT (OUTER) JOIN`: returns all records from the left table, and the matched records from the right table. -* `RIGHT (OUTER) JOIN`: returns all records from the right table, and the matched records from the left table. -* `FULL (OUTER) JOIN`: returns all records when there is a match in either left or right table. - -

-![INNER JOIN](images/b/notes/sql/img_innerjoin.gif) -![LEFT JOIN](images/b/notes/sql/img_leftjoin.gif) -![RIGHT JOIN](images/b/notes/sql/img_rightjoin.gif) -![FULL OUTER JOIN](images/b/notes/sql/img_fulljoin.gif) -

- -#### Nested queries - -A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a `SELECT` query somewhere inside another one, for example `SELECT ... IN (SELECT ...)`, where the nesting is occurring inside the parenthesis after the `IN` statement. - -A nesting isn't constrained to the `IN` statement, it can appear anywhere, for example in a `WHERE` statement: `SELECT ... WHERE something = (SELECT ...)`. - -#### Triggers - -A block of SQL code that will define a certain action that will happen when a specific operation is performed on the database. It is **recommended to change the `DELIMITER` temporarily from semi-colon to something else** (since we need to use semi-colon to end the trigger) while the trigger is created. The basic syntax is `CREATE TRIGGER trigername triggertime triggerevent ON tablename FOR EACH ROW triggerorder triggerbody`. For more: [MySQL 8.0 Reference Manual: 13.1.22 CREATE TRIGGER Statement](https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html) and [MySQL 8.0 Reference Manual: 25.3.1 Trigger Syntax and Examples](https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html). - -#### Entity Relationship Diagrams (ERD) - -When designing a database it's important to define a **database schema** which is just a definition of all the different tables and their attributes that are going to live inside the database. So, basically, an ERD diagram is a diagram that consists of text, symbols and shapes that are combined to create a relationship model. - -The diagram consists of: - -* **Entity**: a square with the name of the entity inside it. -* **Attributes**: ovals with the name of the attributes inside it; an attribute defines specific pieces of information about an entity (columns). -* **Primary key**: same as with attributes but with name underlined; the primary key uniquely identifies the entity. -* **Composite attribute**: an attribute that consists on one or more (sub-)attributes. -* **Multi-valued attribute**: oval with another oval inside it and the name of the attribute. -* **Derived attribute**: dotted oval; this attribute can be derived from other attributes from the entity. -* **Relationship**: a diamond with the relationship name in it, for the connections a single line (partial participation) or a doubled line (total participation); it denotes how two or more attributes are related to each other; all members must participate in the relationship. -* **Relationship attribute**: denoted like a normal attribute, but it's child of a relationship; it defines what attributes exists because of the relationship, it's not stored in any of the entities related, but on the relationship object itself. -* **Relationship cardinality**: denoted with a number on the line connecting the relationship to the entity; detones the number of instances of an entity from a relation that can be associated with the relation. -* **Weak entity**: rectangle inside a rectangle with its name inside; it cannot be uniquely identified by its attributes alone. -* **Weak entity's primary key**: oval with its text underlined, but the line is dotted. -* **Identifying relationship**: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity. - -![ERD example taken from wikipedia](images/b/notes/sql/erd_example.png) diff --git a/blog/trash/linux_video_notes.md b/blog/trash/linux_video_notes.md new file mode 100644 index 0000000..8906304 --- /dev/null +++ b/blog/trash/linux_video_notes.md @@ -0,0 +1,93 @@ +title: Linux tutorial video notes +author: David Luévano +lang: en +summary: Notes of videos about basic Linux terms, usage and commands, as requested by a mentor of mine. +tags: notes + english + +I was requested to make a summary of a video about basic Linux stuff (like the [SQL tutorial video notes](https://blog.luevano.xyz/a/sql_video_notes)); this time, I did most of the notes depending on the topic since I'm familiar with most of the stuff presented in the video. The video in question is: [The Complete Linux Course: Beginner to Power User!](https://www.youtube.com/watch?v=wBp0Rb-ZJak). Also, some notes were taken from [Arch Linux Wiki](https://wiki.archlinux.org/) since it's got pretty decent documentation, and, of course, general googling. + +## (Basic) commands + +A list of basic commands and small explanation (note that options are started with either `-` or `--`, depending on the program, but most of the time `-` is used for letter options and `--` for word options, `-l` vs `--list` for example): + +* `pwd`: "print working directory", full **absolute** path to the current directory. +* `cd`: "change directory", followed by the absolute or relative path of the directory to change to. + * Absolute path is started with `/`, while a relative path is started with `./` or just the name of the folder. + * Use `..` (two dots) to go up one directory. + * An abbreviation of `/home/username` is `~` (tilde). +* `ls`: "list" files and directories in current directory, or specify a directory from which to show the list after typing `ls`. Has many options, the most common ones being: + * `l`: use long listing format. + * `r` or `reverse`: reverse order while sorting. + * `s`: sort by file size, largest first. + * `a` or `all`: do not ignore entries starting with `.`. +* `mkdir`: "make directory", create a new directory with specified name. +* `touch`: create new (empty) files. +* `cp`: "copy" files or directories (using option `r` for recursive). Requires file/directory to copy and destination, separated by space. +* `mv`: "move" files or directories, also requires file/directory to copy and destination, separated by space. This is also used to **rename** files/directories. +* `rm`: "remove", followed by a file to remove it. +* `rmdir`: "remove empty directory", followed by a directory to remove it. If the directory is not empty, use `rm -r` on the directory ("remove recursive"). +* `su`: "switch user", by default to **root** user, but another one can be specified. +* `sudo`: "switch user, do", similar to `su`, but only to execute a command as **root** or the specified user. +* `clear`: clear the terminal window, a (common) keyboard shortcut is `Ctrl + l`. +* `find`: search for files/directories matching a pattern or all contents of a directory (using `.`). +* `grep`: comes from the `ed` command "g/re/p", for searching plain-text for lines that match a regular expression (regex). +* `top`: a task manager program, shows currently running commands and gives important info such as PID (process ID), user who is running that command, command name, cpu and ram usage, etc.. Some useful commands to manage programs running are: + * `pgrep`: get the PID of a running process, or a list in chronological order. + * `kill` or `pkill`: kill a running process either by PID or by name. + * `killall`: similar to `pkill`. +* `ssh`: "secure shell" is a remote login client used to connect into a remote machine and executing commands remotely, basically taking control of the remote machine. Widely used when managing servers. +* `ftp` or `sftp`: "(secure) file transfer protocol" used to transfer files from one machine to another one (usually a server). It's recommended to use `sftp` instead of `ftp` because anyone can look through the packages if it's not secured (encrypted). + +And in general, to see the options supported by almost any command, use `command -h` or `command --help`, for a quick explanation. **IMPORTANT**: Most programs have **man (manual) pages**; to access them do `man command`, this is a very powerful tool to use. + +Commands can be redirected to other commands (the output), which is powerful to create mini scripts or to achieve a goal in a single command. Most of the time the redirection can be done with the special characters `>`, `<` and most powerful, the `|` (pipe). Also, some commands accept an option to execute another command, but this depends on a command to command basis (`exec` option for `find`, for example). + +**Most terminal programs accept `Ctrl-c` or just `q` to exit the program.** + +## File permissions and ownership + +When listing files with `ls -l`, an output with file attributes (permissions) and ownership is shown, such as `drwxr-xr-x 2 user group 4096 Jul 5 21:03 Desktop`, where the first part are the attributes, and `user` and `group` the ownership info (all other info is irrelevant for now). + +File attributes (`drwxr-xr-x` in the example above) are specified by 10 (sometimes 11) characters, and can be break into 4 parts (or 5): + +* The first character is just the file type, typically `d` for directories or just `-` for files. There is `l` too, which is for **symlinks**. +* The next 3 characters represent the permissions that the **owner** has over the file. +* Next 3 the permissions that the **group** has over the file. +* Next 3 the permissions everyone else (**others**) have over the file. +* An optional `+` character that specifies whether an alternate access method applies to the file. When the character is a space, there is no alterante access method. + +Each of the three permission triads (`rwx`) can be: + +* `-` or `r`, for the first character, if the file can be **read** or directory's content can be shown. +* `-` or `w`, for the second character, if the file can be **modified** or the directory's content can be modified (create new files or folders or rename existing files or folders). +* `-` or `x`, for the third character, if the file can be **executed** or the directory can be **accessed** with `cd`. Other characters can be present, like `s`, `S`, `t` and `T` (for more: [Arch Linux Wiki: File permissions and attributes](https://wiki.archlinux.org/index.php/File_permissions_and_attributes)). + +To change attributes or ownership use `chmod` and `chown`, respectively. + +## Services + +Special type of linux process (think of a program or set of programs that run in the background waiting to be used, or doing essential tasks). There are many ways to manage (start, stop, restart, enable, disable, etc.) services, the most common way (if using `systemd`) is to just use `systemctl`. Basic usage of `systemctl` is `systemctl verb service`, where `verb` could be `start`, `enable`, `stop`, `disable`, `restart`, etc. Also, to get a general system status run `systemctl status` or just `systemctl` for a list of running **units** (a unit is an instance of a service, or a mount point or even a device or a socket). For more: [Arch Linux Wiki: systemd](https://wiki.archlinux.org/index.php/systemd). + +`systemd` also provides a way to do tasks based on a **timer**, where you can schedule from the second to the year. One could also use `cron` (using `crontab` with option `e`) to do this. These timers provide support for calendar time events, monotonic time events, and can be run asynchronously. + +## User and group management + +Most mainstream linux distributions come with a Graphic User Interface (GUI) to manage users and groups on the system. For a Command-Line Interface (CLI) just use `useradd` (with `passwd` to create a password for a given user) and `groupadd`. Also, other useful commands are `usermod`, `userdel`, `groups`, `gpasswd`, `groupdel` and more, each used for a basic management of users/groups like modification, deletion, listing (of all existing users/groups), etc.. For more: [Arch Linux Wiki: Users and groups](https://wiki.archlinux.org/index.php/users_and_groups). + +## Networking + +### Hosts file + +Located at `/etc/hosts`, serves as a translator from **hostname** (web addresses or URLs) into IP addresses (think of DNS records), meaning that any URL can be overridden to make it point to whatever IP address it's specified (only locally on the machine affected). The syntax of the file is pretty simple: first column for IP, second for hostname (URL) and third+ for aliases. + +### (Some) commands + +These commands serve the sole purpose of showing information about the network and stuff related to it: + +* `ping`: gives information about latency to a given ip/domain. +* `ifconfig`: gives similar information to `ipconfig` on windows, general info of physical network devices with their addresses and properties. An alternative could be `ip addr`, depending on the linux distribution being used and programs installed. +* `tcpdump`: "transmission control protocol dump" gives information on all "packets" being sent and received through the network. +* `netstat`: "network statistics" general statistics about network devices usage, display connections to the machine and more. +* `traceroute`: shows the route that the packets go through (how the packets jump from one server to another one) when trying to access an IP (or, for example, a website). +* `nmap`: "network mapper" explore network available hosts, opened ports, reverse DNS names, can guess the operating system of the device, it's type, MAC address and more. diff --git a/blog/trash/shell_scripting_video_notes.md b/blog/trash/shell_scripting_video_notes.md new file mode 100644 index 0000000..680663f --- /dev/null +++ b/blog/trash/shell_scripting_video_notes.md @@ -0,0 +1,268 @@ +title: Shell scripting tutorial video notes +author: David Luévano +lang: en +summary: Notes of videos about shell scripting, as requested by a mentor of mine. +tags: notes + english + +Another summary, this time about shell scripting in general. And just like with the [Linux notes](https://blog.luevano.xyz/a/linux_video_notes), I also did most of the notes myself or with resources outside the video. The videos in question are: [The Bad Tutorials (YT): Shell Scripting Tutorials](https://www.youtube.com/playlist?list=PL7B7FA4E693D8E790) and [Automation with SCripting (YT): Complete Shell Scripting Tutorials](https://www.youtube.com/playlist?list=PL2qzCKTbjutJRM7K_hhNyvf8sfGCLklXw). Also, some notes were taken from [tutorialspoint: UNIX / LINUX Tutorial](https://www.tutorialspoint.com/unix/index.htm) and general googling. + +## Basic concepts + +A **shell** it's an **interface** between the user and the **kernel**. While the kernel it's the layer that interacts between the shell and the **hardware**. And you access the shell either via a **terminal**, or executing a **shell script**. Note that if you're using a GUI environment, you need a **terminal emulator** to actually use a terminal (most Linux distros come with everything needed, so no need to worry). + +When using a terminal a blank screen with some text and a cursor that shows you where to type will appear and depending on the shell being used (`sh`, `dash`, `ksh`, `bash`, `zsh`, `fish`, etc.) the **prompt** will be different. The most common one being of the form `user@host:~$`, which tells that the `user` is using `host` machine and the current working directory is `~` (can be `/any/path/` too), and lastly, the `$` shows the current privileges of the shell/user using the shell (a `$` for normal user and `#` for root access). + +To clear the screen use command `clear` or simply do `Ctrl + l` (most terminals let you do this) and to cancel or create a new prompt do `Ctrl + c`, this also cancels any running program that's using the terminal (typing `q` when a program is running also stops the process, sometimes). + +Also there are **POSIX** (portable operating system interface) compliant shells like `sh`, `dash`, `ksh`, etc., that have a standard syntax and are portable to any Unix system. Non POSIX compliant shells (or not necessary fully POSIX compliant) are `bash`, `zsh`, `fish`, etc., that provide a more modern syntax but lack speed on executing scripts. + +### Common commands/programs + +A list of common commands or programs with a short description (for more, do `man command` or `command -h` or `command --help`): + +* **`man`: an interface to the system reference manuals.** +* `pwd`: print name of current/working directory. +* `cd`: change the working directory. +* `ls`: list directory contents. +* `echo`: display a line of text. Also, see **escape sequences** ([Bash Prompt HOWTO: Chapter 2. Bash and Bash Prompts: 2.5. Bash Prompt Escape Sequences](https://tldp.org/HOWTO/Bash-Prompt-HOWTO/bash-prompt-escape-sequences.html)). +* `mkdir`: make directories. +* `touch`: change file timestamps (if no file exists, creates a new blank one). +* `cat`: concatenate files and print on the standard output. +* `mv`: move (rename) files. +* `rm`: remove files or directories. +* `rmdir`: remove empty directories. +* `cp`: copy files and directories. +* `ln`: make links between files (hard or soft, also known as symbolic). +* `umask`: get or set the file mode creation mask. +* `chmod`: change file mode bits (change file permissions). +* `chown`: change file owner and group. +* `wc`: print newline, word, and byte counts for each file. +* `file`: determine file type. +* `sort`: sort lines of text files. +* `cut`: remove sections from each line of files. +* `dd`: convert and copy a file (mostly used to make bootable USBs). +* `compress`: compress data. +* `gzip`, `gunzip`, `zcat`: compress or expand files. +* `uname`: print system information. +* `cal`: display a calendar. +* `date`: print or set the system date and time. +* `read`: read from standard input into shell variables (also used to read from a file). +* `tr`: translate or delete characters. +* `readonly`: set the readonly attribute for variables. +* `set`: set or unset options and positional parameters. +* `unset`: unset values and attributes of variables and functions. +* `expr`: evaluate expressions. +* `tput`, `reset`: initialize a terminal or query terminfo database (used for more complex terminal output). +* `grep`, `egrep`, `fgrep`: print lines that match patterns (usually used to find text in a file or some text). +* `sleep`: delay for a specified amount of time. +* `break`: exit from for, while, or until loop. +* `continue`: continue for, while, or until loop. +* `logname`: print user's login name. +* `write`: send a message to another user. +* `mesg`: display (or do not display) messages from other users. +* `return`: return from a function or dot script. +* `exit`: cause the sell to exit. + +And some special "commands" or "operators" (for more: [gnu: 3.6 Redirections](https://www.gnu.org/software/bash/manual/html_node/Redirections.html)): + +* `|` (pipe): used between two commands and the output from the command from the left serves as input to the command from the right. +* `>`: redirects output to a file, overwriting the file (or creating a new file). +* `>>`: redirects output to a file, appending to the file (or creating a new file). + +## Shell scripting + +A shell script is nothing more but a file that contains commands in it; they're executed in the same order they are present in the file. A shell script file is usually terminated with a `.sh` extension, independently of the shell being used, but it's not 100% necessary as in Unix systems, an extension mean nothing, other than distinction (visually) between files. Then one can just have an extension-less file as a script. **The script must have execution permissions (`chmod +x file`)**, unless `shell script` is executed in the terminal, where `shell` could be `sh`, `bash`, etc. **Comments** are created by prepending `#` to whatever the text should be a comment. + +It's common practice to have the first line as a **she-bang** (`#!`), which is just a comment telling the interpreter which shell to execute the script with (usable when having the script in your **PATH** so you only call the name of the script like any other command/program). A she-bang has the syntax `#!/path/to/shell some_other_options`, the most common she-bangs being: `#!/bin/sh`, `#!/bin/bash`, `#!/usr/bin/python`, etc. + +Also, some people argue that you shouldn't use absolute paths, since not all Unix operating systems have the same directory structure, or not all programs are going to be installed in the same folder. So a portable she-bang can be made by prepending `/usr/bin/env` and the specify the program to run, for example: `#!/usr/bin/env bash`. + +Like always... the basic "Hello, world!" script: + +```sh +#!/bin/sh +echo "Hello, world!" +``` + +Three ways of executing this script (assuming the file name is `hw`): + +1. Type in terminal `sh hw`. +2. Type in terminal `./hw`. Requires the file to have execute permissions. +3. Type in terminal `hw`. Requires the file to have execute permissions. Requires the file to be in your PATH. + +### Variables + +Variables are case sensitive, meaning that `my_var` and `MY_VAR` are different and a variable name can only contain letters and numbers (`a-z`, `A-Z` and `0-9`) or the underscore character `_`. Can't contain a space. Variables are called by prepending `$` to the variable name. + +Like in most programming languages, there are some reserved words like `if`, `select`, `then`, `until`, `while`, etc., that can't be used as variables or as values of variables. For more: [D.2 Index of Shell Reserved Words](https://www.gnu.org/software/bash/manual/html_node/Reserved-Word-Index.html). + +There is no need to specify a variable type. Anything surrounded by `"` will be treated as text. You can use booleans, numbers, text and arrays (the implementation of arrays depends on the shell being used). Make a variable readonly by calling `readonly variable_name`. Basic syntax: + +* Text variables: `var="my var"`. +* Numeric variables: `var=123`. +* Boolean variables: `var=true` and `var=false`. +* Arrays (assuming `bash` is the shell): + * `var[0]=value1`, `var[...]=...`, `var[n]=valuen`, etc. + * `var=(value1 ... valuen)` + * Access single values with `${var[index]}` and all values with `${var[*]}` or `${var[@]}`. + +There are special variables (for more. [tutorialspoint: Unix / Linux - Special Variables](https://www.tutorialspoint.com/unix/unix-special-variables.htm)): + +* `$`: represents the process ID number, or PID, of the current shell. +* `0`: the filename of the current script. +* `n`: where `n` can be any whole number, correspond to arguments passed to the script (`command arg1 arg2 arg3 argn`). +* `#:` number of arguments supplied to the script. +* `*:` all the arguments are double quoted. +* `@:` all the arguments are individually double quoted. +* `?:` exit status of the last command executed. +* `!:` process number of the last background command. + +When calling a script, you can pass optional (or required) positional arguments like: `command arg1 arg2 arg3 argn`. + +Note that a variable can also take the output of another command, one common way to do this is using `$(command)` or `` `command` ``, for example: `var="$(echo 'this is a command being executed inside the definition of a variable')"` which, since the `echo` command is being run, `var="this is a command being executed inside the definition of a variable"`, which doesn't seem like much, but there could be any command inside `$()` or `` `command` ``. Note that this is not special to defining variables, could also be used as arguments of another command. + +#### Internal Field Separator (IFS) + +This is used by the shell to determine how to do word splitting (how to recognize word boundaries). The default value for `IFS` consists of whitespace characters (space, tab and newline). This value can ve overridden by setting the variable `IFS` to something like, for example, `:`. + +### Conditionals + +#### Exit status + +Any command being run has an exit status, either `0` or `1`, if the command has been executed successfully or otherwise (an error), respectively. + +#### `if` statement + +Pretty similar to other programming languages, evaluates an expression to a `true` or `false` and executes code as specified. `if` statements can be nested, and follow normal rules of logical operations. Basic syntax is: + +```sh +#!/bin/sh +if expression +then +do_something +elif another_expression +then +do_another_thing +else +do_something_else +fi +``` + +The expression is usually wrapped around `[]` or `[[]]`, the first being POSIX compliant and the second `bash`-specific (and other shells). + +Also, some **operators** to compare things use `==` for "equals" and `>` for "greater than", for example; while in a POSIX compliant shell, `=` for "equals" and `-gt` for "greater than" has to be used. For more operators: [tutorialspoint: Unix / Linux - Shell Basic Operators](https://www.tutorialspoint.com/unix/unix-basic-operators.htm) (this also covers **logical operators** and **file test operators**). + +### Case statement + +A common good alternative to multilevel `if` statements, enables you to match several values against one variable. Basic syntax is: + +```sh +case $var in + pattern1) + do_something1 + ;; + pattern2) + subpattern1) + do_subsomething1 + ;; + subpattern2) + do_subsomething2 + ;; + *) + pattern3|pattern4|...|patternN) + do_something3 + ;; + patternM) + do_somethingM + ;; + *) + do_something_default + ;; +esac +``` + +Where the `*` pattern is not necessary but serves the same purpose as a "default" case. + +### Loops + +Loops enable execution of a set of commands repeatedly. Loops, naturally, can be nested. `expression` here (in the basic syntax examples) work the same as mentioned in the "`if` statement" section. For more: [tutorialspoint: Unix / Linux - Shell Loop Types](https://www.tutorialspoint.com/unix/unix-shell-loops.htm). + +#### Loop control + +Similar than other programming languages, there are loop controls to interrupt or continue a loop: + + * `break` statement. + * `continue` statement. + +These statements accept an argument that specify from which loop to exit/continue. + +#### `while` loop + +Enables to execute a set of commands repeatedly until some condition occurs. Basic syntax: + +```sh +#!/bin/sh +while expression +do + do_something +done +``` + +#### `until` loop + +Similar to the `while` loop, the difference is that the `while` loop is executed as long as a condition is true, but the `until` loop... until a condition is true. Basic syntax (similar to `while` loop): + +```sh +#!/bin/sh +until expression +do + do_something +done +``` + +#### `for` loop + +Operates on lists of items. It repeats a set of commands for every item in a list. Basic syntax: + +```sh +#!/bin/sh +for var in word1 word2 ... wordN +do + do_something_with_var +done +``` + +Where `var` is the current value (`word1`, `word2`, etc.) in the loop and the expression after `for` can refer to an array, or the output of a command that outputs a list of things, etc. + +#### `select` loop + +Provides an easy way to create a numbered menu from which users can select options. Basic syntax (similar to `for` loop): + +```sh +select var in word1 word2 ... wordN +do + do_something_with_var +done +``` + +### Meta characters + +Meta characters are used to execute several commands on a single line (depending on what it's needed). The most used meta characters to accomplish this are semi-colon `;`, double ampersand `&&` and double "pipe" `||`. + +* `;`: is used to finish one command (similar to some programming languages), after the command on the left of `;` is finished (whatever the exit code is), the command on the right will be executed. +* `&&`: similar to `;`, but only if the command on the left exits with code `0` (success). +* `||`: similar to `&&`, but for exit code `1`(error). + +### Functions + +Enable to break down the overall functionality of a script into smaller, logical subsections, which can then be called upon to perform their individual tasks when needed (like in any other programming language...). For more: [tutorialspoint: Unix / Linux - Shell Functions](https://www.tutorialspoint.com/unix/unix-shell-functions.htm). Basic syntax: + +```sh +#!/bin/sh +function_name () { + do_something +} +``` + +Functions can also take arguments and can access their individual arguments (each function will have a different "storage" for their arguments). Functions can also be nested. Here `exit` will not only will finish the function code, but also the shell script that called it, instead use `return` plus an exit code to just exit the function. diff --git a/blog/trash/sql_video_notes.md b/blog/trash/sql_video_notes.md new file mode 100644 index 0000000..ff20f26 --- /dev/null +++ b/blog/trash/sql_video_notes.md @@ -0,0 +1,179 @@ +title: SQL tutorial video notes +author: David Luévano +lang: en +summary: Notes of videos about basic SQL syntax and usage, as requested by a mentor of mine. +tags: notes + english + +I was requested to make summaries of videos about SQL, these are the notes (mostly this is a transcription of what I found useful). The videos in question are: [SQL Tutorial - Full Database Course for Beginners](https://www.youtube.com/watch?v=HXV3zeQKqGY), [MySQL Tutorial for Beginners [Full Course]](https://www.youtube.com/watch?v=7S_tz1z_5bA) and [Advanced SQL course | SQL tutorial advanced](https://www.youtube.com/watch?v=2Fn0WAyZV0E). Also, some notes were taken from [w3schools.com's SQL Tutorial](https://www.w3schools.com/sql/) and [MySQL 8.0 Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/). + +## What is a database (DB)? + +Any collection of related information, such as a phone book, a shopping list, Facebook's user base, etc.. It can be stored in different ways: on paper, on a computer, in your mind, etc.. + +### Database Management Systems (DBMS) + +A special software program that helps users create and maintain a database that makes it easy to manage large amounts of information, handles security, backups and can connect to programming languages for automation. + +### CRUD + +The four main operations that a DBMS will do: create, read, update and delete. + +### Two types of databases + +* Relational (SQL) + * Organize data into one or more tables. + * Each table has columns and rows. + * A unique key identifies each row. +* Non-relational (noSQL/not just SQL) + * Key-value stores. + * Documents (JSON, XML, etc). + * Graphs. + * Flexible tables. + +#### Relational databases (RDB) (SQL) + +When we want to create a RDB we need a Relational Database Management System (RDBMS) that uses Structured Query Language (SQL) which is a standardized language for interacting with RDBMS and it's used to perform CRUD operations (and other administrative tasks). + +#### Non-relational databases (NRDB) (noSQL/not just SQL) + +Anything that's not relational, stores data in anything but static tables. Could be a document (JSON, XML, etc.), graph (relational nodes), key-value hash (strings, json, etc.), etc. + +NRDB also require a Non-Relational Database Management System (NRDBMS) to maintain a database. But it doesn't have a standardized language for performing CRUD and administrative operations like how RDB have. + +### Database queries + +A DB query is a request that is made to the (R/NR)DBMS for a specific information. A google search is a query, for example. + +## Tables and keys + +A table is composed of columns, rows and a primary key. The primary key is unique and identifies one specific row. Columns and rows are trivial, a column identifies a field and has a specific data type (name, email, birth) and a row identifies a table entry (person that contains a name, email and birth). + +Also, there are foreign keys, it's purpose is to relate to another database table; this foreign key is unique in it's own table, but can be repeated where you use it as a foreign key. + +It's possible to use the same table keys as foreign keys to make relations inside the same table. + +## SQL basics + +It's actually a hybrid language, basically 4 types of languages in one: + +* Data Query Language (DQL) + * Used to query the database for information. + * Get information that is already stored there. +* Data Definition Language (DDL) + * Used for defining database schemas. +* Data Control Language (DCL) + * Used for controlling access to the data in the database. + * User and permissions management. +* Data Manipulation Language (DML) + * Used for inserting, updating and deleting data from a database. + +### Queries + +A set of instructions given to the RDBMS (written in SQL) that tell the RDBMS what information you want it to retrieve. Instead of getting the whole database, retrieve only a bit of information that you need. + +Also, SQL keywords can be either lower or upper case, but it's **convention to use upper case**. And **queries are ended by a semi-colon**. + +#### Data types + +Just some SQL data types (for more: [MySQL 8.0 Reference Manual: Chapter 11 Data Types](https://dev.mysql.com/doc/refman/8.0/en/data-types.html), the notation is `DATATYPE(SIZE(,SIZE))`: + +* `INT`: integer numbers. +* `DECIMAL(M,N)`: decimal numbers. +* `VARCHAR(N)`: string of text of length N. +* `BLOB`: Binary Large Object, stores large data. +* `DATE`: YYYY-MM-DD. +* `TIMESTAMP`: YYYY-MM-DD HH:MM:SS. + +#### Basic management of tables + +To **create a table**, the basic syntax is `CREATE TABLE tablename (column1 datatype constraint, column2 datatype constraint, ...)`, where a constraint could be (for more: [MySQL 8.0 Reference Manual: 13.1.20 CREATE TABLE Statement](https://dev.mysql.com/doc/refman/8.0/en/create-table.html)): + +* `NOT NULL`: can't have a `NULL` value. +* `UNIQUE`: all values are unique. +* `PRIMARY KEY`: uniquely identifies each row. +* `FOREIGN KEY`: uniquely identifies a row in another table. +* `CHECK expresion`: satisfy a special condition (`expresion`). +* `DEFAULT value`: if no value is specified use value `value`. +* `INDEX`: to create and retrieve data from the database very quickly. + +Get the **table structure** with `DESCRIBE tablename` and delete it with `DROP TABLE tablename`. **Add columns** to the table with `ALTER TABLE tablename ADD column DATATYPE(N,M)`, similar syntax to **delete a specific column** `ALTER TABLE tablename DRORP COLUMN column`. + +**Add entries** to the table with `INSERT INTO tablename VALUES(value1, value2, ...)` where all the fields must be specified, or `INSERT INTO tablename(column1, column2) VALUES(value1, value2)` to just add some fields to the new entry. While at it, (all) the table content can be fetched with `SELECT * FROM tablename`. + +Basic **Updating of entries** with `UPDATE tablename SET expression1 WHERE expression2`, where `expression1` could be `column = value2` and `expression2` could be `column = value1`, meaning that the value of `column` will be changed from `value1` to `value2`. Note that the expressions are not limited by `column = value`, and that the `column` has to be the same, it would be any expression. Also, this is really extensive as `SET` can set multiple variables and `WHERE` take more than one condition by chaining conditions with `AND`, `OR` and `NOT` keywords, for example. + +##### ON DELETE statement + +When an entry needs to be updated somehow based on a modification on a foreign key. If two tables are related to each other, if something is deleted on one end, update the other end in some way. + +For example on creation of a table, on the specification of a foreign key: `CREATE TABLE tablename (..., FOREIGN KEY(column) REFERENCES othertable(othertablecolumn) ON DELETE something)`. That something could be `SET NULL`, `CASCADE`, etc.. + +#### SELECT queries + +Instead of doing `SELECT * FROM tablename`, which gets all the data from a table, more complex `SELECT` queries can be implemented, such as `SELECT column FROM tablename` to only get all data from one column of the table. Append `LIMIT N` to limit the query to `N` entries. Append `WHERE condition` to meet a custom condition. + +Other statements that can be used in conjunction with `SELECT` are `ORDER BY column ASC|DESC`, `SELECT DISTINCT`, `MIN(column)`, `MAX(column)`, `COUNT(column)`, `AVG(column)`, `SUM(column)`, `LIKE` and more. For more, visit [MySQL 8.0 Reference Manual: 13.2.10 SELECT Statement](https://dev.mysql.com/doc/refman/8.0/en/select.html). + +MySQL uses regular expressions (regex) like pattern matching, some wildcards that can be used with the `LIKE` statement are: + +* `%`: zero or more characters. +* `_`: a single character. +* `[]`: any single character within the brackets. +* `^`: any character not in the brackets. +* `-`: a range of characters. + +An extended regex can be used with the statement `REGEX_LIKE(expression)`; `REGEXP` and `RLIKE` are synonyms for `REGEX_LIKE`. For more: [MySQL 8.0 Reference Manual: 3.3.4.7 Pattern Matching](https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html). + +#### Unions + +A specialized SQL operator that is used to combine multiple `SELECT` statements into one. The basic syntax is `SELECT ... UNION SELECT ...`, where `...` is a whole `SELECT` statement; there can be any amount of unions. There are some rules that apply when doing unions, such as having the same amount of columns on both statements and being of the same data type. + +#### Joins + +Used to combine rows from two or more tables based on a related column between them. Basic syntax is `SELECT table1.column1, ..., table2.column1, ... FROM table(1|2) JOIN table(1|2) ON table1.common_column = table2.common_column`, where the table specified in the `FROM` statement is called the "left" table, where the one in the `JOIN` statement is the "right" table. For more: [MySQL 8.0 Reference Manual: 13.2.10.2 JOIN Clause](https://dev.mysql.com/doc/refman/8.0/en/join.html). + +There are different types of SQL JOINs: + +* `(INNER) JOIN`: returns records that have matching values in both tables. +* `LEFT (OUTER) JOIN`: returns all records from the left table, and the matched records from the right table. +* `RIGHT (OUTER) JOIN`: returns all records from the right table, and the matched records from the left table. +* `FULL (OUTER) JOIN`: returns all records when there is a match in either left or right table. + +

+![INNER JOIN](images/b/notes/sql/img_innerjoin.gif) +![LEFT JOIN](images/b/notes/sql/img_leftjoin.gif) +![RIGHT JOIN](images/b/notes/sql/img_rightjoin.gif) +![FULL OUTER JOIN](images/b/notes/sql/img_fulljoin.gif) +

+ +#### Nested queries + +A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a `SELECT` query somewhere inside another one, for example `SELECT ... IN (SELECT ...)`, where the nesting is occurring inside the parenthesis after the `IN` statement. + +A nesting isn't constrained to the `IN` statement, it can appear anywhere, for example in a `WHERE` statement: `SELECT ... WHERE something = (SELECT ...)`. + +#### Triggers + +A block of SQL code that will define a certain action that will happen when a specific operation is performed on the database. It is **recommended to change the `DELIMITER` temporarily from semi-colon to something else** (since we need to use semi-colon to end the trigger) while the trigger is created. The basic syntax is `CREATE TRIGGER trigername triggertime triggerevent ON tablename FOR EACH ROW triggerorder triggerbody`. For more: [MySQL 8.0 Reference Manual: 13.1.22 CREATE TRIGGER Statement](https://dev.mysql.com/doc/refman/8.0/en/create-trigger.html) and [MySQL 8.0 Reference Manual: 25.3.1 Trigger Syntax and Examples](https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html). + +#### Entity Relationship Diagrams (ERD) + +When designing a database it's important to define a **database schema** which is just a definition of all the different tables and their attributes that are going to live inside the database. So, basically, an ERD diagram is a diagram that consists of text, symbols and shapes that are combined to create a relationship model. + +The diagram consists of: + +* **Entity**: a square with the name of the entity inside it. +* **Attributes**: ovals with the name of the attributes inside it; an attribute defines specific pieces of information about an entity (columns). +* **Primary key**: same as with attributes but with name underlined; the primary key uniquely identifies the entity. +* **Composite attribute**: an attribute that consists on one or more (sub-)attributes. +* **Multi-valued attribute**: oval with another oval inside it and the name of the attribute. +* **Derived attribute**: dotted oval; this attribute can be derived from other attributes from the entity. +* **Relationship**: a diamond with the relationship name in it, for the connections a single line (partial participation) or a doubled line (total participation); it denotes how two or more attributes are related to each other; all members must participate in the relationship. +* **Relationship attribute**: denoted like a normal attribute, but it's child of a relationship; it defines what attributes exists because of the relationship, it's not stored in any of the entities related, but on the relationship object itself. +* **Relationship cardinality**: denoted with a number on the line connecting the relationship to the entity; detones the number of instances of an entity from a relation that can be associated with the relation. +* **Weak entity**: rectangle inside a rectangle with its name inside; it cannot be uniquely identified by its attributes alone. +* **Weak entity's primary key**: oval with its text underlined, but the line is dotted. +* **Identifying relationship**: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity. + +![ERD example taken from wikipedia](images/b/notes/sql/erd_example.png) diff --git a/static/css/style.css b/static/css/style.css index 753cf3e..47ec270 100644 --- a/static/css/style.css +++ b/static/css/style.css @@ -41,6 +41,7 @@ body > footer { main { grid-area: main; border-radius: 5px; + padding-bottom: 0.5em; } a{ @@ -54,14 +55,20 @@ body > header, body > footer, main { padding-right: 0.5em; } +main.art { + width: clamp(30ch, calc(100% - 1em), 100%); +} + -/* article elements */ -div.article-info { +/* article/art elements */ +div.article-info, +div.art-info { line-height: 0.3; font-size: smaller; } -div.article-info > div.article-tags { +div.article-info > div.article-tags, +div.art-info > div.art-tags { font-size: larger; } @@ -224,7 +231,8 @@ img.qr { } /* img grid */ -div.img-grid, div.img-grid > p { +div.img-grid, +div.img-grid > p { display: grid; gap: 1em; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); @@ -238,17 +246,15 @@ div.img-grid img { overflow: hidden; } - -/* art grid */ -div.art-grid, div.art-grid > p { +/* art grid / art gallery */ +div.art-grid { display: grid; - gap: 1em; + gap: 0.5em; grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); - grid-auto-rows: minmax(250px, auto); + grid-auto-rows: auto; } -div.art-grid img { - border: 1px solid white; +div.art-grid a { display: flex; flex-direction: column; justify-content: center; @@ -256,12 +262,79 @@ div.art-grid img { overflow: hidden; } +div.art-grid a { + display: contents; +} + +div.art-grid img { + border: 1px solid white; + object-fit: cover; +} + +div.art-grid a.wide img { + width: 100%; +} + +div.art-grid a.tall img { + height: 100%; +} + @media screen and (min-width: 600px) { - div.art-grid img.wide { + div.art-grid a.wide img { grid-column: span 2 / auto; } - div.art-grid img.tall { + div.art-grid a.tall img { grid-row: span 2 / auto; } } + +a.zoom-in { + cursor: zoom-in; +} + +/* art nav */ +div.art-nav { + width: 100%; + display: grid; + grid-template-areas: + 'next index prev'; + grid-template-columns: 1fr 1fr 1fr; + + align-items: center; + justify-items: center; +} + +div.art-nav > span.index { + grid-area: index; +} + +div.art-nav > span.previous { + grid-area: prev; +} + +div.art-nav > span.next { + grid-area: next; +} + +div.art-nav > span { + border-radius: 5px; + min-width: 1em; + max-width: 10em; + padding-top: 0.2em; + padding-bottom: 0.2em; + padding-left: 0.4em; + padding-right: 0.4em; + margin-left: 0.2em; + margin-right: 0.2em; +} + +div.art-nav > span span { + display: none; +} + +@media screen and (min-width: 600px) { + div.art-nav > span span { + display: inline; + } +} diff --git a/static/css/theme.css b/static/css/theme.css index f490841..8f900ba 100644 --- a/static/css/theme.css +++ b/static/css/theme.css @@ -21,16 +21,16 @@ .theme-light { --bg: var(--color5); --body-bg: var(--color4); - --navitem-bg: var(--color9); - --navitem-bg-hl: var(--color10); + --navitem-bg: var(--color10); + --navitem-bg-hl: var(--color9); - --fg: var(--color3); - --fg-hl: var(--color0); + --fg: var(--color0); + --fg-hl: var(--color3); --link: var(--color15); --link-hl: var(--color7); - --navitem-link: var(--color8); - --navitem-link-hl: var(--color7); + --navitem-link: var(--color7); + --navitem-link-hl: var(--color6); --fg-acc1: var(--color11); --fg-acc2: var(--color12); @@ -44,6 +44,11 @@ --switch-sun: var(--color13); --code-border: var(--color3); + + --pagenav-bg: var(--color1); + --pagenav-bg-hl: var(--color2); + --pagenav-link: var(--color8); + --pagenav-link-hl: var(--color7); } .theme-dark { @@ -72,6 +77,11 @@ --switch-sun: var(--color13); --code-border: var(--color4); + + --pagenav-bg: var(--color10); + --pagenav-bg-hl: var(--color9); + --pagenav-link: var(--color7); + --pagenav-link-hl: var(--color6); } /* general */ @@ -177,3 +187,20 @@ button.theme-switcher > .fa-sun { .theme-light button.theme-switcher > .fa-sun { color: var(--switch-sun); } + +/* art nav */ +div.art-nav > span { + background: var(--pagenav-bg); +} + +div.art-nav > span > a { + color: var(--pagenav-link); +} + +div.art-nav > span:hover { + background: var(--pagenav-bg-hl); +} + +div.art-nav > span:hover > a { + color: var(--pagenav-link-hl); +} diff --git a/static/images/a/elephant_octopus.png b/static/images/a/elephant_octopus.png new file mode 100644 index 0000000..28fdd09 Binary files /dev/null and b/static/images/a/elephant_octopus.png differ diff --git a/static/images/a/elephant_octopus_small.png b/static/images/a/elephant_octopus_small.png new file mode 100644 index 0000000..bd43688 Binary files /dev/null and b/static/images/a/elephant_octopus_small.png differ -- cgit v1.2.3-70-g09d2

Elephant octopus

Index -- Luévano's Art

Art filtered by black-white

Art filtered by digital

Art filtered by drawing

Art filtered by spanish

Index -- {{config.title}}

{{page.title}}

Articles

{{p.cdate_list_sep}}

{{p.cdate_list_sep}}

Posts filtered by {{tag[0]}}

Art filtered by {{tag[0]}}

Linux tutorial video notes

(Basic) commands

File permissions and ownership

Services

User and group management

Networking

Hosts file

(Some) commands

Shell scripting tutorial video notes

Basic concepts

Common commands/programs

Shell scripting

Variables

Internal Field Separator (IFS)

Conditionals

Exit status

if statement

Case statement

Loops

Loop control

while loop

until loop

for loop

select loop

Meta characters

Functions

SQL tutorial video notes

What is a database (DB)?

Database Management Systems (DBMS)

CRUD

Two types of databases

Relational databases (RDB) (SQL)

Non-relational databases (NRDB) (noSQL/not just SQL)

Database queries

Tables and keys

SQL basics

Queries

Data types

Basic management of tables

ON DELETE statement

SELECT queries

Unions

Joins

Nested queries

Triggers

Entity Relationship Diagrams (ERD)

February 2021

Basic concepts

Common commands/programs

Shell scripting

Variables

Internal Field Separator (IFS)

Conditionals

Exit status

if statement

Case statement

Loops

Loop control

while loop

until loop

for loop

select loop

Meta characters

Functions

(Basic) commands

File permissions and ownership

Services

`if` statement

`while` loop

`until` loop

`for` loop

`select` loop

`if` statement

`while` loop

`until` loop

`for` loop

`select` loop