What's cool is not only this new feature itself, but that I didn't built it:
You can now download @taleshape.bsky.social tables directly as CSV.
Last week Shaper got attention on HN and now people start to actively contributing and making it better for everyone. That's why Shaper is open source 💙
They often download charts to add to presentation or report.
Now the charts automatically credit where the data came from, a win-win for everyone.
This is what Shaper is all about: Integrating data visualizations into your and your customers' workflows.
@taleshape.bsky.social now has "watermarks" for chart download to make it easy for your customers to credit you.
One of the companies I work with integrated Shaper into their product. And now their customers use various dashboards regularly as part of their daily work.
1/2
thanks! let me know if I can help with any input!
Nice newsletter!
Shaper - the viz+dashboarding tool I am building on top of duckdb just got some attention on HN yesterday. Great to see so much interest around DuckDB out there. Let me know if that's something you would be interested in sharing in some form.
news.ycombinator.com/item?id=4705...
Got curious why there is a sudden spike in github stars and turns out someone posted @taleshape.bsky.social on HN:
news.ycombinator.com/item?id=4705...
I couldn't imagine a better fit than DuckDB for @taleshape.bsky.social:
Shaper is all about using SQL to build data visualizations and sharing them.
There are many databases, but DuckDB and its powerful extension system allow Shaper to query many different data sources, all from a single binary.
I sometimes forget that @taleshape.bsky.social supports dark mode:
Hi Simon, just finished this post of yours and wanted to say thank you for sharing! I was always curious what draws so many smart, rational people to religion. And I feel like I understand it more now thanks to you sharing your thought process. I feel like I will be back and reread :)
@taleshape.bsky.social is open source for one reason:
I am building the tool I wish I had.
I don't want to keep user data in-house and not bother with regulations.
And I never want to worry about integrating analytics too deeply into our product because the vendor might some day raise prices.
Have you seen @taleshape.bsky.social's file-based workflow?
Use your favorite text editor to build dashboards all in SQL!
Easier to show than explain. Here is short demo video:
www.youtube.com/watch?v=HHYv...
(also: my first youtube video! will keep practicing 🙏)
I am launching @taleshape.bsky.social on @peerlist.bsky.social this week.
Appreciate any upvotes and comments 🙏
peerlist.io/jorin/projec...
#buildinpublic
I will be speaking at FOSSASIA this year to show how to quickly visualize data entirely in SQL using Shaper and DuckDB!
I had a great time as participant last year:
Great energy and many interesting conversations about what everyone is building in open source - in Asia and around the globe.
Demo Board:
demo.taleshape.com/view/v7x0870...
SQL Code:
taleshape.com/code-feature...
Bar and Line Charts, Tables, Text, Gauges, Boxplots, Filters, PDF, CSV, Excel, Pie and Donut Charts - @taleshape.bsky.social starts to have a lot of features!
I just created a demo board that shows how to use them all:
(link in comment)
New Year, New Features! 🍰🍩
@taleshape.bsky.social now has Pie and Donut Charts for when your dashboard needs some more colors.
And big Thank You to James for contributing this feature:
github.com/taleshape-co...
It's beautiful seeing the magic of open source collaboration🙏
Depends on your needs. Focus is on making small teams productive, whether they are part of a small or big company.
What specifically do you have in mind?
- Use Shaper to share visualizations and curated datasets while using "chat with your data" tools for data exploration.
- Use Shaper together with AI agents to automatically generate dashboards.
- Use Shaper if you want control over your data and avoid vendor lock-in.
The BI tooling market is changing rapidly:
Lots of consolidations around data platforms + AI tools replacing traditional BI dashboards.
So why bother building @taleshape.bsky.social?
Shaper is open-source, SQL-driven, focused on embedded analytics + data sharing:
1/2
github.com/taleshape-co...
@taleshape.bsky.social is essentially a DuckDB wrapper to visualize + share data.
And I am more excited than ever about @duckdb.org.
I just want to do everything in SQL:
Data ingest + transform, data viz + automation.
The ease of using DuckDB.
The extension system.
AI agents for writing SQL.
Together with Shaper's new File-based Workflow we introduced the shaper-bin PyPi.
Live-previewing dashboards right from your own editor is as simple as:
$ pipx run shaper-bin dev
Shaper now deploys dashboards directly from SQL files and live-previews changes.
$ shaper dev
Build analytics dashboards:
- using your favorite editor + LLM
- version controlled in Git
- with pull requests + code reviews
- integrated into your CI/CD pipeline
taleshape.com/blog/analyti...
Added "Copy Markdown" buttons to the @taleshape.bsky.social docs.
More AI support coming very soon 🙏
Teaser: File-based Workflow for @taleshape.bsky.social coming soon ✨
Edit SQL file in your favorite editor and live-preview dashboard changes.
Once this is ready you can track dashboards in Git,
and use your own editor with all its AI features to build dashboards.
🟢🔴🟢 is rare to see on this screen
Who would have thought Box Plots are this popular!
Less than 24h after release I already saw people using them for:
- Visualizing medical scores
- Debugging audio translation quality
- Monitoring urban mobility data
My favorite part about @taleshape.bsky.social Box Plots:
You can define what what to show when hovering an outlier data point to make it directly actionable.
boxplot chart example
boxplot code sample
Box Plots just shipped in @taleshape.bsky.social:
Quickly visualize data distributions with a single line of SQL.
Thanks to @duckdb.org macros you just type "BOXPLOT(my_value)" to calculate all statistics - including outliers.
Give it a try:
github.com/taleshape-co...
Is it just me or anyone else has this strange workflow?
I basically spent 80% of my time in a single "todo.md" file.
It's where I plan out work, write messages and so on.
And now with LLM prompts I spent even less time in other apps.
Boxplots are coming to @taleshape.bsky.social!
And I just created a DuckDB helper function to do the math for you.
Pretty neat that that's possible as a simple macro.
Makes using boxplots straight forward.
And please tell me if I got the math wrong somehow 🙏
