How to connect to a remote database （rqlite）？

Questions / Help
,
1

hello all,
I use sqlite as the database. In the local database, It is all right
config.exs

config :store_api, StoreApi.Repo,
  database: Path.expand("../store_api_dev.db", Path.dirname(__ENV__.file)),
  pool_size: 5,
  stacktrace: true,
  show_sensitive_data_on_connection_error: true

But when I change the remote database.I don’t know how to modify config.exs
like mysql or postgres. In config.exs. add hostname field and tablename

config :store_api, StoreApi.Repo,
  hostname: "192.168.113.124:4001",
  database: "store_api_dev.db",
  pool_size: 5,
  stacktrace: true,
  show_sensitive_data_on_connection_error: true

It is incorrect. my log is

[error] Exqlite.Connection (#PID<0.605.0>) failed to connect: ** (Exqlite.Error) got :eio while retrieving Exception.message/1 for %Exqlite.Error{message: :eio, statement: nil} (expected a string)

what should I do ?
thanks everyone!!!

2

sqlite isn’t a networked database and has no way to connect through a network, if you really want to do it the easiest way would be to mount the remote folder where the database file is in the computer where the application is running using something like NFS.

But I don’t think that’s a good idea though…

3

Thank you for your reply and suggestion！ :grinning: