@bbgatchi
iAccount based inUnited States!
About this account
- Account based in
- United States
- Connected via
- United States App Store
! X says this location may be affected by a proxy or VPN.
Account-level information from X, not a live location or the device used for a specific post.
Analytics professional working in the hospitality industry. I like Python, SQL, data, hotels, and music.
Joined June 2020
- Tweets387
- Following5K
- Followers329
- Likes13.6K
Virgin Voyages announces Project Ruby, an AI tool for planning and booking a trip. virginvoyages.com/ahoy/stori…
Virgin Voyages announces Project Ruby, an AI tool for planning and booking a trip. virginvoyages.com/ahoy/stori…
Time series foundation models: game-changer or overhyped? Rami Krispin breaks it down in our latest pod.
ow.ly/6HXM50YMNCz
@richierocks
Can’t believe @GitHubCopilot has just completely paused new Pro and Pro+ signups.
I unsubscribed for 1 month and now I’m locked out 😭
Colorado: Land of the burger 🍔
Amazing view right now of the Northern Lights from Ely, Minnesota youtube.com/live/CevQg8IoInI
theauroraguy.com/pages/webca…
New DuckDB Blog Post:
Maching Learning Prototyping with DuckDB and scikit-learn
Have you incorporated DuckDB into any of your work with scikit-learn? If so, does it look like this blog post, or different?
duckdb.org/2025/05/16/scikit…
"It is the gate which leads you to the state of mind, in which you live so close to your own heart that you no longer need a language.
It is utterly ordinary. It is what is in you already. Your first, most primitive impulses are right, and will lead you to do the right thing, if you will only let yourself.
There is no skill required. It is only a question of whether you will allow yourself to be ordinary, and to do what comes naturally to you, and what seems most sensible, to your heart, always to your heart, not to the images which false learning has coated on your mind."
- Christopher Alexander, The Timeless Way of Building
I recently encountered an interesting SQL issue.
Suppose you have a CTE that assigns random row numbers. You then join that CTE to itself, referencing the row numbers two times. They should match, right? Since they're coming from the same CTE.
Wrong!
At least in BigQuery and DuckDB, CTEs can be evaluated each time they're referenced. Here, the CTE is re-created twice, generating different random row numbers each time.
To avoid this, use a temporary table instead.
Read more: bbgatch.com/projects/sql/202…
Very cool!
The people spoke. We built. Meet the radically simple, radically affordable Slate. Reserve yours at Slate.auto
Ben retweeted
Today, @motherduck released InstantSQL and it will change how you work with databases. See query results *as you type* for instant feedback and more.
Watch below as I edit a query and errors and results change as I add predicates. Note I can click INTO a cte !
A new version of Forecasting: Principles and Practice has been released for Python! 🐍📈 otexts.com/fpppy/
Ben retweeted
The journey to developing a high level of talent occurs through a similar general process regardless of the specific talent domain. It can be roughly divided into 3 stages, and we all know people who have fallen into various failure modes.
DuckDB and the future of databases | Hannes Mühleisen | Data Science Han... youtu.be/GvgbcWtHgVY?si=EUcG… via @YouTube