| ▲ | aleda145 a day ago |
| https://kavla.dev/ It's an infinite canvas that runs SQL. I've been working with data my entire career. I feel like we need to alt+tab so much. What if we just put it all on a canvas? Currently very WIP, but there's a simple titanic demo available! Built with tldraw and duckdb wasm, running on cloudflare durable objects |
|
| ▲ | mjaniczek a day ago | parent | next [-] |
| Look at count.co for a Figma-like approach to databases. We were using it at work (transitioning to Metabase); it's great for exploring and debugging and prototyping but it ends up too much of a tangled spaghetti mess for anything long-term. Would not recommend for user-/other-company-departments-facing reports or dashboards. |
| |
| ▲ | aleda145 21 hours ago | parent [-] | | That's super interesting! With Kavla I want to lean into the exploring/debugging phase for analytics. "Embrace the mess", in a way. My vision is that there will be an "export to dbt" button when you're ready to standardize a dashboard. What made you pick count?
Was spaghetti the major reason you left count, or something else? | | |
| ▲ | mjaniczek 15 hours ago | parent [-] | | The choice to use Count was made before I joined the company; IIRC they migrated to it from Tableau. We wanted to migrate (to Streamlit, back then) to have the SQL not live locked in a tool, but inside our git repository; to be able to run tests on the logic etc. But the spaghetti mess was felt too, even if it wasn't the main reason to switch. (But then, 1) some team changes happened that pushed us towards Metabase, and 2) we found that Streamlit managed by Snowflake is quite costly, compute-time wise. (The compute server that starts when you open a Streamlit report, stays live for tens of minutes, which was unexpected to us.) ---- Export to DBT sounds great. Count has "export to SQL" which walks the graph of the cell dependencies and collects them into a CTE. I can imagine there being a way to export into a ZIP of SQL+YML files, with one SQL file per cell. | | |
| ▲ | aleda145 12 hours ago | parent [-] | | Thank you so much for sharing, super helpful! Great take on the SQL lock in, that's something that I need to think hard about. Ideally a git integration maybe? Kavla also traverses the DAG, psuedo code: deps = getDeps() // recursive
for dep in deps:
if dep is query:
run: "CREAT OR REPLACE VIEW {upstream} AS {upstream.text}
if dep is source:
done
A selected chain of Kavla nodes could probably be turned into a single dbt model using CTEs!Thanks for making me think about this! |
|
|
|
|
| ▲ | p2hari 18 hours ago | parent | prev | next [-] |
| Somehow i had landed on your page sometime back and was just impressed with the quality of landing page and also the concept. Hope to use it in near time. |
|
| ▲ | wkhughes 16 hours ago | parent | prev | next [-] |
| The website is great and the examples (like getting distinct values of a table as a prerequisite investigation) really get the point across. In my job I always end up with big notebooks of data exploration that get messy fast and are hard to share anything but the final result, having a canvas that embraces the non-linear nature is a great idea. |
| |
| ▲ | aleda145 11 hours ago | parent [-] | | That has been my experience as well! Aside from the non-linearity, what key features would make you use Kavla instead of a notebook? |
|
|
| ▲ | potamic 15 hours ago | parent | prev | next [-] |
| Love the brutalist style. Are the components all hand-rolled or something off the shelf? |
| |
|
| ▲ | schnebbau 17 hours ago | parent | prev | next [-] |
| Cool looking website! Is that an open source css library or did you style it yourself? |
| |
|
| ▲ | boredemployee a day ago | parent | prev | next [-] |
| it's so useful, specially to teach SQL, congrats, keep doing it! |
|
| ▲ | hafley66 a day ago | parent | prev | next [-] |
| as someone who loves sql and wants to transition into a DBA specialty from being more frontend, I am very inspired by this |
| |
| ▲ | aleda145 21 hours ago | parent [-] | | Thank you! What resource(s) are you using for learning SQL and DBA concepts? I haven't really thought about Kavla as being a learning environment, maybe you are onto something! |
|
|
| ▲ | DetroitThrow 12 hours ago | parent | prev [-] |
| Wow, this seems great for doing interviews with an analyst, or just demoing data generally. Cool product! |
| |
| ▲ | aleda145 12 hours ago | parent [-] | | Interviewing is an interesting use case! Is that something you're doing? What pain points do you have as interviewer with existing tools? |
|
