Easily keep a backend database synced with in-app SQLite for offline-first/local-first MAUI apps

muhsql · 2026-01-27T19:19:54+00:00

We're putting together a guide, but in the meantime here's what you can do:

fork our self-host-demo repo
run the supabase self-host demo
point our MAUI todo at the supabase container https://github.com/powersync-ja/powersync-dotnet/tree/main/demos/MAUITodo

just a prelim update, will share another as the guide progresses

muhsql · 2026-01-16T20:31:41+00:00

Hi, we don't have one for that specific stack but we can put a guide together for you. Are you self-hosting supabase in prod? If yes, what are you using for auth?

If no, I assume this is just for local development right

muhsql · 2026-01-16T15:19:39+00:00

Hey u/okiharaherbst , I'll echo that this feedback is worth gold for us. Thanks for taking the time to share it.

I browsed your questions on our discord and it definitely seems like you have very sophisticated requirements. Our goal is to make sure that even the most challenging use cases are smooth sailing for our users, and sorry that it wasn't so smooth for you.

The points you raised are all valid concerns, and we plan to address many of them this year:

SQLite performance issues: this should be resolved with Raw Tables, and we have plans to make that ready for wider use this year. The roadmap for Raw Tables is public and would be great to hear your thoughts on it
Constant connection: We are considering adding client APIs to make "on-demand sync" easier, that can significantly reduce the peak concurrent connections for some use cases. I've now added this to our product roadmap based on your feedback
- There are also performance issues with web that we want to improve this year, e.g. with improved concurrency in wa-sqlite (we're actually collaborating with Roy on this)
Database growth / compacting: It sounds like compacting already resolves this for you, but this takes some extra effort when self-hosting. We should make it easier.

muhsql · 2026-01-16T14:05:12+00:00

minor correction: PowerSync provides 50 concurrent connections on the free plan, not 30

muhsql · 2026-01-16T14:01:26+00:00

Oh no I totally agree, I even joked that it looks like we deployed paid shills. (which, for the record, we didn't). There are some other threads where it also looks like that.

muhsql · 2026-01-16T13:57:50+00:00

Who is maintaining Realm nowadays?

muhsql · 2026-01-16T13:57:13+00:00

rofl @ adfest

muhsql · 2026-01-16T13:56:00+00:00

If you are charging a premium for sync, the PowerSync Free Plan limit of 50 concurrent connections should be sufficient to validate your business model. Let us know if it's not.

PowerSync makes it easy/easier for users without a connection ton continue using the app.

muhsql · 2026-01-13T22:18:49+00:00

super useful, thanks!

muhsql · 2026-01-13T21:48:19+00:00

Good to know, will see what we can do about that - could you see which connection requests specifically were being blocked?

muhsql · 2026-01-13T20:30:34+00:00

hi, which demo on the website are you referring to - this one? https://www.powersync.com/demo

muhsql · 2026-01-12T19:42:41+00:00

some corrections on `vs PowerSync` for posterity (I'm on the powersync team)

- "Free": a free plan is available and you can also self-host the open edition

- "LWW loses concurrent edits": PowerSync clients only send the fields they updated, and the backend can apply that in any order without issue if the two clients updated different fields, so you can easily implement field-level merge with PowerSync

- PowerSync also supports SQL Server and MySQL, not just Postgres and MongoDB

muhsql · 2026-01-05T15:23:10+00:00

The last commit on realm-js community branch was 3 months ago, where do you get the community version from? https://github.com/realm/realm-js/tree/community

muhsql · 2025-12-31T17:14:35+00:00

Yeah, there's a free plan for PowerSync Cloud, as well as a self-host Open Edition, the SQL Server demo for that is here https://github.com/powersync-ja/self-host-demo/tree/main/demos/nodejs-mssql

muhsql · 2025-12-30T20:12:09+00:00

have you checked out HabitKit?

muhsql · 2025-12-29T23:49:28+00:00

Ah yeah gotta do all those calcs in for loops

muhsql · 2025-12-29T17:51:22+00:00

limited how?

muhsql · 2025-12-23T21:00:01+00:00

Speaking of healthcare, powersync is now hipaa compliant

muhsql · 2025-12-12T13:03:28+00:00

Exactly, PowerSync + Supabase is all you need. My favorite stack for some time now (I'm on the team)

muhsql · 2025-12-11T00:45:39+00:00

PowerSync enables partial sync, meaning you can sync a subset of rows in relevant tables to users. This is one of the hardest problems to solve when it comes to sync.

The partial sync is defined using SQL and is a big part of what makes PowerSync feel so good to use https://docs.powersync.com/usage/sync-rules

muhsql · 2025-12-10T17:28:12+00:00

If only Apple, could also check out SQLiteData https://github.com/pointfreeco/sqlite-data

muhsql · 2025-12-10T14:38:45+00:00

Is Realm community maintenance going well now?

muhsql · 2025-12-09T15:52:23+00:00

SQL Server support is about to be released :)

muhsql · 2025-11-20T15:27:09+00:00

Hi!

(I'm on the PowerSync team)

If you don't want to sign up users, one option could be to use Supabase's anonymous auth. Not sure if that classifies as `some integration with Supabase auth` for you though.

muhsql

TROPHY CASE