iiinova — where your digital self keeps evolving

Lars-Erik Road @lroal.bsky.social · 05/09/2026

Orange ORM 5.5.0 is out and I am excited about this release! 🎉 With Read-only ad hoc sub queries you can fetch data across any relations with custom filters. orange-orm.io

000

Lars-Erik Road @lroal.bsky.social · 09/07/2026

Orange ORM 5.4 is out Select for update and skip locked. orange-orm.io

000

Lars-Erik Road @lroal.bsky.social · 24/06/2026

The schedule is missing from main web site, app-2026.localfirstconf.com/schedule . But I guess it is not synced yet..😀

app-2026.localfirstconf.com

Schedule – Local-First Conf 2026

The world's first and best event dedicated to local-first software.

010

Lars-Erik Road @lroal.bsky.social · 16/06/2026

Event sourcing is risky, complex, and should be avoided in 99% of systems You don't just store events. You sign up for event versioning, projections, replay strategies, eventual consistency, operational overhead, and significantly harder debugging The biggest risk is that it's difficult to reverse

000

Lars-Erik Road @lroal.bsky.social · 12/06/2026

Just finished the first working prototype of two-way sync for Orange ORM 🚀 The sync plugin will be commercial, but free for up to 5 clients per application. Fair pricing model ? orange-orm.io #opensource #typescript #localfirst

orange-orm.io

Orange ORM - The ultimate ORM for Node and TypeScript

Fetch rows directly in the browser. Developer friendly, concise with powerful filtering.

020

Lars-Erik Road @lroal.bsky.social · 09/02/2026

🚀 Orange ORM v5 is out! 🍊 Breaking: •getAll removed → use getMany (same signature) •getOne(filter, ...) removed → move filter to strategy.where New: •ExpressJS before/after hooks for RLS •SQLite user-defined functions •Enums support orange-orm.io

orange-orm.io

The ultimate ORM for Node and Typescript

Fetch rows directly in the browser. Developer friendly, concise with with powerful filtering.

000

Lars-Erik Road @lroal.bsky.social · 20/11/2025

Drafting the architecture for local-first sync in Orange ORM: SQLite + OPFS on the client, WAL-safe writes, per-table changelogs, trigger-based delta capture, push/pull with conflict strategies, and a thin server applying changes atomically.

010

Lars-Erik Road @lroal.bsky.social · 21/09/2025

Native dependencies in npm are becoming an anti-pattern. Yes, Rust/Go binary is fast, but you're trading away: Cross-platform compatibility nightmares Larger attack surface for supply chain attacks Build complexity that breaks in CI/prod Pure JS may be slower, but it's portable

000

Lars-Erik Road @lroal.bsky.social · 18/09/2025

From the latest create-vue . WTF, this is asking for trouble. Breaking changes ahead !!

000

Lars-Erik Road @lroal.bsky.social · 18/09/2025

Can someone please make a Vite-like tool that: -has ZERO config except for custom proxy -works out-of-the-box for TS/Vue/Svelte/React -works out-of-the-box for server side -has ZERO breaking changes for the next 10 yrs -no extra plugins for basics Is that too much to ask?

000

Lars-Erik Road @lroal.bsky.social · 18/09/2025

Can someone please make a js linter that: -have ZERO config except own rules -have ZERO breaking changes for the next 10 years -requires NO extra packages (even for own rules) -works for js, ts, vue, svelte and tsx out-of-the-box -is not binary (no postinstall !) I don't care about the extra MBs

110

Lars-Erik Road @lroal.bsky.social · 18/09/2025

wtf: esbuild runs esbuild.exe on postinstall !! Running postinstall script is considered unsafe in the npm supply chain. There is no need for esbuild to be a binary dependency. I always turn postinstall off by having ignore-scripts=true in .npmrc. github.com/evanw/esbuil...

github.com

post-install documentation · Issue #4288 · evanw/esbuild

The esbuild package.json includes a "postinstall" script, but I can't find any documentation on it. As far as I can tell, it seems to only do async validation, so should be safe to disable. I'm try...

