I set up a minimal self-hosted data lake platform with DuckDB, DuckLake and @taleshape.bsky.social. The whole setup is a single docker compose file that covers all basic data needs from ingest and storage to transform and visualization: taleshape.com/blog/simple-...

Shaper - a a duckdb powered dashboarding tool Interesting approach of extending SQL with dashboarding instructions. Slight difference to evidence with using SQL in markdown and then custom tags. taleshape.com/shaper/docs/

Today @taleshape.bsky.social launched on Uneed and people seem to like it 👀 If you have a minute, I am happy about your support 🙏 www.uneed.best/tool/taleshape

@taleshape.bsky.social now offers hosting + support for Shaper! Fully-managed, On-Premise BI with White-Labeling for 150/month anyone? I am happy about any feedback🙏 And if you can think of any company that might be interested in code-first embedded analytics powered by DuckDB, please reach out 👀

I haven't updated my personal blog since starting @taleshape.bsky.social so I used that as a chance to give an update on why I am building Taleshape and where things stand right now: jorin.me/building-tal... Also: I am always happy about any ideas on where to take Taleshape next 🙏

On that note, we are currently experimenting with AI agents using @taleshape.bsky.social to run SQL and generate charts. I see the strength of Shaper's SQL approach in how transparent + auditable everything is. Reviewing SQL is much more doable than JSON definitions or even completely custom code.

My biggest recap from FOSSASIA this year: It's all AI now. I felt a stark contrast to last year that basically every talk is about AI. No one writing code by hand is already old news. And now everyone is automating all their processes with agents. It's a wild time to build a software product!

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 💙

@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

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:

@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.

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🙏

- 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.

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.

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...

Did you know that you can download @taleshape.bsky.social dashboards as PDF? Thanks to chromedp we can generate PDFs server-side, in the same Docker image. Thanks @mvdan.cc! Means you get consistent PDF files - even on mobile or using an unusual browser.

Every company is a data company, but most don't know where to start. I just published a new blog post on how to get started building data capabilities at your company, one step at a time. Curious to hear your thoughts! taleshape.com/blog/getting...

Fivetran buys DBT. Just after they bought SQLMesh. What now? Ignore what they say. Judge them by their actions: There is only one way to look at it when you buy the two leading open source data transform tools - A move to establish control over a critical layer of the data stack.

Do you prefer light or dark theme for your dashboards? Shaper supports both: taleshape.com/shaper/docs/

At Taleshape we challenge how you think about data dashboards: Dashboards are not for telling stories. Dashboards are not for exploration. Dashboards get the right data to the right person at the right time. github.com/taleshape-co...

With @taleshape.bsky.social chart annotations are just another SQL query: You can load calendar events or goal lines from any data source and display them in your charts. And not only chart annotations - any text, label or dropdown in Shaper can be generated dynamically.

Open Source won. At least that’s what where my bet is. Open source is resilient. Open source is adaptable. I myself wouldn’t bet my company on a 3rd-party vendor when making fundamental technology choices. So of course my own product also has to be open source: github.com/taleshape-co...

The most underrated DuckDB extension: duckdb.org/community_ex... I am already using it to: - Fetch data from APIs - Send emails - Trigger Slack notifications Thank you for this @qxip.bsky.social 🙏

This podcast changed my understanding of ETL and how DuckDB Airport has the potential to fundamentally change what data pipelines look like. What if instead of needing a separate system to load data you query any external data source like just another SQL table? www.youtube.com/watch?v=qngR...

Today seems like a good day to emphasize that @taleshape.bsky.social is open source and runs on any hosting provider. Code-driven data dashboards and embedded analytics without vendor lock-in or platform risk.

Updated the @taleshape.bsky.social website: Before: - Overview tried to cover everything. Now: - Overview: Demo + Features (what) - About: Background (who & why) - System Architecture: Tech (how)

CREATE TEMP TABLE and getvariable() are my favorite DuckDB features. Thanks to this DuckDB is a natural fit for interactive data dashboards. Temporary tables allow you to define datasets once and reuse them across a dashboard. Variables make defining dynamic data filters intuitive.

I would probably never have built a data visualisation tool if I knew before how much math it takes. Somehow I imagined charting libraries handle it all. But here I am coming up with algorithms and magic numbers to properly format chart legends and labels no matter what data you throw at Shaper.

Why did I decide to build an embedded analytics product? I was setting up a data platform for a client. The scale and complexity of their data was trivial. But they needed to be able to embed data dashboards into their application. And the solution had to run on premise. 1/2

I am all-in on @duckdb.org. With Shaper you can build data dashboards all in SQL. Powered by DuckDB. Why DuckDB? Because of how much flexibility its simple design enables. My customers use DuckDB extensions to query Postgres, Google Sheets and even trigger webhooks. And we are just getting started.

Didn't expect @taleshape.bsky.social to be mentioned in the NATS newsletter! But yes, Shaper makes heavy use of NATS to replicate @duckdb.org across multiple nodes, schedule tasks, buffer data ingestion and more.

This feedback is the reason I am building @taleshape.bsky.social: I want to create dashboards by simply writing SQL. And I want a tool that feels great to self-host. #duckdb #dataengineering #datanalytics #sql

Are you using Bluesky and want to stay on top of what’s happening? Are you curious how you can use Shaper to pull data from APIs and build interactive dashboards, all in a single tool and with just SQL? I created a little demo project: taleshape.com/blog/build-y... #databs #duckdb

We have a first Youtube walk through to get started with Shaper! And it's even me that recorded it. Thanks a lot @nanovms.bsky.social! Really appreciate the shout out 🙏 Great to see you can also run Shaper as unikernel.

Thanks a lot @nanovms.bsky.social for featuring us! That's a great walk through video!

DuckDB is awesome and it’s a great tool to explore and transform data. But DuckDB doesn’t help you visualize and share data with others. That's why I built Shaper: taleshape.com/blog/turn-yo... #duckdb #databs #dataengineering

Working on a fun demo project 👀 #databs #duckdb #dataengineering