如何生成 SQlite 文件?
我想将 Sqlite 连接到 Metabase,但是 Metabase 要求提供 .sqlite 文件才能进行连接。
我使用命令行和 Sqlite 浏览器创建了一个数据库。它创建常规文件(.db、journal),但我找不到任何 .sqlite 文件。
我已经导出为 .SQL 但它不起作用。
我怎样才能生成这个sqlite文件?
我正在使用 Ubuntu 20.04 LTS。
I want to connect Sqlite to Metabase, however, Metabase asks for a .sqlite file to make the connection.
I created a database using the command line and with Sqlite Browser. It creates the regular files (.db, journal) but I can't find any .sqlite file.
I have already exported as .SQL and it didn't work.
How can I generate this sqlite file?
I am using Ubuntu 20.04 LTS.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

我意识到我只需要将扩展名 .db 更改为 .sqlite,来源: https://en .wikipedia.org/wiki/SQLite。
Metabase不支持上传文件,因此我必须将数据库文件复制到下载Metabase的位置。当我尝试建立连接时,我只是编写了如下路径:./file.sqlite。来源:https: //discourse.metabase.com/t/having-trouble-with-uploading-sqlite-db-in-metabase-web-app/16725
I realized that I just needed to change the extension .db to .sqlite, the source: https://en.wikipedia.org/wiki/SQLite.
Metabase does not support uploading files, so I had to copy the database file to where Metabase is downloaded. When I tried to make the connection I just wrote the path as follows: ./file.sqlite. Source: https://discourse.metabase.com/t/having-trouble-with-uploading-sqlite-db-in-metabase-web-app/16725