January 2024 Turso Product and Community Digest

2024 is already off to a great start!

Here is your January 2024 product and community digest. Discord and newsletter subscribers receive these updates earlier - join us!

#CLI Updates

January was packed with some exciting quality of life improvements for Turso CLI users:

#New CLI command to create group tokens

Creating and invalidating group tokens are now even easier with the Turso CLI:

turso group tokens create <group-name> [flags]
turso group tokens invalidate <group-name> [flags]

#New CLI command to transfer groups

You can now transfer an entire group, including all of its databases, to an organization you're an admin or owner of using the new command:

turso group transfer <group-name> <organization-name> [flags]

#Dump file size limit increased to 8GB

It's now even easier to create databases from larger SQLite dump files thanks to the new 8GB limit.

turso db create [database-name] --from-dump ./path/to/dump.sql

We're working to further increase the limit for the CLI and API. Stay tuned!

#Other CLI Updates

The turso quickstart command opens the new Turso Quickstart.
Fixed an issue where the TURSO_API_TOKEN was not shown when running some CLI commands.
Users can now disable automatic updates.
Added command to wakeup groups on the free tier that are currently archived.

#Platform API Updates

The Turso Platform API gives you everything you need to manage your organization, it's members, groups, databases, and API tokens.

#New upload SQL dump endpoint

Creating a database from a dump is really easy using the CLI, but if you're using the Turso Platform API, it's now even easier there too with the new POST /dumps endpoint:

curl -L -X POST 'https://api.turso.tech/v1/organizations/{organizationName}/databases/dumps' \
  -H 'Authorization: Bearer TOKEN' \
  -F 'file=@"~/Downloads/dump.sql"'

The API returns a URL than can be used when seeding a new database.

#New transfer group endpoint

As well as using the CLI to transfer groups, you can do this programmatically using the Turso Platform API:

curl -L -X POST 'https://api.turso.tech/v1/organizations/{organizationName}/groups/{groupName}/transfer' \
-H 'Authorization: Bearer TOKEN' \
-d '{
    "organization": "new-organization-name"
}'

#New audit logs endpoint

The new /audit-logs endpoint returns a list of recent activity:

curl -L https://api.turso.tech/v1/organizations/{organizationName}/audit-logs \
  -H 'Authorization: Bearer TOKEN'

#Client & SDK Updates

Get started with Turso and Golang using the new quickstart.
The CGO based go-libsql library now supports remote-only connections and has improved support for time.Time.
A recent URL parsing fix for @libsql/client means Next.js developers no longer see errors when building.
A new experimental libsql-client-wasm client was released that works in the browser - see examples.

If you see anything that doesn't look right or could be improved, please open an issue on GitHub or chat with us on Discord.

#Community Updates

Turso wouldn't be where it is today without the community. We recently surpassed 2000 members on Discord, and already on our way to 3000!

Here are a few exciting updates from the community:

Dominic Elm surprised us with a StackBlitz demo using libSQL in the browser with WebContainers!
BellHacks is hosting a hackathon on February 3 where users will be implementing Turso for their database needs.
Visal .In created an awesome libsql-studio project that is fully open source!
Fayaz Ahmed created an awesome Turso powered “Pastebin” that is powered by Turso and open source.
Emil Priver has been working on “Geni”, a standalone migration tool that speaks libSQL!
Imam Ali Mustofa has been working on a community PHP libSQL wrapper that works over HTTP.
ThePrimeagen is really flying to Brazil for a Turso meetup!
Neville Brem created a SvelteKit powered blog with Turso that is open source.
cylex created an awesome bookmark manager with Turso - try it out!
Gavin Sidhu is building “miflo”, a standalone migration tool that works with Turso.
Troy Poulter is making it easy to find the cheapest fuel in Australia!

Wow! If you've been working on something and would like us to feature it in our next update, #showcase it with the community on Discord.

#Documentation Updates

We kicked off 2024 with brand new Turso Documentation.

All CLI, API and SDK updates above have been added to the new documentation already. Here are a few other updates we think you'll like:

New Turso Quickstart – Learn how to get started with Turso using the CLI.
New framework specific quickstarts for Next.js, Remix, Astro, Nuxt, Qwik, SvelteKit, Flutter, Quasar, Flask, and Tauri! We're working on framework guides for other languages right now and will share with you in Discord soon as they're ready.
New Platform API Reference for developers integrating Turso.
New local development examples.

What an amazing start to 2024!