Sign in

Dmitriy Ryaboy

@squarecog.bsky.social
2.9K followers 234 following 237 posts

Works with data, runs with swords.

PostsRepliesMedia
Dmitriy Ryaboy @squarecog.bsky.social · 25/09/2026
The founding of the East India Company, in 1600: "a barrel of beer a day was authorised ‘for the better holding together of the workemen from running from ther worke to drinke’." 400 years later, tech offices pretty much running the same playbook.
040
Dmitriy Ryaboy @squarecog.bsky.social · 21/09/2026
Kind of embarrassing how many ML people are reacting to Jev with "lol, LLM noobs discovered classifiers / BERT".
001
Dmitriy Ryaboy @squarecog.bsky.social · 10/09/2026
Viking laws, man. (Well, technically, post Viking. 11th century Norway).
010
Dmitriy Ryaboy @squarecog.bsky.social · 03/09/2026
It's not build vs buy, it's own vs rent. Owning is great *if you are willing to take on upkeep and maintenance*.
110
Reposted by Dmitriy Ryaboy
Gergely Orosz @gergely.pragmaticengineer.com · 03/09/2026
Write about how software engineering is changing inside your company / team / project. Don’t use AI. Win $10K and get published in The Pragmatic Engineer. You have a month: submit by 4 October. Details: blog.pragmaticengineer.com/how-software...
4427
Dmitriy Ryaboy @squarecog.bsky.social · 30/08/2026
Totally wild that they gave Terminator a "neural net cpu" back in 1991
000
Dmitriy Ryaboy @squarecog.bsky.social · 29/08/2026
Claude consistently making code 25% longer when I tell it to DRY things up is equal parts frustrating and hilarious.
220
Dmitriy Ryaboy @squarecog.bsky.social · 17/08/2026
@phokion.bsky.social just finished Whalesong. Excellent as always! The wait for #4 begins.
011
Dmitriy Ryaboy @squarecog.bsky.social · 11/08/2026
Dealing with bare metal providers and, man, I remember now why "cloud" vendors get away with their margins. Any old Twitter people remember NTT America?
static.klipy.com
Neil Patrick Harris Shudders
ALT: Neil Patrick Harris Shudders
130
Dmitriy Ryaboy @squarecog.bsky.social · 27/07/2026
Just parse the AST, they said. It'll be easy, they said. SQL is a pretty small and intuitive language, they said.
030
Dmitriy Ryaboy @squarecog.bsky.social · 25/07/2026
Me: "Problem is, LLMs rarely give a straight call. They equivocate." LLM: "You are half right."
020
Dmitriy Ryaboy @squarecog.bsky.social · 22/07/2026
I knew SQLGlot is a solid sql parser, but it wasn't till I started working on dblect that I learned how powerful it is. medium.com/@squarecog/t...
medium.com
The SQLGlot Appreciation Post
I’ve been putting a fair amount of effort into dblect, a semantic correctness framework for dbt pipelines. The ambition is to catch the…
040
Dmitriy Ryaboy @squarecog.bsky.social · 18/07/2026
We need a new shorthand: TS;DR (too slop, didn't read)
160
Dmitriy Ryaboy @squarecog.bsky.social · 15/07/2026
Who would've thought that the 2 fastest python SQL parsers would be created by 2 different guys named Tobias M.
020
Dmitriy Ryaboy @squarecog.bsky.social · 14/07/2026
dblect 0.1.0 released! Test your dbt workflows and find hidden dangers that linting and unit testing alone won't warn you about. Pypi: pypi.org/project/dble... . Github: github.com/dvryaboy/dbl... Intro blog: medium.com/@squarecog/t...
pypi.org
dblect
Semantic correctness framework for dbt analytics pipelines
010
Dmitriy Ryaboy @squarecog.bsky.social · 08/07/2026
Introducing dblect: medium.com/@squarecog/t...
medium.com
Testing dbt for Structural Hazards, or, Introducing dblect
“The data looks off” sucks. You get this thrown your way in Slack, and consider your day, if not your week , gone. “The data looks off” can…
000
Dmitriy Ryaboy @squarecog.bsky.social · 29/06/2026
A cool thing about the dblect tooling is that you can `noqa` it inside macros. Something sqlfluff doesn't support right now, but i found it necessary for significant dbt usage.
000
Dmitriy Ryaboy @squarecog.bsky.social · 29/06/2026
I'm getting pretty close to the 0.1.0 release of dblect. If you are into the whole actually testing your dbt workflows thing, check out the README: github.com/dvryaboy/dbl...
github.com
GitHub - dvryaboy/dblect: Test your data for meaning
Test your data for meaning. Contribute to dvryaboy/dblect development by creating an account on GitHub.
030
Dmitriy Ryaboy @squarecog.bsky.social · 26/06/2026
I've long held that people underestimate the power of just grepping the codebase. And boy did claude code prove me right... 😅
130
Dmitriy Ryaboy @squarecog.bsky.social · 25/06/2026
Meet the SEMI JOIN. A join in the streets, a filter in the sheets.
030
Dmitriy Ryaboy @squarecog.bsky.social · 24/06/2026
Rough order of planned `dblect` releases: 1. Structural hazards: static analysis across dbt models 2. Logical types + contracts: eg no summing amounts without grouping by currencies 3. Var/flag worlds: awareness of flag values that change generated SQL 4. PBT: generate examples and test execution
010
Dmitriy Ryaboy @squarecog.bsky.social · 23/06/2026
If you build excel file support by pretending it's just a csv wrapped in xml, you're gonna have a bad time.
000
Dmitriy Ryaboy @squarecog.bsky.social · 20/06/2026
OMG my baby tool `dblect` is actually somewhat useful, check this out @matsonj.com : github.com/matsonj/nba-...
github.com
Full outer join to nba_results is silently filtered back to a left join · Issue #195 · matsonj/nba-monte-carlo
Hey Jacob, I'm working on dblect, a tool to identify hard-to-catch SQL bugs in dbt projects (semantic/unit mismatches, NULL-handling hazards, etc.). Let me know if you want a peek :). I used this p...
030
Dmitriy Ryaboy @squarecog.bsky.social · 15/06/2026
I'm working on a tool, dblect, to help test dbt project changes for bugs in meaning, not just sql validity or data diffs. Last weekend it got the ability to call out bugs like summing up money amounts without grouping by currency. This is good stuff, man.
020
Dmitriy Ryaboy @squarecog.bsky.social · 13/06/2026
Anthropic was practically daring US gov to apply export controls.
000
Dmitriy Ryaboy @squarecog.bsky.social · 10/06/2026
Hypothesis is catching such beautiful and weird edge cases. Saving me a lot of future embarrassment. Thanks @drmaciver.bsky.social and the rest of the team!
010
Dmitriy Ryaboy @squarecog.bsky.social · 09/06/2026
It's genuinely hard and takes more work to do a close read of Claude docs and designs than those of a mid-level SE, because Claude makes similar mistakes but it _sounds_ a lot more authoritative. The normal tells of someone not really thinking through it aren't there, they're... different.
120
Dmitriy Ryaboy @squarecog.bsky.social · 07/06/2026
I'm writing something that lets you say "the columns amount:int and currency:varchar make up the type Money". The right name for that is probably SemanticType, but I'm concerned folks will get confused and think this is connected to Semantic Layers. Does DomainType work?
000
Dmitriy Ryaboy @squarecog.bsky.social · 06/06/2026
Claude just called some machinery I built "a cathedral with one tenant in a closet" and I'm genuinely impressed by the literary quality of this burn. ☠️
240
Dmitriy Ryaboy @squarecog.bsky.social · 03/06/2026
Two days ago, I joked "Codeim, I mean Windsurf, I mean whatever it is called now - probably Devin." Yesterday they actually renamed it to Devin. What should I do with my newly discovered powers?
120
Dmitriy Ryaboy @squarecog.bsky.social · 02/06/2026
FiveTran's m&a strategy to basically own the airspace above BigQuery and Snowflake is kind of fascinating.
020
Dmitriy Ryaboy @squarecog.bsky.social · 02/06/2026
The phrase "earning its keep" is no longer earning its keep.
000
Dmitriy Ryaboy @squarecog.bsky.social · 02/06/2026
What if you could have nice types on top of relations, with type inference through your sql workflows. With type refinements. And you could write correctness contracts on them. And it was statically checked. And maybe you could also generate PBT style tests on top. Would that be nice?
120
Dmitriy Ryaboy @squarecog.bsky.social · 02/06/2026
Types are hard, databases are hard, lineage and type propagation on top of database tables is hard... It's all hard, man.
060
Dmitriy Ryaboy @squarecog.bsky.social · 01/06/2026
Pop quiz, how many different sql parsers do FiveTran products run now?
010
Dmitriy Ryaboy @squarecog.bsky.social · 30/05/2026
You all should know there is a 2011 paper called "Don't Thrash: How to Cache Your Hash on Flash" by Bender et al.
120
Dmitriy Ryaboy @squarecog.bsky.social · 29/05/2026
It's been like 15 years since the Twitter API started putting ids as both numbers and strings cause js sucks, and yet there are Real Serious Companies still tossing 64 bit int ids around in json, like loaded footguns.
141
Dmitriy Ryaboy @squarecog.bsky.social · 26/05/2026
Dbt is pig without piglatin. Fight me.
140
Dmitriy Ryaboy @squarecog.bsky.social · 26/05/2026
Old sigmod and vldb papers are gold. I'm working on a thing at the intersection of program analysis and db theory (aka pbt for dbt) and it's hella fun. What a gem the Olston, Chopra, Srivastava 2009 sigmod paper was. Undervalued.
000
Dmitriy Ryaboy @squarecog.bsky.social · 01/10/2025
This is a pretty intriguing idea for future proofing file formats. It does assume wasm is future proof, of course, but that feels like a safer bet than "assume readers are updated"
051
Dmitriy Ryaboy @squarecog.bsky.social · 30/09/2025
If you love this sort of thing, read up on C-store, which introduced this idea in 2005 and commercialized it in Vertica. Stonebraker, Sam Madden, Daniel Abadi. Parquet was also partially inspired by Vertica (and Google's Dremel, and PaX by Natassa Ailamaki et al) :-).
051
Dmitriy Ryaboy @squarecog.bsky.social · 22/09/2025
ML is just applied stats. Stats is just applied algebra. LLM is just ML backward and with an extra L.
000
Dmitriy Ryaboy @squarecog.bsky.social · 20/09/2025
The obvious reaction here is to shift at least some of the hiring out of the country to get access to the talent. The obvious counter reaction is to tax payments and wages to foreign employees and contractors. Which will also provoke a reaction. And none of this makes the US stronger or smarter.
040
Dmitriy Ryaboy @squarecog.bsky.social · 20/09/2025
About a decade late with this, but: Someone should have started a social media ad agency called Twaddle.
000
Dmitriy Ryaboy @squarecog.bsky.social · 19/09/2025
It's tempting to take shortcuts that give you speed today by mortgaging speed tomorrow. Trouble is, today is yesterday's tomorrow.
010
Dmitriy Ryaboy @squarecog.bsky.social · 17/09/2025
I tried 2 different english to insights sql llm agents from reputable vendors in the past week. Data analyst jobs remain safe. Firmly in the toy category for now.
1121
Dmitriy Ryaboy @squarecog.bsky.social · 16/09/2025
Happened to be by the Cloudera building in the south bay earlier. Checked LinkedIn and discovered I have literally 0 1st degree connections who work there now. Not unexpected, I guess, but, man... betwen hnwx and cldr I used to know like 100s of folks there
150
Dmitriy Ryaboy @squarecog.bsky.social · 15/09/2025
Heck of a vote of confidence from LinkedIn for Flyte: www.linkedin.com/blog/enginee...
linkedin.com
OpenConnect: LinkedIn's Next-Generation AI Pipeline Ecosystem
141
Dmitriy Ryaboy @squarecog.bsky.social · 10/09/2025
About once every two years I have cause to re-learn a very important data lesson: never, ever, trust analysis based on ratio metrics.
120
Dmitriy Ryaboy @squarecog.bsky.social · 30/08/2025
Trying and failing to make the page edits look right? Is offline access lackluster? Tired of AI upsell as a replacement for poor search quality? You might be suffering from Notion sickness.
050