Crystal Lang DB Connection Issues
Hey, there!
I'm trying to move my production applications written in Crystal (using the Lucky web framework) from Render to Neon.
Got everything migrated from a data perspective, but when I went to actually change the DB connection string I got a weird error:
I chased things down through the Crystal PG shard that most frameworks use for their connections to this issue: https://github.com/will/crystal-pg/issues/192
Basically - is there any way to not use cleartext for the Neon auth? It seems that there's quite a lot of potential risk based on the driver being used.
I'm really wanting to move all of my paid projects to Neon to support the app as it grows, so I'm hoping I'm just looking past something!
For the record, I was able to use the
Appreciate any help!
I'm trying to move my production applications written in Crystal (using the Lucky web framework) from Render to Neon.
Got everything migrated from a data perspective, but when I went to actually change the DB connection string I got a weird error:
Caused by: server asked for disabled authentication method: cleartextI chased things down through the Crystal PG shard that most frameworks use for their connections to this issue: https://github.com/will/crystal-pg/issues/192
Basically - is there any way to not use cleartext for the Neon auth? It seems that there's quite a lot of potential risk based on the driver being used.
I'm really wanting to move all of my paid projects to Neon to support the app as it grows, so I'm hoping I'm just looking past something!
For the record, I was able to use the
auth_methods=cleartext parameter (even though I'd rather not use cleartext at all), but then the driver doesn't seem to support the Endpoint ID option, so I'm stuck again since the driver doesn't support SNI.Appreciate any help!
GitHub
I came across a problem with the database connection. A standard piece of code: DB.open "postgres://myuser:mypasswd@remoteserver/mydb" do |db| # code end throws an exception: "(DB::C...
