Google Launched Cloud SQL API

Internet search giant, Google, launched an Application Programming Interface (API) to enable users of its Cloud SQL to manage their databases. The Google Cloud SQL was originally available way back October 2011, but only in limited preview. The program lets you run MySQL databases in Google's cloud. Based upon the description of Google Cloud SQL through its website, it enables you to: "Use a fully managed service to maintain and administer your databases, so you can focus more on building your applications and worry less about database management.” In using Google Cloud SQL to connect to your databases, your choices start with the basic command prompt or an SQL prompt in Google's API console that you can use to execute basic SQL statements. The Google Cloud SQL will probably be more useful to developers for its ability to use Google Apps Script's JDBC Service, or Google App Engine Java SDK or Python SDK. The Admin and reporting tools that support JDBC connections works seamlessly. The newest Google Cloud SQL API has now supplemented with an experimental JSON API. It will give you a Restful interface that you can use to manage MySQL databases from your applications. The interface gives you the main administrative options for managing MySQL, so you can create or delete databases, start and restart instances, restore a database from backup, and import and export data. Although given the above-mentioned benefits of the Cloud SQL API, the current service dos have some restrictions; a size limit of 100GB for individual instances, and MySQL replication isn't supported. Aside from that, there are more minor restrictions particularly the lack of support for User Defined Functions, and no support for the following MySQL statements and functions: *** LOAD DATA INFILE *** SELECT ... INTO OUTFILE/DUMPFILE *** INSTALL/UNINSTALL PLUGIN ... *** CREATE FUNCTION ... *** LOAD_FILE() *** SHA2() For more information regarding the Cloud SQL just visit the official website of the Google Cloud Platform.