Local Connection Fails
techgerm opened this issue · 8 comments
Scenario
- I run
pscale connect galaxy --port 3309
locally to connect to my PlanetScale DB - I attempt to connect my T3 app using
import { connect } from "@planetscale/database";
Problem
- When I use
url
to connect to my local db connection, it does not use the specified port - instead is uses port443
:
const connection = connect({
url: "mysql://root@127.0.0.1:3309"
});
- When I use
host
&username
to connect to my local db connection, it uses the correct port but it fails with aERR_SSL_WRONG_VERSION_NUMBER
status code
const connection = connect({
host: "127.0.0.1:3309",
username: "root"
});
I'd love to be able to use this package instead of prisma
for my next project.
Anything that can be done to help here would be greatly appreciated!
@mattrobenolt thanks for the quick response and clarification!
In that case, do you know how I can specify a DB branch in this configuration?
When you create credentials, they're bound to a branch. So you'd just create credentials for the branch you want, and it'll work. Are you observing something differently?
Ah that's my mistake, didn't realize that was the case. Thanks again for your help!
Out of curiosity, are there any future plans to bridge the protocols?
Bride them how? I have some plans. 👀 But curious what you have in mind.
Hmm let me give it some thought and I'll get back to you!