PowerSync in 100 Seconds

PowerSync is a self-hostable sync layer for local-first apps. It connects to any Postgres and keeps local SQLite databases in sync in real-time.
#programming #compsci #sql
- website www.powersync.com
- docs docs.powersync.com/self-hosti...
🔖 Topics Covered
- What is local-first?
- What is PowerSync?
- PowerSync self-host quickstart tutorial
h/t ‪@Fireship‬

[@justafreak15able]

lol baiting with fireship thumbnails

[@timothyshiu2263]

Awesome! 👏
PowerSync will be widely used in all full-stack apps. Looking forwards to release 1.0!

[@kobiebotha9868]

Thanks for the feedback! PowerSync Cloud is at v1/stable, but I assume you're referring to the self-hosted version.
For our self-hosted version: under the hood the sync service tech is actually v1/production ready. We're just working on improving the overall developer experience, fleshing out our docs and deployment guides, etc. before we mark it as v1. So the tech can be considered v1, but the developer experience might still be a bit bumpy for a week or two. Hope that makes sense!

[@sandwidimohamed4914]

I was want to use but I let cloud version for pricing, after computation , price can some time high, else I really like your product

[@YusifArbile]

I love the idea of PowerSync yet till up now it’s hard to integrate in existing projects.
For example I have a backend using Prisma ORM, and front end in Flutter with Drift sqlite wrapper.
I tried for days to integrate PowerSync and I didn’t come up with a solution.
Drift-PowerSync package is promising, yet it’s in early stages.
I hope the documentation mentions integrating PowerSync with existing ORMs like Prisma

[@powersync_]

We're happy to help solve any issues you're running into and hear your feedback. Our Discord server is the best place for this but let us know if you prefer a different way to discuss.

[@StabilDEV]

how does powersync relate to replicache?

[@ApexGaara]

Does this also sync transactional Operations for example through supabase if im using an database view/operation

[@kobiebotha9868]

Hi, I'm not sure I understand your question - how are you using views exactly?
Our client SDKs do support transactions and the sync protocol provides consistency.

[@ApexGaara]

@@kobiebotha9868 i meant supabase postgres functions and transactions and these for example can be used as reusable "views"

[@antonperelygin2833]

looks like ElectricSQL

[@powersync_]

The product is similar but there are notable differences, e.g. PowerSync's non-invasive architecture. Read more here; www.powersync.com/blog/electricsql-vs-powersync

[@justiceessiel6123]

Sell us the sizzle not the steak​@@powersync_

[@StoriesWithGR]

Nice Fireship - y style! And a really good Product Idea!!!! Btw you've credited @fireship as h/t. What does that mean exactly? Sorry for my ignorance 🙈

[@powersync_]

H/t is an abbreviation for "hat tip". We use it to give credit or acknowledge the original source of an idea.

[@StoriesWithGR]

@@powersync_ Beautiful!