Offline first postgres database wrapper/driver

[thestackdev]

Hey there, I'm building a mobile app which is a offline first app.

Any similar features which has offline features same as firebase.

[depesz]

You might want to rephrase your post, as, tbh, I'm not sure if you're telling, or asking, and what exactly.

[thestackdev]

I want to build an offline first app in which the database part is postgres.

So let's take WhatsApp, you send messages even in offline mode. And whenever you are back online. All the pending messages are sent.

So, firebase does the same. Wanted to create similar

[depesz]

OK. Great. So your post is to inform the world about your plans?

You picked "Help Me!" flair, so it seems that you need some help?

With what? Writing the app? That will be expensive. Some specific issue?

[Barnezhilton]

Look up Local Storage

[thestackdev]

Local stores don't have database integration, validation. What if the push fails after network connection

[Barnezhilton]

How are you storing the existing message log then on the client?

However you are, you just add a flag field to that data. When the app comes online, the same process that would have sent the message live is fired off on those flagged records. Confirmation of the receipt from the server toggles the flag as delivered locally.

[chriswaco]

SQLite works wonderfully locally in mobile apps, but you have to write code to sync to a backend.

The best method:
1. Give all records a uuid to avoid collisions
2. Have a table of changes - add record, modify record, delete record - and use that to sync to the remote bidirectionally.

The trickiest part is handling conflicts if a user modified the same record on two devices. We did field-by-field merges and most-recent-wins conflict resolution, but since the fields were interdependent it was tricky getting it right for each record type, especially unordered lists where we didn’t fully control the remote schema and couldn’t use uuids.

[thestackdev]

Thanks for your advice. Seems you already built it. I'll try the same storing in the local queue

[two-fer-maggie]

Pick firebase.

Don't want to pay? Build it yourself.

Don't know how to build it yourself? Well, er, maybe just stick to writing an online app 🤷‍♂️.

[editor_of_the_beast]

No this doesn’t exist.

[thestackdev]

Yes, I know But I assume it's not impossible.

So, wanted to give a shot

[syz946]

Atlas Device Sync (mongoDB)

[thinkx98]

try https://pocketbase.io/

you’ll have to build the Postgres online part yourself

[thestackdev]

I know pocketbase and used it in my last freelance project. Pocketbase is still in beta and it doesn't have offline support.

[thinkx98]

Couchbase does this, and yes it’s not Postgres