Title: docs(react/powersync): document sync-stream SQL footguns by sravan27 · Pull Request #467 · TanStack/cli · GitHub
Open Graph Title: docs(react/powersync): document sync-stream SQL footguns by sravan27 · Pull Request #467 · TanStack/cli
X Title: docs(react/powersync): document sync-stream SQL footguns by sravan27 · Pull Request #467 · TanStack/cli
Description: What Adds a "Known Footguns" section to the PowerSync add-on README covering four silent-row-loss bugs in the upstream PowerSync sync-rules engine that affect any starter generated by this add-on, until the upstream fixes ship. Why The PowerSync add-on package.json pins @powersync/web ^1.26.1. The sync-stream SQL evaluator in PowerSync up through that version has four operator implementations that disagree with the SQLite that runs on the client — bucket keys silently diverge and rows fail to sync without any error or log line: JOIN in sync streams silently syncs zero rows (filter compilation does not track joined tables → silent degenerate filter). upper() / lower() use locale-aware Unicode case folding (length-changing on ß, fi, Turkish i) where SQLite is ASCII-only. length() returns UTF-16 code-unit count where SQLite returns Unicode code points (2x divergence on emoji, CJK Extension B-G). substring() / substr() slices by UTF-16 code units and can return unpaired-surrogate strings. The fixes are open upstream: powersync-ja/powersync-service#662 (JOIN — surface as loud error) powersync-ja/powersync-service#663 (ASCII case folding) powersync-ja/powersync-service#664 (length() code points) powersync-ja/powersync-service#665 (substring() code points) Until they land in @powersync/service, this add-on quietly generates starters that will silently lose rows if user data contains any non-ASCII characters or any JOIN gets written into sync-rules.yaml. The README addition documents that explicitly with workarounds. Maintainer note Disclosure: I authored the four upstream PRs linked here, plus four already-merged sync-rules fixes in the same engine. silentdrop is an open-source MIT correctness checker I built that catches this class of bug across JS DB layers. Happy to remove the silentdrop link if you prefer the section be vendor-neutral. This is documentation-only — no code change in the generated app. Summary by CodeRabbit Documentation Added "Sync Stream SQL — Known Footguns" section documenting SQL behavior mismatches between server and client, including unsupported JOIN clauses and operator inconsistencies across execution boundaries.
Open Graph Description: What Adds a "Known Footguns" section to the PowerSync add-on README covering four silent-row-loss bugs in the upstream PowerSync sync-rules engine that affect any starter generated by thi...
X Description: What Adds a "Known Footguns" section to the PowerSync add-on README covering four silent-row-loss bugs in the upstream PowerSync sync-rules engine that affect any starter generate...
Opengraph URL: https://github.com/TanStack/cli/pull/467
X: @github
Domain: github.com
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react-reconciler,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@d5750093facf |
| route-pattern | /:user_id/:repository/pull/:id/files(.:format) |
| route-controller | pull_requests |
| route-action | files |
| fetch-nonce | v2:9a523df3-d402-71e4-f91f-e70d0c2e1e63 |
| current-catalog-service-hash | ae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b |
| request-id | B7D2:319B30:172A02:209FDD:6AF9A0F4 |
| html-safe-nonce | 70901fd805133bb2c68f46ece62340fe43c3fa997b64f0ee92e2d741b247c60f |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCN0QyOjMxOUIzMDoxNzJBMDI6MjA5RkREOjZBRjlBMEY0IiwidmlzaXRvcl9pZCI6IjgxMzM4OTg2NzYxMzAwNDAyMCIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 28eed345f96b9d936b4accdb122a7183498849d754698f73e88fb73ada4bb7ff |
| hovercard-subject-tag | pull_request:3818373680 |
| github-keyboard-shortcuts | repository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/TanStack/cli/pull/467/files |
| twitter:image | https://avatars.githubusercontent.com/u/24377016?s=400&v=4 |
| twitter:card | summary_large_image |
| og:image | https://avatars.githubusercontent.com/u/24377016?s=400&v=4 |
| og:image:alt | What Adds a "Known Footguns" section to the PowerSync add-on README covering four silent-row-loss bugs in the upstream PowerSync sync-rules engine that affect any starter generated by thi... |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 612d3e6ffd693e7ea8d9fcf452370995872baef31d825b1fedef704cd3d24ac7 |
| turbo-cache-control | no-preview |
| diff-view | unified |
| go-import | github.com/TanStack/cli git https://github.com/TanStack/cli.git |
| octolytics-dimension-user_id | 72518640 |
| octolytics-dimension-user_login | TanStack |
| octolytics-dimension-repository_id | 932949058 |
| octolytics-dimension-repository_nwo | TanStack/cli |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 932949058 |
| octolytics-dimension-repository_network_root_nwo | TanStack/cli |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | true |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 072e34035c13c31543fba9f025cbbbda4210dae4 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width