Jacob Matson

Jacob Matson

@matsonj.com

excel lover & data enthusiast. writing at dataduel.co working at motherduck.com

4.4K followers2.4K following1.3K posts

Jacob Matson
@matsonj.com

Haha yes!!

GitRanks@gitranks.bsky.social

@matsonj.com reaching 1k stars across your own repos reflects growing recognition for your work. A concrete step toward even greater contributions ahead. #github https://gitranks.com/profile/matsonj?t=d654Qz2Y

Jacob Matson
@matsonj.com

I'm really excited to share some of the research I've been in doing on Data Agents - and no place better to do it then in SF. Join me to learn how to build your own data agent at 1pm on June 2nd! Register here: thedive.motherduck.com

Jacob Matson
@matsonj.com

me to the new OSS LLMs: "please don't spiral thinking forever about how hard this problem is" them: "you know i think i will just spiral" pic related

Jacob Matson
@matsonj.com

of course, works great for claude web and desktop users too, but you have to download the latest release and add it manually (annoying)

Jacob Matson reposted

Dominik Moritz
@domoritz.de

🚀 We've just open-sourced Embedding Atlas – a tool for exploring large embedding spaces through rich, interactive visualizations 📊.

Jacob Matson
@matsonj.com

i've also been spending a lot of time on pg_duckdb (and how to run it) as we prepare for launching 1.0 of that extension. Can't wait to share more

Jacob Matson
@matsonj.com

One of the notions we think about quite a bit at @motherduck.com is "handling data before it becomes big" and I think this example from @tigrisdata.com really nails it. The trick here is parsing the JSON on insert so its really quick to query it.

Tigris Data@tigrisdata.com

AI scrapers can overload your app before you even see them coming. Anubis uses proof-of-work + honeypots to fight back—paired with @motherduck.com + @tigrisdata.com for real-time pattern detection at scale. 🧠 Detect bots. 🚫 Stop downtime. 🔗 www.tigrisdata.com/blog/anubis/

tigrisdata.comFending off scrapers with Tigris and DuckDB | Tigris Object StorageAnubis is a Web AI Firewall Utility that helps administrators keep their sites up in the wake of abusive scrapers. In order to make Anubis filter things better, you need data. Here's how Xe got that d...
Jacob Matson
@matsonj.com

Another good strategy is partitioning your writes to object storage by date / time (i.e. by hour) so you can easily write naive queries for analysis and backfills, like `select * from 's3://my_bucket/year/month/day/hour/*.json'`

Jacob Matson reposted

General Folders
@generalfolders.com

"Behind every large enterprise data workflow is an SFTP server with CSVs sitting on it (if you are lucky, its object storage and a compressed format, but its the same thing)."

Jacob Matson@matsonj.com

been pondering what the future of data & analytics looks like, so I spent some time writing about it. www.dataduel.co/if-spreadshe...

dataduel.coIf spreadsheets are eternal, are BI tools transitory? – DataDuel.coThe article discusses the evolution of business intelligence (BI) tools, questioning their longevity compared to the enduring nature of spreadsheets. It highlights how spreadsheets facilitated decisio...

Jacob Matson reposted

Howard Beck
@howardbeck.bsky.social

Hello, friends of #NBASky (and all the recent new arrivals). Quick 🧵. It’s been really cool/gratifying to see so many NBA fans/media gather here. I feel like we’ve reached critical mass, to the point where I barely check the other site anymore, and hardly miss it. (cont.)

Jacob Matson
@matsonj.com

Today in “cursed workflows”, you can connect to rest end points with Power BI which means you can serve DuckDB requests to it, no odbc required!

Jacob Matson
@matsonj.com

Traditional BI? SQL. ML? also SQL. AI? Again, SQL!

MotherDuck@motherduck.com

Friday talk! 🎤 @matsonj.com talked about why we should use more SQL and go hands-on with some practical examples of how to read from Iceberg using dbt, DuckDB, and MotherDuck. youtu.be/FMVgwGh8RQA