Jorin

Jorin

@jorin.me

Open Source Data Dashboards + Embedded Analytics, powered by DuckDB: https://taleshape.com

2.9K followers1K following473 posts

Pinned

Jorin
@jorin.me

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.

Jorin
@jorin.me

Are you in tech and want guaranteed employment for the next 10+ years? Pivot into security. It's going to be a wild ride.

Jorin
@jorin.me

Building Shaper Dashboards with Claude Code or your agent of choice just got easier: You can now install the shaper skills directly as Claude plugin or using npx skills. Gett started here: taleshape.com/shaper/docs/...

Jorin
@jorin.me

Shaper allows you to build charts and dashboards all in SQL. Now two years into the project I am planning to introduce a new SQL syntax. What do you think? Would love to hear your thoughts! See Github for details: github.com/taleshape-co...

Jorin reposted

Syntax
@syntax.fm

We have $100K to give away to open source maintainers! Let us know your suggestions and nominations.

Jorin
@jorin.me

Anyone else notices how many security vulnerabilities are reported lately? CI is constantly broken because some dependency has a new vulnerability. And no one pays the open source maintainers to fix all this. Who is willingly maintaining the open source tools that power the internet?

Jorin
@jorin.me

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.

Jorin
@jorin.me

Of course: The maintainers don't owe anyone anything. No one pays them for this. It's wild that software works at all.

Jorin
@jorin.me

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

Jorin
@jorin.me

Luckily we have many great tools nowadays to proactively detect potential threats. We already ensured that our dependencies don't introduce vulnerabilities, but now we also scan the code for other threats ranging from password leaks to SQL injection.

Jorin
@jorin.me

I spent most of my day in a single markdown file: It's my todo list. It's where I think through concepts. It's where I draft mails, Github issues and content. I have been doing this for years. But since coding agents, even coding is just copying over prompts into my terminal.

Jorin reposted

DuckDB
@duckdb.org

🌟 🌟 🌟 🌟 Wow! DuckDB just surpassed 40k stars on GitHub. Thank you to everyone whose contributions, bugfixes, and – of course – stars made this milestone possible. 🦆✨ Here's (a very brief bit of) what’s happened since the last 10k-star milestone: duckdb.org/2026/08/05/g... Next stop: 50k. 💪🏽

Jorin
@jorin.me

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:

Jorin
@jorin.me

Did you know you can read 100s of books for completely free:

This post is unavailable.
Jorin
@jorin.me

One of the best things I did in 2026 so far is reading fiction again. Got an ereader. Downloaded a bunch of books and manga. This plus no more phone in the bedroom.

Jorin
@jorin.me

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

Jorin
@jorin.me

2026 is the year of Bash. I am back to managing servers with shell scripts. Docker Swarm and Nomad are dead. It's all Kubernetes now. 1/3

Jorin
@jorin.me

The mountain of yaml files that comes with that is more bearable when Claude generates them for you. But that doesn't change the fact that you are managing multiple distributed systems before your app ever runs. 2/3

Jorin
@jorin.me

All I need is to run a a few dozen docker containers, put a load balancer in front of it and automate deployments. Yes, Anisble, Coolify, Kamal, and friends exist. But a few lines of Bash does all I need. And working with shell scripts is surprising pleasant if you don't have to write them yourself.

Jorin
@jorin.me

Just the other day I had Claude optimize my laptop's performance and battery usage - now I know what zram, tlp and thermald are.

Jorin@jorin.me

And it's easier than ever to run Linux: 1. Valve/SteamOS do amazing work - especially for gaming. 2. AI completely changes how accessible it is to customize your setup and fix issues. 3. And so many great distros to choose from these days.

Jorin
@jorin.me

I am running Linux for over 10 years and it's never been a better time to give it a try: More reasons than ever to want more control over your setup: 1/3

Jorin
@jorin.me

1. Windows and Mac keep adding bloat you don't want. 2. Hardware is changing fast and prices too. No better feeling than upgrading your own hardware. 3. You want to run containers and AI models at full performance. 2/3

Jorin
@jorin.me

And it's easier than ever to run Linux: 1. Valve/SteamOS do amazing work - especially for gaming. 2. AI completely changes how accessible it is to customize your setup and fix issues. 3. And so many great distros to choose from these days.

Jorin
@jorin.me

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

Jorin
@jorin.me

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.

Jorin reposted

Jorin
@jorin.me

Replying to @mveilleux.com

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!

Jorin
@jorin.me

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

Jorin
@jorin.me

You can already see how these commands are really helpful for an AI agents. Plus with tasks and setup scripts moving right next to your dashboard files agents can do even more on their own.

Jorin
@jorin.me

Coming soon: Shaper Skills. With all building blocks ready, we can now streamline building dashboards so all you have to do is tell what you want and review the results.

Jorin
@jorin.me

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

Jorin
@jorin.me

Last week I ran into a great use case for UNPIVOT: The dataset had the columns p25, p50, p75. But to visualize it with @taleshape.bsky.social we want to use the column name as CATEGORY and the column value as LINECHART. And UNPIVOT does exactly that in a single line of code.

Jorin
@jorin.me

Just updated my Bluesky handle to @jorin.me If I would have known how simple it is, I would have done this from the beginning!

Jorin
@jorin.me

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:

Jorin
@jorin.me

If you know someone that might be looking for one of the following I would love to get in touch: - Customer-facing analytics and data export functionality while ensuring data sovereignty - AI analytics agent without exposing PII - Automating individualized reporting