{"id":1711,"date":"2010-04-08T14:39:32","date_gmt":"2010-04-08T04:39:32","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=1711"},"modified":"2014-10-08T09:16:07","modified_gmt":"2014-10-07T23:16:07","slug":"alsosql","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2010\/04\/08\/alsosql\/","title":{"rendered":"AlsoSQL"},"content":{"rendered":"<p>So there&#8217;s a bit of a swelling around the idea of NoSQL. That is, databases that don&#8217;t have an SQL interface in front of them &#8211; with the promise of better performance. With a well designed backend, this is no doubt the case.<\/p>\n<p>A flexible query language is rather useful though. I think we&#8217;ll see the rise of AlsoSQL. That is systems that present a fast and simple protocol along with a SQL interface.<\/p>\n<p>This hybrid system has seen use for many years. <a href=\"http:\/\/mysql.com\/products\/database\/cluster\/\">MySQL Cluster<\/a> is one such example. SQL through MySQL Server, NoSQL through <a href=\"http:\/\/dev.mysql.com\/doc\/ndbapi\/en\/index.html\">NDB API<\/a>.<\/p>\n<p>With <a href=\"http:\/\/www.drizzle.org\">Drizzle<\/a>, I feel we&#8217;ll be in a pretty good position to offer non-sql based protocols and access methods to existing storage engines.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So there&#8217;s a bit of a swelling around the idea of NoSQL. That is, databases that don&#8217;t have an SQL interface in front of them &#8211; with the promise of better performance. With a well designed backend, this is no &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2010\/04\/08\/alsosql\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"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":[75],"tags":[283,70,628,218,54,120,282],"class_list":["post-1711","post","type-post","status-publish","format-standard","hentry","category-drizzle-work-et-al","tag-alsosql","tag-drizzle","tag-mysql","tag-mysql-cluster","tag-ndb","tag-ndbapi","tag-nosql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s5a6n8-alsosql","jetpack-related-posts":[{"id":2374,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/05\/13\/drizzle-json-interface-merged\/","url_meta":{"origin":1711,"position":0},"title":"Drizzle JSON interface merged","author":"Stewart Smith","date":"2011-05-13","format":false,"excerpt":"https:\/\/code.launchpad.net\/~stewart\/drizzle\/json-interface\/+merge\/59859 Currently a very early version of course, but it's there in trunk if you want to play with it. Just have libcurl and libevent installed and you can submit queries via HTTP and JSON. Of course, the next steps are getting a true non-sql interface going and seeing how\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2362,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/04\/21\/http-json-alsosql-interface-to-drizzle\/","url_meta":{"origin":1711,"position":1},"title":"HTTP JSON AlsoSQL interface to Drizzle","author":"Stewart Smith","date":"2011-04-21","format":false,"excerpt":"So... I had another one of those \"hrrm... this shouldn't be hard to hack a proof-of-concept\" moments. Web apps are increasingly speaking JSON all around the place. Why can't we speak JSON to\/from the database? Why? Seriously, why not? One reason why MongoDB has found users is that JSON is\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.flamingspork.com\/blog\/wp-content\/uploads\/2011\/04\/Screenshot-11-300x230.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2145,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/09\/29\/lca-miniconf-call-for-papers-data-storage-databases-filesystems-cloud-storage-sql-and-nosql\/","url_meta":{"origin":1711,"position":2},"title":"LCA Miniconf Call for Papers: Data Storage: Databases, Filesystems, Cloud Storage, SQL and NoSQL","author":"Stewart Smith","date":"2010-09-29","format":false,"excerpt":"This miniconf aims to cover many of the current methods of data storage and retrieval and attempt to bring order to the universe. We're aiming to cover what various systems do, what the latest developments are and what you should use for various applications. We aim for talks from developers\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1783,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/02\/03\/ndbinfo-with-sql-hits-beta\/","url_meta":{"origin":1711,"position":3},"title":"NDB$INFO with SQL hits beta","author":"Stewart Smith","date":"2010-02-03","format":false,"excerpt":"\u00ef\u00bb\u00bfBernhard blogged over at http:\/\/ocklin.blogspot.com\/2010\/02\/mysql-cluster-711-is-there.html that MySQL Cluster 7.1.1 Beta has been released. The big feature (from my point of view) is the SQL interface on top of NDB$INFO. This means there is now full infrastructure from the NDB data nodes right out to SQL in the MySQL Server for\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1752,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/03\/11\/continuing-the-journey\/","url_meta":{"origin":1711,"position":4},"title":"Continuing the journey","author":"Stewart Smith","date":"2010-03-11","format":false,"excerpt":"A couple of months ago (December 1st for those playing along at home) it marked five years to the day that I started at MySQL AB (now Sun, now Oracle). A good part of me is really surprised it was for that long and other parts surprised it wasn't longer.\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1316,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/12\/18\/ndbinfo-sql-interface\/","url_meta":{"origin":1711,"position":5},"title":"NDB$INFO SQL Interface","author":"Stewart Smith","date":"2008-12-18","format":false,"excerpt":"Just saw a brief \"this is how it's currently working\" on Martin's implementation of the SQL frontend to the NDB$INFO work. It's awesome.","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=1711"}],"version-history":[{"count":2,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1711\/revisions"}],"predecessor-version":[{"id":3832,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1711\/revisions\/3832"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=1711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=1711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=1711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}