tag:blogger.com,1999:blog-7100397.post8372990095760349782..comments2011-11-16T15:16:33.042-07:00Mark Watson, author and consultanthttp://www.blogger.com/profile/05514730816583918651noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7100397.post-4630854732032274382011-11-16T14:13:06.951-07:002011-11-16T14:13:06.951-07:00Mark,<br /><br />I have tried the command line interface as well, and I agree. It should be possible to Google Cloud SQL from outside of the App Engine. Google should either open source that JAR or make it into a service/library that other apps can utilize.<br /><br />Personally I would prefer <a href="http://code.google.com/apis/fusiontables/docs/developers_guide.html" rel="nofollow">REST SQL APIs</a> for the Cloud SQL, similar to what Google provides for Fusion Tables.<br /><br />SaqibSaqib Alihttp://www.blogger.com/profile/02387888275653820697noreply@blogger.comtag:blogger.com,1999:blog-7100397.post-43307510963201188842011-11-15T21:58:58.867-07:002011-11-15T21:58:58.867-07:00Hello Saqib,<br /><br />After reading your comment, I installed the SQL command line tool: https://code.google.com/apis/sql/docs/commandline.html<br /><br />This does give me a command line interface to execute interactive SQL queries from my laptop at home. It took a few minutes to get the &quot;Authorization Code&quot; set up for external access.<br /><br />The command line tool is a JAR containing compiled class files, but no source code. Perhaps Google will release the source code.<br /><br />There must be a workaround, or even a clean way to get remote access from, for example, a Java application running on an external server (or our laptops).<br /><br />-MarkMark Watson, author and consultanthttp://www.blogger.com/profile/05514730816583918651noreply@blogger.comtag:blogger.com,1999:blog-7100397.post-11049251539147171272011-11-15T21:17:22.904-07:002011-11-15T21:17:22.904-07:00Mark,<br /><br />I have been experimenting with the Cloud SQL as well for the last few weeks. It is major step in the right direction. App Engine lacked a RDBMS, and now Google is filling that gap.<br /><br />However, for my RDBMS driven apps, I still can&#39;t use App Engine, because I can&#39;t connect to the Cloud SQL instance from outside of the app engine. Ability to feed data from outside is key to my application. I can probably write a REST service on the app engine to accept and store the data in Cloud SQL, but that would be extra work, and sometimes impossible because the third party apps that are feeding data into my app may not support REST at all.<br /><br />Hopefully Google will allow external connections in the near future. Until then, Amazon RDS is the way to go for me.<br /><br />SaqibSaqib Alihttp://www.blogger.com/profile/02387888275653820697noreply@blogger.com