Live data from Hacker News

Blazer: Business intelligence made simple

github.com

31–39 of 39 posts

Re: Blazer: Business intelligence made simple

#31
post #20

Earlier quoted context omitted.

How are those 500+ data source connectors are implemented? Do you use 3rd party APIs? Im always curious about that.

Great question. We're using Meltano ( https://hub.meltano.com/extractors ), so no third party (we host the meltano jobs on our infra for you).

Wow wasn't aware of such connectors exist. Thought you must pay for something like that. CDATA (https://www.cdata.com/connect/connectors/) charges a fortune for connectors.

Re: Blazer: Business intelligence made simple

#34
post #2

It's open-source Heroku Dataclips (one of my favorite products ever)! I haven't used Blazer, but I have followed and love the idea behind this project. If folks have used it here, I'd love to hear from them.

Love the callout to Dataclips. It was easily my favorite least used feature by Heroku customers. Blazer and PgHero both got a bunch of inspiration from some of the early things we built at Heroku and its amazing having Andrew crank out so many high quality projects to make some of the tooling more broadly available.

Re: Blazer: Business intelligence made simple

#35
post #2

It's open-source Heroku Dataclips (one of my favorite products ever)! I haven't used Blazer, but I have followed and love the idea behind this project. If folks have used it here, I'd love to hear from them.

I've used it before, it's great to start, but here's what happened to me: 1. Connected it to my production postgres (which was fine when I didn't have many users) 2. Spun up a replica postgres on GCP to connect it to instead 3. I wanted Stripe and CRM data in the reports, but I can't sync those to the replica and I didn't want to load them to prod 4. Signed up for Snowflake ($$$) and set up Fivetran ($$$) to sync all…

Can it handle loading data from let's say 100 pg databases (of the same schema but different tenants) and query them as if all the data was in a single database?

I think that's my main issue with tools like this.

Re: Blazer: Business intelligence made simple

#37
post #32

Since it consumes user defined SQL directly, how secure is it from SQL injections?

I did some digging for you, I am not the best at Rails but from my understanding, it seems to throw the queries into ActiveRecords QueryAttribute using bind parameters [1]. So I'd say enough safe from sqli [2].

[1] https://github.com/ankane/blazer/blob/bd06aab33052783e84672b...

[2] https://blog.saeloun.com/2019/10/28/bind-parameters-in-activ...

Re: Blazer: Business intelligence made simple

#38
post #16

This looks super cool. One thing that stands out as missing (or I am missing it) -- does anyone know if there's a way to drill into the data and see the raw tabular data behind a given chart? That's one feature Metabase has that I find essential -- if a number in a chart looks off (or you're just curious) you can drill into the row-level tabular data and figure out what's going on.

This might be a dirty solution but you can just open a rails console in the app to see the raw tabular data.

Re: Blazer: Business intelligence made simple

#39
Blazer is amazing, and we use it every day all day at my startup. Huge thanks to akane.

However, I’ve contributed a couple of PRs and heard crickets. Doesn’t seem as if the repo is maintained actively these days, so we run a modified fork internally.

Post reply on HN