วีดีโอ

I'm getting a blank white blank screen when I run the flutter app

Mine failed Publication powersync not found

I followed the flutter path and I was getting a white screen screen on the android emulator when I run flutter run

FYI, the order and detail of this video is now out of date. for Supabase connection settings you need to unselect 'show pooler'. also, the 'test' button on connection now checks that the powersync publication has been created so I guess that needs to happen first. the documentation order is correct.

How do I create publication for functions publication powersync: create publication powersync for function public.MyFunction();

** Note: some of the syntax shown in this video has changed, see the GitHub README: github.com/powersync-ja/self-host-demo

** Note: some of the syntax shown in this video has changed, see the GitHub README: github.com/powersync-ja/self-host-demo

Video is not updated, we have to go into demos and run it.

5:58 if you flatten before a client has received the changes then wouldn’t it go out of sync?

Good god, I am sold, ive been tweeking with rxdb and watermelon db this past week, I'll just use this and concentrate on what's important

So true. It has been so hard to build your own offline sync engine that the industry almost forgot about this whole concept. Now that good sync technology is ubiquitous (with PowerSync being one), it becomes more than a no brainer. Building a form that changes dynamically based on a backend change is also pretty mind blowing to a user.

does this work with firestore db?

I think you should support DuckDB on the frontend

Even though thumbnail, graphics, and title say "Fireship", the video is too short for an actual "in 100 seconds" Fireship video! 🤔

Awesome

I have an app that saves data to appstate. Can I use this? Or is this only for SQLite?

Hold up, this isn't Fireship

not good click baiting use with fireships style

Looks like a nice solution.

Please use a bigger font next time so we can watch the video on mobile. Thanks !

why does the content begin 30 seconds in

fireship knockoff

Damn didn't even realize I was not watching a video with 1M+ Views. Great Content <3

You clearly have talent and a keen choices about videos. Why are you trying to be a fireship clone?

Great production! Hope you blow up

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

lol baiting with fireship thumbnails

pretty sweet! hacking through and prediciting my future... any way to have a "powersync" code generator that has the .powersync already prepended? Definitely gonna much that up as this starts to get bigger...

how does powersync relate to replicache?

What kind of shit is this? The screen is so small that you can't see anything!

i'm building a web application where a admin/user can login and see dashboard. .i have existing database. i only want some limited info on the user side to appear when no internet is ther. Can i only add PowerSync to some tables of the database only on user login side?

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 🙈

looks like ElectricSQL

i previously tried to link it using the other method and was not succesful, I used sqlite only but now I will retry with this method that looks a lot easier. This solve exactly my problem as im doing a grocery list, I want users to be able to access the list but we also want to know what people have in their lists. Thank you guys great job !

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

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

Does this work using the Web Test Sessions? The SQLite Integration in Flutterflow does not support Web so neither can you test if youre on a free plan

i am getting this error when i am connect it to supabase "Supavisor does not support logical replication. Connect directly to the postgres instance."

Thank you

Thanks! Looking forward to see the easter egg being announced!

That's really awesome! Looking forward to start using this for my next project. Do you have any suggestion how to handle sync of media uploads. e.g profile picture in the user table? Thanks in advance

It's a great piece of software! I'm currently experimenting with it and it works really well, super reliable. I'll most likely end up as a paying customer :). It has some rough edges but I believe these will get smooth over time. One thing I couldn't get to work is the Kysely wrapper in JS. Whenever a query is executed it either gets executed once and the PowerSync connection gets terminated or it doesn't send the query to the PS service at all and terminates the connection. What I ended up with is I use wrapPowerSyncWithKysely to enable type safety features, I compile a type safe kysely query and pass it to the raw powerSync.execute(). I spent some time debugging the issue but it's some kind of race condition - sometimes it get's to the connector.uploadData method and sometimes it gets terminated even before it. powerSync.closed is set to true every time wrappedPowerSync.query[...].execute() is called.

if you are using supabase why still need powersync, supabase already has realtime database ,right? just like firebase

Thanks, great overview.

Your accent sound south african 😂 are you?

Thank you 💯💯💯

It says Publication 'powersync' not found when Testing connection in PowerSync, have tried many ways to resolve the issue with no success, almost no docs as well. Minute 6:53

Awesome guys. Useful for my use case, for farmers in low connectivity area.

How is this different from SQLite provided natively in FlutterFlow?

great tutorial, thank you very much, would like to see a similar tutorial for expo react native though, that would be awesome =)