evidence VS superset

Compare evidence vs superset and see what are their differences.

Our great sponsors
  • SurveyJS - Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
evidence superset
44 137
3,175 57,792
11.2% 2.4%
10.0 9.9
about 9 hours ago 5 days ago
JavaScript TypeScript
MIT License Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

evidence

Posts with mentions or reviews of evidence. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-03-11.
  • SQLPage – Building a full web application with nothing but SQL queries [video]
    5 projects | news.ycombinator.com | 11 Mar 2024
    If you are a data analyst interested in making web apps, I might point you to my own OSS project, Evidence, which is a Static Site Generator for building reports and data apps with SQL and markdown.

    Repo (3K stars): https://github.com/evidence-dev/evidence

    Previous discussions on HN:

    https://news.ycombinator.com/item?id=28304781 - 91 comments

    5 projects | news.ycombinator.com | 11 Mar 2024
    It’s interesting to me how far you have pushed the SQL language in this framework, such that it truly is “SQL only”.

    The challenge as I see it with enabling analysts to build websites is that you need to build abstractions to get from familiar (SQL, yaml) - the language of analytics, to new (HTML, CSS, JS) - the language of the web browser

    As one of the maintainers of Evidence (https://evidence.dev), one of the things I’ve often considered is how accessible our syntax is to analysts. Our syntax combines SQL and Markdown, with MDX style components e.g.

    The are inherently webdev-ey, and I do think they put off potential users.

    On the flip-side, by adhering to web standards, you get extensibility out of the box, and working out what to do is just a Google search away.

    Anyway, thanks for the thought provoking piece.

  • Blazer: Business Intelligence Made Simple
    4 projects | news.ycombinator.com | 27 Feb 2024
    Dataclips was my first experiences writing SQL.

    Writing code was a markedly better DX that building dashboards in Tableau, which is why I'm now working on https://evidence.dev - a SSG for creating data from SQL and markdown

    Previous HN discussions:

  • Is Tableau Dead?
    3 projects | news.ycombinator.com | 26 Feb 2024
    I'm one of the founders of Evidence (https://evidence.dev) - would be great to hear about your experience. Reaching out now!
  • Apache Superset
    14 projects | news.ycombinator.com | 26 Feb 2024
    Full fledged BI tools like Superset and Metabase are amazing for their intended use cases.

    But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. so if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be very useful for latter kind of use cases are SQLPage and Evidence.

    They make it very convenient to whip out some SQL and convert that to a neat professional looking web ui that can be forwarded to an end user. In case of Evidence it is a statically generated site, and in case of SQLPage it is a web app that connects to a live database.

    SQLPage: https://sql.ophir.dev/

    Evidence: https://evidence.dev

    14 projects | news.ycombinator.com | 26 Feb 2024
    We use ECharts in our open source BI tool (Evidence) and it's a great library. Has helped us build a declarative syntax for viz which can be version controlled (https://evidence.dev)
  • A love letter to Apache Echarts
    6 projects | news.ycombinator.com | 18 Feb 2024
    We used ECharts to build our charting library at Evidence and it’s been a great experience overall (https://evidence.dev).

    We started with D3 and a few other tools, but felt that we get a lot more out of the box with ECharts, like interactivity and an events API. ECharts is also a lot more extensible than people give it credit for.

    If anyone is curious, we documented the process of selecting a charting library after assessing several options: https://github.com/evidence-dev/evidence/issues/136

  • Observable 2.0, a static site generator for data apps
    17 projects | news.ycombinator.com | 15 Feb 2024
    The new direction seems very similar to what evidence has been doing for a while

    https://evidence.dev

  • PRQL as a DuckDB Extension
    3 projects | news.ycombinator.com | 25 Jan 2024
    I'm quite excited about this, and would also love to have it distributed as an NPM package.

    I work on an OSS web framework for reporting/ decision support applications (https://github.com/evidence-dev/evidence), and we use WASM duckDB as our query engine. Several folks have asked for PRQL support, and this looks like it could be a pretty seamless way to add it.

  • Nota is a language for writing documents, like academic papers and blog posts
    14 projects | news.ycombinator.com | 19 Oct 2023
    > Not sure the language you choose matters as much as making the API usable by a wide audience.

    Fully agree with this, and having typeset my masters thesis and later my resume using LaTeX, I think that the “authoring experience” is 100% the place to focus on improving.

    If you’re interested in the “markup to document publishing” space, you might also be interested in the open-source report publishing tool I’m now working on, Evidence (https://github.com/evidence-dev/evidence)

    It’s similarly based on markdown, though uses code fences to execute code, HTML style tags for charts and components, and {…} for JavaScript, i.e.

    ---

superset

Posts with mentions or reviews of superset. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-26.
  • Apache Superset
    14 projects | news.ycombinator.com | 26 Feb 2024
    Had a very good experience with Superset.

    Superset allowed us to replace Tableau and not looking back

    Took me a while figure out how to embed it into my app using Superset Embedded SDK.

    Superset Embedded SDK - "Embedded SDK allows you to embed dashboards from Superset into your own app, using your app's authentication. Embedding is done by inserting an iframe, containing a Superset page, into the host application."

    https://github.com/apache/superset/tree/master/superset-embe...

    Superset is based on very high quality and well maintained chart library eChart

    https://echarts.apache.org/examples/en/#chart-type-linesG

    Community Roadmap

    https://github.com/apache/superset/projects?query=is%3Aopen

    Huge respect to Preset.io and its team for contributing to the project and keep it in a great shape

    https://preset.io/blog/

    Superset source code is very easy to read and understand, and as a result it's possible to implement some advanced caching techniques reduce the load on charts.

    No BI is perfect.

    Watching Superset for years gives me confidence the project will work as supposed down the road, and eventually some of its packages can be reusable for all kind of visualizations and data hacking.

    14 projects | news.ycombinator.com | 26 Feb 2024
    Superset is absolutely phenomenal. I really hope Microsoft eventually releases all of their customizations they made to it internally to the OS community someday.

    https://www.youtube.com/watch?v=RY0SSvSUkMA

    https://github.com/apache/superset/discussions/20094

    14 projects | news.ycombinator.com | 26 Feb 2024
  • A modern data stack for startups
    2 projects | news.ycombinator.com | 30 Dec 2023
    Do you have any thoughts on Superset? Did you consider it as a candidate?

    For anyone who doesn't know: https://superset.apache.org/

    (There's at least one service that offers managed Superset hosting if that's what you're looking for; it's easy to find so I won't link it here.)

    2 projects | news.ycombinator.com | 30 Dec 2023
    I recently ran a little shootout between Superset, Metabase, and Lightdash. All have nontrivial weaknesses but I ended up picking Lightdash.

    Superset the best of them at _data visualization_ but I honestly found it almost useless for self-serve _BI_ by business users. This issue on how to do joins in Superset (with stalebot making a mess XD) is everything difficult about Superset for BI in a nutshell. https://github.com/apache/superset/issues/8645

    Metabase is pretty great and it's definitely the right choice for a startup looking to get low cost BI set up. It still has a very table centric view, but feels built for _BI_ rather than visualization alone.

    Lightdash has significant warts (YAML, pivoting being done in the frontend, no symmetric aggregates) but the Looker inspiration is obvious and it makes it easy to present _groups of tables_ to business users ready to rock. I liked Looker before Google acquired it. My business users are comfortable with star and snowflake schemas (not that they know those words) and it was easy to drop Lightdash on top of our existing data warehouse.

  • FLaNK Stack Weekly for 20 Nov 2023
    37 projects | dev.to | 20 Nov 2023
  • Yandex open sourced it's BI tool DataLens
    4 projects | news.ycombinator.com | 26 Sep 2023
    Or like not being able to delete a user without running some SQL:

    https://github.com/apache/superset/issues/13345

    Almostl instantly run into this issue setting up a test instance of Superset. And the issue has been around for years.

  • Apache Superset: Installing locally is easy using the makefile
    3 projects | dev.to | 20 Aug 2023
    Are you interested in trying out Superset, but you're intimidated by the local setup process? Worry not! Superset needs some initial setup to install locally, but I've got a streamlined way to get started - using the makefile! This file contains a set of scripts to simplify the setup process.
  • More public SQL-queryable databases?
    3 projects | /r/datasets | 10 Jul 2023
    Recently I discovered BigQuery public datasets - just over 200 datasets available for directly querying via SQL. I think this is a great thing! I can connect these direct to an analytics platform (we use Apache Superset which uses Python SQLAlchemy under the hood) for example and just start dashboarding.
  • Real-time data analytics with Apache Superset, Redpanda, and RisingWave
    3 projects | dev.to | 20 May 2023
    In today's fast-paced data-driven world, organizations must analyze data in real-time to make timely and informed decisions. Real-time data analytics enables businesses to gain valuable insights, respond to real-time events, and stay ahead of the competition. Also, the analytics engine must be capable of running analytical queries and returning results in real-time. In this article, we will explore how you can build a real-time data analytics solution using the open-source tools Redpanda a distributed streaming platform, Apache Superset, a data visualization, and a business intelligence platform, combined with RisingWave a streaming database.

What are some alternatives?

When comparing evidence and superset you can also consider the following projects:

streamlit - Streamlit — A faster way to build and share data apps.

jupyter-dash - OBSOLETE - Dash v2.11+ has Jupyter support built in!

Apache Hive - Apache Hive

lightdash - Open source BI for teams that move fast ⚡️

Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

django-project-template - The Django project template I use, for installation with django-admin.

react-admin - A frontend Framework for building data-driven applications running on top of REST/GraphQL APIs, using TypeScript, React and Material Design

nifi - Apache NiFi

Baserow - Open source no-code database and Airtable alternative. Create your own online database without technical experience. Performant with high volumes of data, can be self hosted and supports plugins

Airflow - Apache Airflow - A platform to programmatically author, schedule, and monitor workflows

appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.

dagster - An orchestration platform for the development, production, and observation of data assets.