any ETA on the table view of Prisma data? Would lo...
# prisma-whats-new
w
any ETA on the table view of Prisma data? Would love the Graphcool interface
πŸ’― 1
j
Do you talk about the console?
w
yeah
j
They told me not before the mid-february
l
I haven't heard a table view mentioned for Prisma. I know the work around is to SSH into the Docker container with your choice of MySQL client, though I've never done it
w
ohh - I thought about trying that. If anyone has done that lmk
l
It's been done with the Graphcool Framework. Let me find it
d
Are you talking about this? https://www.prismagraphql.com/docs/faq/console-and-dashboard-ikahjeex0x I am also waiting for this one! As of now, it is soonβ„’ πŸ˜…
w
Yeah that!
l
That's the image from the old Graphcool upcoming dashboard. It's probably 6 months old (an eternity here πŸ™‚) The dashboard is coming, but I wouldn't count on everything in the image being a part of Prisma.
j
w
let me try that
l
@johannpinson do you know how to convert those instructions to a MySQL client like Sequel Pro?
n
We're working on a Console for Prisma πŸ™‚ It will be great ✨
d
Yes, the DB access works.. albeit the password is
graphcool
not
prisma
It will be updated soon I think to prisma! πŸ™‚
w
I wonder if I can expose the IP so I can connect with sequel pro
d
Yes you can (in theory).. but publicly exposed mysql is not secure, so, you might want to close it when you are done or something πŸ™‚
w
of course - just for local development, it’s hard to see data easily
d
Yes.. I am sure you are aware of it (I have seen your courses and other shiny stuff πŸ˜‰), wrote that for normally whoever is reading this and not aware! Just writing "yes" would have been misleading (i felt) πŸ˜…
w
πŸ˜„ thanks for the help
πŸ’š 1
n
here's a guide how you can connect to your local DB using Sequel Pro for example: https://www.prismagraphql.com/docs/tutorials/database/database-access-(sql)-eechaeth3l
parrotwave6 1
caveat:
Yes, the DB access works.. albeit the password is
graphcool
not
prisma
πŸ™‚
w
@nilan does the prisma docker image expose it so we can connect with sequel pro? That example just sshes into the docker and uses the CLI
n
yes, you can apply the section "Open MySQL client" to whatever SQL client you use
l
@nilan Is there any way to get a SQL client to a hosted Prisma container? This seems like it'd be quite the trick
w
I dont think 127.0.0.1:3306 is the correct connection though
n
@lawjolla you're right, this is where the Console comes in later πŸ™‚
πŸ‘ 1
@wesbos why do you think so?
w
@nilan does docker just expose it on localhost?
n
yes, check with
docker ps
w
ah you are right - trying to connect with that
There we go! It was port 3307
n
aw, I'll add a note to the tutorial
w
thanks for he help - I’m a docker n00b
d
For context, this might be a temp/permanent solution to this! https://github.com/graphcool/prisma/issues/1559 @nilan: see if you need to mark anything here πŸ™‚