{"id":1709,"date":"2005-10-25T09:26:04","date_gmt":"2005-10-25T07:26:04","guid":{"rendered":"https:\/\/www.fullo.net\/blog\/?p=1709"},"modified":"2005-10-24T17:26:57","modified_gmt":"2005-10-24T15:26:57","slug":"mysql-50-stable","status":"publish","type":"post","link":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/","title":{"rendered":"MySQL 5.0 stable!"},"content":{"rendered":"<p><a href=\"http:\/\/www.mysql.com\/\">MySQL 5.0<\/a> ha finalmente visto la luce. Questa versione ricchissima di novit\u00e0 (come le stored procedures, l&#8217;uso di trigger e la presenza delle view) era da lungo attesa dalla comunit\u00e0 di sviluppatori web che lo adottano per il <a href=\"http:\/\/www.php-mag.net\/itr\/news\/psecom,id,24896,nodeid,113.html\">44% dei loro progetti<\/a>..<\/p>\n<p>Sul sito \u00e8 presente anche un <a href=\"http:\/\/www.mysql.com\/why-mysql\/white-papers\/mysql_wp_inside50.php\">whitepaper<\/a>, leggibile per\u00f2 solo una dopo registrazione gratuita, contenente i dettagli di tutte le novit\u00e0.<\/p>\n<p>Bisogna ricordare che molte delle feature presenti in MySQL 5.0 sono condivise dal motore SQL che da vita alle tabelle InnoDB, <a href=\"https:\/\/www.fullo.net\/blog\/archives\/2005\/10\/10\/oracle-compra-innodb\/\">da poco acquistato da Oracle<\/a>. <\/p>\n<p><small>questo post \u00e8 presente anche su <a href=\"http:\/\/www.downloadblog.it\/post\/661\/mysql-50\">DownloadBlog.it<\/a><\/small><\/p>\n<p>ciauz<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL 5.0 ha finalmente visto la luce. Questa versione ricchissima di novit\u00e0 (come le stored procedures, l&#8217;uso di trigger e la presenza delle view) era da lungo attesa dalla comunit\u00e0 di sviluppatori web che lo adottano per il 44% dei loro progetti.. Sul sito \u00e8 presente anche un whitepaper, leggibile per\u00f2 solo una dopo registrazione [&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":[13,5],"tags":[678,747,410,699,190,700,679],"class_list":["post-1709","post","type-post","status-publish","format-standard","hentry","category-open-source","category-tecnologia","tag-db","tag-dbms","tag-development","tag-innodb","tag-mysql","tag-oracle","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL 5.0 stable! - 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\/2005\/10\/25\/mysql-50-stable\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL 5.0 stable! - Fullo\" \/>\n<meta property=\"og:description\" content=\"MySQL 5.0 ha finalmente visto la luce. Questa versione ricchissima di novit\u00e0 (come le stored procedures, l&#8217;uso di trigger e la presenza delle view) era da lungo attesa dalla comunit\u00e0 di sviluppatori web che lo adottano per il 44% dei loro progetti.. Sul sito \u00e8 presente anche un whitepaper, leggibile per\u00f2 solo una dopo registrazione [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/\" \/>\n<meta property=\"og:site_name\" content=\"Fullo\" \/>\n<meta property=\"article:published_time\" content=\"2005-10-25T07:26:04+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\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/\"},\"author\":{\"name\":\"Francesco Fullone\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"headline\":\"MySQL 5.0 stable!\",\"datePublished\":\"2005-10-25T07:26:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/\"},\"wordCount\":96,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#\\\/schema\\\/person\\\/24e91bc6caea6c411a8668df5639428c\"},\"keywords\":[\"db\",\"dbms\",\"development\",\"innodb\",\"mysql\",\"oracle\",\"sql\"],\"articleSection\":[\"open source\",\"tecnologia\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/\",\"url\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/\",\"name\":\"MySQL 5.0 stable! - Fullo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/#website\"},\"datePublished\":\"2005-10-25T07:26:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/2005\\\/10\\\/25\\\/mysql-50-stable\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fullo.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL 5.0 stable!\"}]},{\"@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 5.0 stable! - 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\/2005\/10\/25\/mysql-50-stable\/","og_locale":"en_US","og_type":"article","og_title":"MySQL 5.0 stable! - Fullo","og_description":"MySQL 5.0 ha finalmente visto la luce. Questa versione ricchissima di novit\u00e0 (come le stored procedures, l&#8217;uso di trigger e la presenza delle view) era da lungo attesa dalla comunit\u00e0 di sviluppatori web che lo adottano per il 44% dei loro progetti.. Sul sito \u00e8 presente anche un whitepaper, leggibile per\u00f2 solo una dopo registrazione [&hellip;]","og_url":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/","og_site_name":"Fullo","article_published_time":"2005-10-25T07:26:04+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\/2005\/10\/25\/mysql-50-stable\/#article","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/"},"author":{"name":"Francesco Fullone","@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"headline":"MySQL 5.0 stable!","datePublished":"2005-10-25T07:26:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/"},"wordCount":96,"commentCount":1,"publisher":{"@id":"https:\/\/www.fullo.net\/blog\/#\/schema\/person\/24e91bc6caea6c411a8668df5639428c"},"keywords":["db","dbms","development","innodb","mysql","oracle","sql"],"articleSection":["open source","tecnologia"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/","url":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/","name":"MySQL 5.0 stable! - Fullo","isPartOf":{"@id":"https:\/\/www.fullo.net\/blog\/#website"},"datePublished":"2005-10-25T07:26:04+00:00","breadcrumb":{"@id":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fullo.net\/blog\/2005\/10\/25\/mysql-50-stable\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fullo.net\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL 5.0 stable!"}]},{"@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\/p3OSc1-rz","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1688,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/10\/oracle-compra-innodb\/","url_meta":{"origin":1709,"position":0},"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":1680,"url":"https:\/\/www.fullo.net\/blog\/2005\/10\/05\/sql-designer\/","url_meta":{"origin":1709,"position":1},"title":"SQL Designer","author":"Francesco Fullone","date":"05\/10\/2005","format":false,"excerpt":"SQL Designer \u00e8 un'applicazione ajax enabled che serve a disegnare schemi ER. Con questo script \u00e8 possibile creare nuove tabelle, foreign key, aggiungere e rimuovere campi dalle tabelle come se nulla fosse e con un'interfaccia grafica pulita e molto semplice da usare. Inoltre le relazioni sono controllate e se viene\u2026","rel":"","context":"In &quot;ajax&quot;","block_context":{"text":"ajax","link":"https:\/\/www.fullo.net\/blog\/category\/tecnologia\/ajax\/"},"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":1709,"position":2},"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":[]},{"id":1736,"url":"https:\/\/www.fullo.net\/blog\/2005\/11\/08\/zend-studio-50\/","url_meta":{"origin":1709,"position":3},"title":"Zend Studio 5.0","author":"Francesco Fullone","date":"08\/11\/2005","format":false,"excerpt":"E' stato rilasciata la versione 5.0 di Zend Studio, nessuna grossa novit\u00e0 rispetto le due beta precedenti (se non qualche bugfix). A seguire un estratto della press release con alcune delle principali novit\u00e0. Web Services support easily connects new PHP applications to existing applications regardless of the technology or devices\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":323,"url":"https:\/\/www.fullo.net\/blog\/2003\/06\/30\/phplinksphp-50-vs-mysql\/","url_meta":{"origin":1709,"position":4},"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":1922,"url":"https:\/\/www.fullo.net\/blog\/2006\/04\/13\/mediawiki-163-e-mysql-4\/","url_meta":{"origin":1709,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/1709","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=1709"}],"version-history":[{"count":0,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/posts\/1709\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/media?parent=1709"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/categories?post=1709"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fullo.net\/blog\/wp-json\/wp\/v2\/tags?post=1709"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}