search

lovasoa / SQLpage

Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
https://sql.datapage.app
MIT License
1.56k stars 89 forks source link

Add support for SSL client certificates in MySQL and Postgres #300

Closed lovasoa closed 5 months ago

lovasoa commented 5 months ago

Discussed in https://github.com/lovasoa/SQLpage/discussions/299

Originally posted by **pettersillander** May 2, 2024 Could implemeting (maybe optional?) encrypted connection between client and server help to ease adoption of SQLpage in diverse environments? Quite a few networks (even closed) are encrypted connections only nowadays. As all the SQLpage supported dbms's support TLS natively it's seems rather cumbersome to use a tunnel for encryption. Just wondering this after configuring SQLpage in existing environments...
lovasoa commented 5 months ago

https://github.com/lovasoa/sqlx-oldapi/pull/7

lovasoa commented 5 months ago

@pettersillander , can you test the latest builds and let me know if it works for you ? The easiest is to test lovasoa/sqlpage:main on docker.

I also updated the documentation: https://github.com/lovasoa/SQLpage/blob/main/configuration.md#database-connection-strings

pettersillander commented 4 months ago

@lovasoa I built main yesterday and tested it at the site. The handshake & connection were succeeded and no errors in logs. So all good for now.