Hacker Newsnew | past | comments | ask | show | jobs | submit | dacort's commentslogin

Metabase 47 also has new serialization features in paid editions that allow for git-based workflows. https://www.metabase.com/learn/administration/git-based-work...


A while ago I wrote an Athena connector for querying SQLite in S3. ;) https://github.com/dacort/athena-sqlite Uses a similar approach.


SQLite is amazingly prevalent as well. Your own phone probably has hundreds of SQLite databases on it. One challenge with SQLite, though, is you have to download the whole thing to make use of it.

Shameless plug, but I made a fun side project that allows Amazon Athena to read SQLite databases from S3. https://github.com/dacort/athena-sqlite


As part of a fun side project to make a SQLite driver for Athena, I made a read-only storage driver for S3.

https://github.com/dacort/athena-sqlite/blob/master/lambda-f...

Implemented the VFS side in Python, thanks to the awesome apsw library.


Yea, my guess would be that's it. Coupled with the fact it hasn't been updated in ~3 years.

I've giving this one a shot, might have too much functionality for me though...I liked how bare-bones the other one was. https://chrome.google.com/webstore/detail/json-viewer/gbmdgp...


I also like bare-bones stuff, and I am currently evaluating this https://chrome.google.com/webstore/detail/json-formatter/bcj... that is fast, easy on the eye and minimal. Haven't reviewed the code tho.


Giving that one a try too. Thanks for the link.


Reminds me of the (sadly) now defunct choir.io. Intro post > https://corte.si/posts/choir/intro/choir.html

They had a demo of Github realtime activity and I hooked it into a bunch of different events around the org - Salesforce/Yammer/Github/JIRA - was neat to have a "pulse" of daily activity in the background.


It's one of the largest ferry systems in the world.

Per https://en.wikipedia.org/wiki/Washington_State_Ferries

> The agency maintains the largest fleet of ferries in the United States at 22 vessels, carrying 23 million passengers in 2014. As of 2014 , it was the largest ferry operator in the United States, and the fourth-largest ferry system in the world.


At what level, company size, and cash/equity split?

I'm co-founder of a local startup here w/~140 people and that's pretty comparable/above average to what I've seen depending on the cash/equity split. The big co's (Facebook, Amazon, Google, Twitter, et. al) will be higher than average due to the nature of how hard it is to hire good folks here.

Seattle is fantastic for people that enjoy the outdoors - hiking, backpacking, rock climbing, ski/snowboarding, camping. The closest ski/snow area is 45 minutes from the city. It doesn't get _too_ cold in Seattle proper - usually around 40° F. The nice thing is that you have the mountains nearby, so if you do want the cold weather it's a quick trip.

One word of caution around UW - your age is definitely on the higher end of other people that will be living in that area. Although the rents are cheap, that's usually for a reason. Reddit is a great resource for info on moving to Seattle --> https://www.reddit.com/r/Seattle/wiki/index


Second this recommendation. Very easy to get up and running - may not be able to handle some complex use cases, but for the basics it's fantastic.


It must have come very far in the past few months then...based on my experimentation, it was far from being ready for production use if you needed anything beyond the most basic of SQL queries. That said, I'm rooting for it (and now, caravel). We use Pentaho, and it's....meh. A lot of moving parts, a big learning curve, and a user experience that's just ok. I'm hoping Metabase (and now Caravel) will both succeed...the open source BI space could really use an influx of simpler, beautiful tools.

A side note: I love that Caravel is written in Python. Metabase switched from Python to Clojure, and I personally believe that to be a barrier to entry for contributing. I've started down the Clojure path a number of times only to stop because I see it as something which would be difficult to impose on my team...Lisp is just so different from what most enterprisey development teams are used to. Python, on the other hand, is easier to justify. I've found things I wanted to help fix in Metabase, but having to learn idiomatic Clojure just to submit a patch is a turn-off.


Hey, Sameer from the Metabase team.

If you don't mind, I'd love to hear why you felt we were far from being ready for production.

Our main challenge has trading off ease of installation and use with the inevitable feature creep that causes the lots of moving parts and learning curve you find meh about Pentaho. You're right in that we've focused on making the most basic of sql queries (via our non-sql tool) usable by anyone in the company on their own vs essentially producing an analytics SDK like Pentaho/Jaspersoft.

On the language front, we made a conscious decision to optimize for ease of installation and low maintenance overhead. While I agree, it's made contributing less accessible, it's been amazing how porting has made Metabase more stable and easier to install. We run a bunch of instances for people, and our ops footprint has been silly small.


I'd love to...but I can't recall the password I used when I set up the h2 db my attempts are stored in and smtp password recovery isn't working (I probably didn't configure it).

If I recall, it was difficult to understand how to properly format the results of a raw sql query to graph. Also, even once properly graphing, saving the graph to a dashboard wouldn't scale properly and would render in a very jumbled manner. Perhaps these issues have been fixed with newer versions....I'll give it another look next week.


Would very much appreciate that as well as walk-through docs.

Got it up and running easily enough, and connected to Redshift. But seemed like creating a new "slice" required custom JSON params to define it. Unless I missed something?

edit: yep, missed something. Can "explore" a table by clicking it's link in the table listing.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: