3 ms·
A customer asked us to integrate their website with our mobile application. They had no IT department to do the integration, and they didn't want to open their
by nurettin 9y ago
A customer asked us to integrate their website with our mobile application. They had no IT department to do the integration, and they didn't want to open their database to the web, so I came up with this solution;
ssh into the machine, select using a db commandline tool, return data back from stdout in csv format, parse data at our side. It's surprisingly fast and secure.
- caleblloyd 9y agoSSH tunneling supports forwarding remote hosts to local ports. Then you could use a proper database connector in your app. For example access MySQL through an SSH tunnel: https://stackoverflow.com/questions/18373366/mysql-connection-over-ssh-tunnel-how-to-specify-other-mysql-server https://stackoverflow.com/questions/18373366/mysql-connectio...
- nurettin 9y agoI forgot to mention that it was an SQLite database.
- chx 9y agoThey could reverse SSH even so they don't have a port open.