{"id":3746,"date":"2014-05-26T11:58:25","date_gmt":"2014-05-26T01:58:25","guid":{"rendered":"https:\/\/www.flamingspork.com\/blog\/?p=3746"},"modified":"2014-05-26T11:58:25","modified_gmt":"2014-05-26T01:58:25","slug":"still-the-best-way-to-explain-nosql","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2014\/05\/26\/still-the-best-way-to-explain-nosql\/","title":{"rendered":"Still the best way to explain NoSQL"},"content":{"rendered":"<p>Those in the MySQL\/Drizzle world have probably seen this a bunch of times before, but I think it still holds up (now five years later) as one of the best NoSQL explanations around.<\/p>\n<p><iframe loading=\"lazy\" width=\"420\" height=\"315\" src=\"\/\/www.youtube.com\/embed\/LhnGarRsKnA\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Those in the MySQL\/Drizzle world have probably seen this a bunch of times before, but I think it still holds up (now five years later) as one of the best NoSQL explanations around.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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},"jetpack_post_was_ever_published":false},"categories":[14],"tags":[628,282],"class_list":["post-3746","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-nosql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-Yq","jetpack-related-posts":[{"id":1711,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/04\/08\/alsosql\/","url_meta":{"origin":3746,"position":0},"title":"AlsoSQL","author":"Stewart Smith","date":"2010-04-08","format":false,"excerpt":"So there's a bit of a swelling around the idea of NoSQL. That is, databases that don't have an SQL interface in front of them - with the promise of better performance. With a well designed backend, this is no doubt the case. A flexible query language is rather useful\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":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":3746,"position":1},"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":2358,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/04\/19\/haildb-a-nosql-api-direct-to-innodb\/","url_meta":{"origin":3746,"position":2},"title":"HailDB: A NoSQl API Direct to InnoDB","author":"Stewart Smith","date":"2011-04-19","format":false,"excerpt":"At the MySQL Conference and Expo last week I gave a session on HailDB. I've got the slides up on slideshare so you can either view through them or download them. I think the session went well, and there certainly is some interest in HailDB out there (which is great!).","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":1899,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/04\/20\/interesting-videos-from-the-mysql-conference-and-expo\/","url_meta":{"origin":3746,"position":3},"title":"Interesting Videos from the MySQL Conference and Expo","author":"Stewart Smith","date":"2010-04-20","format":false,"excerpt":"There's a good number of videos appearing online from the MySQL Conference and Expo that was on last week. Here's a short list of interesting things to look at if you weren't able to make the sessions. Obviously, this is from my view as a Drizzle developer. There were other\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":2356,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/04\/12\/speaking-on-tuesday-haildb-and-dropping-acid-eating-data-in-a-web-2-0-cloud-world\/","url_meta":{"origin":3746,"position":4},"title":"Speaking on Tuesday: HailDB and Dropping ACID: Eating Data in a Web 2.0 Cloud World","author":"Stewart Smith","date":"2011-04-12","format":false,"excerpt":"I'm giving two talks tomorrow (Tuesday) at the MySQL Conference and Expo: HailDB: A NoSQL API direct to InnoDB, 2:00pm, Ballroom D Dropping ACID: Eating Data In A Web 2.0 Cloud World 3:05pm, Ballroom G The HailDB talk is all about a C API to embed an InnoDB based relational\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":1906,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/04\/22\/the-rotating-blades-database-benchmark\/","url_meta":{"origin":3746,"position":5},"title":"The rotating blades database benchmark","author":"Stewart Smith","date":"2010-04-22","format":false,"excerpt":"(and before you ask, yes \"rotating blades\" comes from \"become a fan\") I'm forming the ideas here first and then we can go and implement it. Feedback is much appreciated. Two tables. Table one looks like this: CREATE TABLE fan_of ( user_id BIGINT, item_id BIGINT, PRIMARY KEY (user_id, item_id), INDEX\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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3746","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=3746"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3746\/revisions"}],"predecessor-version":[{"id":3747,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3746\/revisions\/3747"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=3746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=3746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=3746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}