As a minimalist, I really like the clear interface. But could you elaborate on why exactly you committed yourself to R? And am I able to use this tool productively without any background knowledge on R?
@zcei_ger Hey Stephan,
we chose to build the integration with R to provide additional expressivity for data transformations that are harder to do in SQL and very easy in R. One example would be adding a column of running totals, which is a little bit complicated in SQL while being a one-liner in R.
You can definitely use Cluvio without any background knowledge in R.
The use of R on SQL results is completely optional and reports can be build using only SQL.
Best,
Marius
Hey, I'm Marius, one of the founders of Cluvio.
Cluvio allows you to run SQL queries against your database, visualize the results as beautiful dashboards and share these dashboards within your company.
We have integrated an R engine in the pipeline, so you can run custom R script on the sql results to get combined power of SQL and R.
After working on Cluvio for 18 months, we launch today and would love to hear the feedback of the PH community.
@philipp_zentner
Hey Philipp,
good question!
The main advantages of Cluvio over accessing your database via the commandline are:
1. With the "Almanach" you can easily see the structure of your database with its tables, column and column types, while you are assembling the SQL query. No more 'SELECT * from USERS' just to get the exact name of a specific column. The almanach also suggests queries based on the structure of your database.
2. With one click you can download the results of a SQL query as a CSV file to further analyze it. No need to pipe into a tmp.csv file or do copy&paste.
3. Our custom grammar on top of SQL simplifies common expressions. For instance in Cluvio you can write '{created_at:week}', which would then automatically get translated to the correct syntax for your database, e.g. 'date_trunc('week', (created_at)::timestamp)::date' for Postgres.
4. Cluvio makes it very easy to visualize the results of the query by analyzing the structure of the results and intelligently recommending visualizations depending on it.
5. You can easily make SQL queries parametrized, which allows to configure them from the 'outside' and for instance select a specific timerange using our dashboard filters.
You can use Cluvio with AWS RDS with the following database engines:
- Amazon Aurora
- Postgres
- MySQL
- MariaDB
We also support AWS Redshift.
Best,
Marius
Cluvio
CryptoPixels
Cluvio
CryptoPixels
Cluvio