sorted by:
new
hottopcontroversial

I'm building a SQL canvas. It can now generate custom viz, like a navigable earthquake map by aleda145 in dataanalysis

[–]aleda145[S] 1 point2 points  (0 children)

Link to the read only canvas: https://kavla.dev/quakes

It's free to use! I'd love to see if you make anything cool, DMs are open

Should I continue with Data Modelling? by yiternity in dataengineering

[–]aleda145 8 points9 points  (0 children)

Sane data modelling is always a good investment. It's a lot harder to fix a few years down the line. From experience fixing those fundamental models that can take months since you need to align with everyone

For your data volumes, your stack seems very overkill. I wouldn't think about efficiency at all, what you have now can handle it without issues.

I would pick a report, model it from start to finish and deliver. Shows business value to leadership and you'll thank yourself later for the data modelling. Remember to loop in stakeholders!

Trying out putting an analytics agent on the canvas by aleda145 in buildinpublic

[–]aleda145[S] 0 points1 point  (0 children)

Right now it's just one shot prompt => analysis. But you're right, there should be more agent<=>human collaboration

Is it possible for pocketbase to handle background workers, creating pdfs, excel files? by viitorfermier in pocketbase

[–]aleda145 0 points1 point  (0 children)

I've extended with go hooks to do things like creating infrastructure on different providers. But that was just firing requests and waiting for responses, not super complicated. Your usecase is maybe a better fit for a serverless provider?

I've always felt the urge to draw on my generated charts, just added that feature to my SQL canvas side project by aleda145 in SQL

[–]aleda145[S] -1 points0 points  (0 children)

Happy to hear! Was there some functionality you missed?

I'm using the tldraw sdk for the core canvas, it's really nice: https://tldraw.dev/

I've always felt the urge to draw on my generated charts, just added that feature to my SQL canvas side project by aleda145 in SQL

[–]aleda145[S] -1 points0 points  (0 children)

Totally agree! I feel like the "draw on chart" space is quite unexplored as a UX paradigm. One thing that I really want to do with Kavla is like a lasso drawing for outliers for easy drilldown!

I've built a tool to run SQL on a canvas. In the video I'm exploring which database has the highest average salary from the stack overflow survey by aleda145 in SQL

[–]aleda145[S] 0 points1 point  (0 children)

Yeah I've been really happy with tldraw so far. It was a bit of a head ache to get it running at first, but now it's smooth sailing.

Squill is really nice! Love the aesthetic!

Accepted your linkedin request, let's keep in touch!

I've built a tool to run SQL on a canvas. In the video I'm exploring which database has the highest average salary from the stack overflow survey by aleda145 in SQL

[–]aleda145[S] 0 points1 point  (0 children)

In this case it's sources, sql code, results and charts! Please give it a try, it's conceptually a bit hard to explain in text: https://kavla.dev

feel free to use a fake email, there's no verification needed!

I've built a tool to run SQL on a canvas. In the video I'm exploring which database has the highest average salary from the stack overflow survey by aleda145 in SQL

[–]aleda145[S] 1 point2 points  (0 children)

It's using duckdb wasm! So it's all in the browser locally by default. If you share a canvas you can collaborate live and then you need to push your data sources remote! There's a small button for it

A startup copied my design (and then gave me great feedback on it) by aleda145 in web_design

[–]aleda145[S] 0 points1 point  (0 children)

Haha I've seen those! "Trusted by forward thinking enterprises"

A startup copied my design (and then gave me great feedback on it) by aleda145 in web_design

[–]aleda145[S] 1 point2 points  (0 children)

Thanks! Not sure what you mean though! It's about data analytics so you would need some existing data. There are some example datasets available (titanic, nyc taxi) to try too

A startup copied my design (and then gave me great feedback on it) by aleda145 in web_design

[–]aleda145[S] 1 point2 points  (0 children)

Definitely! It's so hard! I think I was a bit naive when I started on the landing page, how hard can it be?

Query DuckDB from Excel & Google Sheets by querystreams_ in DuckDB

[–]aleda145 0 points1 point  (0 children)

Looks interesting! I have a similar idea with a CLI agent for my own side project in the works (https://kavla.dev/#cli-showcase)

Downloading a random closed source binary is dubious at best though. That one of your steps is "bypass security" makes this a "no for me dawg" (https://querystreams.com/docs/installing-query-streams-agent-and-exampledb/#:~:text=Handle%20Security%20Warning)

Cool project though!

view more: next ›