iiinova — where your digital self keeps evolving

Jorin @jorin.me · 05/10/2026

Open source is wild: NPM package "braces" - 190 million WEEKLY downloads. Half the internet depends on it. Last updated: 2 years ago. Now: Critical security vulnerability that blocks thousands of build pipelines. For two weeks already.

100

Jorin @jorin.me · 19/08/2026

Shaper now runs a dedicated security pipeline for any code changes. Why? I am seeing too many reports of open source projects and companies having data breaches and other security issues lately. And my biggest nightmare is to wake up one day and see that this happened to any Shaper users. 1/2

100

Jorin @jorin.me · 07/08/2026

New Shaper Feature: Single Sign-On Shaper now supports external user management with JWT-based SSO. No separate user login to manage. No password to remember. And it's open source and free to use. See it in action:

121

Jorin @jorin.me · 28/07/2026

How does Shaper compare to other data visualization tools? @dataders.bsky.social built a cool project to compare 10+ code-based dashboarding tools. The project is completely code-based and processes data with DBT, then visualizes the results. Most of the tools directly generate static HTML. 1/2

111

Jorin @jorin.me · 14/07/2026

Added a new chart type to @taleshape.com: Scatter Plots This is how you define this chart in SQL: SELECT 'Session Durations'::LABEL; SELECT created_at::XAXIS, category::CATEGORY, duration::SCATTERPLOT, FROM dataset GROUP BY ALL ORDER BY ALL; Docs for more: taleshape.com/shaper/docs/...

011

Jorin @jorin.me · 28/05/2026

And as always, defined directly in the SQL query. More in the docs: taleshape.com/shaper/docs/...

021

Jorin @jorin.me · 28/05/2026

New @aleshape.com Visualization Option: Confidence Bands Allows you to show a band for a line chart which is great to show extra statistical context (the confidence of a prediction, the spread of a distribution, etc) It's a nice middle ground between only show a line and showing a full Boxplot

111

Jorin @jorin.me · 26/05/2026

Did you know you can download @taleshape.com dashboards with SQL? Use Shaper's API to download PDFs, images, Excel files and so on. Call the API with the DuckDB http_client extensions from a Shaper task to post charts to Slack, email a weekly PDF report or automate anything else you can think of.

111

Jorin @jorin.me · 25/05/2026

It's not pretty but works. In the future I will add SQL functions similar to the macro to generate files without needing an API key. And I am thinking to create a generic DuckDB extension to send mail, slack messages and so. Can also generate png, excel, csv & json. Will dm you the code!

022

Jorin @jorin.me · 22/05/2026

Skills for @taleshape.com are here: Use with Claude Code/Codex/Gemini to create dashboards quickly. With the skills the agent knows Shaper SQL, validates the create dashboard and gives you a preview URL once ready. More here: github.com/taleshape-co...

041

Jorin @jorin.me · 15/05/2026

The @taleshape.com CLI just got an upgrade 🚀️ New Commands: - fetch the database schema - validate a dashboard - open a preview in the browser Task Support: - Tasks a files: mytask.task.sql - Run task on startup: `SELECT 'init'::SCHEDULE;` 1/3

121

Jorin @jorin.me · 07/05/2026

Did you know duckdb.org's UNPIVOT feature? You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read: PIVOT turns one row into multiple columns. UNPIVOT turns columns into multiple rows. 1/2

161

Jorin @jorin.me · 06/05/2026

@taleshape.bsky.social Cloud is now in beta! The simplest way to start building dashboards and customer-facing analytics with Shaper. Let me know what you think: taleshape.com/plans-and-pr...

111

Jorin @jorin.me · 01/05/2026

The @taleshape.bsky.social docs now have live examples 📊 Examples are now embedded as live dashboards instead of only screenshots. With this you can also directly see the differences between light and dark mode:

021

Jorin @jorin.me · 30/04/2026

Is anyone else getting flooded with pull requests with numeric titles and cryptic descriptions in Chinese? I'll take it as a sign for @taleshape.bsky.social getting more popular 🙌

010

Jorin @jorin.me · 22/04/2026

Did you know you can build a data analytics agent without the LLM ever seeing your data? That's what we did. We teach the LLM about your data and let it generates SQL. Then we use our open-source tool Shaper generate charts/PDF reports/Excel files and send them directly to you. 1/2

110

