Ben retweetet
Ben
380 posts

Ben
@bbgatch
Analytics professional working in the hospitality industry. I like Python, SQL, data, hotels, and music.
Beigetreten Haziran 2020
4.9K Folgt355 Follower

Colorado: Land of the burger 🍔
Ethan Mollick@emollick
Surprisingly good for the first try. Nano banana pro: "create a map of the US where every state is made out of its most famous food (the states should actually look like they are made of the food, not a picture of the food). Check carefully to make sure each state is right."
English

Amazing view right now of the Northern Lights from Ely, Minnesota youtube.com/live/CevQg8IoI…
theauroraguy.com/pages/webcams

YouTube

English
Ben retweetet
Ben retweetet

Had a lunch just north of Wooodruff Park. Here is half of the scooter ride from our designated scooter parking through @sodowntownatl.
English

@JonnyBird It’s amazing how it feels like you’re out in the country when you’re right in the middle of the city.
English

As my kids like to call “the rock way” on the Beltline between Piedmont Road and Amsterdam Walk headed to the VaHi Summer fest.
3-4 years from now this will be filled with apartments, people, retail, density, and dining!
Atlanta’s future includes more e-bikes, scooters, ride-share, and the ever-increasing Waymo’s.
English

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/sci…
English

"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
English

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/2…


English

@unclebobmartin Thanks Uncle Bob, I assume this Datalog example would be resistant to SQL injection attacks? blog.cleancoder.com/uncle-bob/2017…
I can see how SQL injection is an issue, and it may be worth this extra effort, but this Datalog syntax seems much more bloated and arcane than 50-year old SQL.
English

@bbgatch Here’s one I used last year. The representation is called Datalog. I used it with the XTDB database.

English

@theo SQL was never intended to be used by computer programs. It was a console language for printing reports. Embedding it into programs was one of the gravest errors of our industry.
English
Ben retweetet













