A DuckDB-based metabase alternative

piterrro an hour ago | parent | next [-]

In what extent this is a metabase alternative? I'm a heavy Metabase user and there's nothing to compare really in this product.

▲

written-beyond 2 hours ago | parent | prev | next [-]

This is really nice, specially the pdf report generation.

I feel very moronic making a dashboard for any products now. Enterprise customers prefer you integrate into their ERPs anyway.

I think we lost the plot as an industry, I've always advocated for having a read only database connection to be available for your customers to make their own visualisations. This should've been the standard 10 years ago and it's case is only stronger in this age of LLMs.

We get so involved with our products we forget that our customers are humans too. Nobody wants another account to manage or remember. Analytics and alerts should be push based, configurable reports should get auto generated and sent to your inbox, alerts should be pushed via notifications or emails and customers should have an option to build their own dashboard with something like this.

Sane defaults make sense but location matters just as much.

	▲	mitjam an hour ago \| parent \| next [-]
		1999-2000, the company I worked with gave a smallish number of key users full read rights to the SAP minus HR, briefly after introducing SAP to the global supply chain of that company. The key users came from all orgs using SAP, basically every department had one or two key users. I was part of this and "saw the light". We had such a great visibility into all the processes, it was unreal. It tremendously sped-up cross-org initiatives. Today, I guess, only agents get that privilege.
	▲	matsz 2 hours ago \| parent \| prev [-]
		> I've always advocated for having a read only database connection to be available for your customers to make their own visualisations. A layer on top of the database to account for auth/etc. would be necessary anyways. Could be achieved to some degree with views, but I'd prefer an approach where you choose the publicly available data explicitly. GraphQL almost delivered on that dream. Something more opinionated would've been much better, though.

▲

frafra an hour ago | parent | prev | next [-]

Metabase works great with DuckDB as well, thanks to metabase_duckdb_driver by MotherDuck.

▲

pdyc an hour ago | parent | prev | next [-]

interesting i am trying to build one too but rejected duckdb because of large size, i guess i will have to give in and use it at some point of time.

▲

andrewstuart 2 hours ago | parent | prev [-]

I wanted to love DuckDB but it was so crashy I had to give up.

▲

robowo 2 hours ago | parent [-]

I use it daily and it never crashed. How long ago was this? I am a big fan of DuckDB. Plow through hundrets of GB of logs on a 5 year old linux laptop - no problem.

	▲	pletnes 38 minutes ago \| parent [-]
		Same here. I have however seen a few out of memory cases in the past when given large input files.