Past year, I got interested in Freebase and its query language, MQL. In my opinion, MQL is an interesting database query language in general, and a number of features make it downright excellent for implementing secure but flexible access to relational databases over the web, especially for modern (AJAX) web applications – better than SQL.
I created an implementation dubbed MQL-to-SQL, which is available at http://code.google.com/p/mql-to-sql/ under the terms of the LGPL. It’s basically a PHP script that supports the the protocol of the freebase MQL-read webservice. MQL-to-SQL itself uses PDO (PHP Data Objects – a standard database access abstraction layer built into PHP) for database access and is thus to some extent RDBMS independent. I currently have examples based on the sakila sample database working on SQlite, MySQL, Postgres (pagila) and Oracle. For sample queries, see the project wiki To kickstart it without downloading and installing, try them in the online demo
In this 45-minute session, I want to explain how MQL works and why it is a great solution to solve the RDBMS access problem for modern (AJAX) web applications. In addition, I will explain how I implemented MQL-to-SQL, and how it translates MQL queries to SQL queries, executes them and returns the result document. Time permitting I will show what the advantage is for the web-client (as compared to being limited to tabular results returned by SQL queries)
The outline for the talk follows below:
Solving the data access problem in Web vs client-server applications:
The problem with SQL from the perspective of a web applications
The MQL query language
Why MQL is a great solution for modern (AJAX) web applications:
MQL-to-SQL: an open source MQL implementation for your RDBMS
I studied Molecular Biology, but I’m professionally occupied as Web Application Developer, Information and Business Process Analyst, and Business Intelligence Guy. I have worked for Inter Access, MySQL AB, Sun Microsystems, and I currently work for Strukton Rail.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at email@example.com
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts