English 中文(简体)
How to port a PostgreSQl database to Google App engine
原标题:

i am currently doing a project as one of my university projects and it uses Google maps and right now i am using a postgresql database which is on my localhost but i want to host it some where else i couldn t find any free hosting for postgres and i don t know whether i can use Google App engine or Fusion tables to do it. i am using postgres and php to manipulate data and generate KML files. Google Maps V3 javascript API as the front end any suggestions ?

Thanks !!

问题回答

PHP is one of the most requested features, but it is not yet supported in GAE, so your PHP code is useless. In the future, hosted SQL databases seem to be part of Google plans to provide "Enterprise features" in GAE, stay tuned because that could simplify what you need to do.

Currently, in case that:

  1. your site is implemented as a Java EE or Python web appliaction
  2. you are already using JPA/JDO (only in the Java EE case)
  3. you are not doing JOIN statements (not supported in GAE)

Or even if your service/dao layers are already well isolated, it would be possible to host your "denormalized" database (it would not be a postgres service) and your frontend in GAE without too much effort.





相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...

热门标签