Hi <@U0RQY0KK5>, is there any way for us to manag...
# prisma-whats-new
Hi @nilan, is there any way for us to manage the underlying database or see its structure? For example, if a mysql table ends up having millions of records, from a performance standpoint would be good to know what indexes are created, etc., and in terms of general maintenance sometimes it's easier (or only possible) to just issue raw queries vs. graphql queries/mutations. Thanks!
I’m not 100% sure on anything I’m about to say so just keep that in mind. 1. I have no idea how you would go about doing that if it is possible. 2. An alternative (that I have not tested nor am I even sure about) is running Graphcool on your own infrastructure. It would make sense that you would be able to access your own databases at this point, in which, you’d be able to do what you want to. For example, you could use the framework & throw everything up on AWS, also using Aurora/MySQL/Postgres. Running stuff on your own infrastructure may not be something you want to do and, before you do anything, I’d see what @nilan has to say. But… Hopefully this helps in some way 😄
I’ll also add, I’m pretty sure you can only see the underlying data if your running GC on your own infrastructure. But Mark will be able to verify that. (Or someone else)
You have direct database access on your local cluster and on a private cluster, not on the shared clusters
This will be made more clear in the docs soon as per this open issue: https://github.com/graphcool/framework/issues/1245
@agartha Thanks for the link. I guess I'll need to look into hosting my MongoDB instance elsewhere and using schema stitching with Graphcool.
👍🏻 1