Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

news.ycombinator.com

Post reply on HN
Print view View original

41–50 of 94 posts

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

#42

Post by rhacker »

soheil wrote: post #41

Pretty interesting idea. Can someone edit the page and change one of the queries to drop table bobby

A fix for that would be to process the query in something like spark's interpreter as a middle man, which doesn't allow things like that and is query only.

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

#44

Post by amcaskill »

soheil wrote: post #41

Pretty interesting idea. Can someone edit the page and change one of the queries to drop table bobby

Haha

In production, queries only run at 'build time', and we bake out static outputs to serve to your users. We mainly do this for performance reasons, but there isn't a connection to your db in the production outputs.

Today, you might be able to issue a drop table command from the local dev server though, and we really should make sure there are guard rails for that...

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

#45

Post by amcaskill »

thejosh wrote: post #43

This is exactly what I have wanted to build, changing into a data engineer build. Well done, excited to keep an eye on it.

Thank you! We have actually heard this from quite a few people. We now know of at least four companies that have at one point or another built their reporting systems in a similar way.

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

#48

Post by amcaskill »

41b696ef1113 wrote: post #46

Anyway to reference a .sql script from elsewhere in the project?

We haven't set that up, but it's a good idea. It really would help w/ modularity to have re-usable scripts parked somewhere in your project. I've opened an issue to track this.
Post reply on HN