Add SSL support

[Narigo]

It can be possible to use SSL encrypted connections with the newest driver version (0.2.19). I'll upgrade to that version shortly (that will fix another bug regarding NUMERIC columns) and then we are able to add SSL support.

[onesse]

Hi,
You speak about the SSL support but I don't see how to enable it. I checked on forums and vertx website but there is no really clear explanations. Writing a small paragraph would be great :)
Regards

[Narigo]

It's not supported yet. The driver could do it, but we need to add an API to use SSL in our client here as well.

[onesse]

Ok, thanks for your response. Do you have any idea when this feature will be available ?

[Mart-Bogdan]

I've just encountered same problem.
It's seems quite straight forward to add support, will make PR soon.

It's impossible to run on Heroku w/o SSL :c

this line shouldbe altered https://github.com/vert-x3/vertx-mysql-postgresql-client/blob/issues/sql-options/src/main/java/io/vertx/ext/asyncsql/impl/BaseSQLClient.java#L105

[ghost]

Is there any chance that #88 will be merged in any time soon?

[vietj]

can we close this issue then ?

[Narigo]

Yes!

[jbkoh]

I know this is closed and the PR has been merged. When will the new version be released with this feature?

[vietj]

@jbkoh soon hopefully, it's being staged atm

[jbkoh]

Thanks. I was wondering if I should start from java.sql directly or this.

[vietj]

what are you aiming for ?

[jbkoh]

Just want to make a Vertx service communicate with (or query to) a remote PostgreSQL with SSL enabled. Are there other solutions for this?

[vietj]

you can also check https://github.com/vietj/reactive-pg-client

[jbkoh]

@vietj Thanks for the pointer. I see that you are the main author of both this and that. Could you briefly introduce what the difference is?

[vietj]

the client has been developed to be a client for postgres: it implements a bit more than the actual vertx-mysql-postgresql-client like batching, notifications, java 8 dates.

[jbkoh]

Thanks for the prompt response. I will stick to the later. Thank you.