linrium
89 posts

linrium
@linrium
import { me } from 'world'
Ho Chi Minh, Vietnam Katılım Haziran 2018
240 Takip Edilen10 Takipçiler

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

English

best part: if you ever want to migrate
r2 → s3-compatible, drop-in to aws
d1 → it's sqlite. dump the file, done
better auth → framework-agnostic, zero cf lock-in
kv → swap for upstash redis
email routing → just swap for resend easily
workers → v8 isolates not node. clean fetch-handlers migrate
ibo@ibocodes
stop overcomplicating your stack, just deploy everything to cloudflare - workers (compute) - d1 (sql db) + better auth - kv (cache) - r2 (object storage) - queues (background jobs) - hyperdrive (db acceleration) - email routing (sending) - + waf & ddos built-in worst case your top bill is $10
English
linrium retweetledi

Meet Dory: a free, open-source Docker Desktop and OrbStack alternative for Mac.
One shared VM for all your containers (~4.7x less idle RAM), a real docker socket, one-click Kubernetes, full Linux machines for all dev work. ~6 MB, no Electron, no accounts, GPL-3.0.
augani.github.io/dory
GIF
English
linrium retweetledi
linrium retweetledi
linrium retweetledi
linrium retweetledi

My latest post on control theory and feedback loops has just been published. I’ll start from scratch and gradually build up feedback loops that are self-healing and resilient, capable of scaling thousands of databases.
Check it out: planetscale.com/blog/the-feedb…

English

linrium retweetledi

linrium retweetledi
linrium retweetledi

this isn't the voice of an open-source contributor. this is the openai paycheck talking. this is scam altman's voice coming out of stinky lobster.
"They copied a lot of features, but they skipped security hardening." grifter. you're lecturing the entire field about security with 1,362 packages sitting in your lockfile. hermes agent ships 225, every one pinned to an exact version, after they watched a worm crawl through pypi and poison a real release.
that isn't skipping security hardening. that's doing the part you outsourced to npm and prayed about. bloat isn't a feature list, it's attack surface wearing a feature list.
here's what actually decides this, the thing you keep dancing around. hermes agent reads and repairs tool calls straight off the model, so it just runs on the box on your desk, on basically any local model you point it at. that's not a small thing, that's the whole thing, it's why hermes agent gets used.
and here's the funniest part. you opened this whole thing calling us the copycats. then you quietly shipped tool-call repair, the feature that's basically been hermes agent's entire identity... late, and for exactly one format. so say it again, slow this time. who copied who?
and then there's blank slate. hermes agent ships an install mode where everything is off by default. no web, no browser, no code execution, no skills, no plugins, no mcp, no memory. just file and terminal, and it hardlocks the rest so nothing you didn't choose ever loads, not even after an update. you opt into every capability by hand. deny by default, least privilege. that's not a missing feature, that's the exact security hardening you just accused us of skipping.
1.03 trillion tokens in a single day. more than the entire rest of the top five combined. 5.6x your lobster, and the lobster isn't even second anymore. and of course it stings, that's what all the non-profit and agenda talk now actually is. but rewind to when you were the one on top. you blocked people. you called our PRs slop. the tone changes fast when the leaderboard does.
you didn't lose because we copied you. you lost because we stayed light. tokens are the work, and the work doesn't smell like old stinky lobster bloat.
Peter Steinberger 🦞@steipete
@LeoSparr They copied a lot of features, but they skipped security hardening, not a single report published.
English















