add support for postgresql

[dberardo-com]

i am not quite sure why the developers have added support for sqlite only when developing this gem.

I believe sqlite is not adequate for production, needless to say in a multitenant setup.

i am looking for native tenant support for postgresql is this something foreseeable in short term ?

also: are auto schema-migrations supported for multi tenant setups ? i would like to run migrations only on connections and not everytime a new app version is deployed.

[eglitobias]

We are also interested in this but for PostgreSQL specifically, there's already a draft PR adding Postgres support (#261). I don’t think there’s a committed “short-term” timeline yet, but it should be possible to try it out and provide feedback/testing on it.
Also, issues might not be the best place for roadmap/feature requests. This may fit better as a Discussion unless there's a concrete bug to track.

[rctneil]

I'm also very interested in PostgreSQL support. Will be keeping an eye on this!

[setoelkahfi]

We would like to have this as well.