{"id":1087,"date":"2024-07-31T11:05:58","date_gmt":"2024-07-31T09:05:58","guid":{"rendered":"https:\/\/blog.sutilweb.eu\/?page_id=1087"},"modified":"2024-07-31T11:05:58","modified_gmt":"2024-07-31T09:05:58","slug":"03-herramientas-de-trabajo","status":"publish","type":"page","link":"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/03-herramientas-de-trabajo\/","title":{"rendered":"03. Herramientas de trabajo"},"content":{"rendered":"\n<p>A lo largo de este curso, estaremos utilizando <strong>MySQL<\/strong> o <strong>MariaDB.<\/strong> Podr\u00edamos instalar <strong>MySQL<\/strong> desde su <a href=\"https:\/\/dev.mysql.com\/downloads\/\" target=\"_blank\" rel=\"noreferrer noopener\">p\u00e1gina oficial<\/a>, tambi\u00e9n podemos instalar <strong>MariaDB<\/strong> desde su <a href=\"https:\/\/mariadb.org\/download\/?t=mariadb&amp;p=mariadb&amp;r=11.3.0&amp;os=windows&amp;cpu=x86_64&amp;pkg=msi&amp;m=fe_up_pt\" target=\"_blank\" rel=\"noreferrer noopener\">p\u00e1gina oficial<\/a> directamente.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Si no somos usuarios muy experimentados, podemos instalar un paquete completo que incluye <strong>Apache + MariaDB + PHP + Perl<\/strong>, algunos de estos paquetes son:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.apachefriends.org\/es\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">XAMPP<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.wampserver.com\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">WAMP<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.mamp.info\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">MAMP<\/a><\/li>\n<\/ul>\n\n\n\n<p>Cuando instalamos este tipo de entornos, dicha instalaci\u00f3n viene acompa\u00f1ada de una interfaz de una aplicaci\u00f3n web que ya instala el ejecutable de estos servicios, denominado <a href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">PHPMyAdmin,<\/a> que es como una aplicaci\u00f3n web hecha en <a href=\"https:\/\/www.php.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">PHP<\/a> para poder gestionar las <strong>bases de datos<\/strong>.<\/p>\n\n\n\n<p>Aparte de tener nuestro editor de c\u00f3digo, que se va a tratar de <a href=\"https:\/\/code.visualstudio.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Visual Studio Code<\/a>, vamos a instalar otra herramienta, que es un gestor que permite ejecutar las sentencias a las <strong>bases de datos<\/strong>, y de esta manera poder tener un feedback a tiempo real, dicha herramienta se llama <a href=\"https:\/\/dbeaver.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">DBeaver<\/a>. Esta herramienta es de base de datos universal, es como un editor de c\u00f3digo pero para <strong>bases de datos<\/strong>, y se puede instalar tanto en <strong>Windows, Mac<\/strong> o <strong>Linux.<\/strong><\/p>\n\n\n\n<p>Si utilizamos <strong>Windows,<\/strong> tenemos un gestor de paquetes muy similar a <a href=\"https:\/\/brew.sh\/\" target=\"_blank\" rel=\"noreferrer noopener\">Homebrew<\/a> para <strong>MAC,<\/strong> y que se llama <a href=\"https:\/\/chocolatey.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">Chocolatey,<\/a> que es un gestor de <strong>paquetes para Windows<\/strong>, y permite instalar como dependencias a trav\u00e9s de nuestra terminal de comandos, con el comando <strong><em>choco<\/em><\/strong>, y hay muchas herramientas de programaci\u00f3n, como <strong>lenguajes de programaci\u00f3n<\/strong>, <strong>entornos de programaci\u00f3n<\/strong>, <strong>sistemas gestores de bases de datos<\/strong>, que podemos gestionar a trav\u00e9s de esta herramienta.<\/p>\n\n\n\n<p>Si no queremos instalar nada, tenemos un servidor de bases de datos online, que lo encontramos en la p\u00e1gina <a href=\"https:\/\/www.db-fiddle.com\/,\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.db-fiddle.com\/,<\/a> con el que podemos ir realizando los ejercicios que iremos haciendo a lo largo de los cap\u00edtulos, se trata de una herramienta limitada, aunque lo mejor es instalar <strong>MySQL<\/strong> en nuestra computadora.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A lo largo de este curso, estaremos utilizando MySQL o MariaDB. Podr\u00edamos instalar MySQL desde su p\u00e1gina oficial, tambi\u00e9n podemos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1076,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-1087","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":"A lo largo de este curso, estaremos utilizando MySQL o MariaDB. Podr\u00edamos instalar MySQL desde su p\u00e1gina oficial, tambi\u00e9n podemos [&hellip;]","_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=1087"}],"version-history":[{"count":1,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1087\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1087\/revisions\/1088"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1076"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}