Soof

Hacking thing together (or apart) for a while now. I care about effective impact, tech and pixels.

[Soof @SoofGolan]

@cracked_intern @charliermarsh PR up, just waiting for sensei to approve
https://t.co/RrSVhZoQ5X

[Andrew Gallant @burntsushi5]

I was recently diagnosed with a rare autoimmune disorder called anti-NMDA receptor encephalitis. It's a "disease of chaos" that completely upturned my life for a couple months.

I wrote a blog about it that goes into more detail and discusses prognosis.

https://t.co/mP0ftCuwpp

[Soof @SoofGolan]

Somebody love me as much as coding agents love running inline unversionable scripts and tailing them in order to maximize confusion

[Soof @SoofGolan]

WhatsApp started vibe coding

[Soof @SoofGolan]

/goal P=NP

[Soof @SoofGolan]

So much vibes opus is now thinking twice on everything.

[Armin Ronacher ⇌ @mitsuhiko]

When I'm old I want people to remember Tolkien named companies for things other than weapon and surveillance systems.

[Soof @SoofGolan]

Selling my @PyConDE Early Bird Ticket.
Anyone interested?
DM Me

[Soof @SoofGolan]

/login

[Glauber Costa @glcst]

What if we could run Postgres as a single file, and take advantage of the best SQLite has to offer?

Today I am announcing pg-micro, a crazy experiment I've been undertaking to make this happen.

pg-micro is different than other approaches because it is fully local, and expected to be fast: there is no concurrency limitation and no statement translation.

Here's how it works: we use the actual postgres parser to parse the statement, but compile that to the Turso AST. The Turso AST is then compiled do bytecode, and from there everything executes natively, as it'd do in SQLite. This makes it a perfect target to run in any environment.

There is traditionally a mismatch between Postgres and SQLite in terms of functionality. But @tursodatabase has been hard at work to close this gap: things like MVCC and a rich, strict type system are present in Turso. There are PRs for things like lateral joins, etc. This means that the gap can be closed until it theoretically reaches zero.

What you could do with it? Just imagine for example a primitive like Durable Objects by @Cloudflare, but with a postgres interface? Or imagine you could use the same pattern of local databases for agents that SQLite gives you, totally ephemeral and free, but with a Postgres interface? Or even that you could execute remote postgres in platforms like @vercel but with the unmatched density of the Turso Cloud?

Expect lots not to work at this point. But as usual, this is done in the full spirit of OSS, so PRs welcome!

To get started: npx pg-micro

[Soof @SoofGolan]

Claude writing good tests without mocks wen
@jarredsumner

[Soof @SoofGolan]

FastAPI not being fast because of so many layer of indirection, serialization and deserialization happening on the main thread, locking the event loop from making progress

[Soof @SoofGolan]

cpython is so slow it created a niche in the engineering field of working against the runtime instead of writing things in a dumb and simple way

[Soof @SoofGolan]

We are witnessing the Combine Harvester moments in the software engineering field.
Drop the scythe, learn to drive it.

[Soof @SoofGolan]

Shopping for new IDEs / editors
Is @zed the answer

[Soof @SoofGolan]

@pycharm is unusable since macOS 26, crazy input lags, UI freezes, hangs.

[Soof @SoofGolan]

Welcome to enshittified era of software

[Soof @SoofGolan]

@aarondfrancis @jwmcpeak @eytanlevit
Your small-council and this need to colab

[Soof @SoofGolan]

Reading the docs still gives you (the human) superpowers, LLMs still spew out non-canonical, outdated, crappy solutions and guidance is still a thing.