Seven Weeks Tumblr (3.0; @sevenwks) Database/NoSQL Conferences <p>Conferences for specific databases or soltion sets.</p> <ul><li>Riak @ <a href="">RICON</a>. San Francisco, Oct 10-11</li> <li>PostgreSQL @ <a href="">PostgreSQL Conference EU</a>. Prague, Oct 23-26</li> <li>Redis @ <a href="">RedisConf</a>. Portland, OR, Oct 22</li> <li>Neo4j @ <a href="">Graph Connect</a>. San Francisco, Nov 5-6</li> <li>MongoDB @ <a href="">Local Mongo Confs</a>. Everywhere, always</li> <li>Couchbase @ <a href="">Local Couchbase Confs</a>. Everywhere, always</li> </ul><div>General Confs</div> <ul><li><a href="">NoSQL Matters</a></li> <li><a href="">Lanyard NoSQL Confs</a></li> </ul>, 31 Aug 2012 11:18:57 -0700nosqlconferencesriakneo4jpostgresqlMongoDBcouchbaserediscrudcomicDown the NoSQL Rabbit Hole @ Railsberry, Eric Redmond <iframe width="400" height="300" src="" frameborder="0" allowfullscreen></iframe><br/><br/><p>Down the NoSQL Rabbit Hole @ Railsberry, Eric Redmond</p>, 25 Jul 2012 15:12:09 -0700nosqldatabasesrailsberrycrudcomicHashrocket Interview with Eric Redmond about Seven Databases. <iframe src="" width="400" height="225" frameborder="0"></iframe><br/><br/><p><a href="" target="_blank">Hashrocket</a> Interview with Eric Redmond about <a href="" target="_blank">Seven Databases</a>.</p>, 25 Jul 2012 15:06:10 -0700sevenweeksdatabasesnosqlcrudcomicSeven Databases in Seven Weeks Code <p>So I put the book code out on <a href="">github</a>. As nice as it is that Pragmatic makes all book code available in a zip file for download, I&#8217;m the type of person who will never actually bother to download it. But I&#8217;ll fork a project in an instant&#8230;</p> <p><a href=""><a href=""></a></a></p> <p>Feel free to fork and pull request any bugs you might encounter.</p>, 11 Jul 2012 11:26:37 -0700databasessevenweekscodeexamplescrudcomicMemSQL <p>Another week, another database launch. This time, surprisingly, it&#8217;s not yet another NoSQL offering. Instead, it&#8217;s a loose MySQL fork written by <a href="" target="_blank">Nikita Shamgunov</a>, former SQL Server engineer and ACM wunderkind, called <a href="">MemSQL</a>.</p> <p>The MemSQL magic sauce is supposedly that it compiles SQL queries (I&#8217;m not sure how that makes it different from <a href="" target="_blank">prepared statements</a>, though until I benchmark it I&#8217;ll give them the benefit of the doubt). It seems to gain its speed by keeping most of the database resident in memory, so again, I don&#8217;t see what makes it so different from other in memory databases. So far, not much there.</p> <p>MemSQL might employ a coding prodigy, but <a href="">VoltDB</a> has an in-memory database backed by Mike Stonebreaker, and only one of the two men has his own wikipedia entry. Yeah, I know that&#8217;s an <a href="">Appeal to accomplishment</a>, but I&#8217;ll change my tune when MemSQL provides something a dozen other databases already don&#8217;t (not that I want to imply it won&#8217;t&#8230; it&#8217;s just getting a bit too much of the <a href="">TC-VC-Industrial Complex</a> hype for my taste).</p>, 25 Jun 2012 19:00:00 -0700memsqlrdbmsdatabaserelationalmysqlcrudcomicApache HBase on Amazon EMR <a href="">Apache HBase on Amazon EMR</a>: <p>Finally! Amazon EMR is going to leverage the power of HBase. I love EMR, but I hated its restrictions. A step in the right direction, for sure…</p> <blockquote> <p>AWS has already given you a lot of storage and processing options to choose from, and today we are adding a really important one.</p> <p>You can now use <a href="" target="_self">Apache HBase</a> to store and process extremely large amounts of data (think billions of rows and millions of columns per row) on AWS. HBase offers a number of powerful features including:</p> <ul><li><span>Strictly consistent reads and writes.</span></li> <li><span>High write throughput.</span></li> <li><span>Automatic sharding of tables.</span></li> <li><span>Efficient storage of sparse data.</span></li> <li><span>Low-latency data access via in-memory operations.</span></li> <li><span>Direct input and output to Hadoop jobs.</span></li> <li><span>Integration with Apache Hive for SQL-like queries over HBase tables, joins, and JDBC support.</span></li> </ul><p>HBase is formally part of the <a href="" target="_self">Apache Hadoop</a> project, and runs within <a href="" target="_self">Amazon Elastic MapReduce</a>. You can launch HBase jobs (version 0.92.0) from the command line or the AWS Management Console.</p> </blockquote>, 14 Jun 2012 11:20:00 -0700hbasehadoopembamazonnosqldatabasescrudcomicSeven Weeks Community <a href="">Seven Weeks Community</a>: <p>It’s hard to install some of these databases… just like it was hard to get started with a few of the seven languages as well. With that in mind, we’re toying around with <a href="">hosting a public community</a> where people going through about the seven weeks books can ask/answer, and be searchable.</p>, 12 Jun 2012 21:59:00 -0700communitynosqllanguagesprogrammingcomputerssevenweekscrudcomicLyrics to Seven Databases in Song <p>Relational, columnar, graph or key-value store,<br/> document datastores too.<br/> So much to discover, in this song we&#8217;ll cover<br/> from each type at least one or two.</p> <p>Neo4J, Postgres and HBase and Redis then<br/> CouchDB, Mongo and Riak.<br/> of partitions, consistency, availability:<br/> pick two, you can&#8217;t have all three-ach.</p> <p>Postgres is relational, stable, transactional.<br/> Tables have columns and rows.<br/> Rules, window functions and SQL for querying;<br/> vertically is how it grows.</p> <p>Riak&#8217;s key-value store implements Dynamo,<br/> shards data out to a ring.<br/> It&#8217;s REST-based with mapreduce link-walking functions and<br/> vector-clocks; made in Erlang.</p> <p>HBase is columnar just like BigTable:<br/> distributed, sorted and sparse.<br/> Hadoop&#8217;s ecosystem provides extra features but<br/> setup&#8217;s a pain in the arse.</p> <p>Oh, Mongo stores JSON&#8212;-its documents speedily<br/> replicate so it’s webscale.<br/> Indexes and updates your deep nested attributes<br/> in-line, so data’s not stale.</p> <p>Neo4J is so ACID compliant; this<br/> graph database really shines.<br/> You query through edges that connect two vertices.<br/> No ORM-based designs.</p> <p>The Redis key-value holds rich data structures;<br/> is RAM-based or writes them to disk.<br/> Expiry’s for caching. PUB/SUB message passing,<br/> and queueing by block reading lists.</p> <p>The CouchDB doc store has partial mapreduce;<br/> is RESTful, crash-only and stable.<br/> Great for embedding, ad-hoc replicating,<br/> though don&#8217;t try to join, it’s not able.</p> <p>The database world is now rich with complexity;<br/> so much to research and know.<br/> You have many options you&#8217;ll need to consider like&#8230;</p> <p>Disk read and writing and<br/> Bloom filters, buffering<br/> CPU<br/> querying<br/> TTL<br/> caching plus<br/> consistent hashing <a href="">and more</a>!</p>, 11 Jun 2012 10:10:58 -0700jimbojwSeven Databases in Song! This was so much fun to work on, and... <iframe width="400" height="300" src="" frameborder="0" allowfullscreen></iframe><br/><br/><p>Seven Databases in Song! This was so much fun to work on, and Jim Wilson totally deserves all the credit. Thanks also to Todd Yard for his sexy vocals.</p>, 08 Jun 2012 08:55:33 -0700nosqldatabasessongcrudcomic(Seven Plus Or Minus Two) Databases For Computational Journalists <a href="">(Seven Plus Or Minus Two) Databases For Computational Journalists</a>, 27 May 2012 19:11:49 -0700nosqldatabasecrudcomic"If an API is UX for programmers, then Redis should be in the Museum of Modern Art alongside the Mac..." “If an API is UX for programmers, then Redis should be in the Museum of Modern Art alongside the Mac Cube.”<br/><br/> - <em>Eric Redmond, Seven Databases in Seven Weeks</em>, 23 May 2012 08:55:35 -0700databasenosqlrediscrudcomicBuddy Lindsey: Neo4j (Week 6) <a href="">Buddy Lindsey: Neo4j (Week 6)</a>: <p>The penultimate Buddy Lindsey article about Neo4j.</p>, 21 May 2012 20:57:43 -0700databasenosqlneo4jcrudcomicEric Redmond, author of “Seven Databases in Seven... <iframe src="" width="400" height="225" frameborder="0"></iframe><br/><br/><p>Eric Redmond, author of “Seven Databases in Seven Weeks” spends a week in the Hashrocket office and talks with Paul Elliott about his book.</p> <p>This isn’t the first interview I’ve ever done… but certainly the best produced. Thanks again for the killer week, HR!</p>, 14 May 2012 21:05:00 -0700databasenosqlcrudcomicAn Amazing in Depth Review (Seven DBs) <a href="">An Amazing in Depth Review (Seven DBs)</a>: <p>I loved this walkthrough. Frédéric Dumont was very fair, and I enjoyed his take. He was also one of the best and most productive beta testers.</p> <p><em>Fred: if you’r reading this, you’re in the book acknowledgements. Thanks for all of your help.</em></p>, 30 Apr 2012 21:32:53 -0700nosqlcrudcomicBuddy Lindsey: CouchDB (Week 5) <a href="">Buddy Lindsey: CouchDB (Week 5)</a>: <p>Buddy’s 5th Fair and Balanced(TM) article about seven databases in seven weeks.</p>, 25 Apr 2012 10:21:17 -0700couchcouchdbnosqlcrudcomicYou need to learn Hadoop. This little data analytics engine is... <iframe width="400" height="300" src="" frameborder="0" allowfullscreen></iframe><br/><br/><p>You need to learn Hadoop. This little data analytics engine is so much more than mapreduce, and supports an ecosystem of pre-defined algorithms that makes me wonder why anyone would want to use Mongo’s built-in junk, for example.</p>, 24 Apr 2012 07:31:03 -0700hadoopbig datanosqlmapreducecrudcomicSeven Databases song from Railsberry. Or: 7 databases in 70... <iframe width="400" height="300" src="" frameborder="0" allowfullscreen></iframe><br/><br/><p>Seven Databases song from Railsberry. Or: 7 databases in 70 seconds… Lyrics by Jim Wilson and Eric Redmond. Performed by Eric.</p>, 23 Apr 2012 09:27:07 -0700databasenosqlsongrailsberrycrudcomicEuropean "Vacation" <p>I spent a refulgent week in Jacksonville, Florida with the impossibly brilliant <a href="" target="_self">HashRocket</a> team; drinking expensive whisky, debating the merits of snowboarding v. surfing, and chatting about databases. I&#8217;ll put those videos online when available. I also created the <a href="" target="_blank">worlds dumbest web service</a>, rather than helping Ro debug <a href="" target="_blank">Cypher</a> queries. Sorry man.</p> <p>Next week I&#8217;ll be running (read: flying) through (read: over) Europe. London UK on Apr 17&amp;21, Krakow Poland Apr 18-20.</p> <p>Although I no longer work with MongoHQ, my standing offer still applies: anyone who wants to meet up and chat about databases (or whisky, or snowboarding, or NodeJS) tweet me: <a href="" target="_blank">@coderoshi</a>. It doesn&#8217;t have to be MongoDB, CouchDB, PostgreSQL, Riak, Redis, Neo4j or HBase&#8230; I have opinions on OrientDB, HypergraphDB, Cassandra and others :)</p> <p><img height="288" src="" width="512"/></p>, 12 Apr 2012 17:02:04 -0700nosqlrailsberryeuropecrudcomicA Neo4j Talk Disguised as NoSQL Talk <a href="">A Neo4j Talk Disguised as NoSQL Talk</a>: <p>I tried to upload one of my (Eric Redmond’s) videos about database styles. But Tumblr seems to be finicky right now, so instead, here is Jim Webber’s amazing talk <em><a href="" target="_blank">Highly Connected Data Models in NOSQL Stores</a></em>. It’s 80% about Neo4j, but it’s informative and captivating.</p>, 06 Apr 2012 20:38:00 -0700nosqlneo4jcrudcomicBuddy Lindsey: MongoDB (Week 4) <a href="">Buddy Lindsey: MongoDB (Week 4)</a>: <p>@BuddyLindsey’s 4th database review is Mongo. I’m still enjoying these… and so will you.</p>, 05 Apr 2012 07:56:00 -0700mongodbmongonosqlcrudcomic