000

Lars-Erik Road @lroal.bsky.social · 04/09/2025

“Everyone’s chasing sexy AI solutions while ignoring boring, profitable niches in their own backyard 🏠 For a solo indie dev, a ‘small’ niche market can still mean thousands of customers and solid revenue. What’s too small for big companies = perfect size for you.

020

Lars-Erik Road @lroal.bsky.social · 20/08/2025

Just built my iOS app using @voltbuilder.bsky.social — no Xcode, no certificates hell, no Mac required. An amazing product

volt.build

VoltBuilder

App Builds Made Simple!

000

Lars-Erik Road @lroal.bsky.social · 11/08/2025

I just released Orange ORM v4.7.11 Support for bigint github.com/alfateam/ora...

000

Lars-Erik Road @lroal.bsky.social · 27/07/2025

You can now have cyclic relations in Orange ORM - to infinite depth. t.co/cte5pdKJC0

t.co

https://github.com/alfateam/orange-orm/releases/tag/v4.7.10

010

Reposted by Lars-Erik Road

kode24.no @kode24.no · 03/07/2025

Sjokkmelding: Vibbekoding fører til usikker kode. 🙃 * 40 prosent lekker sensitive data * 20 prosent gir full tilgang til databasen * Prøver du å tette hullene, gjør AI-en det motsatte

kode24.no

40 prosent av AI-genererte apper lekker data

Sjekka tusenvis av apper fra Lovable, Bolt, Base44, Replit og v0, og ble ikke spesielt imponert.

2153

Lars-Erik Road @lroal.bsky.social · 03/07/2025

Open source is a recurring marathon. No medal, no crowd, just new issues and weird edge cases. But somehow, it’s still worth showing up. See you at the starting line next month.

100

Lars-Erik Road @lroal.bsky.social · 03/07/2025

I am so fed up with n-column grid systems, there's a simpler way. CSS Grid handles it natively — no breakpoints, no utility classes. This creates a responsive grid that adjusts the number of columns based on available space. No media queries needed.

010

Lars-Erik Road @lroal.bsky.social · 03/07/2025

A whole conference dedicated to Vite?!! Me: I just want to know why it broke this time — then go back to pretending Vite doesn’t exist. @viteconf.org

000

Lars-Erik Road @lroal.bsky.social · 10/06/2025

Orange ORM featured in the latest Node Weekly newsletter nodeweekly.com/issues/581

nodeweekly.com

Node Weekly Issue 581: June 10, 2025

000

Lars-Erik Road @lroal.bsky.social · 24/05/2025

I am very happy to announce that Orange ORM now supports PGlite 😀! github.com/alfateam/ora...

110

Lars-Erik Road @lroal.bsky.social · 07/05/2025

Just released Orange ORM v.4.6.0 🥳 -Support for Bun and Deno -Using built in sqlite for Node 22 and later github.com/alfateam/ora...

000

Lars-Erik Road @lroal.bsky.social · 08/02/2025

A new release for Orange ORM is soon ready. Supporting Cloudflare D1. This one was very challenging because I needed to remove node:domain - which was used pretty much everywhere. As a bi-effect, it opens the door for other browser based databases like pgLite. It also opens the door for Deno.

000

Lars-Erik Road @lroal.bsky.social · 31/01/2025

Sure. I understand completely. 😊

010

Lars-Erik Road @lroal.bsky.social · 07/01/2025

It is pure data centric - no inheritance, behaviour or polymorphism.

100

Lars-Erik Road @lroal.bsky.social · 27/12/2024

Kafka on the shore by Muakami.

150

Lars-Erik Road @lroal.bsky.social · 20/12/2024

I need to limit scope - otherwise it will be bloated and unmanageable (where prisma and drizzle are heading)

010

Lars-Erik Road @lroal.bsky.social · 20/12/2024

D1 is coming. Migrations i dont know - maybe prisms export. Definitively not sql studio. There are so many good sql managers out there.

000