Jorin @jorin.me · 20/04/2026

@duckdb.org is such a flexible tool that it's hard to categorize. Is it SQLite for analytics? Is it a SQL query engine for any data source? A dataframes alternative? A lightweight data lake?

050

Jorin @jorin.me · 19/04/2026

It's probably the best time ever to get into game development: We gotta make use of all those GPUs out there somehow. And if any of those claims about our productivity in the near future are true, we should have lots of time to play games soon!

010

Jorin @jorin.me · 16/04/2026

Did you know that with @duckdb.org you can directly query your database schema? When you combine this with considerate comments on your tables and columns it becomes a powerful tool to build agents and other systems that dynamically discover and learn to use your data.

171

Jorin @jorin.me · 06/04/2026

Fiction is a great teacher:

“Once men turned their thinking over to machines in the hope that this would set them free. But that only permitted other men with machines to enslave them.”

020

Jorin @jorin.me · 06/04/2026

Working on something fun for @taleshape.bsky.social 👀 Send SQL get back an image or PDF report? Soon: Official API to generate downloads. Point to a dashboard or just send a SQL string. Either get back a file directly or get a URL to a file. And files can be data: JSON/CSV/XLSX, or also PDF or PNG.

010

Jorin @jorin.me · 28/03/2026

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

031

Jorin @jorin.me · 25/02/2026

@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

131

Jorin @jorin.me · 30/01/2026

I sometimes forget that @taleshape.bsky.social supports dark mode:

011

Jorin @jorin.me · 15/01/2026

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.

142

Jorin @jorin.me · 08/01/2026

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)

141

Jorin @jorin.me · 06/01/2026

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🙏

041

Jorin @jorin.me · 05/12/2025

Added "Copy Markdown" buttons to the @taleshape.bsky.social docs. More AI support coming very soon 🙏

031

Jorin @jorin.me · 21/11/2025

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.

051

Jorin @jorin.me · 18/11/2025

🟢🔴🟢 is rare to see on this screen

140

Jorin @jorin.me · 17/11/2025

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.

051

Jorin @jorin.me · 17/11/2025

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

021

Jorin @jorin.me · 13/11/2025

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 🙏

030

Jorin @jorin.me · 23/10/2025

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.

172

Jorin @jorin.me · 13/10/2025

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

141

Jorin @jorin.me · 08/10/2025

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.

052

Jorin @jorin.me · 29/09/2025

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.

2102

Jorin @jorin.me · 26/09/2025

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.

1101

Jorin @jorin.me · 03/09/2025

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

061

Jorin @jorin.me · 26/08/2025

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

0114

Jorin @jorin.me · 25/08/2025

I have $10 Anthropic credits that are expiring this week. Now I need to find some work Claude is good at. Looks like it's time to add new features instead of working on my actual priorities.

000

Jorin @jorin.me · 19/08/2025

Can you tell that these 2 SQL queries do the same thing? DuckDB comes with lots of conveniences for writing SQL. I don't want to go back to thinking about trailing commas ever again,

161

Jorin @jorin.me · 30/07/2025

Shaper now supports a cool DuckDB feature: Temporary Tables. Temporary tables allow you to pre-compute data to reuse within a single dashboard. Seeing how nicely temporary tables integrate into Shaper makes me feel great about the bet to make Shaper dashboards essentially just SQL scripts.

131

Jorin @jorin.me · 28/07/2025

Shaper now supports public dashboard sharing and I added a public demo dashboard to the landing page. I was looking forward to this feature to easily share examples and use Shaper to play around with public datasets. taleshape.com #dataviz #buildinpublic

192

Jorin @jorin.me · 27/07/2025

When you spend so much time on data analytics, you use SQL to calculate your visa due date

061

Jorin @jorin.me · 01/07/2025

when chatgpt does a better job pitching @taleshape.bsky.social than me

010

Jorin @jorin.me · 10/03/2025

Do I still need wifi if my phone gives me this?

150

Jorin @jorin.me · 09/03/2025

i honestly just want to use react router for my next project because of these retro graphics on their landing page

030

Jorin @jorin.me · 09/03/2025

I just learned about Malloy. Such an intriguing alternative to SQL for not only querying, but also modeling data. And they have a concept to tag values which can be used to render data. That's even more elegant to what I try to do in SQL using types. www.malloydata.dev

030