serverpod-offline-sync/test/serverpod_offline_sync_test_server
Repository files (latest commit first)
Filename Latest commit message Latest commit date
Tizian 「ティツィアーン」 012d94d0ca
perf: Skip the projection pass for merged deletes nothing visible outlives
A merge that deleted anything ran the full projection pass, whose closure
follows foreign keys both ways and so loads every row connected to the
deleted ones. A device deleting a card with its revisions, tags and
reviews cost each device receiving it about 4 s, and the server merging
the push about 5.4 s, in a library of 8,000 cards whose tags join it.

A device deleting a row locally tombstones everything visible below it,
so its batch carries those deletes along. What the pass could still
decide is a row below that the deleting device never saw, inserted here
meanwhile, which it hides by cascade. A batch that only deletes (none
restoring) now leaves the pass out when the deleted tables cascade only,
by the same rules as a local delete (_deletesOnlyCascade, shared with
canSkipProjectionAfterLocalDelete now), no attempted value is pending in
the connected tables, and every visible row below a deleted one, found by
walking down the cascades alone, is deleted by the same batch
(canLeaveProjectionUnchangedByMergedDeletes). A batch both inserting and
deleting, or restoring, takes the pass as before.

Measured on PostgreSQL: such a card delete merges in about 35 ms instead
of 5.4 s; received on a device, 99 ms instead of 4 s. The new tests
cover a leaf deleted through the shortcut and a middle row's delete,
which isn't eligible, hiding its children by the pass; in the app's sync
tests a card deleted while another device rated it declines the shortcut,
and dropping the walk's check fails that test. The core, server,
integration and simulation suites pass, but for two PostgreSQL tests
that can't start their database while another embedded PostgreSQL runs.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-10-17 22:10:53 +02:00
..
.test_databases test: Add a DST and tests reproducing found failures (#110) 2026-09-04 13:09:20 -03:00
bin refactor: Replace drift by serverpod as core engine (#33) 2026-05-03 09:09:23 -03:00
config fix: Preserve shared model and SQLite value types during sync (#118) 2026-09-16 00:07:51 -03:00
lib fix: Author the column default an upsert writes for a null foreign key (#164) 2026-10-08 22:48:47 -03:00
migrations fix: Author the column default an upsert writes for a null foreign key (#164) 2026-10-08 22:48:47 -03:00
test perf: Skip the projection pass for merged deletes nothing visible outlives 2026-10-17 22:10:53 +02:00
.gitignore refactor: Move the core implementation to the shared package with no manual queries (#107) 2026-08-04 11:04:04 -03:00
analysis_options.yaml feat: Implement the sync protocol (#54) 2026-05-29 01:54:23 -03:00
CHANGELOG.md refactor: Replace drift by serverpod as core engine (#33) 2026-05-03 09:09:23 -03:00
dart_test.yaml test: Harden DST authored-state checks and workloads (#123) 2026-09-17 10:39:07 -03:00
pubspec.yaml fix: Prevent web deadlocks in transactional membership reads (#161) 2026-10-08 19:00:44 -03:00
README.md refactor: Replace drift by serverpod as core engine (#33) 2026-05-03 09:09:23 -03:00

serverpod_offline_sync_test_server

This is the starting point for your Serverpod server.

To run your server, you first need to start Postgres and Redis. It's easiest to do with Docker.

docker compose up --build --detach

Then you can start the Serverpod server.

dart bin/main.dart

When you are finished, you can shut down Serverpod with Ctrl-C, then stop Postgres and Redis.

docker compose stop