App to easily query, script, and visualize data from every database, file, and API.
Source code for the DataStation documentation site
Hey folks! I quit my job at Oracle almost a year ago now to build DataStation. It's an app I've wanted as an engineering manager for years now.
DataStation helps you query a variety of data sources (conventional SQL like PostgreSQL and MySQL, non-SQL like Prometheus or Elasticsearch), files and HTTP APIs. It is not a SQL layer on top of these various APIs like FDW in Postgres or Apache Calcite. For Prometheus you query with PromQL. For Elasticsearch you query with Lucene. And for SQL databases you query with their SQL dialect.
DataStation is made of panels (other apps might call them cells) that each produce a result. Panels can refer to other panels. These allow you to build workflows that cross the boundary of a particular datasource. For example you might have some data in a CSV a product manager gave you and the bulk of your data is in PostgreSQL. DataStation helps you pull together these data sets and script them.
DataStation is mainly a desktop app today where the end result is that you export graph SVGS or HTML tables or markdown tables or just a CSV file. All this data stays on your laptop so it's as easy to use in a corporate environment as any existing SQL IDE or Jupyter Notebook.
In the last year it's reached 1.5k stars on Github, over 1000 unique users and currently on-average about 40 fairly active users per month (defined as having opened the app more than a few times).
DataStation is primarily an Electron app but the code that evaluates panels is written in Go.
You can find a ton of tutorials on how to interact with supported databases on the DataStation website: https://datastation.multiprocess.io/docs/.
Looking forward to your feedback!
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
How does it compare to Redash (now Databricks SQL): https://github.com/getredash/redash?
🍟 a notebook sql client. what you get when have a lot of sequels.
I love the idea of a data notebook. Have you seen Franchise? It's a lovely design for something similar, though its implementation (which stopped in 2019) didn't go beyond querying and visualization, rather than manipulation. But the stying and component design are lovely, and it may be possible to pull that from their code. https://github.com/HVF/franchise
How to program an appealing data visualization, that automatically synchronizes itself? (Picture in comments)
1 project | reddit.com/r/learnprogramming | 1 Sep 2022
Querying RDS with visible results for monitoring purposes?
1 project | reddit.com/r/aws | 15 Aug 2022
Is Redash dead? The red arrow indicates when Databricks acquired Redash
2 projects | reddit.com/r/dataengineering | 4 Aug 2022
Redash - Make your company data driven
1 project | reddit.com/r/github_trends | 21 May 2022
Open source DW?
1 project | reddit.com/r/dataengineering | 3 Jan 2022