๐๐ป๐ป๐ผ๐๐ป๐ฐ๐ถ๐ป๐ด ๐๐ต๐ฒ ๐ฃ๐ผ๐๐ฒ๐ฟ๐ฆ๐๐ป๐ฐ ๐๐ ๐๐ฎ๐ฐ๐ธ๐ฎ๐๐ต๐ผ๐ป ๐ค๐งโ๐ป
We are hosting a virtual hackathon where the challenge is to build innovative AI-powered software using PowerSync as a sync engine.
more than you want to know: docs.powersync.com/handling-wri...
Great to have Dev on the team. I've already learned so much from him since he joined, and I'm looking forward to him sharing many rich learning experiences with the @powersync.com community.
Central sync engine icon connected to many tech logos (databases, languages, frameworks) on a green gradient background.
What if you could get all the benefits and capabilities of modern sync engines without giving up your existing tech stack?
Learn more about how PowerSync makes building modern and agentic applications simple in our latest blog post โUnleashing the Power of Syncโ
๐งต Could Bitchat have 5x the range and 100x the throughput for the same power expenditure? I explored how Wi-Fi Aware could improve the reliability and throughput of Bitchat and mobile ad-hoc networks in the absence of internet connectivity. #bitchat
๐
Cool, which backend database and client framework are you using?
๐ฅ๐ฅ๏ธ
Doesn't look like you got many bites, but happy to try put you in touch with some relevant customers
A low-hanging fruit use case for offline-first is notes - I might be unable to access the cloud, but my offline-first note taking app (@noteplan.bsky.social) still works and I can be somewhat productive & collaboration is optional.
On the opposite end of the spectrum is something like Door Dash.
Morning run in mountains at 11k feet
My team is hiring for someone to work alongside me doing lots of fun things with mobile apps. Don't get too warded off by the JS because we've got a lot of very modern Swift and Kotlin to write. #FediHire #swift
It was agonizing to choose from among the 34 excellent submissions, but here are the four talks selected from our CFP process!
We are alarmed by reports that Germany is on the verge of a catastrophic about-face, reversing its longstanding and principled opposition to the EUโs Chat Control proposal which, if passed, could spell the end of the right to privacy in Europe. signal.org/blog/pdfs/ge...
Our Discord is also a good place to get help from our engineers, a bit easier sharing code snippets there!
```yaml
bucket_definitions:
<snip>
batches:
parameters: SELECT product_id as product_id FROM products WHERE products.team_id = request.team_id()
# Data Query
data:
- SELECT * FROM batches WHERE batches.product_id = bucket.product_id
```
could you try that?
Sorry about the slow reply ๐
If I'm understanding correctly, something like this might work:
Perhaps, but not following this part:
> The โteam_idโ for batches is determined by the product_id and then by the product.
Could you clarify "and then by the product" ? Is there another column on the product table that filters batches?
Unfortunately views are not included in Postgres replication streams, so we can't sync from them :(
care to share any details on the problem you were having with the sync rules? happy to help figure out whether sync streams would solve it
I would love to get back into Pomodoro... Let me know if you ever need Testflight guinea pigs!
@andygeers.bsky.social wrote this: www.geero.net/2025/01/rewr...
(Hi Andy!)
Might be time to migrate off Amazon Goodreads
Veilid ftw
Dark
Dark
Proof of concept integration between the @powersync.com Swift SDK and Structured Queries by @pointfree.co
Should be able to ship this :)
github.com/powersync-ja...
๐ฅ
