Secured Local Hosted Redash Connection to a remote Postgre SQL hosted on Linode
Technical details:
Hi,
I would like to run Redash on my local Macbookpro and connect to a PostgreSQL hosted on Linode VPS.
Please let me know what is the most secured connection method to make this remote connection.
The reason is we are running our live eCommerce platform on the Linode and need the most secured method to connect to the database directly.
Regards,
Chee
Another approach would be to create an SSH tunnel from your local macbook pro to the remote Linode VPS, configured so Redash (running on the macbook) can query PostgreSQL over the connection.
This is what I’m doing presently, for connecting to a remote host on Scaleway (instead of Linode). The raw command line to run is:
Where linodeserver should be the DNS name, or IP address, of your Linode VPS.
With that command run, ssh will start listening on port 5431. Anything that connects to it will be transparently connected through to 127.0.0.1 (localhost), port 5432 on the remote server.
You tell Redash to run queries against 127.0.0.1:5431 (localhost on your macbook), and ssh will do the tunneling between things.
That may be more secure than setting up Redash on a remote server if you’re not comfortable with securing servers on the internet. If you have a team that can secure a remote server for you though, that may be the better option.
Not sure, I haven’t been using Redash for long myself either.
From a “maximum safety” perspective, it’s probably best to develop your queries against a copy of the database (on a different server) instead of doing it live on a production one.
With SQL in general it’s possible to write bad queries that can impact the entire database. Many companies create replicas of their database on a different server, specifically so people can run all kinds of queries on that and not have a bad effect on their main database server. Not sure how much that applies to your situation though.
Good morning,
I don’t understand your need.
Do you plan to run update/delete and alter queries from Redash ?
If you only plan to execute select queries to feed your dashbord and you’re afraid of “bad queries”, you may create a PotgresSQL user for your Redash datasource who only have “reading rights” (connect on database , usage on schema , select table/views rights)
Just to confirm here: no, Redash does not include rollback protection. It’s designed for data visualization and is not tuned towards the full suite of DB admin activities.
Our company is interested to consider integrating Redash for our Customer Facing use case.
We are a startup company from Singapore and our SaaS is of the same name as our company “Acornity”. It is an eCommerce ads platform. We engage bloggers to provide publication space for merchants to deliver product advertisement.
We have 2 use case:
Case 1: For integrating Redash into Acornity to allow merchant and blogger to check on how their campaigns are doing and provide insight to fine tune their promotion activity and blog content direction. We charge a fee to the merchant to use Acornity. We would like to make this a While Label arrangement and not to display any Redash logo in our service. We will not make code change to Redash.
Case 2: For our internal staff operation usage. To check the various status of operation and optimize our service delivery. This is an internal facing use and we will be able to show and adhere to all Redash license logo display. We will not make code change to Redash.
Please let us know how much the Commercial License will cost and are there any further restriction on use.
Please also let us know if our Case 2 will qualify for a free usage license.
I’m definitely not the correct person to ask about licensing though, as I’m just helping out on here on the forums when I feel like it, rather than working for Redash.
The best person to ask is likely @arikfr, who’ll probably read this message and hopefully respond anyway.
I’m not sure if Redash is the best tool for Case 1 at the moment. We’re working on capabilities to allow embedded analytics scenarios, but we’re not 100% there yet. But this also depends on what functionality you want to provide for your merchants.
Anyway, the open source code is licensed with a standard BSD license and there is nothing preventing you from commercial usage. No license fees are required.
Good luck,
Arik
1 Like
Login or sign up disabled while the site is in read only mode