André König
banner
andrekoenig.com
André König
@andrekoenig.com
Crafting quality software for humans & 🤖 • Father, Consultant, Software Engineer - Staying curious.
Reposted by André König
Introducing LiveStore (beta)

LiveStore is a next-generation state management framework based on reactive SQLite and built-in sync engine.

livestore.dev
LiveStore: Local-first data layer for high-performance appsArrowArrowArrowArrowLiveStore
LiveStore is a state management framework based on SQLite and event-sourcing. It’s designed for demanding applications and based on years of research.
livestore.dev
May 27, 2025 at 10:04 AM
The debate around which web framework to use is (often) less important than one might think.

I treat the framework only as a binding layer between the UI and my domains, carefully crafting them to be framework-agnostic.
March 30, 2025 at 4:01 PM
Sometimes I genuinely don't understand the attitude of people in GitHub issues.

I think we need a mindset shift in Open Source: from 'I use it because it's free' to 'I genuinely care and want to ensure its sustainability.'
March 25, 2025 at 10:16 AM
I'm on my way back home.

My biggest fear was that I would get so much inspiration at the Effect Days that I would become completely sidetracked and want to try all the new things I just learned.

Effect Days just delivered! It was such an amazing conference.
March 22, 2025 at 8:02 PM
I'm currently in Livorno, Italy, looking forward to meeting some of the brightest engineers at the Effect Days, a breathtaking location, and an influx of enough gelato 🍨 to last me the next three years.
March 19, 2025 at 4:20 PM
On AI:

Today I attended my son's first parents' evening at his school. He’s just wrapped up the first half of his initial year and everything seems to be in order. His teacher mentioned that he occasionally struggles with forming some letters of the alphabet. 🧵
February 7, 2025 at 6:57 PM
Great conversation—I enjoyed every single minute, as many of the moments resonated with me, since I see myself as just one thread too. Prioritize each aspect of your work based on your energy level, and you may discover peace even in such a challenging yet truly fascinating industry.
Had a wonderful chat with Adam Wulf who's behind the inspiring local-first Muse.

We talked about what it takes to build software as a "team of one" and other local-first related topics including analytics and the Apple ecosystem.
Episode #20 is out.

Adam Wulf (@adamwulf.bsky.social) on the evolution of Muse, life as a solopreneur and analytics in local-first applications.

Full episode links and show notes in the comments.
February 6, 2025 at 6:28 PM
Reposted by André König
“Craft’s truth emerges only through the friction of material engagement.”

This piece by Ryo poetically captures the nature of my journey through the last 4 years crafting both Overtone and LiveStore.

Must read for any creative out there! 10/10

ryolu.notion.site/how-to-make-...
https://ryolu.notion.site/how-to-make-something-great
t.co
December 23, 2024 at 10:42 AM
Reposted by André König
Episode #18 is out.

James Arthur (@thruflo.com) on ElectricSQL, read/write-path syncing and PGlite to run Postgres everywhere via WASM.

Full episode links and show notes in the comments.
December 3, 2024 at 1:14 PM
Thoughtful Engineering:

We all appreciate elegant abstractions and intuitive APIs, yet there's a common mantra warning against "overthinking" and "over-engineering". However, I believe this perspective is "overly simplistic".
December 1, 2024 at 2:20 PM
Reposted by André König
Really excited to kick off the Cause & Effect podcast!

The goal is to share the stories of various companies and projects building production-grade applications with Effect.

I hope you like it - as always, would love to hear your feedback!
How Zendesk incrementally adopted Effect in a polyglot environment with a large codebase.

Cause & Effect Podcast with Attila Večerek – hosted by @schickling.dev

Give it a listen and let us know what you think about their approach!

www.youtube.com/watch?v=rNAq...
Adopting Effect at Zendesk with Attila Večerek | Cause & Effect #1
YouTube video by Effect | TypeScript at Scale
www.youtube.com
November 26, 2024 at 4:55 PM
Reposted by André König
LiveStore 0.2.0 (in early access):

◆ Schema-aware query builder for SQLite
◆ New example app: Linearlite for Expo
◆ Type-safety improvements & bug fixes

See GitHub for early access: github.com/livestorejs
November 22, 2024 at 1:18 PM
After working with LiveStore over the past months, I can't express how excited I am about this release!

The DX is great, the vision is superb, and the sustainable development model behind the project is amazing.
Give it a try; you'll experience a fun ride!
LiveStore is the data layer I wish I had when working on mobile apps: Reactive, fast and fun to use!

After many months of close collaboration with the folks at @expo.dev, I'm very excited to take a big step towards launching @livestore.dev.
expo.dev Expo @expo.dev · Nov 21
🥳 Launch Party day 4: Introducing LiveStore - a local-first data layer built on SQLite for high performance apps.

The creator of LiveStore is @schickling.dev (former @prisma.io) and he's opening up early access to LiveStore today! Check out his blog post for the details: expo.dev/blog/local-f...
November 21, 2024 at 6:36 PM
The WOFR ("Works On First Run") rate is high with @effect-ts.bsky.social

I have never experienced anything similar before.
November 15, 2024 at 9:04 AM
In my current project, I established a pattern that turned out to be quite handy:

Encoding the entity type within the ID.

Product IDs get a `pro_` prefix, tenant IDs use `ten_`, and so on.

This allows me to quickly identify the type of the entity just by looking at its ID.
November 13, 2024 at 6:14 PM
I think there is huge potential in building an @effect-ts.bsky.social -based web framework.

First, we could start with a thin layer that only takes care of the "controller part". This would involve the following aspects:
November 11, 2024 at 2:01 PM
VB6 and later VB.NET were my gateway to software engineering, and seeing this brings back memories!

bandysc.github.io/AvaloniaVisu...
AvaloniaVisualBasic.Browser
bandysc.github.io
November 11, 2024 at 11:09 AM
My ToDo List Provider: The TypeScript Compiler.
November 9, 2024 at 6:25 PM
Am I really building an abstraction on top of Remix with @effect-ts.bsky.social?
November 8, 2024 at 3:47 PM
I believe in a future where creators can sustainably earn a living by sharing their work online. The Internet is the largest distribution channel humanity has ever seen, yet we need better ways for people to directly support creators.
November 8, 2024 at 10:48 AM
First reaction: 😱
Second reaction: We'll get through it. Keep going 💪🏽
November 6, 2024 at 9:10 AM
Because using .kube/config in GitHub Actions is still a thing, I thought it might be time for a reminder that there is a more secure way to deploy services to Kubernetes: andrekoenig.de/articles/kub...
Securely Deploy to Kubernetes using GitHub Actions
andrekoenig.de
May 14, 2024 at 6:18 AM
Want to have a Kubernetes Cluster for 10 € / month that runs your side projects?

I set it up for you and guide you through the whole process. For free. No strings attached.

Might be a little bit unconventional, but I want to share my knowledge and help beginners get an introduction to this area.
May 8, 2024 at 6:30 PM
I was tired of copying and pasting GitHub Actions workflows from old projects when starting a new project. That is why I built a first version of a central hub for installable workflows: getactions.dev

Curious to hear your feedback 🤗
GitHub Actions Starter Workflows - getactions.dev
getactions.dev
May 8, 2024 at 11:41 AM
"This service could run on a 5$ VPS."

While the sentiment is true, what happens when you have actual users and your little server can't handle the workload anymore? Most cloud providers don't support scaling vertically without downtime. That said, you have to be prepared for such a situation. 🧵
May 6, 2024 at 5:20 PM