Jorin
@jorin
Open Source Data Dashboards + Embedded Analytics, powered by DuckDB:
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
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:
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
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/...
And as always, defined directly in the SQL query. More in the docs: taleshape.com/shaper/docs/...
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
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.
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!
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...
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
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
@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...
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:
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 🙌
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
@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?
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!
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.
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.
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 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
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🙏
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.
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.