diff options
Diffstat (limited to 'blog')
28 files changed, 148 insertions, 68 deletions
diff --git a/blog/.gitignore b/blog/.gitignore deleted file mode 100644 index 741a103..0000000 --- a/blog/.gitignore +++ /dev/null @@ -1,2 +0,0 @@ -# Only keep track of source. -# dst/ diff --git a/blog/dst/a/asi_nomas_esta_quedando.html b/blog/dst/a/asi_nomas_esta_quedando.html index c966291..d8cdfc0 100644 --- a/blog/dst/a/asi_nomas_esta_quedando.html +++ b/blog/dst/a/asi_nomas_esta_quedando.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="es" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/el_blog_ya_tiene_timestamps.html b/blog/dst/a/el_blog_ya_tiene_timestamps.html index 409b29f..9136a86 100644 --- a/blog/dst/a/el_blog_ya_tiene_timestamps.html +++ b/blog/dst/a/el_blog_ya_tiene_timestamps.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="es" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/first_blog_post.html b/blog/dst/a/first_blog_post.html index 6610b25..0acb615 100644 --- a/blog/dst/a/first_blog_post.html +++ b/blog/dst/a/first_blog_post.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/git_server_with_cgit.html b/blog/dst/a/git_server_with_cgit.html index 43584fa..17fe0e4 100644 --- a/blog/dst/a/git_server_with_cgit.html +++ b/blog/dst/a/git_server_with_cgit.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/linux_video_notes.html b/blog/dst/a/linux_video_notes.html index 22e9040..8a7ee0e 100644 --- a/blog/dst/a/linux_video_notes.html +++ b/blog/dst/a/linux_video_notes.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/mail_server_with_postfix.html b/blog/dst/a/mail_server_with_postfix.html index a3ab2c5..952b84b 100644 --- a/blog/dst/a/mail_server_with_postfix.html +++ b/blog/dst/a/mail_server_with_postfix.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> @@ -299,7 +303,7 @@ account required pam_unix.so <pre><code class="language-sh">systemctl start dovecot.service systemctl enable dovecot.service </code></pre> -<h1 id="opendkim">OpenDKIM</h1> +<h2 id="opendkim">OpenDKIM</h2> <p><a href="https://wiki.archlinux.org/index.php/OpenDKIM">OpenDKIM</a> is needed so services like G**gle (we don’t mention that name here [[[this is a meme]]]) don’t throw the mail to the trash. DKIM stands for “DomainKeys Identified Mail”.</p> <p>Install the <code>opendkim</code> package:</p> <pre><code class="language-sh">pacman -S opendkim @@ -436,7 +440,7 @@ systemctl enable spamassassin.service <li>Password: your <code>user</code> password (as in the password you use to login to the server with that user)</li> </ul> <p>All that’s left to do is test your mail server for spoofing, and to see if everything is setup correctly. Go to <a href="https://www.appmaildev.com/en/dkim">DKIM Test</a> and follow the instructions (basically click next, and send an email with whatever content to the email that they provide). After you send the email, you should see something like:</p> -<p><img alt="DKIM Test successful" src="https://static.luevano.xyz/images/b/notes/mail/dkim_test_successful.png"></p> +<p><img alt="DKIM Test successful" src="images/b/notes/mail/dkim_test_successful.png"></p> <p>(Yes, I blurred a lot in the picture just to be sure, either way what’s important is the list on the bottom part of the image)</p> <p>Finally, that’s actually it for this entry, if you have any problem whatsoever you have my info down below.</p> @@ -444,7 +448,7 @@ systemctl enable spamassassin.service <div class="article-info"> <p>By David Luévano</p> <p>Created: Sun, Mar 21, 2021 @ 04:05 UTC</p> - <p>Modified: Fri, Jun 04, 2021 @ 07:59 UTC</p> + <p>Modified: Sun, Jun 06, 2021 @ 00:24 UTC</p> <div class="article-tags"> <p>Tags: <a href="https://blog.luevano.xyz/tag/@english.html">english</a>, <a href="https://blog.luevano.xyz/tag/@server.html">server</a>, <a href="https://blog.luevano.xyz/tag/@tools.html">tools</a>, <a href="https://blog.luevano.xyz/tag/@tutorial.html">tutorial</a> </p> diff --git a/blog/dst/a/new_blogging_system.html b/blog/dst/a/new_blogging_system.html index 2d79ba4..216ed0c 100644 --- a/blog/dst/a/new_blogging_system.html +++ b/blog/dst/a/new_blogging_system.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/shell_scripting_video_notes.html b/blog/dst/a/shell_scripting_video_notes.html index 097a1c3..d048c1d 100644 --- a/blog/dst/a/shell_scripting_video_notes.html +++ b/blog/dst/a/shell_scripting_video_notes.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html index 14a0e56..867c265 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> @@ -186,10 +190,10 @@ <li><code>RIGHT (OUTER) JOIN</code>: returns all records from the right table, and the matched records from the left table.</li> <li><code>FULL (OUTER) JOIN</code>: returns all records when there is a match in either left or right table.</li> </ul> -<p><img alt="INNER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_innerjoin.gif"> -<img alt="LEFT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_leftjoin.gif"> -<img alt="RIGHT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_rightjoin.gif"> -<img alt="FULL OUTER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_fulljoin.gif"></p> +<p><img alt="INNER JOIN" src="images/b/notes/sql/img_innerjoin.gif"> +<img alt="LEFT JOIN" src="images/b/notes/sql/img_leftjoin.gif"> +<img alt="RIGHT JOIN" src="images/b/notes/sql/img_rightjoin.gif"> +<img alt="FULL OUTER JOIN" src="images/b/notes/sql/img_fulljoin.gif"></p> <h4 id="nested-queries">Nested queries</h4> <p>A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a <code>SELECT</code> query somewhere inside another one, for example <code>SELECT ... IN (SELECT ...)</code>, where the nesting is occurring inside the parenthesis after the <code>IN</code> statement.</p> <p>A nesting isn’t constrained to the <code>IN</code> statement, it can appear anywhere, for example in a <code>WHERE</code> statement: <code>SELECT ... WHERE something = (SELECT ...)</code>.</p> @@ -212,13 +216,13 @@ <li><strong>Weak entity’s primary key</strong>: oval with its text underlined, but the line is dotted.</li> <li><strong>Identifying relationship</strong>: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.</li> </ul> -<p><img alt="ERD example taken from wikipedia" src="https://static.luevano.xyz/images/b/notes/sql/erd_example.png"></p> +<p><img alt="ERD example taken from wikipedia" src="images/b/notes/sql/erd_example.png"></p> <hr> <div class="article-info"> <p>By David Luévano</p> <p>Created: Tue, Mar 02, 2021 @ 14:35 UTC</p> - <p>Modified: Fri, Jun 04, 2021 @ 08:00 UTC</p> + <p>Modified: Sun, Jun 06, 2021 @ 00:22 UTC</p> <div class="article-tags"> <p>Tags: <a href="https://blog.luevano.xyz/tag/@english.html">english</a>, <a href="https://blog.luevano.xyz/tag/@notes.html">notes</a> </p> diff --git a/blog/dst/a/website_with_nginx.html b/blog/dst/a/website_with_nginx.html index 9b773de..7834b31 100644 --- a/blog/dst/a/website_with_nginx.html +++ b/blog/dst/a/website_with_nginx.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> @@ -100,7 +104,7 @@ systemctl enable nginx.service systemctl start nginx.service </code></pre> <p>And that’s it, at this point you can already look at the default initial page of nginx if you enter the ip of your server in a web browser. You should see something like this:</p> -<p><img alt="Nginx welcome page" src="https://static.luevano.xyz/images/b/notes/nginx/nginx_welcome_page.png"></p> +<p><img alt="Nginx welcome page" src="images/b/notes/nginx/nginx_welcome_page.png"></p> <p>As stated in the welcome page, configuration is needed, head to the directory of nginx:</p> <pre><code class="language-sh">cd /etc/nginx </code></pre> @@ -163,7 +167,7 @@ cd sites-available systemctl restart nginx </code></pre> <p>If everything goes correctly, you can now go to your website by typing “domain.name” on a web browser. But you will see a “404 Not Found” page like the following (maybe with different nginx version):</p> -<p><img alt="Nginx 404 page" src="https://static.luevano.xyz/images/b/notes/nginx/nginx_404_page.png"></p> +<p><img alt="Nginx 404 page" src="images/b/notes/nginx/nginx_404_page.png"></p> <p>That’s no problem, because it means that the web server it’s actually working. Just add an <code>index.html</code> file with something simple to see it in action. If you keep seeing the 404 page make sure your <code>root</code> line is correct and that the directory/index file exists.</p> <p>I like to remove the <code>.html</code> and trailing <code>/</code> on the URLs of my website, for that you need to add the following <code>rewrite</code> lines and modify the <code>try_files</code> line (for more: <a href="https://www.seancdavis.com/blog/remove-html-extension-and-trailing-slash-in-nginx-config/">Sean C. Davis: Remove HTML Extension And Trailing Slash In Nginx Config</a>):</p> <pre><code class="language-nginx">server { @@ -194,7 +198,7 @@ systemctl restart nginx <div class="article-info"> <p>By David Luévano</p> <p>Created: Fri, Mar 19, 2021 @ 02:58 UTC</p> - <p>Modified: Fri, Jun 04, 2021 @ 08:00 UTC</p> + <p>Modified: Sun, Jun 06, 2021 @ 00:23 UTC</p> <div class="article-tags"> <p>Tags: <a href="https://blog.luevano.xyz/tag/@english.html">english</a>, <a href="https://blog.luevano.xyz/tag/@server.html">server</a>, <a href="https://blog.luevano.xyz/tag/@tools.html">tools</a>, <a href="https://blog.luevano.xyz/tag/@tutorial.html">tutorial</a> </p> diff --git a/blog/dst/index.html b/blog/dst/index.html index 713216b..2a9b624 100644 --- a/blog/dst/index.html +++ b/blog/dst/index.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/rss.xml b/blog/dst/rss.xml index cacc374..eea52d2 100644 --- a/blog/dst/rss.xml +++ b/blog/dst/rss.xml @@ -1,5 +1,6 @@ <?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" + xml:base="https://static.luevano.xyz" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:content="http://purl.org/rss/1.0/modules/content/"> <channel> @@ -12,8 +13,8 @@ <copyright>Copyright 2021 David Luévano Alvarado</copyright> <managingEditor>david@luevano.xyz (David Luévano Alvarado)</managingEditor> <webMaster>david@luevano.xyz (David Luévano Alvarado)</webMaster> - <pubDate>Sat, 05 Jun 2021 09:41:27 GMT</pubDate> - <lastBuildDate>Sat, 05 Jun 2021 09:41:27 GMT</lastBuildDate> + <pubDate>Sun, 06 Jun 2021 00:30:52 GMT</pubDate> + <lastBuildDate>Sun, 06 Jun 2021 00:30:52 GMT</lastBuildDate> <generator>pyssg v0.5.5</generator> <docs>https://validator.w3.org/feed/docs/rss2.html</docs> <ttl>30</ttl> @@ -404,7 +405,7 @@ account required pam_unix.so <pre><code class="language-sh">systemctl start dovecot.service systemctl enable dovecot.service </code></pre> -<h1 id="opendkim">OpenDKIM</h1> +<h2 id="opendkim">OpenDKIM</h2> <p><a href="https://wiki.archlinux.org/index.php/OpenDKIM">OpenDKIM</a> is needed so services like G**gle (we don’t mention that name here [[[this is a meme]]]) don’t throw the mail to the trash. DKIM stands for “DomainKeys Identified Mail”.</p> <p>Install the <code>opendkim</code> package:</p> <pre><code class="language-sh">pacman -S opendkim @@ -541,7 +542,7 @@ systemctl enable spamassassin.service <li>Password: your <code>user</code> password (as in the password you use to login to the server with that user)</li> </ul> <p>All that’s left to do is test your mail server for spoofing, and to see if everything is setup correctly. Go to <a href="https://www.appmaildev.com/en/dkim">DKIM Test</a> and follow the instructions (basically click next, and send an email with whatever content to the email that they provide). After you send the email, you should see something like:</p> -<p><img alt="DKIM Test successful" src="https://static.luevano.xyz/images/b/notes/mail/dkim_test_successful.png"></p> +<p><img alt="DKIM Test successful" src="images/b/notes/mail/dkim_test_successful.png"></p> <p>(Yes, I blurred a lot in the picture just to be sure, either way what’s important is the list on the bottom part of the image)</p> <p>Finally, that’s actually it for this entry, if you have any problem whatsoever you have my info down below.</p>]]></content:encoded> </item> @@ -578,7 +579,7 @@ systemctl enable nginx.service systemctl start nginx.service </code></pre> <p>And that’s it, at this point you can already look at the default initial page of nginx if you enter the ip of your server in a web browser. You should see something like this:</p> -<p><img alt="Nginx welcome page" src="https://static.luevano.xyz/images/b/notes/nginx/nginx_welcome_page.png"></p> +<p><img alt="Nginx welcome page" src="images/b/notes/nginx/nginx_welcome_page.png"></p> <p>As stated in the welcome page, configuration is needed, head to the directory of nginx:</p> <pre><code class="language-sh">cd /etc/nginx </code></pre> @@ -641,7 +642,7 @@ cd sites-available systemctl restart nginx </code></pre> <p>If everything goes correctly, you can now go to your website by typing “domain.name” on a web browser. But you will see a “404 Not Found” page like the following (maybe with different nginx version):</p> -<p><img alt="Nginx 404 page" src="https://static.luevano.xyz/images/b/notes/nginx/nginx_404_page.png"></p> +<p><img alt="Nginx 404 page" src="images/b/notes/nginx/nginx_404_page.png"></p> <p>That’s no problem, because it means that the web server it’s actually working. Just add an <code>index.html</code> file with something simple to see it in action. If you keep seeing the 404 page make sure your <code>root</code> line is correct and that the directory/index file exists.</p> <p>I like to remove the <code>.html</code> and trailing <code>/</code> on the URLs of my website, for that you need to add the following <code>rewrite</code> lines and modify the <code>try_files</code> line (for more: <a href="https://www.seancdavis.com/blog/remove-html-extension-and-trailing-slash-in-nginx-config/">Sean C. Davis: Remove HTML Extension And Trailing Slash In Nginx Config</a>):</p> <pre><code class="language-nginx">server { @@ -1095,10 +1096,10 @@ function_name () { <li><code>RIGHT (OUTER) JOIN</code>: returns all records from the right table, and the matched records from the left table.</li> <li><code>FULL (OUTER) JOIN</code>: returns all records when there is a match in either left or right table.</li> </ul> -<p><img alt="INNER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_innerjoin.gif"> -<img alt="LEFT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_leftjoin.gif"> -<img alt="RIGHT JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_rightjoin.gif"> -<img alt="FULL OUTER JOIN" src="https://static.luevano.xyz/images/b/notes/sql/img_fulljoin.gif"></p> +<p><img alt="INNER JOIN" src="images/b/notes/sql/img_innerjoin.gif"> +<img alt="LEFT JOIN" src="images/b/notes/sql/img_leftjoin.gif"> +<img alt="RIGHT JOIN" src="images/b/notes/sql/img_rightjoin.gif"> +<img alt="FULL OUTER JOIN" src="images/b/notes/sql/img_fulljoin.gif"></p> <h4 id="nested-queries">Nested queries</h4> <p>A query composed of multiple select statements to get a specific piece of information. This is self explanatory, you do a <code>SELECT</code> query somewhere inside another one, for example <code>SELECT ... IN (SELECT ...)</code>, where the nesting is occurring inside the parenthesis after the <code>IN</code> statement.</p> <p>A nesting isn’t constrained to the <code>IN</code> statement, it can appear anywhere, for example in a <code>WHERE</code> statement: <code>SELECT ... WHERE something = (SELECT ...)</code>.</p> @@ -1121,7 +1122,7 @@ function_name () { <li><strong>Weak entity’s primary key</strong>: oval with its text underlined, but the line is dotted.</li> <li><strong>Identifying relationship</strong>: a diamond inside a diamond with its name inside; a relationship that serves to uniquely identify the weak entity.</li> </ul> -<p><img alt="ERD example taken from wikipedia" src="https://static.luevano.xyz/images/b/notes/sql/erd_example.png"></p>]]></content:encoded> +<p><img alt="ERD example taken from wikipedia" src="images/b/notes/sql/erd_example.png"></p>]]></content:encoded> </item> <item> <title>This is the first blog post, just for testing purposes</title> diff --git a/blog/dst/sitemap.xml b/blog/dst/sitemap.xml index 35adaea..4c43131 100644 --- a/blog/dst/sitemap.xml +++ b/blog/dst/sitemap.xml @@ -22,13 +22,13 @@ </url> <url> <loc>https://blog.luevano.xyz/a/mail_server_with_postfix.html</loc> - <lastmod>2021-06-04</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>weekly</changefreq> <priority>1.0</priority> </url> <url> <loc>https://blog.luevano.xyz/a/website_with_nginx.html</loc> - <lastmod>2021-06-04</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>weekly</changefreq> <priority>1.0</priority> </url> @@ -52,7 +52,7 @@ </url> <url> <loc>https://blog.luevano.xyz/a/sql_video_notes.html</loc> - <lastmod>2021-06-04</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>weekly</changefreq> <priority>1.0</priority> </url> @@ -65,49 +65,49 @@ <url> <loc>https://blog.luevano.xyz/tag/@english.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@notes.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@server.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@short.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@spanish.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@tools.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@tutorial.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> <url> <loc>https://blog.luevano.xyz/tag/@update.html</loc> - <lastmod>2021-06-05</lastmod> + <lastmod>2021-06-06</lastmod> <changefreq>daily</changefreq> <priority>0.5</priority> </url> diff --git a/blog/dst/tag/@english.html b/blog/dst/tag/@english.html index af5136a..e42a8fd 100644 --- a/blog/dst/tag/@english.html +++ b/blog/dst/tag/@english.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@notes.html b/blog/dst/tag/@notes.html index d0818e4..a42d265 100644 --- a/blog/dst/tag/@notes.html +++ b/blog/dst/tag/@notes.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@server.html b/blog/dst/tag/@server.html index 222bab6..59b857b 100644 --- a/blog/dst/tag/@server.html +++ b/blog/dst/tag/@server.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@short.html b/blog/dst/tag/@short.html index bae4a32..96721d0 100644 --- a/blog/dst/tag/@short.html +++ b/blog/dst/tag/@short.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@spanish.html b/blog/dst/tag/@spanish.html index 9e297d4..b2f72c4 100644 --- a/blog/dst/tag/@spanish.html +++ b/blog/dst/tag/@spanish.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@tools.html b/blog/dst/tag/@tools.html index 01556dc..e137805 100644 --- a/blog/dst/tag/@tools.html +++ b/blog/dst/tag/@tools.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@tutorial.html b/blog/dst/tag/@tutorial.html index 00d3590..44a471c 100644 --- a/blog/dst/tag/@tutorial.html +++ b/blog/dst/tag/@tutorial.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/dst/tag/@update.html b/blog/dst/tag/@update.html index 372efa8..b3e14cf 100644 --- a/blog/dst/tag/@update.html +++ b/blog/dst/tag/@update.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="en" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="https://static.luevano.xyz"> <meta charset="utf-8"> @@ -46,6 +46,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/plt/base.html b/blog/plt/base.html index 6c56ac4..19377d3 100644 --- a/blog/plt/base.html +++ b/blog/plt/base.html @@ -1,6 +1,6 @@ <!DOCTYPE html> <html lang="{%block html_lang%}{%endblock html_lang%}" - prefix="og: https://ogp.me/ns#"> + prefix="og: https://ogp.me/ns#"> <head> <base href="{{config.static_url}}"> <meta charset="utf-8"> @@ -40,6 +40,10 @@ <a href="https://blog.luevano.xyz/"><i class="fas fa-book-open" alt="Blog"></i><span>Blog</span></a> </li> + <li> + <a href="https://art.luevano.xyz/"><i class="fas fa-paint-brush" alt="Art"></i><span>Art</span></a> + </li> + <li><i class="fab fa-git" alt="Git"></i><span>Git</span> <ul> <li><a href="https://git.luevano.xyz/" target="_blank"><i class="fab fa-git-alt" alt="Git-alt"></i></a></li> diff --git a/blog/plt/rss.xml b/blog/plt/rss.xml index 5be7c37..5ce541d 100644 --- a/blog/plt/rss.xml +++ b/blog/plt/rss.xml @@ -1,5 +1,6 @@ <?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" + xml:base="https://static.luevano.xyz" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:content="http://purl.org/rss/1.0/modules/content/"> <channel> diff --git a/blog/src/.files b/blog/src/.files index cf14e06..361c663 100644 --- a/blog/src/.files +++ b/blog/src/.files @@ -1,10 +1,10 @@ -a/website_with_nginx.md 1616122695.085315 1622793656.0817287 english,server,tools,tutorial +a/website_with_nginx.md 1616122695.085315 1622938985.447357 english,server,tools,tutorial a/git_server_with_cgit.md 1616353229.8983006 1622793595.4845119 english,server,tools,tutorial a/el_blog_ya_tiene_timestamps.md 1615862784.9032707 1621284818.4731243 short,spanish,tools,update a/shell_scripting_video_notes.md 1615701454.6499224 1622793622.0414143 english,notes -a/sql_video_notes.md 1614695711.6048582 1622793648.6416588 english,notes +a/sql_video_notes.md 1614695711.6048582 1622938935.8065531 english,notes a/first_blog_post.md 1614431313.2090824 1621284833.6700118 english,short,tools,update a/linux_video_notes.md 1615701443.6397786 1622793573.704325 english,notes -a/mail_server_with_postfix.md 1616299559.6570284 1622793584.6210845 english,server,tools,tutorial +a/mail_server_with_postfix.md 1616299559.6570284 1622939041.148257 english,server,tools,tutorial a/new_blogging_system.md 1622172099.117893 1622173322.4337702 english,short,tools,update a/asi_nomas_esta_quedando.md 1622795043.0874712 0.0 short,spanish,update diff --git a/blog/src/a/mail_server_with_postfix.md b/blog/src/a/mail_server_with_postfix.md index d72ecac..b65cf54 100644 --- a/blog/src/a/mail_server_with_postfix.md +++ b/blog/src/a/mail_server_with_postfix.md @@ -316,7 +316,7 @@ systemctl start dovecot.service systemctl enable dovecot.service ``` -# OpenDKIM +## OpenDKIM [OpenDKIM](https://wiki.archlinux.org/index.php/OpenDKIM) is needed so services like G\*\*gle (we don't mention that name here \[\[\[this is a meme\]\]\]) don't throw the mail to the trash. DKIM stands for "DomainKeys Identified Mail". @@ -518,7 +518,7 @@ Next, to actually login into a mail app/program/whateveryouwanttocallit, you wil All that's left to do is test your mail server for spoofing, and to see if everything is setup correctly. Go to [DKIM Test](https://www.appmaildev.com/en/dkim) and follow the instructions (basically click next, and send an email with whatever content to the email that they provide). After you send the email, you should see something like: - + (Yes, I blurred a lot in the picture just to be sure, either way what's important is the list on the bottom part of the image) diff --git a/blog/src/a/sql_video_notes.md b/blog/src/a/sql_video_notes.md index b6662db..91c5976 100644 --- a/blog/src/a/sql_video_notes.md +++ b/blog/src/a/sql_video_notes.md @@ -140,10 +140,10 @@ There are different types of SQL JOINs: * `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. - - - - + + + + #### Nested queries @@ -174,4 +174,4 @@ The diagram consists of: * **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. - + diff --git a/blog/src/a/website_with_nginx.md b/blog/src/a/website_with_nginx.md index 1682da2..95c90c1 100644 --- a/blog/src/a/website_with_nginx.md +++ b/blog/src/a/website_with_nginx.md @@ -34,7 +34,7 @@ systemctl start nginx.service And that's it, at this point you can already look at the default initial page of nginx if you enter the ip of your server in a web browser. You should see something like this: - + As stated in the welcome page, configuration is needed, head to the directory of nginx: @@ -117,7 +117,7 @@ systemctl restart nginx If everything goes correctly, you can now go to your website by typing "domain.name" on a web browser. But you will see a "404 Not Found" page like the following (maybe with different nginx version): - + That's no problem, because it means that the web server it's actually working. Just add an `index.html` file with something simple to see it in action. If you keep seeing the 404 page make sure your `root` line is correct and that the directory/index file exists. |