Monday, December 19, 2011

Simple development of App Engine apps using Cloud SQL - Introducing Google Plugin for Eclipse 2.5


Since we added SQL support to App Engine in the form of Google Cloud SQL, the Google Plugin for Eclipse (GPE) team has been working hard on improving the developer experience for developing App Engine apps that can use a Cloud SQL instance as the backing database.

We are pleased to announce the availability of Google Plugin for Eclipse 2.5. GPE 2.5 simplifies app development by eliminating the need for manual tasks like copying Cloud JDBC drivers, setting classpaths, typing in JDBC URLs or filling in JVM arguments for connecting to local/remote database instances.

GPE 2.5 provides support for:
  • Configuring Cloud SQL/MySQL instances
  • Auto-completion for JDBC URLs
  • Creating database connections in Eclipse database development perspective
  • OAuth 2.0 for authentication.
Configuring Cloud SQL/MySQL instances
App Engine provides a local development environment in which you can develop and test your application before deploying to App Engine. With GPE 2.5, you now have the ability to configure your local development server to use a local MySQL instance or a Cloud SQL instance for testing. When you choose to deploy your app, it will use the configured Cloud SQL instance for App Engine.


Auto-completion for JDBC URLs
GPE 2.5 supports auto-completion for JDBC URLs, and quick-fix suggestions for incorrect JDBC URLs.


Creating database connections in Eclipse database development perspective
The Eclipse database development perspective can be used to configure database connections, browse the schema and execute SQL statements on your database.

Using GPE 2.5, database connections are automatically configured in the Eclipse database development perspective for the Development SQL instance and the App Engine SQL instance.


You can also choose to manually create a new database connection for a Cloud SQL instance. In GPE 2.5, we have added a new connection profile for Cloud SQL.


GPE 2.5 now uses OAuth 2.0 (earlier versions were using OAuth 1.0)  to securely access Google services (including Cloud SQL) from GPE. OAuth 2.0 is the latest version of the OAuth protocol focussing on simplicity of client development.

Can’t wait to get started?
Download GPE here and write your first App Engine and Cloud SQL application using GPE by following the instructions here.

We hope GPE 2.5 will make cloud application development using App Engine and Cloud SQL a breeze. We always love to hear your feedback and the GPE group is a great place to share your thoughts.


Posted on behalf of the Google Plugin for Eclipse Team

12 comments:

Chintan said...

Awesome.

Brandon Donnelson said...

I love it. Good job!

Anonymous said...

UTSI offers Database Development services for new or existing systems. Our team of database developers has experience with a variety of databases.

Database Development

Anonymous said...

Wow!!! Great work, lovely post.
I really like it.
Please keep it up :)

Sql server JDBC Driver Download

Unknown said...

thank you want to try to learn to be a developer

Anonymous said...

what about SSL ? there is still not SSL support for non appspot.com domains

Brandon Donnelson said...

SSL is supported.
http://code.google.com/p/gwt-examples/wiki/DemoActivitiesAndPlaces#App_Engine_SSL_Hosting

Anonymous said...

SSL is not supported for custom domains (e.g. adomain.com ). It works only on .appspot.com domain name which is useless if you have a real application

Anonymous said...

The issue is http://code.google.com/p/googleappengine/issues/detail?id=792 and is still not fixed . It's 4 years old so we can say happy new year no SSL !

Brandon Donnelson said...

Sign up to be a Tester for SSL for Custom domain here:
https://groups.google.com/forum/?hl=en#!topic/google-appengine/1_sgDL6dIBA

Or refer to Issue 126 - http://code.google.com/p/googleappengine/issues/detail?id=792

Anonymous said...

yeah I already "signed up" for several times but I got not response yet .

Brandon Donnelson said...

Have you tried App Engine forum?
http://code.google.com/appengine/forum/