Support for schemas (Postgres Oracle etc.)

[vanthome]

Hello, great tool! Do you plan to support DB schemas as they exist in PostgreSQL for example?
BG

[janpio]

What do you mean exactly @vanthome - if we want to support existing databases that already have a schema? Then yes, we have an "Introspection" step that can be used to create a Prisma schema file from an existing database (currently MySQL, Postgres or SQLite) that then can be used to generate Photon.

Or did I misunderstand?

[pantharshit00]

Here you can find docs on introspection: https://github.com/prisma/prisma2/blob/128be311af1a6e0fc47dd4d54e744a5042c43fb7/docs/introspection.md

[vanthome]

Yes, you misunderstood. I'm not referring to the entirety of tables and other objects. I know the term is ambiguous and that's why I mentioned Postgres and Oracle. Please see here what a schema in Postgres is:

https://www.postgresql.org/docs/current/ddl-schemas.html

[pantharshit00]

Oh, we do support Postgres schemas. We ask about them in our cli init flow:

Or you can add it to connection string like so:

Also, we don't currently support oracle. We support SQLite, MySQL and PostgreSQL

[janpio]

Sorry I didn't get your question in the first try, seemed to obvious to me as we really do support this for quite some time.

Does that answer you question @vanthome?
Or are there any aspects that @pantharshit00 did not touch on?

[vanthome]

@janpio well kind of but I would assume you only support one schema at a time and not switching schemas at runtime, right?

[pantharshit00]

Yes, we don't support querying across multiple schemas right now. Maybe you can open a new issue for that titled "Support for multiple (Postgres, Orcale) schemas".

[pantharshit00]

Closing in favour of prisma/prisma#1122