Pythian Group

OpenSQLCamp was a huge success! I took videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded). Unfortunately, I was busy doing administrative stuff for opensqlcamp for the opening keynote and first 15 minutes of the session organizing, and when I got to the planning board, it was already full….so I was not able to give a session.

• Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB by Igal Koshevoy of Pragmaticraft
• Drizzle Client Rewrite – Clark Boylan leads the requirements and design discussion for rewriting the Drizzle Client
• Drizzle Plugin Hacking
• Drizzle is Not MySQL with Changes – Brian Aker gives a talk on Drizzle, and how Drizzle is not MySQL.
• Fractal Trees – by Bradley Kuszmaul of Tokutek
• Geographic Operators in SQL (PostGIS) by Webb Sprague
• Goal-Driven Performance – Peter Zaitsev speaks about how to achieve goal-driven performance.
• Graph Engine for MySQL – by Antony Curtis
• Intro to Cassandra
• An Intro to CouchDB: What caught Ubuntu’s eye by Mike Miller (Cloudant)
• Maria – MySQL founder Monty Widenius talks about Maria, and the past, present and future of MySQL.



• Memcached functions in MySQL
• mk-query-digest – Baron Schwartz talks about mk-query-digest, which parses logs and can capture live MySQL action to analyze, transform, filter, review and report on queries.
• MongoDB
• SQL For the Insane – Dan Colish presents SQL For the Insane – crazy SQL tricks presented at the November 2009 OpenSQLCamp in Portland, Oregon.
• SQL vs. NoSQL Panel moderated by Ronald Bradford and including:
  
  • Brian Aker – Drizzle
  • Monty Widenius – MariaDB
  • Selena Deckelmann – PostgreSQL
  
  
  • Eric Evans – Cassandra
  • Mike Dirolf – MongoDB
  • Mike Miller – CouchDB

• PBMS, BLOB, S3 Storage and Backup – Barry Leslie of Primebase talks about PBMS, BLOB, S3 Storage and backup with the PBMS Daemon.
• Operations Aspects to Running DBs in the Cloud – Joe Williams from Cloudant talks about: automation (config management, dynamically adding nodes) performance (adding nodes to increase performance, disk tuning) and availability (what if a node goes down?)
• Speak HTTP to your Database – John David Duncan speaks about lessons learned from mod_ndb
• Storage Engine API – Bradley Kuszmaul of Tokutek describes his ideas for a storage engine API for MySQL.
• Using and Optimizing Databases on Flash by Peter Zaitsev
• Xtrabackup tricks – Peter Zaitsev talks about Xtrabackup tricks.

Lightning Talks (same as previously posted, nothing new below):


• All the lightning talks below in one continuous video (just over 54 minutes total)




• The Graph Engine (Antony Curtis)


• Cluster/J, a new set of Java APIs to MySQL Cluster 5.1 (John David Duncan)


• Sphinx, the fulltext storage engine (Peter Zaitsev)


• iiBench, the Indexed Insertion Benchmark (Bradley Kuszmaul of Tokutek)


• JJtree in Coco


• Integrating OSS with Windows (Tom Hanrahan of Microsoft)


• Trainwreck, an agent for MySQL replication (Domas Mituzas)


• Column Stores (David Lutz of Infobright)


• I Play With Data, about doing real statistical calculations of data, when SQL gets in the way (Joseph di Paolantonio)


• Your Guide to NoSQL (Brian Aker)


• PL/Parrot The call for PL/Parrot in Postgres is put out there (Jonathan “Duke” Leto)