MQL-to-SQL is open source software that lets you query a RDBMS over HTTP using MQL (Metaweb Query Language). MQL is the native query language of www.freebase.com. There are good reasons to want MQL also as RDBMS query language, instead of SQL. This talk explains what MQL is, how it compares to SQL, why MQL is great for AJAX apps, and how MQL-to-SQL allows you to query RDBMSes like MySQL & Postgres
Read more.

OpenStreetMap raw data for any non-trivial area
comes as a massive amount of XML data.
Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options though, especially when it comes to producing on demand map data for web applications with acceptable performance.
Read more.

Small web apps running on shared hosting or single/dual server environments can take advantage of many optimizations without requiring additional hardware or drastic application redesign. This session is aimed at developers and covers the "low hanging fruit" type optimizations that just about everyone has to learn the hard way!
Read more.

phpMyAdmin is a well-known PHP application for managing MySQL database. What's wrong with it? It is big, slow and it misses support for many advanced features like stored procedures or triggers.
Its free alternative Adminer provides user-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
Read more.

The Narada Search Application is a project that was an idea that was inspired while writing a book on how to take advantage of Sphinx, Gearman and MySQL that introduces a whole new way of thinking about web applications. Instead of a single monolithic web application, functionality is broken out into several Gearman workers to make for a much more scalable and dynamic application.
Read more.

Presents an in-depth view of how to combine and integrate MySQL subroutines with the security model. Shows how stored programs best support AJAX enabled web applications. Demonstrates how the MySQL security layers can support transaction control in stored functions and procedures. Provides examples on how to encapsulate key logic from web developers.
Read more.

Writing a complete plugin requires quite a bit of infrastructure work to get all the feature registration and build system aspects right. A code generator can take care of such tasks, allowing you to focus on the actual functionality you want to add without having to figure out all plugin API details up front. This can cut the time to create a simple plugin down from hours to minutes.
Read more.

This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation.
I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads.
Read more.

Diamond Sponsor

Gold Sponsors

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com