{"id":7174,"date":"2011-09-20T14:01:11","date_gmt":"2011-09-20T14:01:11","guid":{"rendered":"https:\/\/www.techopedia.com\/definition\/drizzle\/"},"modified":"2012-10-13T16:32:15","modified_gmt":"2012-10-13T16:32:15","slug":"drizzle","status":"publish","type":"definition","link":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle","title":{"rendered":"Drizzle"},"content":{"rendered":"

What Does Drizzle Mean?<\/span><\/h2>\n

Drizzle is an open-source relational database management system (RDBMS) based on MySQL. Drizzle is built for Web and cloud computing applications and has a smaller footprint than MySQL. Commands for Drizzle are written using structured query language (SQL). Its software license is based on the GNU General Public License (GPL) as well as parts of the Berkeley Software Distribution (BSD) license.<\/p>\n

Techopedia Explains Drizzle<\/span><\/h2>\n

Drizzle was initiated by Brian Aker in 2008. Now a product of a community-driven project, Drizzle releases are given out every two weeks, with most of its milestones occurring every three to four months. Drizzle, which is written in C++, was based on version 6.0 of MySQL. (Drizzle is not like SQLite in that it is not designed for embedded systems.) Drizzle is now being developed by people from Canonical Ltd., Google, Six Apart, Sun Microsystems, Rackspace and Intel. This RDBMS is designed for Unix-like operating systems including Linux, Mac OS X, Solaris and FreeBSD. <\/p>\n

To come up with a smaller version of MySQL, developers removed nonessential code, refactored whatever code remained and made it run on a microkernel. The operations that were removed from the kernel are offered as pluggable components. <\/p>\n

Despite being a stripped-down version of MySQL, Drizzle already includes the following features: <\/p>\n

    \n
  • POSIX compliance\n<\/li>\n
  • Pluggable architecture for views\n<\/li>\n
  • Stored procedures\n<\/li>\n
  • User-defined functions\n<\/li>\n
  • Storage engines\n<\/li>\n
  • Intelligent proxy\n<\/li>\n
  • Multi CPU\n<\/li>\n
  • Optimized field types\n<\/li>\n
  • Efficient memory usage\n<\/li>\n
  • InnoDB default storage engine\n<\/li>\n
  • Localized command line tools<\/li>\n<\/ul>\n

    Some of the data types supported by Drizzle are:<\/p>\n

      \n
    • INT\n<\/li>\n
    • DOUBLE\n<\/li>\n
    • FLOAT\n<\/li>\n
    • VARCHAR\n<\/li>\n
    • BLOB\n<\/li>\n
    • DATE\n<\/li>\n
    • TIMESTAMP\n<\/li>\n
    • DATETIME\n<\/li>\n
    • ENUM<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      What Does Drizzle Mean? Drizzle is an open-source relational database management system (RDBMS) based on MySQL. Drizzle is built for Web and cloud computing applications and has a smaller footprint than MySQL. Commands for Drizzle are written using structured query language (SQL). Its software license is based on the GNU General Public License (GPL) as […]<\/p>\n","protected":false},"author":7813,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","om_disable_all_campaigns":false,"footnotes":""},"definitioncat":[215,225,227,222,228],"class_list":["post-7174","definition","type-definition","status-publish","format-standard","hentry","definitioncat-cloud-computing","definitioncat-cloud-native-development","definitioncat-data-management","definitioncat-database","definitioncat-risk-management"],"acf":[],"yoast_head":"\nWhat is Drizzle? - Definition from Techopedia<\/title>\n<meta name=\"description\" content=\"This definition explains the meaning of Drizzle and why it matters.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Drizzle\" \/>\n<meta property=\"og:description\" content=\"This definition explains the meaning of Drizzle and why it matters.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\" \/>\n<meta property=\"og:site_name\" content=\"Techopedia\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/techopedia\/\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-13T16:32:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@techopedia\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\"},\"author\":{\"name\":\"Margaret Rouse\",\"@id\":\"https:\/\/www.techopedia.com\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5\"},\"headline\":\"Drizzle\",\"datePublished\":\"2011-09-20T14:01:11+00:00\",\"dateModified\":\"2012-10-13T16:32:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\"},\"wordCount\":260,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.techopedia.com\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#respond\"]}],\"articleSection\":\"\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\",\"url\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\",\"name\":\"What is Drizzle? - Definition from Techopedia\",\"isPartOf\":{\"@id\":\"https:\/\/www.techopedia.com\/#website\"},\"datePublished\":\"2011-09-20T14:01:11+00:00\",\"dateModified\":\"2012-10-13T16:32:15+00:00\",\"description\":\"This definition explains the meaning of Drizzle and why it matters.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.techopedia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Risk Management\",\"item\":\"https:\/\/www.techopedia.com\/topic\/21\/risk-management\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database (DBMS)\",\"item\":\"https:\/\/www.techopedia.com\/topic\/8\/database\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Term\",\"item\":\"https:\/\/www.techopedia.com\/definition\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Drizzle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.techopedia.com\/#website\",\"url\":\"https:\/\/www.techopedia.com\/\",\"name\":\"Techopedia\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.techopedia.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.techopedia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.techopedia.com\/#organization\",\"name\":\"Techopedia\",\"url\":\"https:\/\/www.techopedia.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.techopedia.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2025\/02\/techopedia-light-logo.svg\",\"contentUrl\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2025\/02\/techopedia-light-logo.svg\",\"caption\":\"Techopedia\"},\"image\":{\"@id\":\"https:\/\/www.techopedia.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/techopedia\/\",\"https:\/\/x.com\/techopedia\",\"https:\/\/www.linkedin.com\/company\/techopedia\/\",\"https:\/\/www.youtube.com\/c\/Techopedia\"],\"publishingPrinciples\":\"https:\/\/www.techopedia.com\/about\/editorial-policy\",\"ownershipFundingInfo\":\"https:\/\/www.techopedia.com\/about\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.techopedia.com\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5\",\"name\":\"Margaret Rouse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.techopedia.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg\",\"contentUrl\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg\",\"caption\":\"Margaret Rouse\"},\"description\":\"Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other\u2019s highly specialized languages.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/margaretrouse\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/@techdefinitions\"],\"knowsAbout\":[\"Technology Expert\"],\"url\":\"https:\/\/www.techopedia.com\/contributors\/margaret-rouse\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What is Drizzle? - Definition from Techopedia","description":"This definition explains the meaning of Drizzle and why it matters.","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Drizzle","og_description":"This definition explains the meaning of Drizzle and why it matters.","og_url":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle","og_site_name":"Techopedia","article_publisher":"https:\/\/www.facebook.com\/techopedia\/","article_modified_time":"2012-10-13T16:32:15+00:00","twitter_card":"summary_large_image","twitter_site":"@techopedia","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#article","isPartOf":{"@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle"},"author":{"name":"Margaret Rouse","@id":"https:\/\/www.techopedia.com\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5"},"headline":"Drizzle","datePublished":"2011-09-20T14:01:11+00:00","dateModified":"2012-10-13T16:32:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle"},"wordCount":260,"commentCount":0,"publisher":{"@id":"https:\/\/www.techopedia.com\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.techopedia.com\/definition\/13880\/drizzle#respond"]}],"articleSection":""},{"@type":"WebPage","@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle","url":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle","name":"What is Drizzle? - Definition from Techopedia","isPartOf":{"@id":"https:\/\/www.techopedia.com\/#website"},"datePublished":"2011-09-20T14:01:11+00:00","dateModified":"2012-10-13T16:32:15+00:00","description":"This definition explains the meaning of Drizzle and why it matters.","breadcrumb":{"@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.techopedia.com\/definition\/13880\/drizzle"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.techopedia.com\/definition\/13880\/drizzle#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.techopedia.com\/"},{"@type":"ListItem","position":2,"name":"Risk Management","item":"https:\/\/www.techopedia.com\/topic\/21\/risk-management"},{"@type":"ListItem","position":3,"name":"Database (DBMS)","item":"https:\/\/www.techopedia.com\/topic\/8\/database"},{"@type":"ListItem","position":4,"name":"Term","item":"https:\/\/www.techopedia.com\/definition"},{"@type":"ListItem","position":5,"name":"Drizzle"}]},{"@type":"WebSite","@id":"https:\/\/www.techopedia.com\/#website","url":"https:\/\/www.techopedia.com\/","name":"Techopedia","description":"","publisher":{"@id":"https:\/\/www.techopedia.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.techopedia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.techopedia.com\/#organization","name":"Techopedia","url":"https:\/\/www.techopedia.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.techopedia.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2025\/02\/techopedia-light-logo.svg","contentUrl":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2025\/02\/techopedia-light-logo.svg","caption":"Techopedia"},"image":{"@id":"https:\/\/www.techopedia.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/techopedia\/","https:\/\/x.com\/techopedia","https:\/\/www.linkedin.com\/company\/techopedia\/","https:\/\/www.youtube.com\/c\/Techopedia"],"publishingPrinciples":"https:\/\/www.techopedia.com\/about\/editorial-policy","ownershipFundingInfo":"https:\/\/www.techopedia.com\/about"},{"@type":"Person","@id":"https:\/\/www.techopedia.com\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5","name":"Margaret Rouse","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.techopedia.com\/#\/schema\/person\/image\/","url":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg","contentUrl":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg","caption":"Margaret Rouse"},"description":"Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other\u2019s highly specialized languages.","sameAs":["https:\/\/www.linkedin.com\/in\/margaretrouse\/","https:\/\/x.com\/https:\/\/twitter.com\/@techdefinitions"],"knowsAbout":["Technology Expert"],"url":"https:\/\/www.techopedia.com\/contributors\/margaret-rouse"}]}},"_links":{"self":[{"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/definition\/7174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/definition"}],"about":[{"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/types\/definition"}],"author":[{"embeddable":true,"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/users\/7813"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/comments?post=7174"}],"version-history":[{"count":0,"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/definition\/7174\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/media?parent=7174"}],"wp:term":[{"taxonomy":"definitioncat","embeddable":true,"href":"https:\/\/www.techopedia.com\/wp-json\/wp\/v2\/definitioncat?post=7174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}