v1.5.0
clockworklabs/SpacetimeDBv1.5.0Oct 1, 2025by cloutiertyler
AI Summary
This release implements the Postgres Wire Protocol (Beta) and introduces SpacetimeAuth (Beta), a managed authentication and user management service, alongside datastore improvements.
Key Highlights
- Postgres Wire Protocol (Beta) support for connecting standard Postgres clients.
- SpacetimeAuth (Beta) for user management and authentication.
- Datastore improvements including `clear_table`, `truncate`, and column support.
New Features
- Postgres Wire Protocol (Beta)
- SpacetimeAuth (Beta)
- Datastore `clear_table` and `truncate` support
- Datastore column support
- Metrics tracking database restore time
Full Release Notes
We've got some releases coming at you fast this month, and there's more to come! We've got some very exciting new features in SpacetimeDB v1.5.0. ## Postgres Wire Format (Beta) The initial version of the Postgres Wire Protocol is now implemented in SpacetimeDB. This means you can connect normal Postgres clients like `psql` or `tokio-postgres` to SpacetimeDB on port `5432`. Please note that this is the first step on a (very) long journey to make SpacetimeDB as Postgres compatible as the architecture allows and it comes with a set of caveats, but as of today you can officially connect to SpacetimeDB with a Postgres client! You can find the full documentation on what is supported [in the docs](https://spacetimedb.com/docs/sql/pg-wire). <img width="1175" height="922" alt="image" src="https://github.com/user-attachments/assets/211faf2a-fcfa-4152-ac6d-7975c15d8153" /> ## SpacetimeAuth (Beta) We are also releasing another major feature today as well, SpacetimeAuth! SpacetimeAuth is a new authentication and user management service operated by Clockwork Labs. The goal is deep integration with SpacetimeDB so you get user management for all your projects and databases with the click of a button. No more having to spin up an auth service just to deploy an app on SpacetimeDB. Now you can just navigate to `SpacetimeAuth` in your profile menu dropdown or go to https://spacetimedb.com/spacetimeauth and create a new project for your application. Your users can then log in to your SpacetimeDB application by using a new customizable webpage. <img width="1488" height="1141" alt="SpacetimeAuth" src="https://github.com/user-attachments/assets/c6b99a2e-54e5-4f72-a746-cafd1d26ac63" /> ## What's Changed * Removed `@clockworklabs/typescript-sdk` in favor of `spacetimedb` by @cloutiertyler in https://github.com/clockworklabs/SpacetimeDB/pull/3262 * Bump remaining versions to 1.4.0 by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3267 * datastore: add `clear_table` and fix `drop_table` by @Centril in https://github.com/clockworklabs/SpacetimeDB/pull/3214 * datastore: add support for truncation by @Centril in https://github.com/clockworklabs/SpacetimeDB/pull/3215 * Add reducer name to database log records by @gefjon in https://github.com/clockworklabs/SpacetimeDB/pull/3274 * Update C# DLLs to 1.4.0 by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3270 * datastore: add columns support by @Shubham8287 in https://github.com/clockworklabs/SpacetimeDB/pull/3230 * Finish making PG tests use a dynamic server address by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3277 * Remove incorrect broken links by @JasonAtClockwork in https://github.com/clockworklabs/SpacetimeDB/pull/3280 * Wrap some tests in a `mod` so that I can `--skip` them by @gefjon in https://github.com/clockworklabs/SpacetimeDB/pull/3284 * Loosen `spacetimedb` dep on `spacetime init --lang rust` by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3286 * TypeScript: Add confirmed reads config by @kim in https://github.com/clockworklabs/SpacetimeDB/pull/3247 * Rust SDK: Make confirmed parameter optional by @kim in https://github.com/clockworklabs/SpacetimeDB/pull/3283 * Add metrics tracking time to restore a database from disk by @gefjon in https://github.com/clockworklabs/SpacetimeDB/pull/3285 * Expand scope of `DurabilityProvider` to include snapshotting by @kim in https://github.com/clockworklabs/SpacetimeDB/pull/3281 * Revert "Expand scope of `DurabilityProvider` to include snapshotting (#3281)" by @kim in https://github.com/clockworklabs/SpacetimeDB/pull/3293 * SATS: impl ser/de for tuples by @Centril in https://github.com/clockworklabs/SpacetimeDB/pull/3292 * Support `BytesSource`s other than the one for reducer args by @gefjon in https://github.com/clockworklabs/SpacetimeDB/pull/3294 * Make optional to listen to pg wire protocol and param for the port by @mamcx in https://github.com/clockworklabs/SpacetimeDB/pull/3309 * Fix CI breakage by PR #3309 by @mamcx in https://github.com/clockworklabs/SpacetimeDB/pull/3314 * Make the .NET global.json file global by @kim in https://github.com/clockworklabs/SpacetimeDB/pull/3297 * Bump versions to 1.5.0, update DLLs, and regenerate files by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3310 * Integrate `tools/upgrade-version` into cargo and expand by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3308 * CI - Move Unity testsuite to a different runner by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3318 * CI - `apt install` invocations correctly pass `-y` by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3324 * C# tests - update snapshots by @bfops in https://github.com/clockworklabs/SpacetimeDB/pull/3321 * Improve message error if the port is taken by @mamcx in https://github.com/clockworklabs/SpacetimeDB/pull/3320 **Full Changelog**: https://github.com/clockworklabs/SpacetimeDB/compare/v1.4.0...v1.5.0