Find solution
What is a database engine?

What database does Google App Engine use?

  • I would like to develop apps utilizing "https://developers.google.com/appengine/" to power the infrastructure. I am interested to know what type of database this system supports. For example: can I use http://www.postgresql.org/ or http://www.mysql.com/?

  • Answer:

    "The App Engine datastore is a schemaless object datastore, with a query engine and atomic transactions." "The App Engine datastore provides robust, scalable storage for your web application, with an emphasis on read and query performance. An application creates entities, with data values stored as properties of an entity. The app can perform queries over entities. All queries are pre-indexed for fast results over very large data sets." You currently cannot use Postgres or MySQL in production, although at the time of this answer Google Cloud SQL (http://code.google.com/apis/sql/) is in limited preview.

Gilbert Erik Garcia at Quora Visit the source

Was this solution helpful to you?

Other answers

http://code.google.com/appengine/docs/java/datastore/overview.html I think you have to learn GQL in order to interact with the app engine datastore. I do not think that you can use or on an app engine server. Or perhaps you can rewrite them for this platform...

David Combe

As of now there is no way to connect to the MySQL/Postgres or any other RDBMS from Google App Engine as it has clearly blacklisted JDBC and related APIs from appengine SDK. Google App Engine has its own datastore (often called as BigTable) which is non-RDBMS and follows NoSQL strategy. You get ample space for each app (1 GB free quota). But the only setback is the data loading and management which is kind of tough which could have been lot easier with other RDBMS. To write queries against Datastore, you need to use GQL (Google Query Language) which is a SQL-variant but not a clone. If you are more inclined to use RDBMS, the only way currently is to expose some kind of webservice/RESTful access from your DB if it is hosted elsewhere. Remember that every time you make RESTful call for the query, you will be counting on the daily URLFetch limit. Also, there is something coming up in favor of RDBMS http://code.google.com/appengine/business/#features.. not sure abt the release date.. All in all, GAE makes a great platform though it doesn't let us complete freedom. Other features like Blobstore API, TaskQueue etc are also quite good.

Rakesh Chintha

Ali Demir

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.