Zero 0.3

Schema Migrations and Write Perms

Install

npm install @rocicorp/zero@0.3

Schema Migrations: Zero now has first-class support for schema migration (documentation).
Write Permissions: First-class write permissions based on ZQL (documentation).
Date/Time related types: Zero now natively supports the TIMESTAMP and DATE Postgres types (sample app, documentation).
SolidJS: We now have first-class support for SolidJS (documentation).
Intellisense for Schema Definition: Introduce createSchema and createTableSchema helper functions to enable intellisense when defining shemas. See Sample App.
escapeLike() : Add helper to properly escape strings for use in LIKE filters. See Sample App.
New QuickStart App: Entirely rewrote the setup/sample flow to (a) make it much faster to get started playing with Zero, and (b) demonstrate more features.

The @rocicorp/zero package now downloads a prebuilt sqlite instead of compiling it locally. This significantly speeds up install.
Support rds.force_ssl=1 RDS configuration.
Fixed bug where sibling subqueries could be lost on edit changes.
Fixes to error handling to ensure zero-cache prints errors when crashing in multiprocess mode.
If zero-cache hears from a client with an unknown CVR/cookie, zero-cache forces that client to reset itself and reload automatically. Useful during development when server-state is frequently getting cleared.

Improve startup perf: ~3s → ~1.5s Hawaii ↔ US East. More work to do here but good progress.
Responsive design for mobile.
“Short IDs”: Bugs now have a short numeric ID, not a random hash. See Demo Video.
First-class label picker.
Unread indicators.
Finish j/k support for paging through issues. It’s now “search-aware”, it pages through issues in order of search you clicked through to detail page in.
Text search (slash to activate — needs better discoverability)
Emojis on issues and comments
Sort controls on list view
remove fps meter temporarily
numerous other UI polish