diff options
32 files changed, 278 insertions, 45 deletions
diff --git a/blog/dst/a/asi_nomas_esta_quedando.html b/blog/dst/a/asi_nomas_esta_quedando.html index d8cdfc0..e66162c 100644 --- a/blog/dst/a/asi_nomas_esta_quedando.html +++ b/blog/dst/a/asi_nomas_esta_quedando.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Así nomás está quedando el página -- Luévano's Blog"/> diff --git a/blog/dst/a/el_blog_ya_tiene_timestamps.html b/blog/dst/a/el_blog_ya_tiene_timestamps.html index 9136a86..acb94fa 100644 --- a/blog/dst/a/el_blog_ya_tiene_timestamps.html +++ b/blog/dst/a/el_blog_ya_tiene_timestamps.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Así es raza, el blog ya tiene timestamps -- Luévano's Blog"/> diff --git a/blog/dst/a/first_blog_post.html b/blog/dst/a/first_blog_post.html index 0acb615..388d703 100644 --- a/blog/dst/a/first_blog_post.html +++ b/blog/dst/a/first_blog_post.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="This is the first blog post, just for testing purposes -- Luévano's Blog"/> diff --git a/blog/dst/a/git_server_with_cgit.html b/blog/dst/a/git_server_with_cgit.html index 17fe0e4..65dbb4f 100644 --- a/blog/dst/a/git_server_with_cgit.html +++ b/blog/dst/a/git_server_with_cgit.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Create a git server and setup cgit web app (on Nginx) -- Luévano's Blog"/> diff --git a/blog/dst/a/linux_video_notes.html b/blog/dst/a/linux_video_notes.html index 8a7ee0e..fce901a 100644 --- a/blog/dst/a/linux_video_notes.html +++ b/blog/dst/a/linux_video_notes.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Linux tutorial video notes -- Luévano's Blog"/> diff --git a/blog/dst/a/mail_server_with_postfix.html b/blog/dst/a/mail_server_with_postfix.html index 952b84b..e07e1b8 100644 --- a/blog/dst/a/mail_server_with_postfix.html +++ b/blog/dst/a/mail_server_with_postfix.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM -- Luévano's Blog"/> diff --git a/blog/dst/a/new_blogging_system.html b/blog/dst/a/new_blogging_system.html index 216ed0c..8e517dd 100644 --- a/blog/dst/a/new_blogging_system.html +++ b/blog/dst/a/new_blogging_system.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="I'm using a new blogging system -- Luévano's Blog"/> diff --git a/blog/dst/a/shell_scripting_video_notes.html b/blog/dst/a/shell_scripting_video_notes.html index d048c1d..7d7fdd2 100644 --- a/blog/dst/a/shell_scripting_video_notes.html +++ b/blog/dst/a/shell_scripting_video_notes.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Shell scripting tutorial video notes -- Luévano's Blog"/> diff --git a/blog/dst/a/sql_video_notes.html b/blog/dst/a/sql_video_notes.html index 867c265..9205eb6 100644 --- a/blog/dst/a/sql_video_notes.html +++ b/blog/dst/a/sql_video_notes.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="SQL tutorial video notes -- Luévano's Blog"/> @@ -190,10 +190,12 @@ <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> +<div class="img-grid"> <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> +</div> <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> @@ -222,7 +224,7 @@ <div class="article-info"> <p>By David Luévano</p> <p>Created: Tue, Mar 02, 2021 @ 14:35 UTC</p> - <p>Modified: Sun, Jun 06, 2021 @ 00:22 UTC</p> + <p>Modified: Sun, Jun 06, 2021 @ 03:41 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 7834b31..5cb1875 100644 --- a/blog/dst/a/website_with_nginx.html +++ b/blog/dst/a/website_with_nginx.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Create a website with Nginx and Certbot -- Luévano's Blog"/> diff --git a/blog/dst/index.html b/blog/dst/index.html index 2a9b624..2d30138 100644 --- a/blog/dst/index.html +++ b/blog/dst/index.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Index -- Luévano's Blog"/> @@ -96,7 +96,7 @@ <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>June 2021</h3> <li>Jun 04 - <a href="https://blog.luevano.xyz/a/asi_nomas_esta_quedando.html">Así nomás está quedando el página</a></li> <h3>May 2021</h3> diff --git a/blog/dst/rss.xml b/blog/dst/rss.xml index eea52d2..4a949b8 100644 --- a/blog/dst/rss.xml +++ b/blog/dst/rss.xml @@ -13,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>Sun, 06 Jun 2021 00:30:52 GMT</pubDate> - <lastBuildDate>Sun, 06 Jun 2021 00:30:52 GMT</lastBuildDate> + <pubDate>Sun, 06 Jun 2021 04:16:37 GMT</pubDate> + <lastBuildDate>Sun, 06 Jun 2021 04:16:37 GMT</lastBuildDate> <generator>pyssg v0.5.5</generator> <docs>https://validator.w3.org/feed/docs/rss2.html</docs> <ttl>30</ttl> @@ -1096,10 +1096,12 @@ 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> +<div class="img-grid"> <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> +</div> <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> diff --git a/blog/dst/tag/@english.html b/blog/dst/tag/@english.html index e42a8fd..62d8ea3 100644 --- a/blog/dst/tag/@english.html +++ b/blog/dst/tag/@english.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by english -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by english</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>May 2021</h3> <li>May 28 - <a href="https://blog.luevano.xyz/a/new_blogging_system.html">I'm using a new blogging system</a></li> <h3>March 2021</h3> diff --git a/blog/dst/tag/@notes.html b/blog/dst/tag/@notes.html index a42d265..d4a1216 100644 --- a/blog/dst/tag/@notes.html +++ b/blog/dst/tag/@notes.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by notes -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by notes</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>March 2021</h3> <li>Mar 14 - <a href="https://blog.luevano.xyz/a/shell_scripting_video_notes.html">Shell scripting tutorial video notes</a></li> <li>Mar 14 - <a href="https://blog.luevano.xyz/a/linux_video_notes.html">Linux tutorial video notes</a></li> diff --git a/blog/dst/tag/@server.html b/blog/dst/tag/@server.html index 59b857b..8f4ad53 100644 --- a/blog/dst/tag/@server.html +++ b/blog/dst/tag/@server.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by server -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by server</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>March 2021</h3> <li>Mar 21 - <a href="https://blog.luevano.xyz/a/git_server_with_cgit.html">Create a git server and setup cgit web app (on Nginx)</a></li> <li>Mar 21 - <a href="https://blog.luevano.xyz/a/mail_server_with_postfix.html">Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM</a></li> diff --git a/blog/dst/tag/@short.html b/blog/dst/tag/@short.html index 96721d0..0157d7f 100644 --- a/blog/dst/tag/@short.html +++ b/blog/dst/tag/@short.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by short -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by short</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>June 2021</h3> <li>Jun 04 - <a href="https://blog.luevano.xyz/a/asi_nomas_esta_quedando.html">Así nomás está quedando el página</a></li> <h3>May 2021</h3> diff --git a/blog/dst/tag/@spanish.html b/blog/dst/tag/@spanish.html index b2f72c4..9788ed0 100644 --- a/blog/dst/tag/@spanish.html +++ b/blog/dst/tag/@spanish.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by spanish -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by spanish</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>June 2021</h3> <li>Jun 04 - <a href="https://blog.luevano.xyz/a/asi_nomas_esta_quedando.html">Así nomás está quedando el página</a></li> <h3>March 2021</h3> diff --git a/blog/dst/tag/@tools.html b/blog/dst/tag/@tools.html index e137805..fcc6d4b 100644 --- a/blog/dst/tag/@tools.html +++ b/blog/dst/tag/@tools.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by tools -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by tools</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>May 2021</h3> <li>May 28 - <a href="https://blog.luevano.xyz/a/new_blogging_system.html">I'm using a new blogging system</a></li> <h3>March 2021</h3> diff --git a/blog/dst/tag/@tutorial.html b/blog/dst/tag/@tutorial.html index 44a471c..308f334 100644 --- a/blog/dst/tag/@tutorial.html +++ b/blog/dst/tag/@tutorial.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by tutorial -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by tutorial</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>March 2021</h3> <li>Mar 21 - <a href="https://blog.luevano.xyz/a/git_server_with_cgit.html">Create a git server and setup cgit web app (on Nginx)</a></li> <li>Mar 21 - <a href="https://blog.luevano.xyz/a/mail_server_with_postfix.html">Create a mail server with Postfix, Dovecot, SpamAssassin and OpenDKIM</a></li> diff --git a/blog/dst/tag/@update.html b/blog/dst/tag/@update.html index b3e14cf..f05dee2 100644 --- a/blog/dst/tag/@update.html +++ b/blog/dst/tag/@update.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> <meta property="og:title" content="Posts filtered by update -- Luévano's Blog"/> @@ -82,7 +82,7 @@ <h1>Posts filtered by update</h1> <h2>Articles</h2> - <ul> + <ul class="page-list"> <h3>June 2021</h3> <li>Jun 04 - <a href="https://blog.luevano.xyz/a/asi_nomas_esta_quedando.html">Así nomás está quedando el página</a></li> <h3>May 2021</h3> diff --git a/blog/plt/base.html b/blog/plt/base.html index 19377d3..42564d0 100644 --- a/blog/plt/base.html +++ b/blog/plt/base.html @@ -22,7 +22,7 @@ <!-- theme related --> <script type="text/javascript" src="scripts/theme.js"></script> <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> - <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/solarized-dark.min.css"> + <link id="code-theme-css" rel="stylesheet" type="text/css" href="hl/styles/nord.min.css"> <!-- og meta --> {%block head_og%}{%endblock head_og%} diff --git a/blog/plt/page_list.html b/blog/plt/page_list.html index 16dc4d5..bd1f678 100644 --- a/blog/plt/page_list.html +++ b/blog/plt/page_list.html @@ -1,6 +1,6 @@ {%macro print(pages)%} <h2>Articles</h2> - <ul> + <ul class="page-list"> {%for p in pages%} {%if loop.previtem%} {%if loop.previtem.cdate_list_sep !=p.cdate_list_sep%} diff --git a/blog/src/.files b/blog/src/.files index 361c663..d74933b 100644 --- a/blog/src/.files +++ b/blog/src/.files @@ -2,7 +2,7 @@ a/website_with_nginx.md 1616122695.085315 1622938985.447357 english,server,tools 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 1622938935.8065531 english,notes +a/sql_video_notes.md 1614695711.6048582 1622950879.0081563 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 1622939041.148257 english,server,tools,tutorial diff --git a/blog/src/a/sql_video_notes.md b/blog/src/a/sql_video_notes.md index 91c5976..ff20f26 100644 --- a/blog/src/a/sql_video_notes.md +++ b/blog/src/a/sql_video_notes.md @@ -140,10 +140,12 @@ 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. +<div class="img-grid" markdown="1"> ![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) +</div> #### Nested queries diff --git a/luevano/404.html b/luevano/404.html index 1b366ed..ade81da 100644 --- a/luevano/404.html +++ b/luevano/404.html @@ -6,6 +6,8 @@ <meta name="viewport" content="width=device-width, initial-scale=1"> <title>404 Not found -- Luévano's Site</title> <meta name="description" content="404 page."/> + <link rel="alternate" type="application/rss+xml" href="https://blog.luevano.xyz/rss.xml" title="Luévano's Blog RSS"> + <link rel="alternate" type="application/rss+xml" href="https://art.luevano.xyz/rss.xml" title="Luévano's Art RSS"> <link rel="icon" href="images/icons/favicon.ico"> <!-- general style --> diff --git a/luevano/contact.html b/luevano/contact.html index 783a70a..479aec6 100644 --- a/luevano/contact.html +++ b/luevano/contact.html @@ -79,7 +79,7 @@ Contact </h1> - <img src="images/gifs/head_talking_1_trans.gif" alt="Contact info"> + <img class="wrap-right" src="images/gifs/head_talking_1_trans.gif" alt="Contact info"> <p> You can contact me through: @@ -97,7 +97,6 @@ <br> <a href='https://compliance.conversations.im/server/luevano.xyz'><img src='https://compliance.conversations.im/badge/luevano.xyz'></a> - <br> <a href='https://xmpp.net/result.php?domain=luevano.xyz&type=client'><img src='https://xmpp.net/badge.php?domain=luevano.xyz' alt='xmpp.net score'/></a> </li> diff --git a/luevano/donate.html b/luevano/donate.html index fa4468a..a241802 100644 --- a/luevano/donate.html +++ b/luevano/donate.html @@ -79,14 +79,14 @@ Donate </h1> - <img src="images/gifs/dollar_sign_spin_1.gif" alt="Donate"> + <img class="wrap-right" src="images/gifs/dollar_sign_spin_1.gif" alt="Donate"> <p> - I don't really do much on the internet nor do I provide any type of service, but still, if for some reason you want to donate, you can do it via my <i class="fab fa-paypal" alt="Paypal"></i><a href="https://paypal.me/dlvna">Paypal</a>, either by its link or using my email <code class="email">david@luevano.xyz</code>. + I don't really do much on the internet nor do I provide any type of service, but still, if for some reason you want to donate, you can do it via my <i class="fab fa-paypal" alt="Paypal"></i> <a href="https://paypal.me/dlvna">Paypal</a>, either by its link or using my email <code class="email">david@luevano.xyz</code>. </p> <p> - I wanted to add more *fiat* options but I don't have access to them *down here*. So, instead you could use some of my referral links or donate crypto. + I wanted to add more <em>fiat</em> options but I don't have access to them <em>down here</em>. So, instead you could use some of my referral links or donate crypto. </p> <h2> @@ -100,6 +100,7 @@ <ul> <li> <i class="fab fa-monero" alt="Monero"></i> Monero: (<a target="_blank" href="images/crypto/monero.png">XMR QR</a>) <code class="crypto">83CoxLgBTzb8muMAHtqR4fYmwA6gcvahzRWgA6nWY3x3BCpde9cE4d8G2fFYufb7qTgo8Cc4M8qnNHdDfrXn7bKhAQmXhAq</code> + <br> <img class="qr" src="images/crypto/monero.png" alt="XMR QR"> </li> @@ -116,15 +117,15 @@ <ul> <li> - <a href="https://www.vultr.com/?ref=8733834-6G" alt="Vultr referral">Vultr</a>: Reliable server hosting, I host <code class="link">luevano.xyz</code> here. <b>You get $100 USD in credit for a month and if you continue using the service I get $25 after you spend $25 yourself.</b> + <a href="https://www.vultr.com/?ref=8733834-6G" alt="Vultr referral">Vultr</a>: Reliable server hosting, I host <code class="link">luevano.xyz</code> here. <strong>You get $100 USD in credit for a month and if you continue using the service I get $25 after you spend $25 yourself.</strong> </li> <li> - <a href="https://hostodo.com/portal/aff.php?aff=914" alt="Hostodo referral">Hostodo</a>: Cheaper server hosting, I host <code class="link">ezclap.xyz</code> here, which is being used only for some game servers and "bigger" stuff. <b>I get 12% for every sale and renewal.</b> + <a href="https://hostodo.com/portal/aff.php?aff=914" alt="Hostodo referral">Hostodo</a>: Cheaper server hosting, I host <code class="link">ezclap.xyz</code> here, which is being used only for some game servers and "bigger" stuff. <strong>I get 12% for every sale and renewal.</strong> </li> <li> - <a href="https://www.epik.com/?affid=da5ne9ru4" alt="Epik referral">Epik</a>: Domain registrar, where I buy my domains. <b>I get 20% of the initial sale.</b> + <a href="https://www.epik.com/?affid=da5ne9ru4" alt="Epik referral">Epik</a>: Domain registrar, where I buy my domains. <strong>I get 20% of the initial sale.</strong> </li> </ul> diff --git a/luevano/test.html b/luevano/test.html new file mode 100644 index 0000000..028877c --- /dev/null +++ b/luevano/test.html @@ -0,0 +1,100 @@ +<!DOCTYPE html> +<html lang="en"> + <head> + <base href="https://static.luevano.xyz/"> + <meta charset="utf-8"> + <meta name="viewport" content="width=device-width, initial-scale=1"> + <title>Test page -- Luévano's Site</title> + <meta name="description" content="Test page."/> + <link rel="alternate" type="application/rss+xml" href="https://blog.luevano.xyz/rss.xml" title="Luévano's Blog RSS"> + <link rel="alternate" type="application/rss+xml" href="https://art.luevano.xyz/rss.xml" title="Luévano's Art RSS"> + <link rel="icon" href="images/icons/favicon.ico"> + + <!-- general style --> + <link rel="stylesheet" type="text/css" href="css/style.css"> + <link rel="stylesheet" type="text/css" href="fork-awesome/css/fork-awesome.min.css"> + <link rel="stylesheet" type="text/css" href="font-awesome/css/all.min.css"> + + <!-- theme related --> + <script type="text/javascript" src="scripts/theme.js"></script> + <link id="theme-css" rel="stylesheet" type="text/css" href="css/dark.css"> + </head> + + <body> + <header> + <nav> + <ul> + <li> + <a href="https://luevano.xyz/"><i class="fas fa-home" alt="Home"></i><span>Home</span></a> + </li> + + <li> + <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> + + <li><a href="https://github.com/luevano" target="_blank"><i class="fab fa-github" alt="Github"></i></a></li> + + <li><a href="https://gitlab.com/dluevano" target="_blank"><i class="fab fa-gitlab" alt="Gitlab"></i></a></li> + </ul> + </li> + + <li><i class="fas fa-box-open" alt="Stuff"></i><span>Stuff</span> + <ul> + <li><a href="https://gb.luevano.xyz/"><i class="fas fa-gamepad" alt="Gameboy"></i><span>Gameboy</span></a></li> + </ul> + </li> + </ul> + </nav> + + <div class="theme-switch-container"> + <i class="fas fa-sun"></i> + <label class="switch theme"> + <input id="theme-switch" type="checkbox" onclick="toggleTheme()"> + <span class="slider round"></span> + </label> + <i class="fas fa-moon"></i> + </div> + </header> + + <main> + <h1> + Test page + </h1> + + <div class="art-grid"> + <img class="wide" src="images/gifs/contact_info_1.gif"> + <img src="images/gifs/dollar_sign_spin_1.gif"> + <img class="tall" src="images/gifs/head_talking_1_trans.gif"> + <img class="wide tall" src="images/gifs/stars_1.gif"> + <img src="images/gifs/under_construction_1.gif"> + <img src="images/gifs/under_construction_2.gif"> + </div> + + </main> + + <footer> + <span> + <i class="fas fa-address-card" alt="Contact"></i> + <a href="https://luevano.xyz/contact.html">Contact</a> + </span> + + <span> + <i class="fas fa-donate" alt="Donate"></i> + <a href="https://luevano.xyz/donate.html">Donate</a> + </span> + + <br> + <span class="copyright"> + Copyright <i class="fal fa-copyright" alt="Copyright"></i> 2021 David Luévano Alvarado + </span> + </footer> + </body> +</html> diff --git a/static/css/dark.css b/static/css/dark.css index 1cb3028..31b025a 100644 --- a/static/css/dark.css +++ b/static/css/dark.css @@ -26,6 +26,8 @@ --switch-ol: var(--color4); --switch-moon: var(--color3); --switch-sun: var(--color13); + + --code-border: var(--fg); } /* general */ @@ -66,6 +68,11 @@ main { background: linear-gradient(var(--bg) 0.5em, 1em, var(--body-bg) 1.5em calc(100% - 1.5em), calc(100% - 1em), var(--bg) calc(100% - 0.5em)); } +pre, code { + border-radius: 5px; + border: 1px solid var(--code-border); +} + /* nav bar */ body > header { background: linear-gradient(var(--body-bg) calc(100% - 1.5em), calc(100% - 1em), var(--bg) calc(100% - 0.5em)); @@ -129,4 +136,3 @@ div.gallery:hover { .switch input:focus + .slider { box-shadow: 0 0 0.1em var(--switch-ol); } - diff --git a/static/css/light.css b/static/css/light.css index 27df3c4..0b1456c 100644 --- a/static/css/light.css +++ b/static/css/light.css @@ -26,6 +26,8 @@ --switch-ol: var(--color0); --switch-moon: var(--color3); --switch-sun: var(--color13); + + --code-border: var(--fg); } /* general */ @@ -62,6 +64,11 @@ body { color: var(--fg); } +pre, code { + border-radius: 5px; + border: 1px solid var(--code-border); +} + main { background: linear-gradient(var(--bg) 0.5em, 1em, var(--body-bg) 1.5em calc(100% - 1.5em), calc(100% - 1em), var(--bg) calc(100% - 0.5em)); } @@ -129,4 +136,3 @@ div.gallery:hover { .switch input:focus + .slider { box-shadow: 0 0 0.1em var(--switch-ol); } - diff --git a/static/css/style.css b/static/css/style.css index 0ba4e05..9be32e0 100644 --- a/static/css/style.css +++ b/static/css/style.css @@ -3,6 +3,20 @@ font-size: larger; } +h1 { + text-align: center; +} + +ul { + margin-left: 2em; + margin-right: 2em; +} + +ul.page-list { + margin-left: 0; + margin-right: 0; +} + body, html { margin: 0; padding: 0; @@ -42,12 +56,23 @@ a{ body > header, body > footer, main { justify-self: center; - width: clamp(45ch, 50%, 75ch); + width: clamp(30ch, calc(100% - 1em), 75ch); padding-left: 0.5em; padding-right: 0.5em; } +/* article elements */ +div.article-info { + line-height: 0.3; + font-size: smaller; +} + +div.article-info > div.article-tags { + font-size: larger; +} + + /* nav bar / header */ body > header { display: flex; @@ -103,6 +128,10 @@ body > footer { text-align: center; } +body > footer > span { + font-size: smaller; +} + /* theme swticher */ .switch { @@ -154,3 +183,77 @@ body > footer { .slider.round:before { border-radius: 1em; } + + +/* code blocks */ +code.crypto { + font-size: smaller; + overflow-wrap: anywhere; +} + + +/* images */ +img { + border-radius: 5px; + max-width: 100%; + display: block; + margin-left: auto; + margin-right: auto; + vertical-align: middle; +} + +img.wrap-right { + float: right; +} + +img.wrap-left { + float: left; +} + +img.qr { + max-width: 200px; + padding: 1em; +} + +/* img grid */ +div.img-grid, div.img-grid > p { + display: grid; + gap: 1em; + grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); +} + +div.img-grid img { + display: flex; + flex-direction: column; + justify-content: center; + align-items: center; + overflow: hidden; +} + + +/* art grid */ +div.art-grid, div.art-grid > p { + display: grid; + gap: 1em; + grid-template-columns: repeat(auto-fit, minmax(250px, 1fr)); + grid-auto-rows: minmax(250px, auto); +} + +div.art-grid img { + border: 1px solid white; + display: flex; + flex-direction: column; + justify-content: center; + align-items: center; + overflow: hidden; +} + +@media screen and (min-width: 600px) { + div.art-grid img.wide { + grid-column: span 2 / auto; + } + + div.art-grid img.tall { + grid-row: span 2 / auto; + } +} diff --git a/static/scripts/theme.js b/static/scripts/theme.js index 489060f..1a425d5 100644 --- a/static/scripts/theme.js +++ b/static/scripts/theme.js @@ -21,6 +21,7 @@ window.onload = () => { href = href.replace('dark.css', 'light.css'); theme.setAttribute('href', href); + /* let code_theme = document.getElementById('code-theme-css'); let code_href; @@ -29,6 +30,7 @@ window.onload = () => { code_href = code_href.replace('solarized-dark.min.css', 'solarized-light.min.css'); code_theme.setAttribute('href', code_href); } + */ } } @@ -50,31 +52,39 @@ function toggleTheme(){ let theme = document.getElementById('theme-css'); let href = theme.getAttribute('href'); + /* let code_theme = document.getElementById('code-theme-css'); let code_href; if (code_theme !== null){ code_href = code_theme.getAttribute('href'); } + */ if(href.endsWith('dark.css')){ href = href.replace('dark.css', 'light.css'); + /* if (code_theme !== null){ code_href = code_href.replace('solarized-dark.min.css', 'solarized-light.min.css'); } + */ } else if (href.endsWith('light.css')){ href = href.replace('light.css', 'dark.css'); + /* if (code_theme !== null){ code_href = code_href.replace('solarized-light.min.css', 'solarized-dark.min.css'); } + */ } else{ console.log('Wrong replacement.'); } theme.setAttribute('href', href); + /* if (code_theme !== null){ code_theme.setAttribute('href', code_href); } + */ setTheme(); } |