{"id":993,"date":"2004-09-07T18:23:28","date_gmt":"2004-09-07T16:23:28","guid":{"rendered":"\/\/?p="},"modified":"2004-09-07T18:23:28","modified_gmt":"2004-09-07T16:23:28","slug":"mysql","status":"publish","type":"post","link":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/","title":{"rendered":"mysql"},"content":{"rendered":"<p>sy <a href=\"http:\/\/blog.codefront.net\/archives\/2004\/09\/06\/why-not-to-use-mysql\/\">redemption<\/a> ho trovato due link che spiegano perch\u00e8 mySQL non <em>andrebbe utilizzato<\/em>:<br \/>\n&#8211; <a href=\"http:\/\/sql-info.de\/mysql\/gotchas.html\">mySQL Gotchas<\/a><br \/>\n&#8211; <a href=\"http:\/\/vulcanus.its.tudelft.nl\/~acm\/got\/antimysql.php\">AntiMySQL<\/a><br \/>\nnon dico che siano cose non vere, anzi&#8230; resta il fatto che grazie a mySQL sono nati tantissimi progetti (e software opensource) online e che la crescita di questo RDBMS negli ultimi anni \u00e8 stata notevole non solo in numero di installazioni ma anche in funzionalit\u00e0 e performance (punto di forza del software).<\/p>\n<p>ciauz<\/p>\n","protected":false},"excerpt":{"rendered":"<p>sy redemption ho trovato due link che spiegano perch\u00e8 mySQL non andrebbe utilizzato: &#8211; mySQL Gotchas &#8211; AntiMySQL non dico che siano cose non vere, anzi&#8230; resta il fatto che grazie a mySQL sono nati tantissimi progetti (e software opensource) online e che la crescita di questo RDBMS negli ultimi anni \u00e8 stata notevole non [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[],"class_list":["post-993","post","type-post","status-publish","format-standard","hentry","category-tecnologia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>mysql - Fullo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mysql - Fullo\" \/>\n<meta property=\"og:description\" content=\"sy redemption ho trovato due link che spiegano perch\u00e8 mySQL non andrebbe utilizzato: &#8211; mySQL Gotchas &#8211; AntiMySQL non dico che siano cose non vere, anzi&#8230; resta il fatto che grazie a mySQL sono nati tantissimi progetti (e software opensource) online e che la crescita di questo RDBMS negli ultimi anni \u00e8 stata notevole non [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Fullo\" \/>\n<meta property=\"article:published_time\" content=\"2004-09-07T16:23:28+00:00\" \/>\n<meta name=\"author\" content=\"Francesco Fullone\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@fullo\" \/>\n<meta name=\"twitter:site\" content=\"@fullo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Francesco Fullone\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/\"},\"author\":{\"name\":\"Francesco Fullone\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"headline\":\"mysql\",\"datePublished\":\"2004-09-07T16:23:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/\"},\"wordCount\":72,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"articleSection\":[\"tecnologia\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/\",\"name\":\"mysql - Fullo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\"},\"datePublished\":\"2004-09-07T16:23:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2004\\\/09\\\/07\\\/mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mysql\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\",\"name\":\"Fullo\",\"description\":\"nulla e&#039; impossibile per chi non lo deve fare!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\",\"name\":\"Francesco Fullone\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\",\"width\":622,\"height\":622,\"caption\":\"Francesco Fullone\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.fullo.net\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1\"},\"sameAs\":[\"http:\\\/\\\/www.fullo.net\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/fullo\",\"https:\\\/\\\/x.com\\\/fullo\"],\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/author\\\/fullo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mysql - Fullo","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/","og_locale":"en_US","og_type":"article","og_title":"mysql - Fullo","og_description":"sy redemption ho trovato due link che spiegano perch\u00e8 mySQL non andrebbe utilizzato: &#8211; mySQL Gotchas &#8211; AntiMySQL non dico che siano cose non vere, anzi&#8230; resta il fatto che grazie a mySQL sono nati tantissimi progetti (e software opensource) online e che la crescita di questo RDBMS negli ultimi anni \u00e8 stata notevole non [&hellip;]","og_url":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/","og_site_name":"Fullo","article_published_time":"2004-09-07T16:23:28+00:00","author":"Francesco Fullone","twitter_card":"summary_large_image","twitter_creator":"@fullo","twitter_site":"@fullo","twitter_misc":{"Written by":"Francesco Fullone"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/#article","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/"},"author":{"name":"Francesco Fullone","@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"headline":"mysql","datePublished":"2004-09-07T16:23:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/"},"wordCount":72,"commentCount":0,"publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"articleSection":["tecnologia"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/","url":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/","name":"mysql - Fullo","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/#website"},"datePublished":"2004-09-07T16:23:28+00:00","breadcrumb":{"@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fullo.net\/blog\/2004\/09\/07\/mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fullo.net\/blog\/"},{"@type":"ListItem","position":2,"name":"mysql"}]},{"@type":"WebSite","@id":"https:\/\/www.fullo.net\/blog\/#website","url":"https:\/\/www.fullo.net\/blog\/","name":"Fullo","description":"nulla e&#039; impossibile per chi non lo deve fare!","publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fullo.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c","name":"Francesco Fullone","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","url":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1","width":622,"height":622,"caption":"Francesco Fullone"},"logo":{"@id":"https:\/\/i0.wp.com\/www.fullo.net\/blog\/wp-content\/uploads\/2024\/10\/hawiaina-gold-circled-white.png?fit=622%2C622&ssl=1"},"sameAs":["http:\/\/www.fullo.net","https:\/\/www.linkedin.com\/in\/fullo","https:\/\/x.com\/fullo"],"url":"https:\/\/www.fullo.net\/blog\/author\/fullo\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s3OSc1-mysql","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":323,"url":"https:\/\/www.fullo.net\/blog\/2003\/06\/30\/phplinksphp-50-vs-mysql\/","url_meta":{"origin":993,"position":0},"title":"php::Links(&#8216;PHP 5.0 vs. MySQL&#8217;)","author":"Francesco Fullone","date":"30\/06\/2003","format":false,"excerpt":"terrore e raccapriccio :(! stanotte, forse per la troppa emozione non ho notato questo appunto nella nota di release di php 5.0: Due to issues surrounding the MySQL 4.0 license, the MySQL libraries are no longer bundled with PHP. For more information on these licensing changes please see the MySQL\u2026","rel":"","context":"In &quot;tecnologia&quot;","block_context":{"text":"tecnologia","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2081,"url":"https:\/\/www.fullo.net\/blog\/2006\/10\/14\/php-6-e-mysql-3x\/","url_meta":{"origin":993,"position":1},"title":"PHP 6 e MySQL 3.x","author":"Francesco Fullone","date":"14\/10\/2006","format":false,"excerpt":"Pare che con PHP 6 si eliminer\u00e0 il supporto all'estensione mysql per dare pi\u00f9 ampio spazio a mysqli. Questo perch\u00e8 la vecchia estensione, scritta per MySQL 3.x non supporta e non potr\u00e0 mai supportare Unicode. Anche se la notizia sembra da poco il problema \u00e8 che moltissimi hosting offrono ancora\u2026","rel":"","context":"In &quot;php&quot;","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1922,"url":"https:\/\/www.fullo.net\/blog\/2006\/04\/13\/mediawiki-163-e-mysql-4\/","url_meta":{"origin":993,"position":2},"title":"Mediawiki 1.6.3 e MySQL 4","author":"Francesco Fullone","date":"13\/04\/2006","format":false,"excerpt":"Finalmente \u00e8 stato rilasciata la versione 1.6 di MediaWiki, il famoso Wiki engine scritto in PHP che gestisce, tra l'altro, la stessa WikiPedia. Ma perch\u00e8 finalmente? Perch\u00e8 adesso sono stati ufficialmente adottati tutti i criteri di antispam, come il CAPTCHA e le blacklist che tanto erano necessari in un software\u2026","rel":"","context":"In &quot;php&quot;","block_context":{"text":"php","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1688,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/10\/oracle-compra-innodb\/","url_meta":{"origin":993,"position":3},"title":"Oracle compra InnoDB","author":"Francesco Fullone","date":"10\/10\/2005","format":false,"excerpt":"Con una mossa a sorpresa Oracle ha rilevato l'azienda open source Innobase. Azienda che non \u00e8 altro che la sviluppatrice delle tabelle InnoDB tanto care agli utenti MySQL. Bisogna ricordare che la tecnologia InnoDB \u00e8 infatti rilasciata con una licenza duale simile a quella di MySQL e che quindi (a\u2026","rel":"","context":"In &quot;open source&quot;","block_context":{"text":"open source","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/open-source\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":697,"url":"https:\/\/www.fullo.net\/blog\/2004\/02\/03\/mysql-admin\/","url_meta":{"origin":993,"position":4},"title":"mysql admin","author":"Francesco Fullone","date":"03\/02\/2004","format":false,"excerpt":"nuova versione per mySQL administrator potente e flessibile tool per l'amministrazione e la gestione di un database mySQL. Il prodotto \u00e8 tra rilasciato con la particolare licenza di tipo Quid pro Quo (non sto scherzando) che permette l'utilizzo senza alcun costo per chi sviluppa prodotti open-source. ciuaz","rel":"","context":"In &quot;tecnologia&quot;","block_context":{"text":"tecnologia","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":324,"url":"https:\/\/www.fullo.net\/blog\/2003\/06\/30\/phplinksphp-50-vs-mysql-2\/","url_meta":{"origin":993,"position":5},"title":"php::Links(&#8216;PHP 5.0 vs. MySQL 2&#8217;)","author":"Francesco Fullone","date":"30\/06\/2003","format":false,"excerpt":"pare che l'attuale snapshot di php 5.0 per windows abbia di nuovo le librerie per l'accesso a MySQL (3.x per\u00f2). Per maggiori informazioni c'\u00e8 il blog di php|architect, che tra l'altro, in un altro post, spiega anche come ricompilare il supporto MySQL su Linux. ciuaz","rel":"","context":"In &quot;tecnologia&quot;","block_context":{"text":"tecnologia","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/comments?post=993"}],"version-history":[{"count":0,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/993\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/media?parent=993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/categories?post=993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/tags?post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}