点击一个SQLite数据库到Heroku？ [英] Push an SQLite database to Heroku with taps?

问题描述

所以我试图把一个SQLite3数据库推到我以为可以使用的Heroku，但是阅读这里和这里意味着它可能不是（下面不起作用）。

  heroku pg：push sqlite：// db / development.sqlite3 HEROKU_POSTGRESQL_OLIVE_URL 
！ LOCAL_SOURCE_DATABASE不是有效的数据库名称
  

Heroku将语法切换为 pg：push 来自 db：push 或者它永远不可能？



这是不可能的解决方案是将SQLite3中的任何数据迁移到本地postgres然后推送到Heroku？解决方案

Heroku使用只读文件系统，这意味着像SQLite3这样的基于本地文件系统的数据库与其基础结构不兼容。据我所知，从SQLite3数据库直接推送到Heroku上的Postgres是不可能的。

您应该将您的数据迁移到本地Postgres数据库并从那里推送。

So I am trying to push a SQLite3 database to Heroku which I thought used to be possible, but reading here and here imply that it may not be (the below doesn't work).

heroku pg:push sqlite://db/development.sqlite3 HEROKU_POSTGRESQL_OLIVE_URL
 !    LOCAL_SOURCE_DATABASE is not a valid database name

Was this changed when Heroku switched the syntax to pg:push from db:push or was it never possible?

Given that it's not possible is the solution to migrate any data from SQLite3 to local postgres and then push to Heroku?

解决方案

Heroku uses a read-only filesystem, which means that local file system based databases like SQLite3 aren't compatible with their infrastructure. And to my knowledge it has never been possible to push from a SQLite3 db directly to Postgres on Heroku.

You should migrate your data to a local Postgres database and push from there.

这篇关于点击一个SQLite数据库到Heroku？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！