Skip to content

v0.9.0

Choose a tag to compare

@github-actions github-actions released this 08 Nov 21:09
· 1044 commits to main since this release

Changes

  • Safe fetch: hand every checked address to happy eyeballs (9825f3a)
  • Visual baselines from ubuntu-latest (7a6b8ee)
  • README: workflows in the feature list (#168) (611cc5d)
  • README: PostgreSQL, Redis and cluster mode as options next to SQLite (1ae674d)
  • Tests: the SFTP test server takes a host key ssh2 can parse (43b5a4d)
  • Help docs: regenerated (draw.io maximize, diagram page) (7f21b86)
  • draw.io: maximize the editor, "Diagramm-Seite" template (#110) (d8ef189)
  • Workflows (#168): approve and reject from the apps' push notifications (0f21531)
  • Workflows (#168): wake the other instances only after the commit (01ec17c)
  • Workflows (#168): spec – wave 3 contract (11.7) and its deliberate deviations (c64eede)
  • Workflows (#168): French "par ex." in the sender hint (2fba5bb)
  • Workflows (#168): help docs regenerated with the workflow pages; the node reference checked against the catalogue (98afa9f)
  • Workflows (#168): wave 3 texts in French and Chinese (2ec43c1)
  • Workflows (#168): wave 3 interface – start screen with templates, AI builder, import/export, workflow button, phone fixes (0f08ccf)
  • Workflows (#168): dry runs of the templates with sample data succeed (f5c98d5)
  • Workflows (#168): wave 3 API – REST routes, OpenAPI and SDKs, MCP tools, export/import, button rights, instance move (a04306a)
  • Workflows (#168): wave 3 templates and AI builder (server) (d650651)
  • Workflows (#168): spec – wave 2 contract (11.6) and its deliberate deviations (651c139)
  • Workflows (#168): wave 2 texts in French and Chinese, English server messages (0abefd1)
  • Workflows (#168): system dark mode for the workflow colours, no clash with the global .error class, chips' filters in the flow of the panel, labels of recipients (70fd940)
  • Workflows (#168): wave 2 editor – new node forms, approvals, versions, chips, changes, retry, tablets (0decdf0)
  • Command palette: "Show introduction" uses a compass, the sparkle stays the AI sign (d75e64d)
  • Help docs: regenerated (Ask AI sources) (ef08a28)
  • Workflows (#168): security review of wave 2 – fixes with tests (907b1b8)
  • Ask AI: only the cited sources as chips, the others behind "n weitere Quellen" (#180); AI icon on "Propose actions" (f2a8c57)
  • Workflows (#168): wave 2 node tests – logic, AI with a mock model, HTTP/SSRF, webhooks, inbound mail, e-mail, chat, journal (056d77a)
  • Workflows (#168): wave 2 engine – switch, for each, wait, approval, AI, HTTP, e-mail, chat, inbound triggers (f833ad3)
  • Workflows (#168): undo survives React's double effects, keyboard in the browser spec (2d2c1cb)
  • Workflows (#168): rules open in the canvas, admin limits, shortcuts, French and Chinese (6d45a6c)
  • Workflows (#168): the editor – canvas, palette, panel, picker, list, runs (c940602)
  • Admin, accounts: the filter pills are no longer cut off at the bottom (fe2a547)
  • Workflows (#168): the instance that claimed a step is no account (51a1a5a)
  • Workflows (#168): API contract and decisions in the spec; snapshots of drafts; no import cycle (4c769bb)
  • Workflows (#168): notification kinds, i18n (fr/zh complete), "Statusregeln und Erledigt" (f27baaa)
  • Workflows (#168): cluster test – three instances, one killed hard, bus wake-ups, one schedule event (399e79c)
  • Workflows (#168): exactly-once test with four workers and stolen leases (d0dd72f)
  • Workflows (#168): the page kind across the server – tree, search, sharing, archive, export (9f7d5a7)
  • Workflows (#168): node tests for the engine, the page kind and the pure parts (0833a4b)
  • Workflows (#168): schema 97, graph format, catalogue, placeholders, engine and queue (830f068)
  • Quick capture (web): the preview names shorthand and links the AI changed or removed (#172) (0200d06)
  • Help docs: regenerated (journal completed records and AI summary, code copy, capture "Improve text", option renames, CSV of the view, date filter time zones) (acab8d5)
  • French: typographic apostrophes in the journal AI summary texts (138c5ef)
  • Journal: "Alle / Nur meine" for the records completed below a day (#169) (6e1947a)
  • Option renames: versions keep the settings, linked views and subgroups follow (#173) (dfd9cec)
  • Quick capture: "Text verbessern" with AI, shorthand kept (#172) (790ae1b)
  • Workflows (#168): design specification, draft for review (c9a115e)
  • CSV export: write shared and empty titles by name, never as ids (#174) (0885b87)
  • Journal review: "Mit KI zusammenfassen" for the selected week or month (#170) (e835359)
  • Journal: "An diesem Tag erledigt" below each day (#169) (666e387)
  • AI answers: code blocks get their own copy button (#171) (8ebd856)
  • /issue skill: ask the maintainer for issue images that can't be downloaded (d6a9ef3)
  • Date filters read timestamps in the condition's time zone (#176) (598ec7d)
  • /issue skill: propose "won't implement", check old and closed issues for new comments (86507ec)
  • Visual baselines from ubuntu-latest (1a0308c)
  • Tests: the AFFiNE backlink spec waits for the imported page to open (99bebe3)
  • Browser specs: catch up with the current app (498ad8a)
  • Survey builder: one column on phones again (a951242)
  • Databases: text cells can be edited offline again (ee4c7ff)
  • Editor: a click on a page link opens it while something else is selected (74d64ff)
  • Code blocks: the language search works inside records (cf9a67a)
  • Tests: on phones a page opened from the drawer comes without a view transition (339b5b6)
  • Page tree: the menu a long press opens stays open when the finger lifts (303a51e)
  • Phones: the formatting buttons above a record's text get 44 px as well (981a0a1)
  • Tests: the record's text property is a formatted-text field in the hide-keyboard spec (7495b40)
  • Stale-copy check: cancel the unread body of the health request (ffda18a)
  • Database search: an empty field folds only after the press that took its focus (3dbd95f)
  • Tests: open relation records through the title cell's button (8b6a887)
  • Journal and settings confirmations no longer show as errors (aef85f5)
  • CSV export of a view writes its columns, and people and records by name (4d81344)
  • Renamed select options take their records, filters and database rules along (65bbcc5)
  • Formula and diagram dialogs: follow the node through its Yjs element; a save is an undo step of its own (12debea)
  • Tests: a version chosen from the history is the one restored, on both databases (76a6a0b)
  • Whiteboard: one undo step per gesture or command; frame order keys work from the current order (b20b05e)
  • Drags: the next press ends the swallowing of the drag's click (d5de27a)
  • Formula and diagram dialogs find their node again after a remote edit redraws its block (a1f8aa5)
  • Test: the cached semantic neighbours are checked by identity, not by counting event loop turns (load-dependent on PostgreSQL) (697c65a)
  • Help docs: regenerated (Windows Hello in the desktop app, long press to drag, AFFiNE nesting) (2d2080e)
  • AFFiNE import: documents with exactly one backlink go below the linking document (#167) (f55d344)
  • Touch: drag handles lift only after a long press (#166) (9eb0f3c)
  • PostgreSQL: published pages render again (e688b4f)
  • Sign-in: passkeys in the Windows desktop app's window (#165) (594f048)
  • Help docs: regenerated (Forgejo issue sync, security fixes, data folder check) (94dcc84)
  • Security: unverified custom-domain claims expire after 7 days (fbcb6f8)
  • Share links: a guest save keeps PDF blocks (0b6e0fd)
  • Security: MCP list_pages names no page of a journal behind a PIN (4b38de2)
  • Security: membership changes and per-account limits take turns on PostgreSQL (01c5b0a)
  • PostgreSQL restore: run no SQL of the dump, only its rows (6225ab2)
  • Security: custom domains are verified only by their DNS TXT record (c6d6172)
  • Security: the LDAP directory only for people of the organisation, attributes from an allow-list (eadf0ec)
  • Security: attempt limits hold under parallel requests, journal PIN failures survive the rollback, private-record files stay hidden behind references (a240413)
  • Container start: stop with a clear message when the data folder isn't writable (0690b76)
  • Tests: calendar feed links are replaced and revoked (71747a3)
  • Tests: sprint changes, saved record views and the record layout command (6c53cc7)
  • Browser tests: the Word, EPUB and print downloads against the server (45c9b8a)
  • Tests: the administration's account commands end to end (b6c9e0c)
  • Issue sync: codeberg.org allowed by default for Forgejo (#162) (3591e53)
  • Issue sync: Forgejo/Gitea as a third provider (#162) (5f3daae)
  • Version history and other insertion-ordered lists: ties go by seq (18d1727)
  • PostgreSQL: the last owner and the last admin stay under concurrency (80888ec)
  • Security: copying records duplicates only the source database's own visible, untrashed files (4f0cc6a)
  • Security events: one per activity-log entry, not one per route bundle (dca9f17)
  • Help docs: regenerated (PostgreSQL, migration, cluster mode, sizing) (08f11dd)
  • CI: runs on main again (the db-refactor branch trigger was temporary) (b93d362)
  • Help docs: regenerated (media trash, background imports) (018f28d)
  • Large AFFiNE imports: bounded memory, background job, memory guard (#163) (027bc2a)
  • pg_dump restores with newer client tools: through the psql script, without settings the server lacks; no hang when psql stops (caccf21)
  • Media library: delete files into the trash, mark unused files (#164) (1d64f45)
  • Administration: restore a scheduled pg_dump backup (.dump) on PostgreSQL (69d6d12)
  • Cluster mode requires shared keys; PgBouncer: FLOWPLAN_PG_PREPARE and DATABASE_SESSION_URL; .env.example for PostgreSQL and cluster mode (92cfff0)
  • Postgres CI: the failures' prefix by substr, not a text range; security events and ops counters written in order (21d8381)
  • Design doc: sizing on the merged branch (1 instance 30 VUs, 2 instances 40–50), test results after the merge (5ffa53d)
  • Helm chart test: the schema step's path in the image (1238210)
  • Design doc: wording (674d91a)
  • Design doc: phase 3a test results (a58c0ec)
  • Design document: phase 3 results (0987af2)
  • Load test README: the cluster run (eb444e2)
  • Design doc: phase 3a (cluster mode) – pieces, races reviewed, health and shutdown, deployment, tests, open risks; §14 sizing from the cluster load test (fa3d474)
  • CI: PostgreSQL with pgvector, client tools checked; the standalone check searches and backs up (82363bc)
  • Relation sync writes nothing when there is nothing to sync; a staged dump waits for its tools (51a90dd)
  • Cluster load test: --pin gives each instance a core of its own (5bc8de1)
  • PostgreSQL: the offline change log's triggers upsert instead of delete-then-insert (unique violations under concurrent writes, found by the cluster load test); a changed translation at the same schema version is applied (schema_hash in flowplan_meta) (c2be01f)
  • Design document for phase 3 (search, pgvector, pg_dump, migration procedure); translations (833902c)
  • Search rebuild command; PostgreSQL client tools and database scripts in the image (bc48e65)
  • pg_dump backups on PostgreSQL; migration tool tested on a realistic instance (e7da709)
  • Helm chart test: one replica with Recreate by default, replicas and rolling updates only in cluster mode, secrets only as references (e7193c2)
  • Readiness: FLOWPLAN_READY_REQUIRE picks which shared services count (default all three); probe and shutdown tests; design doc §13 (phase 3a) drafted (532e8e8)
  • Cluster mode: gathers on whiteboards reach every instance; restores on PostgreSQL take turns; load test of cluster mode (scripts/load-test-cluster.mjs, a balancer, the seeder on PostgreSQL) (cf6795f)
  • Deployment examples for cluster mode: deploy/compose/cluster (PostgreSQL, Redis, MinIO, schema step, two instances, Caddy) and cluster mode in the Helm chart (671993e)
  • PostgreSQL: a new or older database gets this version's schema at the first use (advisory lock), scripts/db-schema.mjs as the deployment's migration step, in the image as /app/db-schema.mjs (1694f8f)
  • Cluster tests: configuration, Redis protocol and client, and several instances as child processes – leader election and failover, heartbeats, live updates and shared rate limits (6c76548)
  • Search parity and pgvector tests on both databases (e50d804)
  • Concurrency: locks for sign-up, shares, accepted invitations and quotas; tests with parallel clients (7ebe9a1)
  • Search on PostgreSQL: trigram indexes and BM25 as FTS5 ranks; pgvector for semantic search (6bfb5d1)
  • Cluster mode: readiness and liveness probes, graceful shutdown, system view in Administration → Monitoring (66db59b)
  • Cluster mode foundation: pool limits, Redis client, bus, leader, heartbeats, shared rate limits, storage queue with LISTEN/NOTIFY and SKIP LOCKED (6e346df)
  • CI: run on the db-refactor branch while the refactor is under way (removed before merging) (23e6cc8)
  • Design doc: phase 2 results (SQLite 2,064/2,064; Postgres without the bridge 2,058 pass, 0 fail, 6 skipped) and what phase 3 must know (c42cfa2)
  • Security events: securityWritesSettled() for writes still under way (Postgres round trips); the test waits for them (101a704)
  • Data steps loaded lazily (import cycle through lib/formatted-text.ts); messenger timer catches its read (f4b1f24)
  • CI: the whole suite on PostgreSQL 16, then the build and the standalone check against it (3aeb36b)
  • Data steps of the migrations run on both databases (lib/data-steps.ts) (19ab420)
  • Snapshots and restores on Postgres: asynchronous and with bounded memory (854eff5)
  • Remove the blocking Postgres bridge (lib/db-driver/pg-sync.ts and its worker) (a75e998)
  • Postgres without the bridge: statements prepared anew after a schema change; two timing tests (0ebd261)
  • Async sweep: transaction hooks, after-commit tasks and keep callbacks awaited; tests follow (05ad808)
  • Async sweep, step 3: what the codemod listed, by hand; tsc clean (61f89ab)
  • Async sweep, step 2: codemod output (scripts/codemod-async-sweep.mjs) (58dbf8f)
  • Async sweep, step 1: the database helpers of lib/db.ts become asynchronous (d221f6a)
  • Design doc: results of phase 1 (SQLite 2,045/2,045; Postgres 2,036 pass, 0 fail, 9 skipped; next build) (8221d79)
  • setup-restore test: wait up to a minute for the scheduled backup (a Postgres snapshot under load) (b65f84b)
  • Test schemas of a process are dropped one after the other (lock slots); doc: max_locks_per_transaction for the test server (e38da51)
  • Standalone check on Postgres; the schema-file test compares without the seed rows (8988bed)
  • schemaVersion(): the schema version on either database (instance move pre-flight) (c6251af)
  • inSavepoint: savepoint names by depth (a fixed set of statements) (a040575)
  • Design doc: phase 1 – dialect rules, counts before/after, schema 93, trigger decisions, search seam, backups across databases, decisions, notes for phase 2 (54e64cd)
  • lockFor(key): advisory locks for check-then-write sections on Postgres (0740501)
  • sidebar-state test: the SQLite schema version only on SQLite (edfaf7c)
  • Caught writes inside transactions run in savepoints (a failed statement spoils a Postgres transaction); MAX(a,b) in the merge; numbered ?N parameters refused (c5c24f4)
  • Formatted text conversion through one/all/run (it wrote into the SQLite file on Postgres); tests adapted where they read SQLite files or plans; restore tests switch Postgres schemas like data folders (8bd8f04)
  • Fix the quoted alias literal (bb46049)
  • Byte length helper, quoted mixed-case alias, backend-specific trigger toggling in a test; scan finds both (f40843a)
  • lastInsertRowid → INSERT … RETURNING (security events, end-to-end encrypted updates) (35fa5ee)
  • Postgres triggers: unixepoch()*1000 in whole seconds as SQLite has it, julianday('now') in milliseconds (3ed4264)
  • Restore and instance move load the backup into Postgres; the bridge no longer rewrites SQL (276947c)
  • Object storage queue through one/all/run on both databases; Postgres queues uploads by a PL/pgSQL trigger (e383d9b)
  • Postgres: seed rows of the migrations, typed ? IS NULL, upsert self-references qualified, UPDATE OR IGNORE as updateIgnoringConflicts (2df6c49)
  • Migration tool: key order instead of rowid, triggers after the copy, search index rebuilt (6316d23)
  • Backups and moves on Postgres write the same SQLite file; pages get seq; char(10) → newline literal (75b0e21)
  • Tests and queries: no SQLite-only SQL (rowid → seq/number, json_set in JS, schema checks through helpers); "end" quoted (ff28497)
  • Spaces keep their insertion order in seq (tie-breaker of SPACE_ORDER) (09bfd36)
  • Dialect pass: upserts for INSERT OR REPLACE, schema helpers instead of PRAGMA, day helpers (d36e9fe)
  • Help docs: regenerated (mentions, journal PIN sharing, PIN reset step-up, archive manifest) (e638a3a)
  • Comment mentions notify, journal PIN revokes shares, PIN reset step-up, 64 MB archive manifest (7b94492)
  • Dialect pass: NOCASE as lower(), json_each/json_extract/instr/max through helpers, IS [NOT] DISTINCT FROM (03251d6)
  • Schema 93: explicit insertion order (seq) instead of rowid; triggers in PL/pgSQL; search through lib/search-store.ts (455c046)
  • Dialect pass: CURRENT_TIMESTAMP as a nowText() parameter, INSERT OR IGNORE as ON CONFLICT DO NOTHING (f3fe5fb)
  • Markdown export: databases above 5,000 records export in full (817ac13)
  • Database spike: design doc; read-memo stays correct on Postgres (390bac7)
  • Database spike: migration tool SQLite ⇄ Postgres, benchmark (b3a2f8e)
  • Database spike: sign-up/sign-in and tags on the async Db, Postgres tests (5822600)
  • Database spike: sessions and API token identity on the async Db (e97fe2a)
  • Database layer spike: async Db interface for SQLite and PostgreSQL (8f6ae59)
  • Help docs: regenerated after merges (d39b765)
  • Performance: read a database's own records once when opening it (c086d8f)
  • Performance: remember record previews by their source (659fd71)
  • Help docs: who hears about comments, notification retention, content archive limits (cf359c0)
  • Comments notify the people they concern, not the whole workspace; old notifications are pruned (5af5d86)
  • Content archive: large databases go out and come back (no 5,000-record cap) (cca0594)
  • Performance: check permissions once per request (e55b272)
  • Performance: index search entries without full scans and in batches (2c4618a)
  • Journal PIN attempts keep counting for a day (f9a21e6)
  • Performance: cache prepared statements of one/all/run (47477cb)
  • Journal PIN: close the remaining readers of content below a locked journal (c5d6f27)
  • Sessions: end the others when TOTP is turned on or a passkey removed; verify link respects SSO-only; demo ends the previous session (1e49982)
  • Sign-in limits: per account and address, a ceiling and growing delay per account (6cdfe52)
  • CI: pin the actions of the publishing workflows to commit SHAs (874496b)
  • Setup hardening: one first admin only, warn without FLOWPLAN_SETUP_TOKEN, Helm generates it (95c8a2e)
  • Test: the keep-alive SSRF server listens on all local addresses (localhost is ::1 in CI) (5e7d788)
  • Help docs: audit fixes (document size, journal PIN, webhooks) (2363fb1)
  • Sign-in hand-off reads its small bodies with a limit (audit follow-up) (e10f7ea)
  • Proxy: browser prefetches of a page get the Content-Security-Policy (d566f16)
  • CSV exports: one formula guard for all of them (4b3b48d)
  • Image placeholders: inflate PNGs only to their pixel size, one at a time (40ab050)
  • Inbound mail: linear address and date parsing, capped headers (ReDoS) (2190003)
  • Previews and AI fill: count only records the person sees (e052aa3)
  • Time tracking: respect the read and write rules of a time property (d152605)
  • NetBox import: a budget of requests, bytes and devices (6994464)
  • Dashboards: no definitions of properties hidden from the reader (aa50179)
  • AI rules: no names of spaces the person cannot open (f32b8f2)
  • AI hardening: bound database title matching, limit link lookups (5044d6a)
  • SSRF guard: no kept-alive connections, IP check in safeSend (e092f83)
  • Quick capture AI: check the AI switches for every candidate workspace (8b326e3)
  • Journal PIN: only the creator and workspace owners set it; owners reset it (abb032f)
  • Seal webhook secrets and addresses and Git connections at rest (e274fd7)
  • AI actions: drop images from written text, show the whole text first (bdd55c7)
  • Webhooks: only what the webhook's owner may read (c967662)
  • Link previews: read the page head in one pass (ReDoS) (9838260)
  • AI fill: only use inputs every reader of the target may read (7dab442)
  • Web clipper: read pages in one linear pass (ReDoS) (73ae7f0)
  • Guests: no member names or addresses in mention choices and forms (e8dbe3b)
  • Record templates: no hidden property values through templates (bf66e50)
  • Record templates: placeholders of formulas from hidden properties stay empty (9f3e7e1)
  • Document FLOWPLAN_MAX_DOCUMENT_MB in .env.example (707d623)
  • Cap the size of collaborative documents (FLOWPLAN_MAX_DOCUMENT_MB) (90d8a85)
  • Inbound mail and Slack replies: refuse replayed signed deliveries (c381e92)
  • MCP, browser extension, SCIM: instance-move freeze and address blocks (3ba2414)
  • Charge the AI limit before preparing a question; scan vectors in slices (d8fe745)
  • CalDAV and calendar feeds: not from a personal API token (ad1aa49)
  • Client address: X-Real-IP only behind exactly one trusted proxy (cf6f404)
  • Journal PIN: keep databases below a locked journal closed (0fe1a26)
  • Read request bodies with a limit before parsing them (b74b267)
  • Security audit (sign-in): API tokens can't start an app hand-off; hand-off sessions aren't 'recent'; LDAP/SCIM link only confirmed addresses (981830c)
  • Load test: scripts/loadtest and opt-in runtime metrics (558b1c3)
  • Skills: build the :beta image again at the end of /ship and /issue (84c9b3c)
  • Scheduled backups into a folder on another file system (#161) (4a15ed6)
  • Help docs: merged PRs #146–#160 (16a2cfe)
  • Follow-ups to #148–#160; invitation links only for the invited address; no beta build unless asked (89ff628)
  • Workspace archive: no templates, tags or definitions of spaces the member cannot open (5bcb77a)
  • Skills: /issue categorises items without a type label; add Cloudflare's security-audit skill (0bafba8)
  • Database confirmations show as info toasts instead of errors (d6d971d)
  • The mention dialog picks hits with the arrow keys and Enter (8253be8)
  • No scheduled backup before the instance has an account (20265ee)
  • Setup restore of an uploaded database backup reports its missing files (7941cf9)
  • Formula date functions return empty for an empty date (4fc788c)
  • CSV import keeps formula-like text and tags with commas as exported (a3e8ebc)
  • SFTP backup keeps remote files the database still lists (7e0e50b)
  • English (US): month-first dates and weeks from Sunday (8b19775)
  • Invitation links let the invited person create an account while sign-ups are closed (d042e17)
  • A double-click on a table cell no longer picks a value in its editor (9e75801)
  • Column width handle and formula placeholder in the reader's language (c809f4e)
  • Enter saves number and plain text cells (c8fe832)
  • Escape in a record keeps the typed title and properties (df0d128)
  • Changelog: security notes for v0.8.13 (460c50d)

Full changelog: v0.8.13...v0.9.0