Turso now supports Database Branching and Point-in-Time Restore

With our generous plans, Turso allows you to create 10,000 databases in the Scaler plan, and 500 databases in the Starter plan. You can also create databases from SQLite files. With so many databases available, and the ease of manipulating SQLite files, it's the right time to introduce two new features users have been eagerly awaiting:

#Branching

Turso now supports database branching. To create a branch, all you have to do is create a new database, specifying an existing one:

turso db create new-db --from-db old-db

You can create as many branches as you want, and they will just be accounted for in the same way as a normal database is.

Branching is available to all users on every plan, including the free Starter plan.

#Point-in-Time Restore

Building on the previous functionality, you can also create a new database from another database, at a specific point in time, allowing you to restore backups at a specific point in time.

To restore a database from a specific point-in-time:

turso db create new-db --from-db old-db --timestamp 2023-10-02T10:16:13-03:00

And if you then need the data locally you can download it as a SQLite dump by doing

turso db shell new-db .dump

Point-in-Time Restore is available for everybody. Starter plan users can restore up to 24h, while Scaler plan users can restore up to 30 days. Custom retention periods are available for Enterprise Customers.

Note: make sure you have updated your Turso CLI to 0.85.3 or later in order to use these features