Live data from Hacker News

Launch HN: Evidence (YC S21) – Web framework for data analysts

news.ycombinator.com

71–80 of 94 posts

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#71

I have been doing this in emacs org mode for years i.e. reading from database and plotting the results along with documentation in single org file which is version controlled using git, how is this different? I can also export to html and share with others. something like this #+begin_src emacs-lisp (require 'ob-sqlite) #+end_src #+RESULTS: : ob-sqlite * Headline 1 * Headline 2 #+begin_src sqlite :db users.db :colnam…

A lot of people have told us that they have done some flavour of this. We think that’s a good thing!

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#74

Very cool! I would like to see an option to make a copy of the analyzed data and/or a hash value for it.

There's a discussion earlier in the thread about static vs. live data. I think there are some interesting things we could do here. There are also some other great products doing data diffing, like datafold that might fit the bill here.

Just to give you a bit of background on my request I work in banking and specifically validating models. We generate a lot of paperwork for the tests we perform on the models for the regulators.

Being the results of the test reproducible is a pretty neat feature that's why having a way to store the analyzed data in a standard way would be good, if the data is too big and for some situations at least having a way to check that the data has not change could be enough, that's why the hash.

Finally, this is a problem being tackled now in my area and I have seen 4 or 5 big companies demoing solutions to solve the problem.

Thanks and good luck!

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#75

Will check back again when MS SQL is supported.

AFAIK its rather far off from Postgres syntax, or certainly has a lot of different functions at least. It may be a while, given cultural differences.

I'm rather surprised they're not using something like knex here, which would make psql + mssql + mysql etc available fairly out of the box, but I'm sure there's a good technical reason they're not.

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#77
post #25

Would you be interested in using https://redbean.dev to enhance your product? It's really nice for building web apps that handle sensitive data since you can put redbean with your CSVs or SQLite database on something like an Iron Key and anyone you share it with will be able to use your app and view the reports in a purely offline manner on any o/s. If your app is built on Node it's got an unwieldy amount of dependen…

Redbean seems pretty ingenious, albeit totally over my head. I will take a more detailed look when I have some time. Thanks for sharing!

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#78
post #16

> In our experience, the BI layer is the weakest part of the modern data stack. The BI layer has a poor developer experience, and decision makers don’t really like the outputs they get Totally agree, very interested in trying this out. FWIW I've tried and been frustrated by Looker, Metabase, PowerBI, Superset, Redash. I do think that while dbt does a great job with dimensional modelling, the BI layer is still require…

You have cut straight to the heart of a pretty interesting problem that we are still thinking through. You are exactly right, right now this is pure front-end. That's intentional, and there's a lot that we like about that approach, especially in light of the success of dbt. We think dbt fundamentally changes what is needed from a BI tool and that vendors who are maintaining really heavy built-in data transformation l…

Have you looked at umetric from Uber? Does that serve the purpose?

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#79
post #36

Earlier quoted context omitted.

You have cut straight to the heart of a pretty interesting problem that we are still thinking through. You are exactly right, right now this is pure front-end. That's intentional, and there's a lot that we like about that approach, especially in light of the success of dbt. We think dbt fundamentally changes what is needed from a BI tool and that vendors who are maintaining really heavy built-in data transformation l…

I believe that we’re working on a similar product that you described. Our metrics layer, metriql, extends dbt for metrics definitions and provides an open-source CLI that serves your metrics to the data tools. We have REST API and use Trino protocol so in case you support Trino (formerly Presto) you already support metriql. :) Here is the link: https://metriql.com

Thanks for posting! Is metriql entirely open source, or just the CLI? How do you plan to make revenue?

Re: Launch HN: Evidence (YC S21) – Web framework for data analysts

#80

Earlier quoted context omitted.

You have cut straight to the heart of a pretty interesting problem that we are still thinking through. You are exactly right, right now this is pure front-end. That's intentional, and there's a lot that we like about that approach, especially in light of the success of dbt. We think dbt fundamentally changes what is needed from a BI tool and that vendors who are maintaining really heavy built-in data transformation l…

Have you looked at umetric from Uber? Does that serve the purpose?

Just checked it out briefly, that looks like it's aiming to solve the same problem -- do you know if it's open source?
Post reply on HN