如何将我的Sqlite数据库移植到GAE？ [英] How can I port my Sqlite database up to GAE?

问题描述

我在本地HD中有一个SQLite格式的数据库。我想将数据库提交到GAE，以便我可以使用它创建特定的酷网络应用程序。我浏览过一个方法来做到这一点。但是，大多数可用的项目都是将GAE中的数据库备份到本地HD。有没有一种方法可以将本地Sqlite数据库升级到GAE？

I have a database in SQLite format in my local HD. I would like to get the database up to GAE so that I can use it to create certain cool web-apps. I have browsed around for a way to do it. However, mostly the projects available are to backup the database in GAE to my local HD. Is there an existing way to get the local Sqlite db up to GAE already?

推荐答案

有没有办法可以做到这一点直接在appengine上，因为写入文件被限制在appengine中。我会说，你应该将你的sqlite数据库文件导出为像csv这样的通用格式，设计类似于sqlite表格模式的模型。然后编写一个脚本将所有这些sqlite记录加载到dev_sever（包含在sdk中的开发环境），然后您可以轻松地将数据从本地开发服务器上传到Google Appengine。查看这个知道如何导出开发服务器数据到appengine。

There is no way that you can do it directly on appengine, as writing to a file is restricted in appengine . I would say, you should export your sqlite database file to some common format like csv , design the model similar to sqlite table schema. Then write a script to load all those sqlite records into dev_sever (development env included in sdk), Then you can easily upload the data from local developement server to google appengine. Have a look at this to know how to export development server data to appengine.

这篇关于如何将我的Sqlite数据库移植到GAE？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！