cube icon indicating copy to clipboard operation
cube copied to clipboard

SQL API Encryption

Open justusfowl opened this issue 3 years ago • 4 comments

Dear all,

first of all let me thank you for providing such a great product, I really like cube-js.

I have a question on the SQL API:

I am currently trying to identify options how to encrypt the connection to the SQL API and wonder if people can share best practices on how to offer this API with TLS encryption.

I am thinking to offload the TLS of the TCP connection at a proxy (nginx) and forward the connection in an unencrypted manner.

Thanks a lot - grateful for any hints :)

best

justusfowl avatar Sep 08 '22 12:09 justusfowl

@justusfowl Hey Justus! Connection encryption isn't part of an open source. If you're looking for encryption implementation for SQL API, you should consider using Cube Cloud.

paveltiunov avatar Sep 09 '22 05:09 paveltiunov

Ok thanks - I really would, but due to data privacy constraints of clients this is not an option sadly. Do you plan to add this feature for the SQL API anytime in the future?

justusfowl avatar Sep 09 '22 05:09 justusfowl

@justusfowl you can take a look at pgbouncer.

NikKomarov avatar Sep 09 '22 08:09 NikKomarov

Thanks @NikKomarov - I appreciate it!

justusfowl avatar Sep 09 '22 08:09 justusfowl