144 karma · joined June 23, 2020
https://bsky.app/profile/totalhack.bsky.social
I've bootstrapped and sold two startups, first time with 5 (!) equal cofounders and second time with 3. I've learned a lot along the way, obviously some of that through mistakes of my own. Have my cofounders been perfect? Heck no -- one lacks the same level of drive, the other is less trustworthy (always multiple irons in the fire kinda guy). But we all have strengths, are all generally better off together, and have the combined skill set to run super lean. Even if you think you can do some things better alone, you can never do it all, and that grind will take quite a toll.
Related: over the years the topic of going into business with some of my best friends has come up, and I always say I would never do that. Running a fast-moving, high stakes business with multiple founders involves a lot of tough conversations and occasional relationship strain. My business partners are business partners first, friends second, and I think that's important to consider if you really value a friendship.
The air or an mb pro seems so nice until I remember the sting of dealing with the dev environment and docker on a Mac compared to Linux. No amount of battery life or marginal jump in performance (which gets lost through needed virtualization) will make up for that for me.
Some comments on this thread mention popular semantic layer tools like cube.dev. I also made an open source one that I use regularly, though it's currently in I-hope-to-put-more-time-into-this-someday mode. Been busy with an acquisition this year.
I bet the desktop is interesting, but first I was in a 30m waiting room to access their website (what?!?) and then the button to pre order the desktop is broken. Ouch.
Just bought an HP omnibook flip with an Intel 258v. From what I've read I expect most things to work, or work soon with kernel updates. All applications I care about work well. Would be nice to see OpenAI make a desktop app for Linux, or some other open source equivalent.
I have nothing against SQL of course. The simplified approach of a UI built on top of zillion or tools like it really enables a whole next level of productivity for business users that are never going to learn SQL, but also need more query flexibility than just "dashboards" without having to wait on a BI team for answers -- I die inside a little bit every time I hear of a company doing this. And as you have noted, I also think text-to-semantic-layer is an interesting approach for involving AI/NLP.
I've been pulled away from this project for some time due to an acquisition at my day job but hoping to get back into it soon!
https://github.com/totalhack/zillion
Disclaimer: been sidetracked by an acquisition at my day job this year, intend to put more time into this project soon, but I use it in production to great effect.
Many years later I heard they were still relying on that tool!
It first runs one or more queries against your DataSources in a drill-across query fashion. You can think of DataSources as one or more completely separate databases. You could have one mysql, one postgresql, one duckdb etc all in the same Warehouse (not saying this is common in production, just an example). Within those DataSource queries it's also joining all needed tables together for you, i.e. joining multiple tables in each database to meet your required grain.
It then takes the results of all those queries and combines that data in another layer which is currently an in-memory sqlite database. The purpose of that layer is joining the data for presentation as well as applying some additional features like rollups, technicals, formula fields, etc.
I'm not familiar with what superset does under the hood or exposes as an API so I don't know how to compare it, if there is some similar backend piece. But I suspect no part of superset is quite the same as this, based on what its front end can do.
Happy to answer any other questions you have.
I built my own semantic layer instead. I use this in production in my company but obviously use at your own risk as it's a one-man show.